Create Settlement Batches does not Create Output File (No transactions were retrieved from DB for profile x) (Doc ID 726614.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Payments - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Oracle iPayment - Version: 12.0.4


Symptoms

Create Settlement Batches is not generating any output when run as part of the Bills Receivable Remittance process:

Here is portion from log file:

IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: ENTER
IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: vendor_id_in: 10120
IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: vendor_key_in: OPEX PS
IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: merchant_id_in: OPZ
IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: req_type_in: ORAPMTEFTCLOSEBATCH
IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: profile_code_in: 21
IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: settlement_date_in: 09-JUL-08
IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: oldstatus_in: 100
IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: Invoking grouping ..
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: ENTER
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: Payment Profile Cd: 21
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: Instrument Type: BANKACCOUNT
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: Request Type: ORAPMTEFTCLOSEBATCH
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 21. Exiting transaction grouping ..
IBY_TRANSACTIONCC_PKG.performTransactionGrouping: EXIT
IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: # batches created: 0
IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: # transactions processed: 0
IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: mbatchids count: 0
IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew: EXIT

The issue can be reproduced at will with the following steps:
1. Receivables > Bills Receivables-> Remittances
2. Approve remittance batch.
3. In 'Funds Capture Process Manager' responsibility, submit the 'Create Settlement Batches' concurrent request.
4. No output is generated.

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