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 laterInformation in this document applies to any platform.
Symptoms
On : 16.0.3 version, Financials
ACTUAL BEHAVIOR
---------------
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
STEPS
-----------------------
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)
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 |
| References |