Cannot Configure Profile Option "MSC: Additional Demantra Item Hierarchy In APCC" (Doc ID 1917304.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

Issue Clarification:
--------------------------------
12.2.3 Demantra - VCP
When we try to configure profile option "MSC: Additional Demantra Item hierarchy in APCC" we get an error message. Error Message uploaded.

ERROR:
-------------
Profiles couldn't determine the valid values for profile MSC_APCC_DMTRA_ITEM_HIERS. This problem is usually due to an error in the SQL validation for that profile. Use the 'Define Process' form to fix the SQL Validation for the MSC_APCC_DMTRA_ITEM_HIERS profile. This error may appear immediatelly following an Oracle error, which gives more information about what was wrong with the SQL Validation

Business Impact
------------------------
Business Process blocked

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