Payments Cannot Be Confirmed Because An Error Was Returned From AP_PMT_CALLOUT_PKG.payments_complete

(Doc ID 1636219.1)

Last updated on JANUARY 25, 2018

Applies to:

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


On : version, Manage Payments-Process Payment Files

When attempting to complete payment batch,the following error occurs.

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: You must assign a document sequence. Details: The Sequential Numbering Enforced profile option is set to Partial, but no document sequence assignment exists for category code EFT PAY, application 200, method code A, determinant value xxxxxx, and transaction date: 2014-03-14.
After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().
Error while executing IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete()

The issue has the following business impact:
Due to this issue, users cannot complete payment batch.


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