Category: Interview Questions

How to Put Concurrent Requests in Hold Status?

During some scheduled maintenance activities, oracle apps database administrator would require to keep the Pending Jobs on Hold before bounce and release them after the scheduled activity.
This process help to bring down Concurrent Manager quickly and the pending jobs are preserved for running after the maintenance is complete.

1) Create table apps.conc_req_on_hold as select * from fnd_Concurrent_requests where PHASE_CODE=’P’ and hold_flag=’N’;
2) select count(*) from apps.conc_req_on_hold
3) update fnd_Concurrent_requests set hold_flag=’Y’ where PHASE_CODE=’P’ and hold_flag=’N’ and request_id in (select request_id from apps.conc_req_on_hold);

NOTE: You have to commit if select & update are same number of records. Otherwise rollback and try again till the numbers are same

4) Commit;

To Release hold on Concurrent Requests patching, run the below sql :

5) update fnd_Concurrent_requests set hold_flag=’N’ where request_id in (select request_id from apps.conc_req_on_hold);

6)Commit the changes

 commit;


Oracle Applications Database Administrator Interview Questions





1. How to verify if a patch is applied or not (11i and R12)


A: Query from ad_bugs table.(11i and r12)
select bug_number,created.last_update_date from ad_bugs where bug_number=’&patchnum’;


R12.2


select ad_patch.is_patch_applied(‘R12’,-1,20034256) from dual;


expected results:
EXPLICIT = applied
NOT APPLIED = not applied / aborted


2.What is the difference between ad_bugs and ad_applied_patches?


A: If a patch is applying multiple bug fixes, the details of all bugs fixed by the patch can be found from ad_bugs,
ad_applied_patches has information only about patches applied using adpatch.




Two tables to check if the patch is applied or not:


This table includes the defined bugs on the system: 
SELECT   bug_number 
FROM     apps.ad_bugs
WHERE   bug_number LIKE ‘%’&patchnum’%’;


This table includes patches applied on the system:
SELECT patch_name 
FROM   apps.ad_applied_patches
WHERE patch_name LIKE ‘%’&patchnum’%’


3. How to check if a forms patch is applied?


A: There is no specific way to check if a forms patch is applied. Forms Patches are usually applied through Shell scripts.