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

Last updated on MARCH 18, 2014

Applies to:

Oracle Fusion Payments - Version 11.1.7.0.0 and later
Oracle Fusion Payments Cloud Service - Version 11.1.7.0.0 and later
Oracle Fusion Payables - Version 11.1.7.0.0 and later
Oracle Fusion Payables 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

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