Unable To Compile OE_CREDIT% Invalid Objects After Upgrade to 12.0.6 (Doc ID 781103.1)

Last updated on FEBRUARY 29, 2016

Applies to:

Oracle Order Management - Version: 12.0.6 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.
***Checked for relevance on 04-Jan-2011***

Symptoms

-- Problem Statement:
After applying patches to upgrade from R12 RUP4 to R12 RUP6, the following objects are remaining as --

INVALID. Attempt to re-compile are failing.

List of invalid objects:

OWNER OBJECT_NAME               OBJECT_TYPE
----- ------------------------- -------------
APPS  OE_CREDIT_CHECK_LINES_PVT PACKAGE BODY
APPS  OE_CREDIT_CHECK_ORDER_PVT PACKAGE BODY
APPS  OE_CREDIT_CHECK_UTIL      PACKAGE BODY
APPS  OE_CREDIT_ENGINE_GRP      PACKAGE BODY

Error messages showing in aderrchk.sql output:

LINE ERROR
---- -------------------------------------------------------------
PACKAGE BODY OE_CREDIT_CHECK_LINES_PVT
   0 PLS-00907: cannot load library unit APPS.OE_CREDIT_CHECK_UTIL
(referenced by APPS.OE_CREDIT_EXPOSURE_PVT)
2231 PL/SQL: Statement ignored

PACKAGE BODY OE_CREDIT_CHECK_ORDER_PVT
   0 PLS-00907: cannot load library unit APPS.OE_CREDIT_CHECK_UTIL
(referenced by APPS.OE_CREDIT_EXPOSURE_PVT)
1736 PL/SQL: Statement ignored

PACKAGE BODY OE_CREDIT_CHECK_UTIL
   0 PLS-00907: cannot load library unit APPS.OE_CREDIT_CHECK_UTIL
(referenced by APPS.OE_CREDIT_EXPOSURE_PVT)
5529 PL/SQL: Statement ignored

PACKAGE BODY OE_CREDIT_ENGINE_GRP
   0 PLS-00907: cannot load library unit APPS.OE_CREDIT_CHECK_UTIL
(referenced by APPS.OE_CREDIT_EXPOSURE_PVT)
   0 PLS-00907: cannot load library unit APPS.OE_CREDIT_CHECK_UTIL
(referenced by APPS.OE_CREDIT_EXPOSURE_PVT)
   0 PLS-00907: cannot load library unit APPS.OE_CREDIT_CHECK_UTIL
(referenced by APPS.OE_CREDIT_EXPOSURE_PVT)
 663 PL/SQL: Statement ignored
 808 PL/SQL: Statement ignored
1033 PL/SQL: Statement ignored

Changes

Upgrade to 12.0.6.

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