My Oracle Support Banner

RI/RSP: LOAD_PDS_FACT_INITIAL_PROCESS_ADHOC Failure with Error "ORA-01403: no data found" (Doc ID 2973701.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service - Version 23.1 and later
Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service - Version 23.1 and later
Oracle Retail AI Foundation Cloud Service - Version 23.1 and later
Oracle Retail Demand Forecasting Cloud Service Plus - Version 23.1 and later
Information in this document applies to any platform.

Goal

There is an error in the LOAD_PDS_FACT_INITIAL_PROCESS_ADHOC process. We are only loading one week's worth of data with EOW_DATE 20230910.

The POM log shows the following error: "ORA-01403: no data found".
 

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.