Invalid PACKAGE BODY PON_DRT_PKG And PACKAGE PO_DRT_PKG With Errors PLS-00201 PLS-00905 PLS-00304 PLS-00304 (Doc ID 2778990.1)

Last updated on APRIL 20, 2023

Applies to:

Symptoms

After applying CLM patch 28945350:R12.PO.D there are many invalid objects in package PON_DRT_PKG and PO_DRT_PKG.
While trying to compile those invalid objects the follwoing error apepars :

Errors
--------------
PON_DRT_PKG PON_DRT_PKG.plb BODY INVALID
Errors for PACKAGE BODY PON_DRT_PKG
PLS-00201: identifier 'PON_DRT_PKG' must be declared
PLS-00304: cannot compile body of 'PON_DRT_PKG' without its specification
PL/SQL: Compilation unit analysis terminated

PO_DRT_PKG PO_DRT_PKG.pls SPEC INVALID
Errors for PACKAGE PO_DRT_PKG
PLS-00201: identifier 'PER_DRT_PKG.RESULT_TBL_TYPE' must be declared
PL/SQL: Declaration ignored
PLS-00201: identifier 'PER_DRT_PKG.RESULT_TBL_TYPE' must be declared

PO_DRT_PKG PO_DRT_PKG.pls SPEC INVALID
Errors for PACKAGE BODY PO_DRT_PKG
PLS-00905: object APPS.PO_DRT_PKG is invalid
PLS-00304: cannot compile body of 'PO_DRT_PKG' without its specification

STEP
--------
1. Apply CLM patch 28945350:R12.PO.D
2. Find invalid objects in package PON_DRT_PKG and PO_DRT_PKG

Cause

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