List of Oracle Apps Interview questions.
Basic Questions
What is a responsibility?
Responsibility is a collection of different modules that
the user is to access .
How many responsibilities can be defined for a Module?
Unlimited
Can a responsibility be assigned to multiple users?
Yes
What are the components of a responsibility?
Menu
Data Group
Request Group
What is a data group?
It is an integration of one or more modules for
Cross application reference,
Cross application transferring,
Cross application report.
What are the component servers in Oracle Applications
architecture?
A: NETWORK TIER
Browser,
APPLICATION SERVER
Apache server,
Internet application server,
Form server,
Report server,
Concurrent manager server
DATABASE TIER
.dbf file
Is it mandatory to have a reports server?
Yes, it is necessary to run the reports.
Can modules of two data groups be merged?
No.
What is the name of the seeded datagroup that is provided
by applications?
A: Standard
Multiple Reporting Currencies
What is a security group?
Security Group, groups the forms and functionality of
an application into logical menu structures that will appear in the Navigator.
Which table captures the datagroup definition?
FND_DATAGROUPS
What is Flint60.exe?
We use the Oracle Applications upgrade utility, flint60,
on the Oracle Forms 6i .fmb file to apply changes that help your form to
obey the rule of Release 11i standards.
The changes flint60 makes to your form (in upgrade mode)
are listed in a detailed .html log file. These changes may include:
-
Converting most boilerplate to associated prompts for items
or frames
-
Converting lines and boxes to frames
-
Setting certain property classes or individual properties
for objects as appropriate (for example, lists of values have the property
class set to LOV if it is not already set)
-
Adjusting y-coordinate alignments of fields if they are slightly
offset from character-cell boundaries (for example, old display-only text
items did not use bevels and were previously offset to make them line up
with fields that had bevels, but now the display-only text items also use
bevels)
-
Replacing access key property settings with ampersands in
labels (for example, a label of ”Charge” with a separate access key property
setting of ”h” becomes ”C&harge” and the access key setting is removed).
-
The flint60 utility also checks for certain other conditions
including:
-
database items whose maximum length does not match the length
of the corresponding database column
-
library attachments with a hardcoded path or .pll extension
What are the mandatory steps in Application Development
process?
-
Create the application directory structure in prodappl directory
-
Register the application using AOL(Application Object Library)
-
Create a database user for new module
-
Grant Roles
-
Register Database user with AOL(Application Object Library)
-
Create tables,views,sequence,program unit etc
-
Create its public synonyms in apps schema
-
Register all the database object with AOL(Application Object
Library)
-
Create form using form builder
-
Compile the form and copy the .fmx file into module specific
product directory
-
Register all the forms with AOL module
-
Create form function and assign form to form function
-
Define a new menu for the module
-
Assign form function to menu
-
Define a Data group in System Administration module
-
Create a responsibility for a new module
-
Assign Menu,Data Group to the Responsibility
-
Create a user
-
Assign Responsibility to the user
-
Modify prod.env in appl_top
-
Set APPLFULL
-
Set Path
-
Run prod.cmd in appl_top from Server
|