Oracle Apps Interview Questions-7

Oracle Apps Interview Questions,

91) What resources are provided for developing applications which will be

integrated into Oracle Applications Release 11?

  • The Oracle Applications Developer's Guide Release 11 and the Oracle Applications User Interface Standards Release 11.
  • The AU_TOP/forms/US/TEMPLATE.fmb for developing a new form.
  • The AU_TOP/forms/US/APPSTAND.fmb contains standard property classes for your runtime platform.
  • The AU_TOP/resource/FNDSQF.pll contains routines for Flexfields,Function Security, User Profiles, Message Dictionary.
  • The AU_TOP/resource/APPCORE.pll contains standard User Interface routines.
  • The AU_TOP/resource/APPDAYPK.pll contains the Calendar Widget routines.
  • The AU_TOP/resource/CUSTOM.pll for adding custom code which affects Oracle Applications forms without changing Oracle Applications code.
  • The AU_TOP/resource/GLOBE.pll allows Oracle Applications developers to incorporate global or regional features into Oracle Applications forms without modifying the base Oracle Applications forms. Globe calls routines JA, JE, and JL libraries.
  • The AU_TOP/resource/JA.pll called from Globe and contains Asia/Pacific code.
  • The AU_TOP/resource/JE.pll called from Globe and contains EMEA (Europe/Middle East/Africa) code.
  • The AU_TOP/resource/JL.pll called from Globe and contains Latin America code.
  • The AU_TOP/resource/VERT.pll allows Oracle Applications developers to incorporate vertical industry features (for automotive, consumer packaged goods, energy, and other industries) into Oracle Applications forms without modifying the base Oracle Applications forms.
  • Oracle Developer/2000 Server Release 1.6.1.
NOTE: All FMB and PLL files must be migrated to your desktop if you intend to develop and integrate custom applications into Oracle Applications Release 11.

92. What are the supported versions of Forms and Reports used for developing on Oracle Applications Release 11?

The following supported versions are provided in Developer/2000 Release 1.6.1:
  • Forms 4.5
  • Reports 2.5
93. How do I compile and/or generate an Oracle Applications form?


cd $AU_TOP/forms/US

f45gen module=FNDSCAUS.fmb userid=APPS/APPS output_file=
/appl/v1100000/fnd/11.0.28/forms/US/FNDSCAUS.fmx module_type=form
batch=no compile_all=special
Windows NT
cd F:\applr11\au\11.0.28\forms\US
f45gen32 userid=APPS/APPS module=FNDSCAUS.fmb output_file=
applr11\fnd\forms\US\FNDSCAUS.fmx module_type=form batch=no

94. How do I open, compile and/or generate a custom Oracle Applications form on my desktop?To port the AU_TOP/forms/US and AU_TOP/resource files to your Windows

  • Make copies of all required files.
  • Replicate the AU_TOP directory structure on your desktop.
  • Move the files to their appropriate AU_TOP/forms/US for FMB and AU_TOP/resource for PLL.
  • Include the AU_TOP/forms/US and AU_TOP/resource directories in your FORMS45_PATH.
  • Open, compile and/or generate forms.
NOTE: The FORMS45_PATH is specified either in your Registry or It may sometimes be necessary to convert FMB -> FMT and PLL -> PLD before porting from a Unix platform to your desktop.

95. How do I add a CUSTOM_TOP to Oracle Applications?

a. Replicate an existing Oracle Applications product directory structure underneath your APPL_TOP:

| |
b. Make sure all the permissions on the files and directories are the same
as the other product directories.
c. Add the full path to this CUSTOM_TOP to your APPLSYS.env ( Source your
APPLSYS.env) or your Windows NT Registry:
UNIX: /u01/oracle/apps/vd11/xxcus/11.0.28
Windows NT: D:\oa\appltst\vd11\xxcus\11.0.28
d. Login to Oracle Applications using the System Administrator or Application
Developer Responsibility.
e. Navigate: Application -> Register and add your new CUSTOM_TOP to Oracle
Application Short Name Base path Description
Custom Application XXCUS XXCUS_TOP Custom Application
f. Shutdown and restart your Internal Concurrent Manager (ICM) so that the concurrent manager will recognize the change to the environment that was made to the APPLSYS.env and Registry.

