My Oracle Support Banner

Wrong Parameters Passed When Submitting Fetch Settlement Batch Clearing For One Specific Batch (Doc ID 1134643.1)

Last updated on JANUARY 24, 2020

Applies to:

Oracle Payments - Version 12.1.0 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


When submitting the Fetch Settlement Batch Clearing process for one specific batch picked from the Settlement Batches list, the program behaves incorrectly and performs additional steps that are not related to the Fetch flow.

The log shows the program parameters are passed incorrectly:

IBY_FC_FETCH_BATCH_CLEARING module: Fetch Settlement Batch Clearing
Current system time is 27-APR-2010 11:07:16
instr_type: null
prog_name: IT_PAYEE
retry_flag: null

In addition, the following ORA-01403 error may be seen because the program is executed with wrong parameters, and instead of running only BATCH QUERY (acknowledgement) process, it runs other processes as well (like BATCH RETRY) which fail and throw the ORA-01403 exception:
Processing BATCH RETRY operations ..
Retrying the batch 1_1
attempting batch close retry for batch(payee id=NIB,account id=null,batch id=1_1)
Profile codes for the batch: [1]
java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 163
ORA-06512: at line 1
Steps To Reproduce:
1. Funds Capture Process Manager -> Home
2. In the Home Dashboard, there is one viewlet entitled "Recent Successful Settlement Batches"
    This table contains a "Fetch Clearing" column.
3 Click the Fetch Clearing button for one of the pending batches




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.