Fetch Clearing Program Is Failing but Transaction status changes to 0 (Doc ID 2259137.1)

Last updated on JULY 27, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, FC Core

"Fetch Settlement Batch Clearing" program is failing even if all the transactions are updated to status 0.

ERROR
-----------------------
BY_TRANSACTIONCC_PKG.insert_batch_status_new: ENTER: overloaded API.
IBY_TRANSACTIONCC_PKG.insert_batch_status_new: Comma Separated string of profile codes: '22'
IBY_TRANSACTIONCC_PKG.insert_batch_status_new: num rows is zero
IBY_TRANSACTIONCC_PKG.insert_batch_status_new: STEP 1
IBY_TRANSACTIONCC_PKG.insert_batch_status_new: Invoking grouping ..
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: ENTER: Overloaded API.
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: Payment Profile Cd:
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: Instrument Type: CREDITCARD
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: Request Type: ORAPMTCLOSEBATCH
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: f_pmt_channel_in:
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: f_curr_in:
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: f_settle_date:
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: f_due_date:
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: f_maturity_date:
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: f_instr_type:
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: Current numeric char mask: .,
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: Dynamic SQL snippet:
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: No transactions were retrieved from DB for profile '22'. Exiting transaction grouping ..
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: EXIT
IBY_TRANSACTIONCC_PKG.insert_batch_status_new: # batches created: 0
IBY_TRANSACTIONCC_PKG.insert_batch_status_new: # transactions processed: 0
IBY_TRANSACTIONCC_PKG.insert_batch_status_new: vendor_id_in: 10081
IBY_TRANSACTIONCC_PKG.insert_batch_status_new: vendor_key_in: amx_unifirst_canada
IBY_TRANSACTIONCC_PKG.insert_batch_status_new: merchant_id_in: UNF_Payee
IBY_TRANSACTIONCC_PKG.insert_batch_status_new: req_type_in: ORAPMTCLOSEBATCH
IBY_TRANSACTIONCC_PKG.insert_batch_status_new: mbatchids out count: 0
IBY_TRANSACTIONCC_PKG.insert_batch_status_new: batchids out count: 0


IBY_TRANSACTIONCC_PKG.performTransactionGrouping: No transactions were retrieved from DB for profile '22'. Exiting transaction grouping ..




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Fetch Clearing program
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot clear Receipt

Changes

 

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