My Oracle Support Banner

Upon Organization Reclassification, the Dimension Hierarchy Column ORG_DH_WID for the Location Is Not Updated (Doc ID 2090660.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

IMPROPER MAPPING OF ORG_CH_WID IN PLP_RETAILORGANIZATIONDIMENSIONRECLASSPRETEMPL.


Steps to Reproduce:

  1. Run the package PLP_RETAILORGANIZATIONDIMENSIONRECLASSTEMP
  2. The package will execute interface: PLP_RetailOrganizationDimensionReclassPreTempLoad and PLP_RetailOrganizationDimensionReclassTempLoad
  3. In Interface PLP_RetailOrganizationDimensionReclassPreTempLoad, it is loading incorrect mapping for column W_INT_ORG_RECLASS_TMP.ORG_CH_WID = W_INT_ORG_DH_RTL_TMP.ORG_CH_NUM

 

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.