R12.2 : Requisition Error - Jsava.sql.SQLException: ORA-04063: package body (Doc ID 1986432.1)

Last updated on AUGUST 24, 2015

Applies to:

Oracle iProcurement - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

In iProcurement when creating Requisitions, the following exception is returned:

EXCEPTION ERROR :

Java.sql.SQLException: ORA-04063: package body "APPS.PO_REQAPPROVAL_INIT1" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.PO_REQAPPROVAL_INIT1"
ORA-06512: at "APPS.POR_UTIL_PKG", line 1589


Steps to reproduce :

1. Navigate to iProcurement
2. Attempt to create requisition
3. Receive  exception

Purchasing Diagnostic Apps check found the following Invalid objects:

PO_REQAPPROVAL_INIT1 POXWPA1S.pls 120.23.12020000.3 SPEC VALID
PO_REQAPPROVAL_INIT1 POXWPA1B.pls 120.141.12020000.20 BODY INVALID

Errors for PACKAGE BODY PO_REQAPPROVAL_INIT1

PLS-00201: identifier 'PO_MULTI_MOD_DOCS.MULTI_MOD_REQUEST_ID' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'PO_MULTI_MOD_REQUESTS.MULTI_MOD_REQUEST_TYPE' must be declared
PL/SQL: Item ignored
...
PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: Statement ignored
...
PO_MULTI_MOD_PVT PO_MULTI_MOD_PVT.pls 120.4 SPEC VALID
PO_MULTI_MOD_PVT PO_MULTI_MOD_PVT.plb 120.11.12020000.3 BODY INVALID

Errors for PACKAGE BODY PO_MULTI_MOD_PVT

PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored
...
PLS-00201: identifier 'PO_MULTI_MOD_REQUESTS' must be declared
PL/SQL: Item ignored
...

PO_MULTI_MOD_VALIDATIONS PO_MULTI_MOD_VALIDATIONS. 120.8.12020000.2 SPEC VALID
PO_MULTI_MOD_VALIDATIONS PO_MULTI_MOD_VALIDATIONS. 120.21.12020000.5 BODY INVALID

Errors for PACKAGE BODY PO_MULTI_MOD_VALIDATIONS

PLS-00201: identifier 'PO_MULTI_MOD_REQUESTS.MULTI_MOD_REQUEST_TYPE' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'PO_MULTI_MOD_REQUESTS.NOVATION_EFFECTIVE_DATE' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'PO_MULTI_MOD_REQUESTS.ACCEPTANCE_REQUIRED_FLAG' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'PO_MULTI_MOD_REQUESTS.ACCEPTANCE_DUE_DATE' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'PO_MULTI_MOD_REQUESTS.CLM_NOOFCOPIES' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'PO_MULTI_MOD_REQUESTS.EXEMPTION_REASON' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'PO_MULTI_MOD_REQUESTS.INITIATE_APPROVAL_FLAG' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'PO_MULTI_MOD_REQUESTS.CLM_CONTRACT_OFFICER' must be declared
PL/SQL: Item ignored
PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored


 

Changes

 Upgrade to release 12.2

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