R12: IBY: View IBY_XML_FD_PMT_1_0_V and Package Body IBY_FD_EXTRACT_GEN_PVT are INVALID After Applying Patch 33527653
(Doc ID 2903514.1)
Last updated on OCTOBER 20, 2022
Applies to:
Oracle Payments - Version 12.2.3 and laterInformation in this document applies to any platform.
View IBY_XML_FD_PMT_1_0_V and Package Body IBY_FD_EXTRACT_GEN_PVT are INVALID After Applying Patch 33527653
Symptoms
On : 12.2.3 version, Patch Application Issues
Invalid Objects
1)IBY_XML_FD_PMT_1_0_V
2)IBY_FD_EXTRACT_GEN_PVT
after RUP16 Patch 33527653.
ERROR
-----------------------
IBY_FD_EXTRACT_GEN_PVT ibyfdxgs.pls 120.42.12020000.2 SPEC VALID
IBY_FD_EXTRACT_GEN_PVT ibyfdxgb.pls 120.139.12020000.22 BODY INVALID
Errors for View IBY_XML_FD_PMT_1_0_V
APPS IBY_XML_FD_PMT_1_0_V VIEW 1 0 0 ORA-00904: "PMT"."INVOICING_LEGAL_ENTITY_ID": invalid identifier
Errors for PACKAGE BODY IBY_FD_EXTRACT_GEN_PVT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
729/5 PL/SQL: SQL Statement ignored
731/12 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors
737/5 PL/SQL: SQL Statement ignored
739/12 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors
806/6 PL/SQL: SQL Statement ignored
808/9 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors
923/2 PL/SQL: SQL Statement ignored
924/7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors
932/2 PL/SQL: SQL Statement ignored
933/7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors
940/2 PL/SQL: SQL Statement ignored
941/7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors
949/2 PL/SQL: SQL Statement ignored
950/7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors
957/2 PL/SQL: SQL Statement ignored
958/7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors
966/2 PL/SQL: SQL Statement ignored
967/7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors
976/2 PL/SQL: SQL Statement ignored
977/7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply RUP16 Patch 33527653.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users experience invalids
Changes
Patch 33527653 was applied
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |