​Issue

Describe the use of ADOP utility and the functions it performs while applying a patch in Oracle EBS R12.2 environment

Solution

You use the adop (AD Online Patching) utility to apply patches to the Oracle E-Business Suite file system or database. You can either allow adop to prompt for the information required to apply a patch, or enter the information without being prompted. Whichever method you choose, adop will then perform the tasks required to apply the patch.

While executing ADOP will perform the following tasks (depending upon the phase in which it was run):

• Reads patch metadata to determine patch dependencies and requirements
• Uploads patch information from a prior patch session to the database (if applicable)
• Reads and validate the patch driver file and reads the product driver files
• Compares version numbers of object modules from the product libraries and version numbers of the existing files against the patch files
• Backs up all existing files that will be changed by the patch
• Copies files
• Archive files in libraries
• Relinks executables
• Generates forms, reports, messages, graphics, and Java archive (JAR) files
• Compiles JSP files and invalid database objects
• Updates database objects
• Runs AutoConfig to update configuration files if any template files are introduced or updated by the patch
• Saves patch information to the database

Environment

• Oracle E-Business Suite release 12.2.x