Error ORA-01400: Cannot Insert NULL IDEAL_ACTUALS_ITEM_LOC. REPORTING_DATE
(Doc ID 2899622.1)
Last updated on SEPTEMBER 30, 2022
Applies to:Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.
On : 16.0.3 version, Financials
When processing the POSU file, salesprocess does not consider the Agreement Closing Date, and rejects the file for processing. Returned by program unit CORESVC_SALES_UPLOAD_PRST_SQL.PERSIST_DEAL_ACTUALS_IL
The issue can be reproduced at will with the following steps:
1. Generate POSU files with deal promotion as expired one.
2. Run uploadsales.ksh and salesprocess.ksh batches.
3. Notice the below error:
@0PACKAGE_ERROR@1ORA-01400: cannot insert NULL into ("RMS01"."DEAL_ACTUALS_ITEM_LOC"."REPORTING_DATE")@2CORESVC_SALES_UPLOAD_PRST_SQL.PERSIST_DEAL_ACTUALS_IL)
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