My Oracle Support Banner

RSE_MASTER_ADHOC_PROCESS Fails Sending Foundation Data from RI to AI Foundation: Extended Hierarchy Level mismatch (Extended hierarchy leaf Node != Transaction Data hierarchy level (Doc ID 2971700.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Oracle Retail AI Foundation Cloud Service - Version 23.2 and later
Oracle Retail Science Platform Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Goal

After Product, Location and Calendar hierarchies were loaded into RI, an "Extended Hierarchy Level mismatch (Extended hierarchy leaf Node != Transaction Data hierarchy level" errors occurs while trying to send dimension data from RI to AI Foundation. Checking RSE_CONFIG table after seeing "Extended hierarchy" in the log confirms the PARAM_VALUE of "Y" for LOAD_EXTENDED_PROD_HIER and "RMS" as EXTENDED_HIERARCHY_SRC.

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.