MSC_CL_PRE_PROCESS Object Got Invalid After Applying the ASCP Patch:1273102 (Doc ID 2078702.1)

Last updated on NOVEMBER 25, 2015

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.
MSCPPW - MSC Pre Process Worker
MSCPPM - Pre-Process Monitor

Symptoms

Problem Statement
After applying the ASCP <Patch.12731023>, MSC_CL_PRE_PROCESS Object got invalid. 

When trying to compile, it finishes compile with the following error messages.

Error
LINE/COL ERROR
-------- -----------------------------------------------------------------
345/5 PL/SQL: Statement ignored
345/5 PLS-00201: identifier 'G_WARNING_FLAG' must be declared
362/7 PL/SQL: Statement ignored
362/7 PLS-00201: identifier 'G_WARNING_FLAG' must be declared
378/5 PL/SQL: Statement ignored
378/5 PLS-00201: identifier 'G_WARNING_FLAG' must be declared
394/7 PL/SQL: Statement ignored
394/7 PLS-00201: identifier 'G_WARNING_FLAG' must be declared
3331/2 PL/SQL: SQL Statement ignored
3335/6 PL/SQL: ORA-00904: "MSC_ST_UTIL"."IS_NUMBER": invalid identifier
3335/18 PLS-00302: component 'IS_NUMBER' must be declared
3335/18 PLS-00302: component 'IS_NUMBER' must be declared
3337/2 PL/SQL: SQL Statement ignored
3342/6 PL/SQL: ORA-00904: "MSC_ST_UTIL"."IS_NUMBER": invalid identifier
3342/18 PLS-00302: component 'IS_NUMBER' must be declared
3342/18 PLS-00302: component 'IS_NUMBER' must be declared
3387/3 PL/SQL: SQL Statement ignored
3391/7 PL/SQL: ORA-00904: "MSC_ST_UTIL"."IS_NUMBER": invalid identifier
3391/19 PLS-00302: component 'IS_NUMBER' must be declared
3391/19 PLS-00302: component 'IS_NUMBER' must be declared

Steps to Reproduce

  1. Applying the ASCP <Patch.12731023>

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