My Oracle Support Banner

RSP: Why Is an Error Type Warning "PROD_HIER_NON_NUMERIC_DATA" Occurring When Loading PRODUCT.csv? (Doc ID 2953579.1)

Last updated on JUNE 05, 2023

Applies to:

Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service - Version 23.1 and later
Oracle Retail Predictive Application Server Cloud Edition - Version 22.1 and later
Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service - Version 23.1 and later
Oracle Retail Demand Forecasting Cloud Service Plus - 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

While uploading the data dimension for PRODUCT.csv file a Warning is being received (viewed through APEX) "PROD_HIER_NON_NUMERIC_DATA" for table "BAD_PROD_PROD_CAT_DHS". What action do we need to take?

Oracle Retail AI Foundation Cloud Services Operations Guide states the following: " Your product hierarchy levels use alphanumeric characters for the level IDs. This is not allowed if you are implementing Retail Insights; all levels must be numbers." and the Retail Analytics and Planning Cloud Services Data Interfaces spreadsheet <NOTE 2539848.1> shows for the PRODUCT interface, PRODCAT_ID columns are VARCHAR2(255 CHAR) type.
 

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.