After Post Void Of One Of Duplicated Transactions, Simptlogfin Is Voiding Also The Second One (Doc ID 1436373.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Sales Audit - Version 13.1.2.4 and later
Information in this document applies to any platform.

Symptoms

When performing a post void for one of the duplicate transactions , SAIMPTLOGFIN batch is voiding both the transactions.

Steps To Reproduce:

1. Create a store/day.

2. Upload a RTLOG file two times for a particular store day and run all RESA (Retail Sales Audit) batches with "Posupld" batch.

For example if the TRAN_SEQ_NO for the first transaction is 15011001, and for the duplicate transaction is 15012001. SA_EXPORTED also have export record for both tran_seq_nos.

3. Post void the duplicate transaction (15012001), new TRAN_SEQ_NO 27371001 is generated for the PVOID transaction.

4. Run "Saimptlogfin" batch, all transactions getting status 'V', instead of the voided transaction only.
Also the original transaction 15011001 gets deleted from SA_EXPORTED table, only duplicate transaction 15012001 existing there.

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