R12.1.1 : Invalid IBY object after patch application :
Hi,
Invalid IBY objects after patch application :
Log file :
--------------------------------------
PACKAGE BODY IBY_UPG_PPP_PKG 102
PL/SQL: SQL Statement ignored
191
PL/SQL: ORA-00904: "INACTIVE_DATE": invalid identifier
965
PL/SQL: SQL Statement ignored
1051
PL/SQL: ORA-00904: "INACTIVE_DATE": invalid identifier
============
VIEW IBY_UPG_PPP_VL 0
ORA-00904: "B"."INACTIVE_DATE": invalid identifier
============
VIEW IBY_XML_FNDCPT_DOC_LINE_V 0
ORA-00904: "INV_LINE"."INVOICE_CURRENCY_CODE": invalid
identifier
============
VIEW IBY_XML_FNDCPT_DOC_LINES_V 0
ORA-04063: view "APPS.IBY_XML_FNDCPT_DOC_LINE_V" has errors
=============
VIEW IBY_XML_FNDCPT_DOC_HEADER_V 0
ORA-04063: view "APPS.IBY_XML_FNDCPT_DOC_LINE_V" has errors
Invalid IBY objects after patch application :
Log file :
--------------------------------------
PACKAGE BODY IBY_UPG_PPP_PKG 102
PL/SQL: SQL Statement ignored
191
PL/SQL: ORA-00904: "INACTIVE_DATE": invalid identifier
965
PL/SQL: SQL Statement ignored
1051
PL/SQL: ORA-00904: "INACTIVE_DATE": invalid identifier
============
VIEW IBY_UPG_PPP_VL 0
ORA-00904: "B"."INACTIVE_DATE": invalid identifier
============
VIEW IBY_XML_FNDCPT_DOC_LINE_V 0
ORA-00904: "INV_LINE"."INVOICE_CURRENCY_CODE": invalid
identifier
============
VIEW IBY_XML_FNDCPT_DOC_LINES_V 0
ORA-04063: view "APPS.IBY_XML_FNDCPT_DOC_LINE_V" has errors
=============
VIEW IBY_XML_FNDCPT_DOC_HEADER_V 0
ORA-04063: view "APPS.IBY_XML_FNDCPT_DOC_LINE_V" has errors
Tagged:
0