R12.2 - IBY_FD_EXTRACT_GEN_PVT invalid after Patch:18465457:R12.IBY.C - ibyfdxgb.pls 120.139.12020000.10

(Doc ID 1917743.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Payables - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

After applying Patch 18465457:R12.IBY.C, the following invalid appears:

ORA-04063: package body "APPS.IBY_FD_EXTRACT_GEN_PVT" has errors

 

APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 1 728 12 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 2 726 5 PL/SQL: SQL Statement ignored ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 3 736 12 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 4 734 5 PL/SQL: SQL Statement ignored ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 5 805 9 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 6 803 6 PL/SQL: SQL Statement ignored ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 7 921 7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 8 920 2 PL/SQL: SQL Statement ignored ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 9 930 7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 10 929 2 PL/SQL: SQL Statement ignored ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 11 938 7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 12 937 2 PL/SQL: SQL Statement ignored ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 13 947 7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 14 946 2 PL/SQL: SQL Statement ignored ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 15 955 7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 16 954 2 PL/SQL: SQL Statement ignored ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 17 964 7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 18 963 2 PL/SQL: SQL Statement ignored ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 19 974 7 PL/SQL: ORA-04063: view "APPS.IBY_XML_FD_PMT_1_0_V" has errors ERROR 0
APPS IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY 20 973 2 PL/SQL: SQL Statement ignored ERROR 0
APPS IBY_XML_FD_PMT_1_0_V VIEW 1 0 0 "ORA-00904: ""IBY_FD_EXTRACT_GEN_PVT"".""GET_PMT_FVFIELDSAGG"": invalid identifier" ERROR 0

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms