R12 E-Business Suite Patch Installation Fails With Error 'FAILED: file adrevokegrants.sql on worker 1 for product ad username <APPLSYS>.' When Applying Superceeded Patch 22614470 (Doc ID 2190278.1)

Last updated on JUNE 01, 2024

Applies to:

Symptoms

E-Business Suite R12 Applications DBA, Patch Application issues

Users report the following issue while applying <Patch 22614470>:

ERROR
-----------------------

Starting phase 6 (A6): last+90

There are now 1 jobs remaining (current phase=A6):
0 running, 1 ready to run and 0 waiting.

Assigned: file adrevokegrants.sql on worker 1 for product ad username <APPLSYS>.
FAILED: file adrevokegrants.sql on worker 1 for product ad username <APPLSYS>.
Deferred: file adrevokegrants.sql on worker 1 for product ad username <APPLSYS>. (Deferment number 1 for this job)
Assigned: file adrevokegrants.sql on worker 1 for product ad username <APPLSYS>.
FAILED: file adrevokegrants.sql on worker 1 for product ad username <APPLSYS>.
Deferred: file adrevokegrants.sql on worker 1 for product ad username <APPLSYS>. (Deferment number 2 for this job)
Assigned: file adrevokegrants.sql on worker 1 for product ad username <APPLSYS>.
FAILED: file adrevokegrants.sql on worker 1 for product ad username <APPLSYS>.

ATTENTION: All workers either have failed or are waiting:

FAILED: file adrevokegrants.sql on worker 1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.