Interview Questions.

Question 1. Define Request Group?

Answer :

A request protection institution is the collection of requests, request units, and concurrent packages that a consumer, operating beneath a given duty, can choose from the Submit Requests window.

Question 2. Incompatibility In Report Registration And Run Alone?

Answer :

Identify packages that need to not run concurrently together with your concurrent application due to the fact they might interfere with its execution.You can specify your application as being incompatible with itself.

Application: Although the default for this area is the application of your concurrent software, you could enter any valid utility call.

Name: The software call and alertness you specify ought to uniquely discover a concurrent application. Your list shows the consumer-pleasant name of this system, the short call, and the outline of the program.

Scope: Enter Set or Program Only to specify whether your concurrent application is zincompatible with this application and all its infant requests (Set) or best with this application (Program Only).

Run Alone: Indicate whether your application have to run on my own relative to all other packages inside the same logical database. If the execution of your program interferes with the execution of all different applications in the identical logical database (in other phrases, if your software is incompatible with all packages in its logical database, such as itself), it ought to run alone.

Oracle 10g Interview Questions
Question three. What Is Tca (buying and selling Community Architecture)?

Answer :

Oracle Trading Community Architecture (TCA) is a statistics model that permits you to manage complicated records about the events, or clients, who belong on your commercial network, including companies, locations, and the community of hierarchical relationships among them. This information is maintained within the TCA Registry, which is the single supply of buying and selling community facts for Oracle E-Business Suite programs.

Question four. What Is Summary Columns?

Answer :

A summary column performs a computation on any other column's information. Using the Report Wizard or Data Wizard, you could create the following summaries: sum, common, depend, minimal, most, % overall. You can also create a summary column manually inside the Data Model view, and use the Property Palette to create the following extra

summaries: first, remaining, fashionable deviation, variance.

Oracle 10g Tutorial
Question 5. What Is Formula Column?

Answer :

A method column plays a consumer-defined computation on some other column(s) records, consisting of placeholder columns.

Oracle 9i Interview Questions
Question 6. What Is Place Holder Columns?

Answer :

A placeholder is a column is an empty box at design time. The placeholder can maintain a value at run time has been calculated and located in to It by means of pl/sq. Code from another item.

You can set the fee of a placeholder column is in a Before Report cause.

Store a Temporary fee for future reference. EX. Store the present day max profits as statistics are retrieved.

Question 7. Form Development Process?

Answer :

