Duplicate Record Of New Hierarchy In New Partition Of Inventory After Reclassification In EOM (Doc ID 2223686.1)

Last updated on JANUARY 23, 2017

Applies to:

Oracle Retail Merchandising Insights - Version 13.2 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.

Symptoms

When performing reclassification at EOM date encountering another issue.

This  inserted inventory of new hierarchy twice in W_RTL_INV_IT_LC_DY_F and W_RTL_INV_IT_LC_WK_A table. So, there are  duplicate records for the reclassified organization or product.

• PLP_RETAILFACTOPENFACT inserts the new hierarchy in Next partition (P88) which is effective from EOM(current vdate)+1
• PLP_RETAILFACTCLOSEFACT closes the old hierarchy in previous partition(P77)
• PLP_RETAILPARTSEEDFACT inserts all the open records (including new hierarchy records that was already inserted by PLP_RETAILFACTOPENFACT) from W_RTL_INV_IT_LC_G tables to W_RTL_INV_IT_LC_DY_F and W_RTL_INV_IT_LC_WK_A and the result is duplicate records.


Steps to Reproduce:

RA --First Batch Cycle
1. SDE_RETAILETLREFRESHGENERAL (etlrefreshgensde.ksh)
2. PLP_RETAILETLREFRESHGENERAL (etlrefreshgenplp.ksh)
3. SDE_RETAILORGANIZATIONDIMENSIONHIERARCHY (orghiersde.ksh)
4. SDE_RETAILORGANIZATIONFINANCEDIMENSION (orgfinsde.ksh)
5. SDE_RETAILLOCATIONDIMENSION (orglocsde.ksh)
6. SIL_RETAILORGANIZATIONFINANCEDIMENSION (orgfinsil.ksh)
7. SIL_INTERNALORGANIZATIONHIERARCHY (orghiersil.ksh)
8. SIL_INTERNALORGANIZATIONDIMENSION (orgsil.ksh)
9. PLP_RETAILORGANIZATIONDIMENSIONLKUPTEMP (orgdimlkuptmpplp.ksh)
10. PLP_RETAILORGANIZATIONDIMENSIONRECLASSTEMP (orgdimreclassplp.ksh)

RA -- Second Batch Cycle
1. PLP_RETAILFACTOPENFACT (factopenplp.ksh)
2. PLP_RETAILFACTCLOSEFACT (factcloseplp.ksh)
3. PLP_RETAILPARTSEEDFACT (retailpartseedfactplp.ksh)
4. SDE_RETAILETLREFRESHGENERAL (etlrefreshgensde.ksh)
5. PLP_RETAILETLREFRESHGENERAL (etlrefreshgenplp.ksh)

Changes

 

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