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

Last updated on MAY 17, 2017

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Purchasing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

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

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 hundreds of Community platforms