96. How to get the data from the views in Multi_ORG views ?

Using the profiles and client info package.

SELECT * FROM po_headers – this is multi org view
If we can‟t get the data with the above query then we have to write a procedure as shown below.


x NUMBER:=0; 39

fnd_client_info.set_org_context (204);
END;Compile and run the query once again.

97) What is Responsibility / Request Group?

Responsibility is used for security reason like which Responsibility can do what type of jobs etc.

Set of Responsibility is attached with a Request group. When we attach the request group to a concurrent program, that can be perform using all the Responsibilities those are attached with Request group.

98) What is DFF?

The Descriptive Flexi field is a field that we can customize to enter additional information for which Oracle Apps product has not provided a field.

Ex. ATP program calculates for those warehouses where Inventory Org Type is DC or Warehouse in DFF Attribute11 of MTL_PARAMETERS table.

99) What is Value Set?

Value Sets define and store the valid items of data, which may be entered into a field.

Key Flexfields, Descriptive Flexfields and many standard fields use Value Sets.
Oracle already comes with hundreds of Value Sets.

We define additional Value Sets to support our own user-defined Key and Descriptive Flexfields (although we may use any existing standard Value Sets if they suit our purpose).

In defining a new Value Set, we are defining the physical format of valid data, which can reside in that Value Set.

Data in a Value Set can be of several types:

Independently loaded into a Value Set (through a standard form).

Resident in a table (to which we direct the Value Set definition).
There could be No Validation (any data can go into the field, but still subject to the formatting rules.)
Dependent on the value of data in a preceding Independent segment (loaded through a standard form).
Ex: For Supplies & Accessories CC in ATP, we define GEMS_GPO_ASSIGN_SET value set for the assignment set associated with that OU.

100) What is multi-org?

Ans: It is data security functionality in Oracle 10.6 and above. Applicable User responsibilities are created and attached to specific Operating Unit. User can access the data that belongs to the Operating unit they login under. The benefit is it enables multiple operating units to use a single installation of various modules, while keeping transaction data separate and secure by operating unit.

It has an effect on the following modules:
  • Order Entry
  • Receivable
  • Payable
  • Purchasing
  • Project Accounting
101) Can you explain the Organization structure?

Business Unit / Group : It represents the highest level in Organization structure and has no accounting impact. It determines which employees will be available to Set Of Books and Operating Units.

Ex: Consolidated Enterprise / a major division / an operating company.

Set Of Books: It is a financial reporting entity that uses a particular
Chart of accounts,
Functional currency and
Accounting calendar.
It is the highest level with accounting significance. Document Sequencing (important in Europe) is at the Set of Books level. Also Period open/close is at the Set of Books level.
A Set of Books is associated with only one Business Group. A Business Group may be assigned several Sets of Books i.e Multiple sets of books can share the same business group if they share the same business group attributes.
Base Table: apps.gl_sets_of_books
Legal Entity: A legal company for which you prepare fiscal or tax reports.
Each Legal Entity is associated with only one Set of Books. A Set of Books may have multiple Legal Entities.
Base Table: apps.hr_legal_entities
Operating Unit: An organization that uses oracle order management, cash management, shipping execution, payables, purchasing and receivables.
It may be a sales office, a division, or a department. Standard reports are at the Operating Unit level.
An operating unit is associated with a legal entity.
Base Table: apps.hr_operating_units
Inventory Organization : An organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products.
An Operating Unit may have multiple Inventory Organizations.
Ex: manufacturing plants, warehouses, distribution centers, and sales offices. 41
Base View: apps.org_organization_definitions
Subinventory: An inventory organization has a number of subinventories associated with it.
Base Table: apps.mtl_secondary_inventories (secondary_inventory_name = subinventory name)
Locator : These are the different locations in side a subinventory.
Base Table: apps.mtl_item_locations

105)What are the mandatory parameters in Concurrent program?

errbuf and Retcode (In case pl/sql store procedure)

p_conc_request_id (In case Oracle Report, it is an user-parameter)


No comments:

Post a Comment