Multiple invalid objects after CLM RUP3 patches (Doc ID 1605736.1)

Last updated on SEPTEMBER 20, 2021

Applies to:

Symptoms

After upgrading Release 11.5.10 instance to Release 12.1.3 and applied Contract Lifecycle Management CLM RUP patches, multiple objects are invalid.

Listing of invalid objects and error details:

PO_CHANGE_RESPONSE_PVT
[Error] PLS-00323 (22: 11): PLS-00323: subprogram or cursor 'MOVECHANGETOPO' is declared in a package specification and must be defined in the package body

PO_DOCUMENT_CONTROL_PUB
"[Error] PLS-00302 (193: 48): PLS-00302: component 'ENTITY_DTL_REC_TYPE_TBL' must be declared
[Error] PLS-00320 (254: 5): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] PLS-00320 (291: 7): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] PLS-00320 (292: 7): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] PLS-00320 (293: 7): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] PLS-00320 (294: 7): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] PLS-00320 (297: 9): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] PLS-00320 (298: 9): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] PLS-00320 (301: 9): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] PLS-00320 (302: 9): PLS-00320: the declaration of the type of this expression is incomplete or malformed"

PO_DOCUMENT_REVISION_GRP
[Error] PLS-00323 (173: 11): PLS-00323: subprogram or cursor 'CHECK_REV_DIFF' is declared in a package specification and must be defined in the package body

PO_PERIODS_SV
"[Error] PLS-00323 (30: 13): PLS-00323: subprogram or cursor 'GET_GL_DATE' is declared in a package specification and must be defined in the package body
[Error] PLS-00323 (34: 13): PLS-00323: subprogram or cursor 'BUILD_GL_ENCUMBERED_DATE' is declared in a package specification and must be defined in the package body"

PO_REQAPPROVAL_FINDAPPRV1
/* $Header: POXWPA3B.pls 120.8.12010100.2 2010/11/19 11:23:04 inagdeo ship $ */
[Error] PLS-00305 (49: 1): PLS-00305: previous use of 'CHECKOWNERCANAPPROVE' (at line 215) conflicts with this use
[Error] PLS-00328 (49: 11): PLS-00328: A subprogram body must be defined for the forward declaration of CHECKOWNERCANAPPROVE.PO_WF_PO_RULE_ACC

PO_WF_PO_RULE_ACC
/* $Header: POXRUACB.pls 120.1.12010100.2 2011/05/10 07:03:32 uchennam ship $*/
[Error] PLS-00323 (76: 11): PLS-00323: subprogram or cursor 'IS_OVERRIDE_CHARGE_ACCOUNT' is declared in a package specification and must be defined in the package body

PO_ChangeOrderWF_PVT
/* $Header: POXVSCWB.pls 120.42.12010100.9 2011/11/18 10:44:30 ppotnuru ship $ */
[Error] PLS-00302 (7498: 26): PLS-00302: component 'MOVECHANGETOPO' must be declared

PO_REQCHANGEREQUESTWF_PVT
/* $Header: POXVRCWB.pls 120.82.12010100.10 2012/04/27 08:41:33 rojain ship $ */
[Error] PLS-00302 (2364: 36): PLS-00302: component 'MOVECHANGETOPO' must be declared
[Error] PLS-00302 (2772: 36): PLS-00302: component 'MOVECHANGETOPO' must be declared

PO_DOCUMENT_UPDATE_GRP
/* $Header: POXGCPOB.pls 120.5.12010100.1 2011/07/26 21:37:03 ajunnikr ship $*/
[Error] PLS-00323 (23: 11): PLS-00323: subprogram or cursor 'UPDATE_DOCUMENT' is declared in a package specification and must be defined in the package body

PO_CONTROL_ACTION_VALIDATIONS (Specification)
/* $Header: PO_CONTROL_ACTION_VALIDATIONS.pls 120.0 2012/06/28 09:14:29 vlalwani noship $*/
[Error] PLS-00302 (18: 54): PLS-00302: component 'DOC_ACTION_CALL_TBL_REC_TYPE' must be declared
[Error]  (17: 1): PL/SQL: Declaration ignored

PO_CONTROL_ACTION_VALIDATIONS (Body)
/* $Header: PO_CONTROL_ACTION_VALIDATIONS.plb 120.0 2012/06/28 09:15:19 vlalwani noship $ */
[Error] PLS-00905 (1: 19): PLS-00905: object APPS.PO_CONTROL_ACTION_VALIDATIONS is invalid
[Error] PLS-00304 (1: 19): PLS-00304: cannot compile body of 'PO_CONTROL_ACTION_VALIDATIONS' without its specification
[Error]  (0: 0): PL/SQL: Compilation unit analysis terminated

PO_AUBI_SERVICES (Specification)
/* $Header: PO_AUBI_SERVICES.pls 120.0.12010100.2 2012/06/28 19:00:39 rarajar noship $ */
[Error] PLS-00201 (44: 47): PLS-00201: identifier 'WF_SVC_NTF_HIST_ARRAY' must be declared
[Error]  (43: 3): PL/SQL: Declaration ignored

PO_AUBI_SERVICES (Body)
-- $Header: PO_AUBI_SERVICES.plb 120.0.12010100.4 2012/11/27 03:17:02 beyi noship $
[Error] PLS-00905 (1: 19): PLS-00905: object APPS.PO_AUBI_SERVICES is invalid
[Error] PLS-00304 (1: 19): PLS-00304: cannot compile body of 'PO_AUBI_SERVICES' without its specification
[Error]  (0: 0): PL/SQL: Compilation unit analysis terminated

PO_VAL_DISTRIBUTIONS2
 -- $Header: PO_VAL_DISTRIBUTIONS2.plb 120.16.12010100.4 2011/03/08 16:55:34 vrecharl ship $
PLS-00306: wrong number or types of arguments in call to 'VALIDATE_PROJECT_INFO'
PL/SQL: Statement ignored

PO_PDOI_DISTRIBUTIONS_SV3
/* $Header: POXPIDVB.pls 120.2.12010100.2 2010/10/01 07:06:35 sprao ship $ */
[Error] PLS-00306 (673: 20): PLS-00306: wrong number or types of arguments in call to 'VALIDATE_PROJECT_INFO'
[Error] PLS-00323 (133: 11): PLS-00323: subprogram or cursor 'VALIDATE_PROJECT_INFO' is declared in a package specification and must be defined in the package body

PO_UOM_S
/* $Header: RCVTXU1B.pls 120.8.12010100.1 2010/11/22 07:01:02 vlalwani ship $*/
[Error] PLS-00323 (320: 10): PLS-00323: subprogram or cursor 'RTI_TRX_QTY_TO_SOC_QTY' is declared in a package specification and must be defined in

Changes

Apply 12.1.3 CLM RUP patches.

Cause

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