Memory-Based Snapshot (MSCNSP) or Memory Based Snapshot 64-bit (MSCNSP64) Errors With APP-FND-01564, ORA-01405, Begin msc_snapshot_pk.calculate_plan_buckets
(Doc ID 1324086.1)
Last updated on OCTOBER 01, 2018
Applies to:Oracle Advanced Supply Chain Planning - Version 22.214.171.124 and later
Information in this document applies to any platform.
Executable:MSCNSP - Memory-Based Snapshot
Users are running an ASCP plan. However it fails with the following errors in MSCNSP - Memory Based Snapshot or any of the 64 bit Memory Based Snapshots for HP, HP Itanium, Sun, Linux, IBM AIX
APP-FND-01564: ORACLE error 1405 in main
Cause: main failed due to ORA-01405: fetched column value is NULL
The SQL statement being executed at the time of the error was: begin =
msc_snapshot_pk . calculate_plan_buckets ( :plan_id , :err_mesg: and was =
executed from the file .
APP-MRP-22075: An internal error has occurred (main, 1, , )
1. Navigate to Responsibility > Advanced Supply Chain Planner.
2. Run an ASCP Plan
3. The Memory Based Snapshot ends with multiple errors
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