Cannot Create Payment Batch (Doc ID 2200345.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

Payment batch processing failed with error:

 

IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete: Call to
payments_completed hook completed at::2016-10-28 13:29:13.199859000 +00:00
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete: Fatal: External app
callout 'AP_PMT_CALLOUT_PKG.payments_completed', returned failure status - E.
Raising exception.
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete: Fatal: External app
callout 'AP_PMT_CALLOUT_PKG.payments_completed', generated exception.
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete: SQL code: -20001
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete: SQL err msg: ORA-20001:
IBY_BUILD_INSTRUCTIONS_PUB_PKG.payment_file_confirmation: Error: Could not mark the payments associated with payment instruction 36443 as complete.
Returning failure response ..
IBY_BUILD_INSTRUCTIONS_PUB_PKG.payment_file_confirmation: Exception occured
when completing payment file
IBY_BUILD_INSTRUCTIONS_PUB_PKG.payment_file_confirmation: SQLCODE: -20001
IBY_BUILD_INSTRUCTIONS_PUB_PKG.payment_file_confirmation: SQLERRM: ORA-20001:

Solution

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