My Oracle Support Banner

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

Last updated on MAY 16, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.