My Oracle Support Banner

AIF DATA - Nightly - RDE_INTERSCHED_CHECK_STAGETRANDATA_JOB Fails with "ORA-00980: synonym translation is no longer valid." (Doc ID 3072329.1)

Last updated on FEBRUARY 20, 2025

Applies to:

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

Symptoms

RDE_INTERSCHED_CHECK_STAGETRANDATA_JOB failed and log shows:

INFO AbstractShellJobExecutor - <JLB> EXT_PROG_SYS_OUT:mmhome: ### 07-02-2025_03:34:20 merch_rde_intersched_check_cfs.ksh PID:78866 SQL Script failed with FROM rms_rde_batch_status rbs, * ERROR at line 2: ORA-00980: synonym translation is no longer valid. <JLE>

Cause

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.