Category Archives: Oracle Apps Interview Questions

What is the lock option in reports layout? | Oracle Apps Questions

By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields.

Posted in Oracle Apps Interview Questions | Leave a comment

Can you send blob attachments via workflow notifications? | Oracle Apps Questions

Yes, you can send BLOB Attachments. For details on how to do this, refer to link for BLOG atachments to notifications.

Posted in Oracle Apps Interview Questions | Leave a comment

How will you open a bc4j package in jdeveloper? | Oracle Apps Questions

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 … Continue reading

Posted in Oracle Apps Interview Questions | Leave a comment

What is the role of Document Manager in Oracle Purchasing? | Oracle Apps Questions

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

Posted in Oracle Apps Interview Questions | Leave a comment

What is the significance of profile option “Responsibility Trust Level”. | Oracle Apps Questions

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 … Continue reading

Posted in Oracle Apps Interview Questions | Leave a comment

Which table is used to provide drill down from Oracle GL into sub-ledger? | Oracle Apps Questions

GL_IMPORT_REFERENCES

Posted in Oracle Apps Interview Questions | Leave a comment

Can you use concurrent program “Gather Schema Statistics” to gather stats on sys schema in oracle apps? | Oracle Apps Questions

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

Posted in Oracle Apps Interview Questions | Leave a comment

Does Oracle support running of gather stats on SYS schema in Oracle Apps? | Oracle Apps Questions

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 … Continue reading

Posted in Oracle Apps Interview Questions | Leave a comment

What will be your partitioning strategy on GL_BALANCES? Your views please? | Oracle Apps Questions

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.

Posted in Oracle Apps Interview Questions | Leave a comment

Does oracle support partitioning of tables in Oracle Apps? | Oracle Apps Questions

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 … Continue reading

Posted in Oracle Apps Interview Questions | Leave a comment