Purge Data Repository ESS Process Does Not Purge UOM (Unit Of Measure) Cross Reference Data (Doc ID 1540841.1)

Last updated on JANUARY 25, 2017

Applies to:

Oracle Fusion Global Order Promising - Version 11.1.4.0.0 to 11.1.8.0.0 [Release 1.0]
Information in this document applies to any platform.
***KM Review - Dec 2016 - Checked for Relevance - Release 9 Specific***

Symptoms

We have run the Purge Data Repository ESS process which does NOT Purge UOM (Unit of Measure) cross reference data for the Source System.

Our expectation is that this should delete ALL xref (cross reference) data for the source system as per Dev's description of this process:


This program takes 2 inputs – Instance code and Global Flag
It deletes the collected data for all non-global entities for the given instance. In addition, if Global Flag is Yes, it also deletes the collected data for global entities for the given instance.
To obtain a list of global entities, execute the following SQL.

 

 Results of which are:

INSTANCE_CODEENTITY_NAMEATTRIBUTE_NAMEUOM_CODE
XXXXXX UOM_CODES UNIT_OF_CODE 1
XXXXXX UOM_CODES UNIT_OF_MEASURE 1

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