My Oracle Support Banner

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 11.5.10.2 and later
Information in this document applies to any platform.
Executable:MSCNSP - Memory-Based Snapshot

Symptoms

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, , )


STEPS:
1. Navigate to Responsibility > Advanced Supply Chain Planner.
2. Run an ASCP Plan
3. The Memory Based Snapshot ends with multiple errors

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
Solution


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