My Oracle Support Banner

Planning Manager and MDS Fail with ORA-01400 MRP_SALES_ORDER_UPDATES.NEW_SCHEDULE_DATE (Doc ID 268971.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Materials Requirement Planning - Version 11.5.6 and later
Information in this document applies to any platform.
Materials Requirement Planning - Version: 11.5.6 to 12.1
MRCRLF Planning Manager
MRCSAL1 Load/Copy/Merge MDS


Symptoms

Planning Manager and/or Load/Copy/Merge MDS process fails with error messages
that can contain one or more of the following examples:

begin mrp_manager_pk . compute_sales_order_changes ( :request_id , :us 2479230/mrp/src/mrlscc.pc

ORACLE error 1400 in mrcsoc_compute_sales_order_changes

Cause: mrcsoc_compute_sales_order_changes failed due to
ORA-01400: cannot insert NULL into (MRP.MRP_SALES_ORDER_UPDATES.NEW_SCHEDULE_DATE)


The Planning Manager concurrent request log file can show a message similar to:

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

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