RI/RSP: How to Resolve LOAD_DIM_INITIAL_ADHOC Failure with Error "PROD_HIER_MULTIPLE_TOP_LEVEL_RECORD" in BAD_PROD_PROD_CAT_DHS Table? (Doc ID 2971662.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

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

Goal

During the products hierarchy file load through LOAD_DIM_INITIAL_ADHOC the job is failing and in the BAD_PROD_PROD_CAT_DHS table the following error is shown: PROD_HIER_MULTIPLE_TOP_LEVEL_RECORD

The default of 1 for the company code (TOP_LVL_PRODCAT_ID) is being used and there are no duplicate nodes. How can this be resolved?

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.

RI/RSP: How to Resolve LOAD_DIM_INITIAL_ADHOC Failure with Error "PROD_HIER_MULTIPLE_TOP_LEVEL_RECORD" in BAD_PROD_PROD_CAT_DHS Table? (Doc ID 2971662.1)

Applies to:

Goal

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!