Apply Patch in Oracle EBS

1. Download required patch from the support.oracle.com -> patches and update.
2. Unzip the patch where you have downloaded.
3. Read the patch file ‘READ ME.HTML’ carefully.
4. Read Pre patch & post patch application steps. If there are some patches to apply before this patch, apply them before, and if there are some patches to be apply after this patch, apply those after applying this patch.
5. Check the patch is not already applied using the above SQL. 
1. select * from ad_applied_patches
6. Go to cd opt1/oracle/apps/apps_st/appl/ and find environment file using ‘ls *.env’ then set environment of server you using.
7. Down the application services using ‘. /home/oracle/down.sh ’
8. Copy the patch to server at this location cd /home/oracle/patches
9. Go to the path where patch exist cd /home/oracle/patches/Your_Patch_Folder.
10. Type adadmin.
11. All defaults values, system/manager, apps/apps
12. Go to Change Maintenance Mode 5, Enable maintenance mode 1.
13. To start the patch type adpatch. For some patches( adpatch preinstall=y)
14. Top default.
15. Type password system/manager, apps/apps.
16. Give the patch driver file uPATCH_NAME.drv
17. If AutoPatch is complete, then patch applied successfully. 
18. If there is some error go to log file. 
19. Vi /opt1/oracle/apps/apps_st/appl/admin/SID/log/PATCH_NAME.log
20. Type adadmin, All defaults values, system/manager, apps/apps
21. Change maintenance mode. 5, Disable maintenance mode 2.
22. Up Application