My Oracle Support Banner

Duplicate Inserts in DAILY_DATA_BACKPOST While SALDLY is Run with Multiple Threads (Doc ID 2296963.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Merchandising System - Version 14.0.1 and later
Information in this document applies to any platform.


When attempting to run SALDLY batch, the program inserts duplicate entries in DAILY_DATA_BACKPOST when an open stock count exists in closed month and late transactions present in IF_TRAN_DATA as part of closed month whose TRAN_DATE is less or equal to stock take date.

Steps to Reproduce:

1. Create stock count request.
3. Close the stock take month.
4. In current month create transactions with TRAN_DATE less or equal to stock take date whose department/class/subclass exists in STAKE_PROD_LOC.
5. Run SALSTAGE to move the above transactions from TRAN_DATA to IF_TRAN_DATA.
6. Run SALDLY with multiple threads.
7. Note that post batch execution we can find duplicate entries in DAILY_DATA_BACKPOST.




To view full details, 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 a vibrant support community of peers and Oracle experts.