My Oracle Support Banner

Applying Patch 33527666 R12.ATG_PF.C.Delta.11 Failed on AFVLTPCY.sql with ORA-4063 in Worker Logfile (Doc ID 2969370.1)

Last updated on OCTOBER 31, 2023

Applies to:

Oracle Applications DBA - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

When applying Patch 33527666 R12.ATG_PF.C.Delta.11 on EBS12.2.9 DB19.6 environment, it may fail on AFVLTPCY.sql with the following errors:

ERROR
- u33527666.log

Assigned: file AFVLTPCY.sql on worker 1 for product fnd username APPLSYS.

Time is: Thu Jul 20 2023 11:45:43

FAILED: file AFVLTPCY.sql on worker 1 for product fnd username APPLSYS.

Time is: Thu Jul 20 2023 11:45:43

ATTENTION: All workers either have failed or are waiting:

FAILED: file AFVLTPCY.sql on worker 1.

- adwork001.log

sqlplus -s APPS/***** @/<APPL_TOP>/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/<APPL_TOP>/fnd/12.0.0/patch/115/sql/AFVLTPCY.sql '
Connected.

PL/SQL procedure successfully completed.

declare
*
ERROR at line 1:
ORA-04063: package body "APPS.FND_CRYPTO" has errors
ORA-06512: at "APPS.FND_VAULT", line 1646
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_CRYPTO"
ORA-06512: at "APPS.FND_RANDOM_NUMBER", line 886
ORA-06512: at "APPS.FND_RANDOM_NUMBER", line 1058
ORA-06512: at "APPS.FND_RANDOM_NUMBER", line 1101
ORA-06512: at "APPS.FND_VAULT", line 662
ORA-06512: at "APPS.FND_VAULT", line 1449
ORA-06512: at "APPS.FND_VAULT", line 1456
ORA-06512: at "APPS.FND_VAULT", line 1481
ORA-06512: at "APPS.FND_VAULT", line 1609
ORA-06512: at "APPS.FND_VAULT", line 1637
ORA-06512: at "APPS.FND_VAULT", line 1658
ORA-06512: at "APPS.FND_VAULT", line 1692
ORA-06512: at "APPS.FND_VAULT", line 2045
ORA-06512: at line 135

Time when worker failed: Thu Jul 20 2023 11:45:43

Manager says to quit.


STEPS
adop phase=apply patches=33527666


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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