Technical Interview Questions and Answers :: Oracle Apps HRMS
101 / 106
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
102 / 106
1.Secured views display information only for the current period
2.Unsecured views is used to get the information from the entire rows
103 / 106
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.
104 / 106
You can either use wf_engine.start_process or you can attach a runnable process such that it subscribes to a workflow event.
105 / 106
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.
106 / 106
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') ;