Sales Load Rejecting for "Dimension Identifier(s) missing." (Doc ID 3065935.1)

Last updated on JANUARY 07, 2025

Applies to:

Goal

We are currently facing issues loading a sales history file (SALES.csv) into a Non-Prod environment for the first time, following the RAP Implementation Guide Initial Batch Processing.

The process is failing with the following rejection reason: "Dimension Identifier(s) missing." What causes this error?

STEPS:
1. Create the file SALES.csv containing one or more days of sales data along with a CTX file defining the columns which are populated. Optionally include the SALES_PACK.csv file as well.
2. Upload the history files to Object Storage using the RAP_DATA_HIST.zip file.
3. Execute the HIST_ZIP_FILE_LOAD_ADHOC process.
4. Execute the HIST_STG_CSV_SALES_LOAD_ADHOC process to stage the data in the database. Validate your data before proceeding. Refer to Sample Validation SQLs for sample queries you can use for this.
5. Execute the HIST_SALES_LOAD_ADHOC batch processes to load the data. If no data is available for certain dimensions used by sales, then the load process can seed the dimension from the history file automatically. Enable seeding for all of the dimensions according to the initial configuration guidelines; providing the data in other files is optional.

Solution