My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.