R12: AP/IBY: IBY_FD_EXTRACT_GEN_PVT And IBY_PAYMENT_FORMAT_VAL_PUB Are Invalid Due to 'GET_FED_INF_AGG and 'FV_PAYMENT_FORMAT_VAL_PUB.FVSPSGWAACH'
(Doc ID 2007409.1)
Last updated on OCTOBER 17, 2022
Applies to:
Oracle Payables - Version 12.1.1 and laterOracle Payments - Version 12.1.1 and later
Information in this document applies to any platform.
Symptoms
The following IBY objects are invalid with the following compilation errors:
IBY_FD_EXTRACT_GEN_PVT PACKAGE BODY
PLS-00302: component 'GET_FED_INF_AGG' must be declared
PLS-00302: component 'GET_TAS_BETC_AGG' must be declared
PL/SQL: Statement ignored
PLS-00302: component 'GET_TAS_BETC_AGG' must be declared
PL/SQL: Statement ignored
IBY_PAYMENT_FORMAT_VAL_PUB PACKAGE BODY
PLS-00201: identifier'FV_PAYMENT_FORMAT_VAL_PUB.FVSPSGWAACH' must be declared
PLS-00201: identifier 'FV_PAYMENT_FORMAT_VAL_PUB.FVSPSGWACHECK' must be declared
PLS-00201: identifier 'FV_PAYMENT_FORMAT_VAL_PUB.FVPAMACH' must be declared
PLS-00201: identifier 'FV_PAYMENT_FORMAT_VAL_PUB.FVPAMCHECK' must be declared
PLS-00201: identifier 'FV_PAYMENT_FORMAT_VAL_PUB.FVSPGWASUMM' must be declared
PL/SQL: Statement ignored
PLS-00201: identifier 'FV_PAYMENT_FORMAT_VAL_PUB.FVSPSGWACHECK' must be declared
PLS-00201: identifier 'FV_PAYMENT_FORMAT_VAL_PUB.FVPAMACH' must be declared
PLS-00201: identifier 'FV_PAYMENT_FORMAT_VAL_PUB.FVPAMCHECK' must be declared
PLS-00201: identifier 'FV_PAYMENT_FORMAT_VAL_PUB.FVSPGWASUMM' must be declared
PL/SQL: Statement ignored
The issue may also appear in the build step of submitting a Payment Process Request (PPR) (Payments -> Entry -> Payment Manager -> Submit Single Payment Process Request)
BUILD PROGRAM ERROR - CANNOT INSERT DOCUMENTS FOR PAYMENT SERVICE REQUEST
Error Message:BUILD PROGRAM ERROR - CANNOT INSERT DOCUMENTS FOR PAYMENT SERVICE REQUEST
An error occurred. Roll back any changes.
Error Message:BUILD PROGRAM ERROR - CANNOT INSERT DOCUMENTS FOR PAYMENT SERVICE REQUEST
An error occurred. Roll back any changes.
With the debug log showing
IBY_VALIDATIONSETS_PUB.initDocDataForPPR: IBY_VALIDATIONSETS_PUB.initDocDataForPPR:SQL code: -4063
IBY_VALIDATIONSETS_PUB.initDocDataForPPR: IBY_VALIDATIONSETS_PUB.initDocDataForPPR:SQL err msg: ORA-04063: package body "APPS.IBY_FD_EXTRACT_GEN_PVT" has errors
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets:ORA-04063: package body "APPS.IBY_FD_EXTRACT_GEN_PVT" has errors
IBY_VALIDATIONSETS_PUB.initDocDataForPPR: IBY_VALIDATIONSETS_PUB.initDocDataForPPR:SQL err msg: ORA-04063: package body "APPS.IBY_FD_EXTRACT_GEN_PVT" has errors
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets:ORA-04063: package body "APPS.IBY_FD_EXTRACT_GEN_PVT" has errors
Changes
Applied patches (including but not limited to patch 20516480 and patch 20308793)
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 |