My Oracle Support Banner

RDE_SETUP_INCRMNTL_RESA_JOB Fails with "No available RESA_EXTRACT in RMS_RDE_BATCH_STATUS for the business date" (Doc ID 3021135.1)

Last updated on MAY 08, 2024

Applies to:

Oracle Retail AI Foundation Cloud Service - Version 24.1 and later
Information in this document applies to any platform.

Goal

When executing the AIF DATA nightly batch in full mode after running the MFCS nightly batch, RDE_SETUP_INCRMNTL_RESA_JOB fails with this error:

ORA-20001: Code: -20001, Message: RDE_INCRMNTL_EXT_UTIL:PR_UPD_NIGHTLY_SALESORA-20001: Error Message: RDE_INCRMNTL_EXT_UTIL:PR_UPD_NIGHTLY_SALES No available RESA_EXTRACT in RMS_RDE_BATCH_STATUS for the business date. Please check. ORA-06512: at "RABE01USER.RDE_INCRMNTL_EXT_UTIL", line 128 ORA-06512: at line 2.

What is the reason for it?

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.