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 laterOracle 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! |