"Invalid hierarchy name" Error In MSCHUBUCH When Loading Custom Hierarchy And Custom Hierarchy Values To APCC From CSV (Doc ID 2077287.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle Advanced Planning Command Center - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

In Advanced Planning Command Center in a 12.2.4 Instance (with VCP Cum Patch 12.2.4.1 - 19549533 - MANDATORY PATCH applied)

We are trying to create a custom hierarchy in APCC by uploading from a csv file.  We are following the instructions from the Oracle Advanced Planning Command Center User's Guide, Release 12.2, Part no. E48757-03, p. 4-11 to 4.14.

We have successfully loaded a hierarchy for the Product dimension, but we are not able to make it work for the Customer Dimension.  We have set the value for system profile "MSC: Additional Customer hierarchy in APCC" to "Customer Category Code 1".  We have a csv file defined, also including the hierarchy name as "Customer Category Code 1".  We are able to run the Import Plan Summary successfully.  But when we run the Refresh APCC Materialized Views, it kicks off another program called "Upload Custom Hierarchy". An error occurs in that program, "Invalid hierarchy name:Customer Category Code 1, this hierarchy name exists in Demantra."  We have tried this with two other settings for the Hierarchy Name, each gives us the error that this hierarchy name exists in Demantra.  Since this works successfully for the Product Dimension, we expect it should work for the Customer dimension.

Although the log files for Import Plan Summary, Refresh APCC Materialized Views, and Upload Custom Hierarchy show that they have completed successfully
(despite the error message), to date we have not seen the Customer Hierarchy show up in APCC.

ERROR
-----------------------

MSCHUBUCH: Upload Custom Hierarchy

 "Invalid hierarchy name:Customer Category Code 1, this hierarchy name exists in Demantra."


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Set the value for system profile "MSC: Additional Customer hierarchy in APCC" to "Customer Category Code 1"
2.  csv file defined, also including the hierarchy name as "Customer Category Code 1
3.  Run Import Plan Summary successfully
4.  When we run the Refresh APCC Materialized Views, it kicks off Upload Custom Hierarchy
5. An error occurs in that program, "Invalid hierarchy name:Customer Category Code 1, this hierarchy name exists in Demantra."
6.  Try this with two other settings for the Hierarchy Name, each gives us the error

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