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.6Information 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 ignoredChanges
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! |
In this Document
Symptoms
Changes
Cause
Solution
References