My Oracle Support Banner

IVTILDEX Batch Generating File with Duplicate Value (Doc ID 2468477.1)

Last updated on MARCH 09, 2019

Applies to:

Oracle Retail Data Warehouse - Version 13.0.2 and later
Information in this document applies to any platform.

Symptoms

IVTILDEX batch generating file with duplicate value. There is data mismatch in the below aggregation tables when compared with base table INV_TSF_ITEM_LD_DM.

INV_TSF_DEPT_LD_DM
INV_TSF_DEPT_LW_DM
INV_TSF_SBC_LD_DM
INV_TSF_SBC_LW_DM
INV_TSF_ITEM_LW_DM

Steps To Recreate:

1. Create a predist allocation for multiple stores(including inter company and intra company).
2. Ship allocation.
3. Execute exctract batch(ivtildex.ksh).
4. Check ivtilddm.txt file generated by ivtildex batch.



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.