My Oracle Support Banner

Unable to Load Alert Dimension (Doc ID 3049740.1)

Last updated on SEPTEMBER 26, 2024

Applies to:

Oracle Retail Inventory Planning Optimization Cloud Service Advanced Edition - Version 24.0 to NA [Release 24.0 to No Release]
Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service Plus - Version 23.2 to NA [Release 23.2 to No Release]
Oracle Retail Merchandise Financial Planning Cloud Service Plus - Version 24.1 to NA [Release 24.1 to No Release]
Information in this document applies to any platform.

Goal

The following error is returned when trying to load the alert dimension directly into RPASCE, even though the headers are in the alt.hdr.csv.dat file:

SQL Sid 'rpas_data_mart_conn_low' ORA-20001: Following levels are missing in the input file: altc,alth,altp,altr,altt
ORA-06512: at "RPAS_DATA_MART_PDS.RP_SCHEMA_INFO_PKG", line 586
ORA-06512: at line 1
 

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.