Oracle Apps Interview Questions & Answers

1. What is Multi Org Architecture?

The Multiorg Architecture is meant to allow multiple companies or subsidiaries to store their records within a single database.

The multiple Organization architecture allows this by partitioning data through views in the APPS schema. Multiorg also allows you to maintain multiple sets of books. Implementation of multiorg generally includes defining more than one Business Group.

2. How can I know if I am using Multi Org?

Run the SQL statement:

select multi_org_flag

from fnd_product_groups;

The result 'Y' means your database is setup for multiorg.

3. What are the relationships I can define in a multi org environment?

You define the relationships among inventory organizations, operating units, legal entities, Business Groups, and sets of books to create a multilevel company structure:

. Business Groups separate major segments of a business. Each can have it's own set of books. Each Group will also have a structure of other organizations classifications assigned to it.

• Legal Entities post to a Set of Books

• Operating Units are part of a Legal Entity

• Inventory Organizations are part of an Operating Unit

• Inventory Organizations define and maintain items used by other manufacturing modules (Order Entry, Purchasing, MRP, etc.). They also collect and pass data to the Financials modules.

4. I want to Setup Additional Organizations, do I have to setup Multiorg?

No, you do not need to setup multiorg. You do not have to be multi-org to have multiple organizations only if you intend to have multiple sets of books.

5. Is there any documentation on how to setup an organization?

A. • Refer to "Oracle Manufacturing Implementation Manual" part#A50765.

• Refer to "Multiple Organizations in Oracle Applications" part#A58478 for Release 11 and part#50771 for Release 10.

• Also refer to note 76440.1 for Organization setup steps.

6. When my organization hierarchy changes, can I move an organization from one set of books or legal entity to another?

No, you should not try to move an organization from one set of books or legal entity to another because your data may not be valid for the new set of books or legal entity. Instead, you should disable the old organization and create a new organization for the appropriate set of books or legal entity. The new organization will contain your new data, and the disabled organization will act as an "old" or "history" entity that stores past transactions.

7. How can I setup a child org to be its own costing organization?

Steps:

• Change the attribute control for "default category set" to organization level

• Change the attribute control for "costing enabled" to organization level

• Change the attribute control for "inventory asset value" to organization control

Then you can make a child organization it's own costing organization by entering the organization name in the column labeled "Costing Organization"

8. How can I define organization restriction?

Use the Organization Access form (INVSDORA) to restrict the list of organizations displayed for each responsibility level.

Refer to Oracle Inventory User's Guide for steps and important notes.

*WARNING* If you populate any rows in this form, you MUST populate a row for EACH responsibility that you wish to have access to that Organization.

9. What responsibility do I need to use to setup organization?

Use the General Ledger responsibility to define the Set of Books Use the Inventory Responsibility to define Organizations and other related information such as Inventory Key Flexfields, Locations, Workday calendar, other Organization Classifications, and other inventory information.

10. What are the main profile options relating to Organization setup and what are they used for?

• HR:User Type = HR User

This is necessary to allow the Inventory responsibility to complete the organization setup. Setting the profile to a value of 'User' as opposed to 'Payroll & User' will restrict the Inventory user from accessing any Payroll information if Oracle Payroll is installed.

• HR: Business Group = {the users Business Group name}

This points the responsibility to the appropriate Business Group.

When multiple Business Groups are defined, you must associate each responsibility with one and only one Business Group.

A responsibility can not see organization data from more than one Business Group.

• MO: Operating Unit = {the users Operating Unit name}

Used primarily in a multiorg environment.

This points the responsibility to the appropriate Operating Unit.

Set the site level to the desired default operating unit.

If there is more than 1 Operating Unit Defined, this profile option must be set at the responsibility level for each responsibility.

11. Does oracle support partitioning of tables in Oracle Apps?

Yes, Oracle does support partitioning of tables in Oracle Applications. There are several implementations that partition on GL_BALANCES. However your client must buy licenses to if they desire to partition tables. To avoid the cost of licensing you may suggest the clients may decide to permanently close their older GL Periods, such that historical records can be archived.

Note: Before running the archival process the second time, you must clear down the archive table GL_ARCHIVE_BALANCES (don’t forget to export archive data to a tape).

12. What will be your partitioning strategy on GL_BALANCES? Your views please?

This really depends upon how many periods are regularly reported upon, how many periods are left open etc. You can then decide to partition on period_name, or period ranges, or on the status of the GL Period.

13. Does Oracle support running of gather stats on SYS schema in Oracle Apps?

If your Oracle Applications instance is on 10g, then you can decide to run stats for SYS schema. This can be done by exec dbms_stats.gather_schema_stats('SYS');

Alternately using command dbms_stats.gather_schema_stats('SYS',cascade=>TRUE,degree=>20);

I will prefer the former with default values.

If you wish to delete the stats for SYS use exec dbms_stats.delete_schema_stats('SYS');

You can schedule a dbms_job for running stats for SYS schema.

14. Can you use concurrent program "Gather Schema Statistics" to gather stats on sys schema in oracle apps?

No, "Gather Schema Statistics" has no parameters for SYS schema. Please use dbms_job.

15. Which table is used to provide drill down from Oracle GL into sub-ledger?

GL_IMPORT_REFERENCES

16. What is the significance of profile option “Responsibility Trust Level”.

In order to make a responsibility accessible from an external web tier, you must set profile option “Responsibility Trust Level” at responsibility level to “External”. Only those responsibilities that have this profile option against them will be accessible from External Middle tiers.

17. What is the role of Document Manager in Oracle Purchasing?

POXCON is an immediate concurrent program. It receives pipe signal from the application when a request is made for approval/reservations/receipts.

18. How will you open a bc4j package in jdeveloper?

Oracle ships a file named server.xml with each bc4j package. You will need to ftp that file alongside other bc4j objects(VO’s, EO’s, AM, Classes etc).

Opening the server.xml will load the complete package starting from AM(application module). This is a mandatory step when building Extensions to framework.