My Oracle Support Banner

Publish Order/Returns Forecast Program Completed With Warning ORA-01400: cannot insert NULL into ("MSC"."MSC_SUP_DEM_ENTRIES"."PUBLISHER_ID") (Doc ID 2013323.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.


Publish Order/Returns Forecast program completed with Warning

When ASCP planned orders are published using Publish Order/Returns Forecast program, it completes with warning status.

insert failed on else statement with base item ORA-01400: cannot insert NULL into ("MSC"."MSC_SUP_DEM_ENTRIES"."PUBLISHER_ID")
Error in insert_sup_dem_entries: ORA-01400: cannot insert NULL into ("MSC"."MSC_SUP_DEM_ENTRIES"."PUBLISHER_ID")

The issue can be reproduced at will with the following steps:
1. Run the Publish Order Returns Forecast program


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.