Introduction
This Post is about to ORA -00980 Synonym Translation no longer valid Error in Oracle EBS R12.
Error Message : ORA -00980 Synonym Translation no longer Valid.
Error Area: it is related Database (Table/view) not associated with forms
When it happens: Synonym is in an inconsistent state; in my case, I have modified the view on which synonym was created (dependent).
How to confirm the issue: when query the data using the synonym in TOAD/sql-developer ….. it shows error message ORA -00980 Synonym Translation no longer valid.
Action Plan/solution: drop the synonym and recreate synonym(after the base view/table modified)
verify: Query the data by using the synonym then it should fetch the data
Summary
This Post described about the Error Message: ORA -00980 Synonym Translation no longer Valid in Oracle EBS R12.
Got any queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
