My Oracle Support Banner

R12: AP: Cancel Payment Process Request (APXCNCLB) Completing with Error "User-Defined Exception occurred in ap_autoselect_pkg.cancel_batch with parameters (p_checkrun_id: xxxxx) while performing the following operation: The return status from IBY API Te" (Doc ID 2952274.1)

Last updated on JULY 08, 2024

Applies to:

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

Symptoms

When attempting to cancel a Payment Process Request (PPR), the error below occurs :


ERROR
-----------------------
User-Defined Exception occurred in ap_autoselect_pkg.cancel_batch with parameters (p_checkrun_id: xxxxx) while performing the following operation:
The return status from IBY API Terminate PMT Request is:E
...
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_request:Fatal: External app callout 'AP_PMT_CALLOUT_PKG.documents_payable_rejected', returned failure status - . Raising exception.
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_request:Fatal: External app callout 'AP_PMT_CALLOUT_PKG.documents_payable_rejected', generated exception.
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_request:SQL code: -20001
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_request:SQL error msg: ORA-20001: The return status from IBY API Terminate PMT Request is:E


Payment batch remains in the 'Failed Document Validation' status.

Steps to reproduce:

-------------------

Navigate to:

1. Payables Responsibility -> Payments -> Payment Manager-> Payment Process Request

2. Submit PPR for ELECTRONIC Payment Method that selects two invoices for two different suppliers.

3. On Invoices Pending Review step, remove invoice for Character, Ascii, leaving only ONE invoice for Supplier.

    Note: The Supplier does not have any payee bank info.

4. Submit the one remaining invoice to continue processing.

5. It will complete showing Payment Process Request Status showing = Failed Document Validation with Error Reason: Document Payee Bank Account Number is required.

6. Click on Terminate and note cancel process APXCNCLB gives error mentioned

 

Changes

 

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


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