R12: Unable To Terminate A Payment Process Request Exception Occured While Restoring The Used Check Number (Doc ID 2008404.1)

Last updated on OCTOBER 28, 2015

Applies to:

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

Symptoms

On : 12.1.3 version, Pmt PayReports PBatch & Prepay

When attempting to terminate a Payment Process Request the following error occurs.

ERROR
-----------------------

sid:741195251: IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:Payment instruction 302159 is not locked.
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:Payment instruction 302159 is not locked.
sid:741195251: IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:Attempting to call hook for voiding withholding certificates: AP_AWT_CALLOUT_PKG.zx_witholdingCertificatesHook
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:Attempting to call hook for voiding withholding certificates: AP_AWT_CALLOUT_PKG.zx_witholdingCertificatesHook
sid:741195251: IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:Restoring the Unused Check numbers by payment instruction 302159
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:Restoring the Unused Check numbers by payment instruction 302159
sid:741195251: IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:Fatal: Exception occured while restoring the used check numbers.302159
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:Fatal: Exception occured while restoring the used check numbers.302159
sid:741195251: IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:Exception occured when terminating payment instruction 302159, with status FORMATTED_READY_FOR_PRINTING
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:Exception occured when terminating payment instruction 302159, with status FORMATTED_READY_FOR_PRINTING
sid:741195251: IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:SQLCODE: 1
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:SQLCODE: 1
sid:741195251: IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:SQLERRM: User-Defined Exception
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:SQLERRM: User-Defined Exception
sid:741195251: IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:EXIT
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_instruction:EXIT
sid:741195251: IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_request:Exception while terminating Payment instruction 302159
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_request:Exception while terminating Payment instruction 302159
sid:741195251: IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_request:Returning error message..
IBY_DISBURSE_UI_API_PUB_PKG.terminate_pmt_request:Returning error message..
sid:741195251: The return status from IBY API Terminate PMT Request is:E
"APP-SQLAP-10000: User-Defined Exception occurred in
ap_autoselect_pkg.cancel_batch
with parameters (p_checkrun_id: 300382)
while performing the following operation:
The return status from IBY API Terminate PMT Request is:E"
Entering Fnd_Product_Initialization.ExecInitFunction


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