R12 PAIGEN Errors With Cursor=505 ORA-00942: Table Or View Does Not Exist/ORA-01775: looping chain of synonyms (Doc ID 1986441.1)

Last updated on NOVEMBER 19, 2016

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for relevance 28-Apr-2015 ***

Symptoms

After upgrading from release 11.5.10.2 to Release 12.1.3 the PAIGEN  PRC: Generate Draft Invoices for a Single Project process encounters the following error:

ORACLE error during DRAFT INVOICE GENERATION (cursor=505 code=-942: ORA-00942: table or view does not exist
OR

ORACLE error during DRAFT INVOICE GENERATION (cursor=505 code=-1775: ORA-01775: looping chain of synonyms

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