Oracle Apps Technical Interview Questions

Oracle Apps Technical Interview Questions

Which is the most commonly used package in apps that uses Autonomous Transaction?
FND_LOG, this is used for debugging. This has a procedure named string, which does a
commit.
Hence your debug messages are not lost in the event of rollback during unhandled exception.
What is one of the limitations of Forms Personalization?
You can not display interactive messages as you can using fnd_message
How to use Flexfields in reports ?
Ans : Most common way is to use FND user exits provided by oracle applications.
1 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
Other way is to directly use the DB views (TableName || ‘_KFV’ or ’_DFV’) created by apps,
and use the concatenated_segments column which holds the concatenated segments of the
key or descriptive flexfields.
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.
2 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
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 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.
3 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
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.
What are different report triggers and what is their firing sequence ?
Ans. : There are five report trigger :
· Before Report
· After Report
· Before Parameter Form
· After Parameter Form
4 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
· Between Pages
The Firing sequence for report triggers is
Before Parameter Form – After Parameter Form – Before Report – Between Pages – After
Report.
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.
5 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
How to attach reports in Oracle Applications ?
Ans: The steps are as follows :
· Design your report in D2K
· Generate the executable file of the report as .rdf.
· Move the executable as well as source file to the appropriate product’s folder.
· Register the report as concurrent executable.
· Define the concurrent program for the executable registered.
· Add the concurrent program to the request group of the responsibility.
6 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
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 :
· Key-triggers
· Navigational-triggers
· Transaction-triggers
· Message-triggers
· Error-triggers
· Query based-triggers
7 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
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.
What are the steps to register concurrent programs in Apps ?
Ans : The steps to register concurrent programs in apps are as follows :
· Register the program as concurrent executable.
· Define the concurrent program for the executable registered.
· Add the concurrent program to the request group of the responsibility
8 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
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.
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.
What are forms customization steps ?
Ans: The steps are as follows :
· 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,
9 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
VERT) are automatically attached .
· Create or open new Forms. Then customize.
· Save this Form in Corresponding Modules.
What is Key and Descriptive Flexfield.
Ans : Key Flexfield: #unique identifier, storing key information
# Used for entering and displaying key information.
For example Oracle General uses a key Flexfield called Accounting
Flexfield to uniquely identifies a general account.
10 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
Descriptive Flexfield: # To Capture additional information.
# to provide expansion space on your form
With the help of [] . [] Represents descriptive
Flexfield.
Difference between Key and Descriptive Flexfield?
Ans :
Key Flexfield
Descriptive Flefield
1. Unique Identifier
1.To capture extra information
2. Key Flexfield are stored in segment
2.Stored in attributes
3.For key flexfield there are flexfield Qualifier and segment Qualifier
11 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
3. Context-sensitive flexfield is a feature
of DFF. (descriptive flexfield)
What are the steps in Customer Interface ?
Ans:
How to handle errors in Customer interface ?
Ans:
12 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
What was your role in Customer Interface?
Ans:
What is the use of CUSTOM Library in Oracle Apps?
Ans:
Can you call APPCORE library in CUSTOM library ?
Ans : you cannot attach the APPCORE library to CUSTOM because it would cause a recursion
problem
(because CUSTOM is attached to APPCORE). As of Oracle Applications Release 11i,
you may
attach the APPCORE2 library to CUSTOM. The APPCORE2 library duplicates most
APPCORE
routines with the following packages:
13 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
· APP_ITEM_PROPERTY2
· APP_DATE2
· APP_SPECIAL2
These packages contain the same routines as the corresponding
APPCORE packages. Follow the documentation for the corresponding
APPCORE routines, but add a 2 to the package names.
Can you use REF cursors in CUSTOM library?
Ans:
14 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
What is FlexField?
Ans: Oracle Application uses Flexfield to capture information about
Your organization. Flexfield have flexible structure for storing key information.
Like Company, Cost Center, and Account. They also give u highly adaptable
Structure for storing customized information in oracle Applications.
How many Flexfields are there in AR and what are they ?
Ans:
15 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
What are User Exits and what are different types of User Exits in Oracle Apps ?
Ans:
What is MRC and what are it’s use?
Ans: The Multi Reporting Currency Feature allows you to report and maintain records at the
transaction level in more than one functional currency. You can do by defining one or more set
of books in addition to primary set of books.
How many reporting currencies can be attached to Primary Set Of Books ?
Ans:
16 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
What are the new features in Release 11I ?
Ans:
What are ad-hoc reports ?
Ans: Ad-hoc Report is made to meet one-time reporting needs. Concerned with or formed for a
particular purpose. For example, ad hoc tax codes or an ad hoc database query
What is FSG and what is it’s use ?
Ans: FSG is a powerful and flexible tool you can use to build your own custom reports without
programming. FSG is only available with GL.
17 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
What are different types of transactions in AR ?
Ans:
What are value sets ?
Ans:
What do you mean by HZ_ in customer tables ?
Ans:
18 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
How can you handle multiple rows without using loops in PL/SQL ?
Ans:
What are the different types of files used in SQL Loader ?
Ans:
What are Interface table in AP, AR,GL ?
Ans: AP INTERFACE TABLE: 1). AP_INTERFACE_CONTROLS.
19 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
2). AP_INTERFACE_REJECTIONS
3). AP_INVOICE_INTERFACE
4). AP_INVOICE_LINES_INTERFACE.
AR INTERFACE TABLE:
1). AR_PAYMENTS_INTERFACE_ALL
2). AR_TAX_INTERFACE
3). HZ_PARTY_INTERFACE
4). HZ_PARTY_INTERFACE_ERRORS
5). RA_CUSTOMERS_INTERFACE_ALL
6). RA_INTERFACE_DISTRIBUTIONS_ALL
7). RA_INTERFACE_ERRORS_ALL
20 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
8). RA_INTERFACE_LINES_ALL
9). RA_INTERFACE_SALESCREDITS_ALL
GLINTERFACE TABLE:
1). GL_BUDGET_INTERFACE
2). GL_DAILY_RATES_INTERFACE
3). GL_IEA_INTERFACE
4). GL_interface
5). GL_INTERFACE_CONTROL
6). GL_INTERFACE_HISTORY
What are different period types ?
21 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
Ans:
What are different types of Journal entries ?
Ans:
What are the setup steps for testing ?
Ans:
What are User Exits ?
22 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
Ans:
What is an Invoice ? How many types of invoices are there in AP and AR ?
Ans:
What is recurring invoices ?
Ans:
23 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
Ans:
Can you add a descriptive FlexField to a table which already have data in it ?
Ans:
If any conflict occurs in FSG the who will override Column Set or Row Set ?
Ans:
24 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
How to take care of null values in SQL Loader ?
Ans:
What is Set of Books ? What are the four conditions when you change your SOBs?
Ans:
What is Multiple Organization technical architecture?
25 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
Ans:
What can we find TEMPLATE.FMB file ?
Ans:
What are the libraries attached to TEMPLATE form ?
Ans:
What is the difference between cross-validation rules and security-rules?
26 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
Ans:
In how many ways can you enter a journal in GL?
Ans:
What are the setup steps for AP, AR, GL?
Ans:
27 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
How to register tables and columns in AOL?
Ans:
What is the difference between discounts and adjustments?
Ans:
What are different types of invoices and what is a recurring invoice?
Ans:
What are cycles of GL, AP, and AR?
28 / 29
Oracle Apps Technical Interview Questions
Written by Anil Passi
Sunday, 22 June 2008 15:17
Ans:
What are Summary Accounts and Rollup groups ?
Ans:
29 / 29