R12: AP/IBY: Payment Process Request (PPR) 'Build Payments' Error ORA-04063: package body "APPS.IBY_FD_EXTRACT_GEN_PVT" has errors (Doc ID 1924914.1)

Last updated on MAY 31, 2017

Applies to:

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

Symptoms

After applying <Patch 18465457:R12.IBY.C> and confirming that the package IBY_FD_EXTRACT_GEN_PVT is valid, when attempting to run Payment Process Request (PPR)  'Build Payment' program execution, the following error occurs.

ERROR
Error Message:BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS
An error occurred. Roll back any changes.
Done roll back changes.

IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets:ORA-04063: package body "APPS.IBY_FD_EXTRACT_GEN_PVT" has errors
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when validating documents. Document validation will be aborted and no document statuses will be committed for payment request 41
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: 1
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: User-Defined Exception
Build program error: Exception occured when attempting to validate the documents payable of the provided payment service request.

Changes

 

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