Planning Data Pull Failing With ORA-06553/PLS-306 In Call To OGC_X For Procedure LOAD_SALES_ORDER(1) (Doc ID 1346801.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0.4 to 12.0.6 [Release 12]
Information in this document applies to any platform.

Symptoms

You currently have a 12.1.3.4 Planning instance connected to a 12.0.6 Source instance (with Collections CU9 applied). When running the Planning Data Collection, the Planning Data Pull program is failing with the following error:
Planning Data Pull Worker Error:

27-JUL 22:23:29 : Procedure MSC_CL_DEMAND_PULL.LOAD_SALES_ORDER(1) started.
27-JUL 22:23:29 : Error pulling data from MRP_AP1_SALES_ORDERS_V to MSC_ST_SALES_ORDERS.
27-JUL 22:23:29 : ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'
27-JUL 22:23:29 : ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'
27-JUL 22:23:29 : Error_Stack...
27-JUL 22:23:29 : ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'
27-JUL 22:23:29 : Error_Backtrace...
27-JUL 22:23:29 : ORA-06512: at "APPS.MSC_CL_PULL", line 6388
ORA-06512: at "APPS.MSC_CL_PULL", line 1686

 

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