MSCPDPW ORA-06553 PLS-306 To OGC_X Pulling From MRP_AP Views
(Doc ID 744598.1)
Last updated on JANUARY 03, 2023
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:
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 : 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
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 |