MSCNSW Memory Based Snapshot Worker Errors With ORA-06553 (Doc ID 311377.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10 and later
Information in this document applies to any platform.
EXECUTABLE:MSCNSW - Memory-Based Snapshot Worker
EXECUTABLE:MSCNSP - Memory-Based Snapshot

Symptoms

MSCNSW module: Memory-Based Snapshot Worker errors with the following:

APP-FND-01564: ORACLE error 6553 in mrsnss_snp_safety_stock

Cause: mrsnss_snp_safety_stock failed due to ORA-06553: PLS-306: wrong number or types of arguments in call to 'GET_SS_DATE'

The SQL statement being executed at the time of the error was: select safety.organization_id
,safety.inventory_item_id ,msc_snapshot_ and was executed from the file 2250399/msc/src/mslsmc.pc.
APP-MRP-22075: An internal error has occurred (mrnspxt, 20, 10009, )
APP-MRP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10009, )
APP-MRP-22075: An internal error has occurred (main, 13, , )


Statement with the error:

select safety.organization_id ,safety.inventory_item_id ,msc_snapshot_
2250399/msc/src/mslsmc.pc

 

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