My Oracle Support Banner

FA: SCM: SCP: Backlog Plan Run Ending in Error: ORA-01400: cannot insert NULL into (???) (Doc ID 2758910.1)

Last updated on MAY 04, 2021

Applies to:

Oracle Supply Planning Cloud Service - Version 11.13.21.01.0 and later
Information in this document applies to any platform.

Symptoms

While running backlog plan in simulation mode or using scheduled process for specific org, plan run fails in error:

ERROR : 10001 : ORA-01400: cannot insert NULL into (???)

Steps to reproduce:

Simulation Run:
1. Navigate to Backlog Analysis UI
2. Search for the order and Org
3. Order lines are listed
4. Click on refresh and plan
5. Plan Id:<plan id>, ends in error

Scheduled Process run:
1. Navigate to Schedule Process UI.
2. New Process-> Start Backlog Planning -> Input organization
3. Click on Submit
4. Request ends in error

Changes

 

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
Changes
Cause
Solution
References


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