Issue

There are times when we need to analyze the diagnostic information in relation to AD and TXK Patches while upgrading from Release 12.2 to 12.2.x. It could be in view of missing patches or errors in applying patches.

Resolution

Simply download patch # 19045166 and run it in all the middletier nodes of the instance.

Step 1. Download and unzip the patch.

Step 2. Confirm the following files are present after unzipping.

adzddbdetails.sql
adzddiagnostic.pl
adzdedndetails.sql
README.txt

Step 3. Login with APPLMGR user on the terminal. Then set the Apps Tier environment using following env file:

/u01/oracle/VIS/EBSapps.env

Step 4. Run the master perl script adzddiagnostic.pl with the command "perl adzddiagnostic.pl"

Step 5. Supply the apps database user password the script prompts for.

Step 6. The script creates a file "diagnostic_info_.*" in the working directory.

Step 7. Attach the file to the SR for analysis.

Environment

+ Oracle E-Business Suite Release 12.2

+ Oracle Linux 5.x (x86-64)

References

MOS Doc Id 1901242.1