R12.1.1 : Found invalid object (VIEW APPS.OKL_TRX_HEADER_UV) after applied R12.1.1 upgrade driver(pa
Hi,
I am starting to upgrade my EBS from 11.5.10.2 to 12.1.x on AIX 6.1 Operating System in Test instance and we are using Oracle Financials modules such as AR,AP,GL,FA,CE only.
But I found a invalid object after successfully applied the R12.1.1 upgrade driver(patch#6678700), please help
SQL> ALTER VIEW APPS.OKL_TRX_HEADER_UV COMPILE ;
Warning: View altered with compilation errors.
SQL> SHOW ERRORS VIEW APPS.OKL_TRX_HEADER_UV;
Errors for VIEW APPS.OKL_TRX_HEADER_UV:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 ORA-00942: table or view does not exist
Thanks & Regards,
I am starting to upgrade my EBS from 11.5.10.2 to 12.1.x on AIX 6.1 Operating System in Test instance and we are using Oracle Financials modules such as AR,AP,GL,FA,CE only.
But I found a invalid object after successfully applied the R12.1.1 upgrade driver(patch#6678700), please help
SQL> ALTER VIEW APPS.OKL_TRX_HEADER_UV COMPILE ;
Warning: View altered with compilation errors.
SQL> SHOW ERRORS VIEW APPS.OKL_TRX_HEADER_UV;
Errors for VIEW APPS.OKL_TRX_HEADER_UV:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 ORA-00942: table or view does not exist
Thanks & Regards,
Tagged:
0