Inconsistent Failure During Loading Of Non-Merchandise Item Records In RTLOG
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Sales Audit - Version 22.214.171.124 and later
Information in this document applies to any platform.
Checked for relevance on December 3rd, 2013.
In Oracle Retail Sales Audit (ReSA) 126.96.36.199:
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
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.
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