Patches Get Stuck at Gathering Stats for AD_CHECK_FILES_TEMP Table

Hello Support,

We were applying patch 8208763.

But, its not related to a single patch as there is no issue recorded in log file and patch work has been done successfully, all workers have quit.

Only the autopatch is not completing and giving the error mentioned in error message.

AutoPatch is not completing, although all workers have quit and FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS have been dropped but its stuck post this step.

Error Codes

---------------------------------------------------

PLS-00201: Identifier 'AD_FILE_UTIL.LOCK_INFRASTRUCTURE' must be declared

=====================================

Post taking the snapshot of the system, autopatch is now stuck at gathering stats for AD_CHECK_FILES_TEMP table