[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.

Technical Interview Questions and Answers :: Oracle Apps HRMS

    61 / 106

    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.

    Please Login First :

    62 / 106

    Does Oracle 10g support rule based optimization?
    Answer:

    Rule Based Optimization (RBO) is no longer supported in Oracle 10g.

    Please Login First :

    63 / 106

    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 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).



     

    Please Login First :

    64 / 106

    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, or on the status of the GL Period.

    Please Login First :

    65 / 106

    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 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.

     

    Please Login First :

    66 / 106

    Can you use concurrent program "Gather Schema Statistics" to gather stats on SYS schema in oracle apps?
    Answer:

    No we can not use Concurrent program "Gather Schema Statics:".  Instead we can your "usedbms_job".


     


    Note: "Gather Schema Statistics" has no parameters for SYS schema.

    Please Login First :

    67 / 106

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

    GL_IMPORT_REFERENCES

    Please Login First :

    68 / 106

    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 that the specific mid-tier is External i.e. it will be exposed to the www.


    In other words this server is not within the firewall of your client. The idea behind this profile option is to flag such middle-tier so that special restrictions can be applied against its security, which means a very restricted set of responsibilities will be available from such Middle-Tier.

    Please Login First :

    69 / 106

    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 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.

    Please Login First :

    70 / 106

    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:



    • 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.


    Please Login First :


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.