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


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