Planning Data Pull failing with Error - ORA-06512: at "APPS.MSC_CL_PULL", line 1686 - in a Distributed environment. (Doc ID 1306597.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Process Manufacturing Process Planning - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

Using a de-centralised APS setup, where the APS instance is 12.1.3.2 and the EBS Source instance is on 12.0.6

When running the Planning Data Collection, they have reported the Error mentioned below in the Planning Data Pull logfile.

<Note 1211093.1> refers to this error and recommends applying Patch 10075785:R12.GMP.B.
The Readme of this patch suggests applying Patch 8467054:R12.GMP.A to the ERP Source instance for Rel 12.0.4/ 12.0.6.

The cust has applied the Patch 8467054:R12.GMP.A to the ERP Source instance, bounced both the Source and Destination instances and re-ran the Planning Data Collection.

The file versions are -

Destination : - GMPBMRTB.pls 120.32.12010000.24
Source :- GMPUTILB.pls 120.0.12000000.2

The error, however, has persisted.


ERROR

03-MAR 16:34:58 : Procedure MSC_CL_BOM_PULL.LOAD_BOM started.
03-MAR 16:35:02 : WSM_COPRODUCT_SPLIT_PERC Exists
l_in_str_org IN (162,1503,1532,1564,1585,1604,1605,1606,1607,1608,1723,1743,1794,1804,1865,1868,1874,1879,1881,1889,1890,1894,1896,1993)
03/03/2011 16:35:04
Calling populate_eff
Error retrieving effectivities: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'POPULATE_EFF'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Effectivity extraction failed
03-MAR 16:35:04 : Error in Routine GMP_BOM_ROUTING_PKG.EXTRACT_EFFECTIVITIES.
03-MAR 16:35:04 : User-Defined Exception
03-MAR 16:35:04 : User-Defined Exception
03-MAR 16:35:04 : Error_Stack...
03-MAR 16:35:04 : ORA-06510: PL/SQL: unhandled user-defined exception

03-MAR 16:35:04 : Error_Backtrace...
03-MAR 16:35:04 : ORA-06512: at "APPS.MSC_CL_PULL", line 6388
ORA-06512: at "APPS.MSC_CL_PULL", line 1686


STEPS
-----------------------
1. Run the Planning Data Pull.

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