PR_LOC_FLEX invalid - dependent on AR_LOCATION_COMBINATIONS 12.1.3
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.
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.
0