Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

PAY_US_EMP_NET_DIST_V_RO is valid after upgrade to R12.1.3

edited Oct 12, 2014 1:55PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered

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

Tagged:

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