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 SEPTEMBER 03, 2021
Applies to:Oracle Advanced Supply Chain Planning - Version 11.5.10 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
before call to calculate plan buckets=20
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