This content has been marked as final. Show 3 replies
We recently did an R12.1.3 upgrade.At any time during an AutoPatch or an AD Administration session, you can run a script to create an AD Job Timing report that shows the progress of the current session. Or you can go to the APPL_TOP/admin/<SID>/out directory to view an adt<session_id>.lst report from a previous session.
There is a file which has details of all the sqls which were run as part of the patch and also has the details of the time each of the sqls took.
Please let me know the file name and the location.
For AutoPatch and AD Administration sessions, the adt<session_id>.lst report is very similar to the web-based Timing Report you can access via Oracle Applications Manager.
Oracle E-Business Suite Maintenance Utilities -- Page 5-2, AD Job Timing Report
Oracle E-Business Suite Patching Procedures -- Page 4-15, Timing Reports