Receivables - EBS (MOSC)

MOSC Banner

PR_LOC_FLEX invalid - dependent on AR_LOCATION_COMBINATIONS 12.1.3

edited Jul 17, 2013 6:31PM in Receivables - EBS (MOSC) 1 commentAnswered
Swati says:
After applying 500+ patches recommended by Patch Wizard, a number of invalid objects are found.  When attempting to compile the invalid object PR_LOC_FLEX, the following error occurs.
ERROR
-----------------------
SQL> alter view APPS.PR_LOC_FLEX COMPILE;

Warning: View altered with compilation errors.

SQL> select text from dba_errors where name ='PR_LOC_FLEX' and owner='APPS';

TEXT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
This object is dependent on the view AR_LOCATION_COMBINATIONS.

Found a similar issue in the Patching Community thread:
3031026
Solution was:
*********************
For the PR_LOC_FLEX, this view is associated with the AR 'Location Information Flexfield' and can also be regenerated via the applications at runtime.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center