My Oracle Support Banner

Payments Cannot Be Confirmed Because An Error Was Returned From AP_PMT_CALLOUT_PKG.payments_complete (Doc ID 1636219.1)

Last updated on NOVEMBER 04, 2024

Applies to:

Oracle Fusion Payments - Version 11.1.7.0.0 to 11.1.8.0.0 [Release 1.0]
Oracle Fusion Payables - Version 11.1.7.0.0 to 11.1.8.0.0 [Release 1.0]
Oracle Fusion Payables Cloud Service - Version 11.1.7.0.0 and later
Oracle Fusion Payments Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.7.0.0 version, Manage Payments-Process Payment Files

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

ERROR
-----------------------
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()




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

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.