Salesprocess Batch Is Failing With "ORA-01400: cannot insert NULL into ("RMS"."DAILY_SALES_DISCOUNT"."PROM_COMPONENT")" Error For Transactions With In store Discount
Last updated on NOVEMBER 29, 2017
Applies to:Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.
When application is trying to process uploaded sales using the salesprocess batch, the following errors occur:
Steps to Reproduce:
- Create from Oracle Retail Sales Audit (ReSA) front end a sale transaction with "In store Discount" discount. The ReSA store day should be already opened.
- Audit the day and generate the POSU file
- Upload and process the POSU file on RMS
- The following errors occur:
salesprocess~20170918051028~EXEC_SQL_T~@0PACKAGE_ERROR@1ORA-01400: cannot insert NULL into ("RMS01"."DAILY_SALES_DISCOUNT"."PROM_COMPONENT")@2CORESVC_SALES_UPLOAD_PRST_SQL.PERSIST_DAILY_SALES_DISCOUNT
salesprocess~20170918051028~PROCESS_SALES~CORESVC_SALES_UPLOAD_SQL.PROCESS_SALES Process:40001 Thread: Failed.
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