Oracle Apps Interview Questions - 1

Oracle Apps  Interview Questions,

1) What is SET-OF-BOOKS?
Collection of Chat of Accounts and Currency and Calendars is called SO.

2) How can u call a standard interface program from sql or pl/sql code?


  •     FND_GLOBAL
  •     FND-FILE
  •     FND_CONCSUB (can submit conc program in host environment)

4) PL/SQL stored procedure parameters? or what are the two parameters that are     mandatory for pl/sql type concurrent program?    Procedure/function (ERRBUF OUT RETCODE OUT ………………….)
ERRBUF :- Used to write the error message to log or request file.
RETCODE :- Populate log request file with program submission details info.

5) What is Value Set?
The value set is a collection (or) container of values.When ever the value set  associated with any report parameters. It provides list of values to the end user to accept one of the values as report parameter value.
    If the list of values needed to be dynamic and ever changing and define a table based values set.

6) What are the validation types?

  •     None -------- validation is minimal.
  •     Independent ------input must exist on previously defined list of values
  •     Dependent ------input is checked against a subset of values based on a prior value.
  •     Table ----- input is checked against values in an application table
  •     Special ------values set uses a flex field itself.
  •     Pair ------ two flex fields together specify a range of valid values.
  •     Translatable independent ----- input must exist on previously defined list of    values; translated values can be used.
  •     Translatable dependent ------- input is checked against a subset of values  based  on a prior values; translated value can be used.
7) What is template?
a) The TEMPLATE form is the required starting point for all development of new Forms.
b) The TEMPLATE form includes platform–independent attachments of several Libraries.

APPSCORE :- It contains package and procedures that are required of all forms to support the MENUS ,TOOLBARS.

APPSDAYPK :- It contains packages that control the oracle applications CALENDER FEATURES.


CUSTOM :- it allows extension of oracle applications forms with out modification of oracle application code, you can use the custom library for customization such as zoom ( such as moving to another form and querying up specific records)

8) What are ad-hoc reports?
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

9) What is responsibility?
It is a collection of menus, request security groups and data groups

    Menus: collection of forms is nothing but menus
    Request security groups: collection of programs.
    Data groups: is a group of modules to be made accessible by the user through  Responsibility;System admin

10) What are different execution methods of executabls?

  •       FlexRpt The execution file is wrnitten using the FlexReport API.
  •       FlexSql The execution file is written using the FlexSql API.
  •       Host The execution file is a host script.
  •       Oracle Reports The execution file is an Oracle Reports file.
  •       PL/SQL Stored Procedure The execution file is a stored procedure.
  •       SQL*Loader The execution file is a SQL script.
  •       SQL*Plus The execution file is a SQL*Plus script.
  •       SQL*Report The execution file is a SQL*Report script.
  •       Spawned The execution file is a C or Pro*C program.
11) Oracle E-Business suite?
Oracle apps + analytical components software.
(Oracle discover) (Oracle sales analyzer) (Oracle financial analyzer) (Oracle marketing analyzer)

12) What is multi org?
“Legal entity has more than one operating unit is called as multi org”

  •        Business group --- Human resources information is secured by Business group
  •        Legal entity. --- inter-company and fiscal/tax reporting.
  •        Operating unit --- secures AR, OE, AP, PA and PO Information.
  •        Organizations --- is a specialize unit of work at particular locations

13) What is ERP? Architecture of apps?
A packaged business software system that lets a company automate and integrate the majority of its business processes; share common data and practices across the enterprise; [and] produce and access information in a real-time environment.

14)What is invoice?
Send you a request for payment

15) Data Link
Data links relate the results of multiple queries.
A data link (Parent - Child Relation Ship) causes the child query to be executed once for each instance of its parent group.