My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

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

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
Cause
 General Information
 Specific information
Solution
 The Patch Level must be correct between both instances.
 Required Setup on the Instances Form when collecting from 11.5.10 ERP Source
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.