How to apply ADOP patches?
Simple way to apply ADOP patches:
0 - Read the readme
of patch.
0 - Check
patch weather already applied or not. ( select * from ad_bugs where bug_number =’no’;)
0 - Check
invalid objects ( select count(*) from dba_objects where status=’INVALID’)
0 - Compile
invalid objects using ADADMIN if necessary.
0 - Copy
unzip patch to fs_ne. (For Eg: /u01/oracle/R1224/fs_ne/EBSapps/patch)
1 - Source
the Environment of Run File System. ( /u01/oracle/R1224/EBSapps.env run )