Open template shape
Save as .Fmb
Change the shape module call as form call.
Delete the default blocks, window, and canvas
Create a window.
Assign the window property elegance to window
Create a canvas (subclass data)
Assign canvas assets class to the canvas
assign the window to the canvas and canvas to the window
Create a facts block
Modify the form level homes. (sub elegance item Text object)
Modify the app_custom package. In the program unit.
Modify the pre-form cause (form level)
Modify the module degree residences ((console window, First navigation
Save and collect the form.
Place the .Fmx inside the server listing.
Oracle 9i Tutorial Oracle 8i Interview Questions
Question 8. What Is Set-of-books?

Answer :

Collection of Chart of Accounts and Currency and Calendars is referred to as SOB

Question 9. Tell Me Something About Sql-loader?

Answer :

Sql  loader is a bulk loader utility used for moving facts from outside files into the oracle database.

Sql loader helps various load codecs, selective loading, and multi-tables hundreds.

Conventional --The traditional route loader basically masses the statistics by using the usage of general ‘insert’ declaration.
Direct -- The direct route loader (direct = real) by means of own of common sense worried with that, and masses without delay in to the oracle facts documents.
EX:- My statistics.Csv report

1001, “scott tiger”,one thousand,40

1002,”gvreddy”,2345,50

Load statistics

Infile ‘c:datamydata.Csv’

insert Into desk emp Fields terminated by means of “,” optionally enclosed through‘”’

(empno, empname,sal,deptno)

>sqlldr scott/tiger@vis control=loader.Ctl log= gvlog.Log bad=gvbad.Terrible discard=gvdis.Dsc .

Oracle 11g Interview Questions
Question 10. What Is Token?

Answer :

Use to transfer values to record builder and it isn't case sensitive.

Oracle 8i Tutorial
Question eleven. What Is Us Folder In The Custom Top?

Answer :

It is a language particular folder used to store the G.U.I like reports and paperwork.

Oracle Apps ERP Interview Questions
Question 12. What Is Meant By Concurrent Program?

Answer :

It is nothing however Instance of the execution along with parameters & Incompatables. Here Incompatables not anything however if we  are submiting cc applications if any one may be execute in the ones software , which packages r no longer imp yet this time we can  mention the ones packages in incompatables tab.

Oracle 10g Interview Questions
Question thirteen. Can We Have Custom Schema When It It Required?

Answer :

sure, we are able to have custom schema, whilst we want to create a brand new desk we required custom schema.     

Oracle 11g Tutorial
Question 14. Where Did U Find The Application Short Name And Basepath Names?

Answer :

choose basepath,application_short_name from fnd_application from the backend. From the from cease we are able to get it Navigation Application Developer.-----> Application---->Register The application call we can get from FND_APPLICATION_TL

Question 15. What Is The Significancy Of Us Folder?

Answer :

It is nothing however language specification via default it's miles in american language. We can have more than one languages folders  based on installed languages. From backend we can get it from

FND_LANGUAGES -- COL --INSTALLED_FLAG I,B,D

              I--INSTALLED,

              B--BASE,

              D--DISABLE

              choose language_code,nls_language from fnd_languages where installed_flag like 'B'

Oracle 7.3 Interview Questions
Question 16. What Is Meant By Custom Top And What Is The Purpose?

Answer :

Custom Top is not anything however Customer Top, which is created for customer handiest. We will have more than one custom tops based totally on client requirement. It is used to store evolved & customized additives. Each time oracle corp making use of patches it'll over trip on all of the modules besides custom pinnacle. This is why we will use custom pinnacle.

Question 17. What Is The Diff Between Apps Schema And Other Schemas?

Answer :

Apps schema incorporates handiest Synonyms we can't create tables in apps schema,in which as different schema s incorporates tables, & all the objects. Here most effective we can create the tables and giving offers on created tables. Almost all each time we  will connect to apps schema best.

Oracle ADF Interview Questions
Question 18. How Do You Make Your Own Query When You Are In Forms Query Mode?

Answer :

You can use a placeholder to achieve this. If you enter a unmarried colon ( : ) in certainly one of your question fields in the course of the Enter Query mode, Oracle Forms Run Query will set off you to enter the text of SQL Where clause.

Oracle 9i Interview Questions
Question 19. What Is Concurrent Processing?

Answer :

Concurrent processing is a manner that concurrently runs applications within the history (normally on the server rather than your computing device) whilst running online.

Question 20. What Is A Concurrent Manager?

Answer :

A Concurrent Manager is a component of concurrent processing that video display units and runs requests while you figure on line. Once the person submits a request to run the job, the facts is saved in the request desk. A concurrent manager receives the information from the request table and executes the required concurrent process.

Oracle Application Framework Interview Questions
Question 21. What Is A Request Set?

Answer :

A request set is a set of stories or packages grouped collectively. Once you post a request set activity, it executes all of the programs in a file set sequentially or in a parallel manner as defined in the request set.

Question 22. What Are The Four Phases Of A Concurrent Request?

Answer :

The 4 phases are as follows: inactive, pending, going for walks, and finished.

Question 23. How Would You Identify The Results Of The Request In The Concurrent View Requests Window?

Answer :

When ever a concurrent activity is submitted, Applications creates a Request ID. You can use this Request ID to view the effects.

Oracle Apps Functional Interview Questions
Question 24. What Are The Profile Options? How Many Levels Of Profile Options Are Available?

Answer :

Profile alternatives are set to determine how the applications look and experience. There are four ranges of profile options available: web page level, software degree, obligation stage, and person level. You may have numerous categories of profile options, together with non-public options, device options, auditing profile options, forex alternatives, Flexfield alternatives, online reporting options, personal output viewer options, and consumer profile options.

Oracle 8i Interview Questions
Question 25. What Is A Document Sequence?

Answer :

A document series assigns precise numbers to the files (transactions) generated by way of Oracle Applications. For example, each bill has its very own particular invoice number and each purchasing record has its personal precise buy order (PO) quantity.

Question 26. What Is A Flexfield? How Many Types Of Flexfields Exist?

Answer :

A Flexfield is a discipline made from segments. Each phase has an assigned name and a listing of legitimate values. Two sorts of Flexfields exist: Key Flexfields and Descriptive Flexfields (DFFs).

Oracle Apps DBA Interview Questions
Question 27. What Is A Key Flexfield?

Answer :

A Key Flexfield is a unique identifier that is made from significant segments to perceive GL account numbers and object numbers. Key Flexfields are commonly saved in SEGMENT1...SEGMENTn database columns.

Some examples would be Item No 34H-AFR-223-112.G and GL Account No:

a hundred-00-one thousand-324-11100.

For an instance GL Account, segments may be identified as Organization, Cost Center, Account, Product, Product Line.

Oracle 11g Interview Questions
Question 28. What Is A Descriptive Flex Field?

Answer :

A DFF lets you define the custom fields into Oracle Application bureaucracy without customizing the program code. DFFs in bureaucracy are represented by way of a "beer mug" area (a single area subject enclosed via brackets) that seems like the subsequent image: [ ]. They are generally stored in ATTRIBUTE 1...ATTRIBUTE n database columns. DFFs also can be used to simply accept report parameters.

Question 29. How Many Validation Types Are There?

Answer :

Six validation sorts exist:
none, based, unbiased, table, unique, and pair.

Oracle Workflow Interview Questions
Question 30. What Are The Required And Optional Steps For Setting Up Flexfields?

Answer :

The required steps are as follows: define the cost units, define the structures, and outline the values, if wished. The elective steps are as follows: define the safety rules, define the move-validation rules, and outline the shorthand aliases, if essential.

Question 31. What Is Oracle Alert?

Answer :

Oracle Alert is an exception reporting machine. It maintains you informed on an as-needed foundation. It also communicates with different customers through e mail regarding exception messages.

Question 32. What Is An Open Interface In Oracle Applications?

Answer :

Open Interface, additionally known as the Application Programmer Interface (API), is a technique wherein the Oracle Applications are linked with outside or legacy systems. Open Interface works as a temporary staging location to load the outside information into Oracle Applications tables. Once the information is demonstrated, it sends the records to the everlasting tables. Rejected transactions may be corrected and resubmitted.

Question 33. Which Schema Has Complete Access To The Oracle Applications Data Model?

Answer :

The APPS schema. AutoInstall automatically sets the FNDNAM environment variable to the name of the APPS schema.

Oracle Apps ERP Interview Questions
Question 34. What Are The Main Prerequisites For Creating A Custom Application Or Responsibility?

Answer :

Set up a listing structure for a custom software, and define an surroundings variable that interprets to your utility base route.

Question 35. Do I Need To Have Who Column Information In Custom Forms?

Answer :

Yes. It is strongly endorsed to feature WHO columns to the custom tables and contact preferred API, FND_STANDARD.SET_WHO in PRE-INSERT, and PRE-UPDATE triggers in each block of the form. Also, specify those fields as hidden in each block of the shape.

Question 36. What Is The Oracle-advocated Application Short Name For Extensions?

Answer :

Oracle recommends an application quick call begin with XX. As an example, extensions to Oracle Purchasing would be XXPO.

Oracle 7.Three Interview Questions
Question 37. Where Do You Maintain Database Customizations?

Answer :

You can preserve all of your desk changes via growing a new schema. You can use your custom utility quick name (consisting of XXPO) as your Oracle schema name for clean identity. The new schema ought to be registered within the Oracle AOL.

Question 38. Can You Create Extensions To Oracle Applications Without Modifying The Standard Form Code?

Answer :

Yes. This may be achieved using the CUSTOM library, that's an Oracle Forms PL/SQL library. You can integrate your custom code without delay with Oracle Applications with out making adjustments for your Oracle Applications forms code. The CUSTOM library is located in the $AU_TOP/res/plsql listing. Once you write the code, you assemble and generate the CUSTOM procedures to make your modifications.

Question 39. When Do You Use The Custom Library?

Answer :

You can use the CUSTOM library in a variety of cases. You can use it to contain Zoom common sense, common sense for well-known occasions, common sense for product-unique occasions, and to add entries for the special menu.

Question forty. What Is Autonomous Transaction?

Answer :

Autonomous transaction way a transaction this is embedded in some other transaction, but capabilities independently.

Oracle ADF Interview Questions