Inconsistent Failure During Loading Of Non-Merchandise Item Records In RTLOG (Doc ID 1466839.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Sales Audit - Version 13.1.5.1 and later
Information in this document applies to any platform.
Checked for relevance on December 3rd, 2013.

Symptoms

In Oracle Retail Sales Audit (ReSA) 13.1.5.1:

For some RTLOG files containing transactions with non-merchandise items, no transactions get loaded. But SA_STORE_DAY shows the DATA_STATUS as Fully loaded and Closes the store even without a DCLOSE record. No records exist on SA_TRAN_HEAD and other related tables. And yet, this does not happen for all Non-Merchandise Items. Some Sale and Return transactions with Non-Merchandise items are loaded successfully.

Steps to Reproduce
Prerequisites:
  The Non-Merchandise Item(NMITEM) does not exist in Retail Merchandising System(RMS).
  SYSTEM_OPTIONS.DEFAULT_TAX_TYPE=GTAX and VAT_IND=N
1. Create an RTLOG with NMITEM as item_type of TITEM record group.
2. Run the required ReSA batch jobs before loading the RTLOG.
3. Run saimptlogi batch job to load in ReSA.
4. Transactions do not get uploaded into ReSA.
    The following error message is generated on $MMHOME/error folder:
saimptlogi_1~20120412112120~flushTranInsertArrays~sa_tran_item~-1400~ORA-01400: cannot insert NULL into ("RMS13"."SA_TRAN_ITEM"."UNIT_RETAIL_VAT_INCL")~Cannot INSERT - row=0

The saimptlogi.bad file is empty.

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