Oracle Apps Interview Questions #1

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

Oracle Application

See Also

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.