ERROR ORA -00980 Synonym Translation no longer valid
Error Area : it is related Database (Table/view) not related to forms
When it happens : Synonym is in 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/sqldeveloper ….. 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