MRCRLF - Planning Manager Fails with ORA-01407 Error NEW_SCHEDULE_QUANTITY (Doc ID 214289.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 11.5.5 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


Materials Requirement Planning - Version: 11.5.5 to 12.1
EXECUTABLE:MRCRLF - Planning Manager
FORM:MRPFUSSM.FMB - Start Planning Manager


Symptoms

PROBLEM

Planning manager errors with error in the log file
begin mrp_manager_pk . compute_sales_order_changes ( :request_id , :us
2769918/mrp/src/mrlscc.pc

In the Planning Manager Form (NAV: MRP / Setup / Planning Manager
we see error information is
ORACLE error 1407 in mrcsoc_compute_sales_order_changes

Cause: mrcsoc_compute_sales_order_changes failed due to ORA-01407:
cannot update ("MRP"."MRP_SALES_ORDER_UPDATES"."NEW_SCHEDULE_QUANTITY") to NULL ORA-06512: at "APPS.MRP_MANAGER_PK"

STEPS

Start the planning manager

BUSINESS IMPACT

cannot plan for the business

Verified by
uploaded error message from the planning manager form shown above

Whenever the planning manager log file shows
begin mrp_manager_pk . compute_sales_order_changes ( :request_id , :us

then see the messages in the form for the required additional information about the error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms