How to circumvent ORA-01775 looping chain of synonyms in Oracle Forms? I think I have a database problem... Not necessarily with Oracle Forms (10g)...Let me explain ...

I'm trying to implement this Oracle Forms Menu Security Configuration When I do it, it says that I get ORA - 01775 "Looping Chain of Synonyms".... Since I have NO IDEA what synonym is creating the problem, I was wondering how you guyz can help me fix this issue.... Maybe there is a DBA script somewhere to solve this....

UPDATE

Oracle Database trace  log says the culprit SQL is :

select ROLE GRPNAME ,FLAG GRPFLG from FRM50_ENABLED_ROLES order by ROLE desc  and FRM50_ENABLED_ROLES is created from step 1 here

That statement executes properly where I execute it in SQL*PLUS
Set the below event in the database:

alter system set events '1775 trace name errorstack level 1';


This will make all the ORA-01775 errors logged in the alert log plus a trace file, and that trace fail should contain the Current SQL statement, that caused the error.