EBS-SNO: Launch SNO Plan Ends In An Error "ORA-00980 Synonym Translation No Longer Valid"

(Doc ID 2360066.1)

Last updated on FEBRUARY 12, 2018

Applies to:

Oracle Strategic Network Optimization - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Data Collections from EBS products (717, 590 and 951) to Planning Data Store

When attempting to launch SNO plan, the following error occurs.

ERROR
-----------------------
java.lang.RuntimeException: SQL Execption occurred: ORA-00980: synonym translation is no longer valid


STEPS

Cause

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 hundreds of Community platforms