[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

    101 / 106

    What are secured Views?
    Answer:

    The Views which do not have the _all to be said as secured views.
    Per_all_people_F
    per_people_f
    per_all_assignemtns_f
    per_assignments_f
    pay_all_payrolls_F
    per_payrolls_f

    Please Login First :

    102 / 106

    What are thew between between secured views and non secured views?
    Answer:

    1.Secured views display information only for the current period
    2.Unsecured views is used to get the information from the entire rows

    Please Login First :

    103 / 106

    How can you add a new column to a List Of Values ( LOV ) in Oracle Applications Framework? Can this be done without customization?
    Answer:

    It can be done without customization, i.e. by using OA Framework Extension coupled with Personalization. Implement the following Steps:-
    a) Extend the VO ( View Object ), to implement the new SQL required to support the LOV.
    b) Substitute the base VO, by using jpximport [ similar to as explained in Link ]
    c) Personalize the LOV Region, by clicking on Add New Item. While adding the new Item, you will cross reference the newly added column to VO.

    Please Login First :

    104 / 106

    What are the various ways to kick-off a workflow
    Answer:

    You can either use wf_engine.start_process or you can attach a runnable process such that it subscribes to a workflow event.

    Please Login First :

    105 / 106

    How do you send a particular Oracle Apps Workflow Activity/Function within a workflow process into background mode.
    Answer:

    If the cost of the workflow activity is greater than 50, then the workflow activity will be processed in background mode only, and it won't be processed in online mode.

    Please Login First :

    106 / 106

    How do you know if a specific Oracle patch has been applied in apps to your environment.
    Answer:

    Use table ad_bugs, in which column bug_number is the patch number.
    SELECT bug_number
    ,to_char(creation_date, 'DD-MON-YYYY HH24:MI:SS') dated
    FROM apps.ad_bugs
    WHERE bug_number = TRIM('&bug_number') ;

    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 Interview Questions and Answers 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.