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!

In this Document
  Symptoms
  Cause
  Solution
     Standard Patching Process
     Patch Wizard
     Have more questions?
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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