Technical Interview Questions and Answers :: Oracle Apps HRMS
- Define a request group, lets say with name "XX_PO_PROGS"
- Add these two concurrent programs to the request group "XX_PO_PROGS"
- Define a new Form Function that is attached to Form "Run Reports"
- In the parameter field of Form Function screen, enter REQUEST_GROUP_CODE="XX_PO_PROGS"REQUEST_GROUP_APPL_SHORT_NAME="XXPO" TITLE="XXPO:XX_PO_PROGS".
- Attach this form function to the desired menu.
61 / 106
62 / 106
Rule Based Optimization (RBO) is no longer supported in Oracle 10g.
63 / 106
Yes, Oracle does support partitioning of tables in Oracle Applications. There are several implementations that partition on GL_BALANCES. However clients 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).
64 / 106
65 / 106
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.
66 / 106
67 / 106
68 / 106
69 / 106
70 / 106
Go through the frequently asked Oracle HRMS Interview Questions and Answers at Freshers & Experienced Level by Interviewers. Multiply your selection chance by going through the Oracle HRMS Interview Questions with Answers by expert members with experience in Oracle HRMS, which will Help the job seeker at Freshers and Experienced level to get a better job.
You can check latest and updated Oracle apps HRMS Technical, Oracle apps HRMS Technical Interview Questions on this page. you can be filtered the questions by companies name or can be saved to the Reading List using TO READING LIST, and see through them anytime anywhere you want.