PAY_US_EMP_NET_DIST_V_RO is valid after upgrade to R12.1.3
Hi,
Apps 12.1.3
Upgraded from R11i to R12.1.3. PAY_US_EMP_NET_DIST_V_RO is invalid.
Asked to compile it and have the following.
SQL> alter view PAY_US_EMP_NET_DIST_V_RO compile;
Warning: View altered with compilation errors.
SQL> show error view PAY_US_EMP_NET_DIST_V_RO
Errors for VIEW PAY_US_EMP_NET_DIST_V_RO:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 ORA-00942: table or view does not exist
SQL> select * from user_errors where name = 'PAY_US_EMP_NET_DIST_V_RO';
NAME TYPE SEQUENCE LINE POSITION
------------------------------ ------------ ---------- ---------- ----------
TEXT