MSCPDPW ORA-06553 PLS-306 To OGC_X Pulling From MRP_AP Views (Doc ID 744598.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Oracle Advanced Supply Chain Planning - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

For a configuration of a 12.0.4 Planning Destination collecting from an 11.5.10 ERP Source, when attempting to run Planning Data Collection, the following error occurs:

Error pulling data from MRP_AP_NOCOST_SYSTEM_ITEMS_V to MSC_ST_SYSTEM_ITEMS.
ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'
ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'


OR

16-MAR 11:11:18 : Error pulling data from MRP_AN2_SALES_ORDERS_V to MSC_ST_SALES_ORDERS.
16-MAR 11:11:18 : ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'
16-MAR 11:11:18 : ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'


Steps To Reproduce:
1. Responsibility: Advanced Supply Chain Planner
2. Navigation: Collections > Oracle Systems > Standard Collection


Note that if the error pulling data is from a view that is not from MRP_AP_NOCOST_SYSTEM_ITEMS_V, the specific cause and solution of this note do not apply.

A problem with an MRP_AP_%_V view can cause the error

ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'

to be reported. Each specific view problem will have it's own root cause and individual solution.

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