My Oracle Support Banner

R12 - SYS_PLSQL_54180_87_1 is invalid after applying a patch (Doc ID 1152013.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Payables - Version: 12.0.0 to 12.1.3 - Release: 12.0 to 12.1
Information in this document applies to any platform.

Symptoms

Invalid object after applying patch:

SYS_PLSQL_54180_87_1 fails to compile


OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE OWNER
------------------- ------------------------------
SYS_PLSQL_54180_87_1
TYPE APPS
SQL> alter type SYS_PLSQL_54180_87_1 compile;
Warning: Type altered with compilation errors.
SQL> show errors;
Errors for TYPE SYS_PLSQL_54180_87_1:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/46 PLS-00201: identifier 'APPS.SYS_PLSQL_54140_2348_1' must be
declared

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!

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