Salesprocess Batch Is Failing With "ORA-01400: cannot insert NULL into ("RMS"."DAILY_SALES_DISCOUNT"."PROM_COMPONENT")" Error For Transactions With In store Discount

(Doc ID 2331947.1)

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.

Symptoms

When application is trying to process uploaded sales using the salesprocess batch, the following errors occur:


Steps to Reproduce:

  1. 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.
  2. Audit the day and generate the POSU file
  3. Upload and process the POSU file on RMS
  4. 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.



Cause

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