mostly askeda apps questions and answers

Hi Folks this is mostly asked interview questions in all MNC’s

<!--[if !supportLists]-->1. <!--[endif]-->How to attach reports in Oracle Applications ?

Ans: The steps are as follows :

<!--[if !supportLists]-->· <!--[endif]-->Design your report.

<!--[if !supportLists]-->· <!--[endif]-->Generate the executable file of the report.

<!--[if !supportLists]-->· <!--[endif]-->Move the executable as well as source file to the appropriate product’s folder.

<!--[if !supportLists]-->· <!--[endif]-->Register the report as concurrent executable.

<!--[if !supportLists]-->· <!--[endif]-->Define the concurrent program for the executable registered.

<!--[if !supportLists]-->· <!--[endif]-->Add the concurrent program to the request group of the responsibility.

<!--[if !supportLists]-->2. <!--[endif]-->What are different report triggers and what is their firing sequence?

Ans. : There are five report trigger :

<!--[if !supportLists]-->· <!--[endif]-->Before Report

<!--[if !supportLists]-->· <!--[endif]-->After Report

<!--[if !supportLists]-->· <!--[endif]-->Before Parameter Form

<!--[if !supportLists]-->· <!--[endif]-->After Parameter Form

<!--[if !supportLists]-->· <!--[endif]-->Between Pages

The Firing sequence for report triggers is

Before Parameter Form – After Parameter Form – Before Report – Between Pages – After Report.

<!--[if !supportLists]-->3. <!--[endif]-->What is the use of cursors in PL/SQL ? What is REF Cursor ?

Ans. : The cursor are used to handle multiple row query in PL/SQL. Oracle uses implicit cursors to handle all it’s queries. Oracle uses unnamed memory spaces to store data used in implicit cursors, with REF cursors you can define a cursor variable which will point to that memory space and can be used like pointers in our 3GLs.

<!--[if !supportLists]-->4. <!--[endif]-->What is record group ?

Ans: Record group are used with LOVs to hold sql query for your list of values. The record group can contain static data as well it can access data from database tables thru sql queries.

<!--[if !supportLists]-->5. <!--[endif]-->What is a FlexField ? What are Descriptive and Key Flexfields ?

Ans: An Oracle Applications field made up of segments. Each segment has an assigned name and a set of valid values. Oracle Applications uses flexfields to capture information about your organization.

<!--[if !supportLists]-->6. <!--[endif]-->What are Autonomous transactions ? Give a scenario where you have used Autonomous transaction in your reports ?

Ans: An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, commit or roll back those operations, then resume the main transaction.

Once started, an autonomous transaction is fully independent. It shares no locks, resources, or commit-dependencies with the main transaction. So, you can log events, increment retry counters, and so on, even if the main transaction rolls back.

More important, autonomous transactions help you build modular, reusable software components. For example, stored procedures can start and finish autonomous transactions on their own. A calling application need not know about a procedure's autonomous operations, and the procedure need not know about the application's transaction context. That makes autonomous transactions less error-prone than regular transactions and easier to use.

Furthermore, autonomous transactions have all the functionality of regular transactions. They allow parallel queries, distributed processing, and all the transaction control statements including SET TRANSACTION.

Scenario : You can use autonomous transaction in your report for writing error messages in your database tables.

What is the use of triggers in Forms ?

Ans : Triggers are used in forms for event handling. You can write PL/SQL code in triggers to respond to a particular event occurred in your forms like when user presses a button or when he commits the form.

The different type of triggers available in forms are :

<!--[if !supportLists]-->· <!--[endif]-->Key-triggers

<!--[if !supportLists]-->· <!--[endif]-->Navigational-triggers

<!--[if !supportLists]-->· <!--[endif]-->Transaction-triggers

<!--[if !supportLists]-->· <!--[endif]-->Message-triggers

<!--[if !supportLists]-->· <!--[endif]-->Error-triggers

<!--[if !supportLists]-->· <!--[endif]-->Query based-triggers

<!--[if !supportLists]-->7. <!--[endif]-->What is the use of Temp tables in Interface programs ?

Ans : Temporary tables are used in Interface programs to hold the intermediate data. The data is loaded into temporary tables first and then, after validating through the PL/SQL programs, the data is loaded into the interface tables.

<!--[if !supportLists]-->8. <!--[endif]-->What are the steps to register concurrent programs in Apps ?

Ans : The steps to register concurrent programs in apps are as follows :

<!--[if !supportLists]-->· <!--[endif]-->Register the program as concurrent executable.

<!--[if !supportLists]-->· <!--[endif]-->Define the concurrent program for the executable registered.

<!--[if !supportLists]-->· <!--[endif]-->Add the concurrent program to the request group of the responsibility

<!--[if !supportLists]-->9. <!--[endif]-->How to pass parameters to a report ? do you have to register them with AOL ?

Ans: You can define parameters in the define concurrent program form. There is no need to register the parameters with AOL. But you may have to register the value sets for those parameters.

<!--[if !supportLists]-->10. <!--[endif]-->Do you have to register feeder programs of interface to AOL ?

Ans : Yes ! you have to register the feeder programs as concurrent programs to Apps.

<!--[if !supportLists]-->11. <!--[endif]-->What are forms customization steps ?

Ans: The steps are as follows :

<!--[if !supportLists]-->· <!--[endif]-->Copy the template.fmb and Appstand.fmb from AU_TOP/forms/us. Put it in custom directory. The libraries (FNDSQF, APPCORE, APPDAYPK, GLOBE, CUSTOM, JE, JA, JL, and VERT) are automatically attached.

<!--[if !supportLists]-->· <!--[endif]-->Create or open new Forms. Then customize.

<!--[if !supportLists]-->· <!--[endif]-->Save this Form in Corresponding Modules.

<!--[if !supportLists]-->12. <!--[endif]-->How to use Flexfields in reports ?

Ans : There are two ways to use Flexfields in report. One way is to use the views (table name + ‘_KFV’ or ’_DFV’) created by apps, and use the concatenated_segments column which holds the concatenated segments of the key or descriptive flexfields.

Or the other way is to use the FND user exits provided by oracle applications.