Unable to Purge Staging Table For Custom Hierarchy

(Doc ID 2422035.1)

Last updated on JULY 11, 2018

Applies to:

Oracle Demand Management Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

Using Planning Central / Load Planning Data from Flat Files
Running 11.13.18.02 in Test:
When attempting to purge data for the Custom Hierarchy entity using the ESS job Purge Staging Tables, find that

ACTUAL BEHAVIOR
---------------
Custom Hierarchy is not listed as an entity that can be purged

EXPECTED BEHAVIOR
-----------------
Expect Custom Hierarchy to be listed as an entity that can be purged.

-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
1. Load Custom Hierarchy data that includes some bad data using data generated from
ScpCustomHierarchyImportTemplate.xlsm .

2. Using the ESS job Purge Staging Tables,
try to purge the Custom Hierarchy data that includes some bad data from the staging tables.

3. Observe that Custom Hierarchy is not listed as an entity that can be purged.

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