R12: AP: Synonym Looping Chain Of Synonyms Errors With ORA-01775 on APPS.AP_INVOICES_PKG (Doc ID 2926632.1)

Last updated on FEBRUARY 17, 2023

Applies to:

Symptoms

ran as apps --> create synonym CUSTOMUSER.AP_INVOICES_PKG for APPS.AP_INVOICES_PKG;
ran as apps --> GRANT EXECUTE ON APPS.AP_INVOICES_PKG TO CUSTOMUSER ;
ran as apps --> select CUSTOMUSER .AP_INVOICES_PKG.GET_POSTING_STATUS(1) from dual; -- this works
ran as CUSTOMUSER --> select CUSTOMUSER.AP_INVOICES_PKG.GET_POSTING_STATUS(1) from dual; -- ORA-01775

Cannot find any looping synonyms. Dropped all synonyms to APPS.AP_INVOICES_PKG.

Changes

 Created a new CUSTOMUSER and created synonyms

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.