My Oracle Support Banner

AR_CASH_RECOS_PS View is Invalid After Applying Patch 7666667:R12.AR.B (Doc ID 848021.1)

Last updated on FEBRUARY 20, 2018

Applies to:

Oracle Receivables - Version 12.1.1 to 12.1.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

The following database view objects are invalid:

These objects should have been created through the application of the file artrx.odf.

Changes

The database objects referenced by these views should have been created through the application of the file artrx.odf. However review of customer's version of this file shows that the tables were created but the APPS synonyms were not.  The absences of the synonym definition impacts the creation of the views.

If the synonyms are created manually, the views become valid upon re-compilation.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

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