Technical Interview Questions in Oracle Apps HRMS - I

 Technical Interview Questions in Oracle Apps HRMS

Question: How will you migrate Oracle General Ledger Currencies and Sets of Books Definitions fromone environment to another without reKeying? Will you use FNDLOAD?

Answer: FNDLOAD can not be used in the scenario. You can use migrator available in "OracleiSetup" Responsibility

 Question: This is a very tough one, almost impossible to answer, but yet I will ask. Which Formin Oracle Applications has most number of Form Functions?

Answer: "Run Reports". And why not, the Form Function for this screen has a parameter towhich we pass name of the "Request Group", hence securing the list of Concurrent Programsthat are visible in "Run Request" Form. Just so that you know, there are over 600 form functionsfor "Run Reports"

 Question: Which responsibility do you need to extract Self Service Personalizations?

Answer: Functional Administrator

 Question: Can you list any one single limitation of Forms Personalization feature that was delivered with 11.5.10

Answer: You can not implement interactive messages, i.e. a message will give multiple options for Response. The best you can get from Forms Personalization to do is popup up Message with OK option.

 Question: You have just created two concurrent programs namely "XX PO Prog1" & "XX POProg2". Now you wish to create a menu for Concurrent Request submission such that only these two Concurrent Programs are visible from that Run Request menu. Please explain the steps to implement this?

Answer:

a) Define a request group, lets say with name "XX_PO_PROGS"

b) Add these two concurrent programs to the request group "XX_PO_PROGS"

 c) Define a new Form Function that is attached to Form "Run Reports" 

d) In the parameter field of Form Function screen, enterREQUEST_GROUP_CODE="XX_PO_PROGS"REQUEST_GROUP_APPL_SHORT_NAME="XXPO" TITLE="XXPO:XX_PO_PROGS"

 e) Attach this form function to the desired menu.

 Question: Does Oracle 10g support rule based optimization?

Answer: The official stance is that RBO is no longer supported by 10g.

 Question: Does oracle support partitioning of tables in Oracle Apps?

Answer: 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 canbe 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). 

 Question: What will be your partitioning strategy on GL_BALANCES? Your views please?

Answer: 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, oron the status of the GL Period.

 Question: Does Oracle support running of gather stats on SYS schema in Oracle Apps?

Answer: If your Oracle Applications instance is on 10g, then you can decide to run stats forSYS schema. This can be done by exec dbms_stats.gather_schema_stats('SYS');Alternately using commanddbms_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.

 Question: Can you use concurrent program "Gather Schema Statistics" to gather stats on sysschema in oracle apps?

Answer: No, "Gather Schema Statistics" has no parameters for SYS schema. Please usedbms_job.

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

Answer: GL_IMPORT_REFERENCES

 Question: What is the significance of profile option “Node Trust Levelâ€ in Oracle Apps.

Answer: If this profile option is set to a value of external against a server, then it signifies thatthe specific mid-tier is External i.e. it will be exposed to the www. In other words this server isnot within the firewall of your client. The idea behind this profile option is to flag such middle-tierso that special restrictions can be applied against its security, which means a very restricted setof responsibilities will be available from such Middle-Tier.

 Question: What is the significance of profile option “Responsibility Trust Levelâ€.

Answer: In order to make a responsibility accessible from an external web tier, you must setprofile option “Responsibility Trust Levelâ€ at responsibility level to “Externalâ€. Onlythose responsibilities that have this profile option against them will beaccessible from ExternalMiddle tiers.

Question: What else can you suggest to restrict the access to screens from external web tiers?

Answer: You may use URL filtering within Apache.

Question: What is the role of Document Manager in Oracle Purchasing?

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