R12: AP/IBY: Error When Completing a Payment Process Request : "Payments Cannot Be Marked Complete Because an Error was Returned by the Callout AP_PMT_CALLOUT_PKG.payments_completed." (Doc ID 2867000.1)

Last updated on JULY 24, 2023

Applies to:

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

Symptoms

When the application attempts to complete a payment process request (PPR) the following error occurs:

Payments cannot be marked complete because an error was returned by the callout AP_PMT_CALLOUT_PKG.payments_completed.

The FND Debug log shows

get_checkrun_info
sid:88888888: ERROR Code : 100
sid:88888888: ERROR Msg : ORA-01403: no data found
sid:88888888: AP.PLSQL.AP_PMT_CALLOUT_PKG..payments_completed - get_checkrun_info
APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_PMT_CALLOUT_PKG.payments_completed
with parameters (Complted Payments Group id = 99999)
while performing the following operation:
get_checkrun_info
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: APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_PMT_CALLOUT_PKG.payments_completed
with parameters (Complted Payments Group id = 99999)
while performing the following operation:
get_checkrun_info
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:Exception occured when marking payments complete for payment instruction 99999
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:SQLCODE: -20001
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:SQLERRM: ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_PMT_CALLOUT_PKG.payments_completed
with parameters (Complted Payments Group id = 99999)
while performing the following operation:
get_checkrun_info
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:EXIT
API returned error statusE
OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: Payments cannot be marked complete because an error was returned by the callout AP_PMT_CALLOUT_PKG.payments_completed.

Steps:

Go to Payments -> Entry -> Payments Manager
Click "Submit Single Payment Process Request"
Fill out the form and submit
At some point after the build but before completion, the row in AP_INV_SELECTION_CRITERIA_ALL must be deleted
Continue to process the Payment Process Request through to completion.

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

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

R12: AP/IBY: Error When Completing a Payment Process Request : "Payments Cannot Be Marked Complete Because an Error was Returned by the Callout AP_PMT_CALLOUT_PKG.payments_completed." (Doc ID 2867000.1)

Applies to:

Symptoms

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!