My Oracle Support Banner

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 FEBRUARY 03, 2019

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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.