My Oracle Support Banner

Error Occurring When Processing Majority of POSU Files (Doc ID 2815357.1)

Last updated on OCTOBER 19, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

Error occurring when processing majority of POSU files.

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

Steps to Recreate:

  1. Generate POSU files.
  2. Run uploadsales and salesprocess 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.