My Oracle Support Banner

R12: Unable to Pay / Cancel Invoice. Build Payment Error / Error from eTax API (Doc ID 2391975.1)

Last updated on NOVEMBER 01, 2020

Applies to:

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

Symptoms

Unable to Pay specific invoice due to the build program error.  Due to this issue, users cannot make payments.

 

When tried to pay via Payment Process Request(PPR)

IBYBUILD: Build Payments completed in error.

Failed Build Payments - Unexpected Errors

ERROR
----------
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.
Done roll back changes.
Request completed in error.

IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents:IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents:SQLCODE: -24381
IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents:IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents:SQLERRM: ORA-24381: error(s) in array DML
IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents:IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents: While inserting document with Invoice Number : XXXXXX with Invoice ID : XXXXXX
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Could not insert documents payable for payment service request. Calling app id 200, calling app payment service request XXXXXXXXXX
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Payment service request cannot be processed further. Exiting build program.
Build program error: Unable to insert documents payable of the provided payment service request into database.

When tried to pay via Payment Workbench:

Error:
Check data is out-of-sync for check number

When tried to Cancel invoice:

FND log shows:

AP.PLSQL.AP_ETAX_SERVICES_PKG.Cancel_Invoice Step 5.5: Handle errors returned by API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Get error message from eTax API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Get error message from stack
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages An unexpected error has occurred. Please contact your system administrator.

 

Issue  can be reproduced at will with the following steps:
1. Run Payment Process Request

2. Build Payment process fails

3. Payables : Payments : Quick Payment

4. Payables : Invoices : Cancel



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


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