My Oracle Support Banner

Hierarchy Import Fails Due To Multi-Parent Error - How Are Old Items Closed? (Doc ID 3051243.1)

Last updated on OCTOBER 03, 2024

Applies to:

Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service - Version NA and later
Oracle Retail Inventory Planning Optimization Cloud Service Advanced Edition - Version NA and later
Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service Plus - Version NA and later
Information in this document applies to any platform.

Symptoms

A Product Hierarchy file was successfully loaded ad-hoc into AI Foundation (AIF). But when the Import Hierarchy process was run in OAT, it failed with the error:

Validating dimension. Multiple parents found. Exiting

It was found that the multiple parent error is due to old items (items that are not in the Product Hierarchy file loaded).

Using the query:

With this parameter set to N, items that are not in the Product Hierarchy file should not have been sent to the Planning Data Schema (PDS) table.

Steps to Reproduce:

1. Ad-hoc load Product Hierarchy file into AIF
2. See that all the tasks complete successfully.
3. Confirm that for scenario_name SIL_ITEMDIMENSION param_name IS_INCEREMENTAL param_value=N
4. Run the Import Hierarchy task in OAT
5. See that it fails with the multiple parent errors.

Cause

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.