views are invalid AP_INVOICE_DISTRIBUTIONS_V,AP_INVOICE_DISTS_INQUIRY_V,IGI_MPP_AP_DIST_MERGE_V afte
views are invalid AP_INVOICE_DISTRIBUTIONS_V,AP_INVOICE_DISTS_INQUIRY_V,IGI_MPP_AP_DIST_MERGE_V after applied patches 4023610 5233248 4263001 4685497
The errors when tried to compile are
SQL> select text from dba_errors where name='AP_INVOICE_DISTRIBUTIONS_V';
TEXT
--------------------------------------------------------------------------------
ORA-00918: column ambiguously defined
SQL> select text from dba_errors where name='AP_INVOICE_DISTS_INQUIRY_V';
TEXT
--------------------------------------------------------------------------------
ORA-00918: column ambiguously defined
SQL> select text from dba_errors where name='IGI_MPP_AP_DIST_MERGE_V'
2 ;
TEXT
--------------------------------------------------------------------------------
ORA-04063: view "APPS.AP_INVOICE_DISTRIBUTIONS_V" has errors
SQL> select text from dba_errors where name='IGI_MPP_EXP_RECOGNITION';
The errors when tried to compile are
SQL> select text from dba_errors where name='AP_INVOICE_DISTRIBUTIONS_V';
TEXT
--------------------------------------------------------------------------------
ORA-00918: column ambiguously defined
SQL> select text from dba_errors where name='AP_INVOICE_DISTS_INQUIRY_V';
TEXT
--------------------------------------------------------------------------------
ORA-00918: column ambiguously defined
SQL> select text from dba_errors where name='IGI_MPP_AP_DIST_MERGE_V'
2 ;
TEXT
--------------------------------------------------------------------------------
ORA-04063: view "APPS.AP_INVOICE_DISTRIBUTIONS_V" has errors
SQL> select text from dba_errors where name='IGI_MPP_EXP_RECOGNITION';
Tagged:
0