My Oracle Support Banner

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 MARCH 15, 2022

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2 and later
Information in this document applies to any platform.

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

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.