Submit Offline Transactions Request Not Selecting Pending Transactions For Settlement (Doc ID 560402.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Payments - Version 12.0.1 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
Checked for relevance on 26-Aug-2013.
Submit Offline Transactions Concurrent Request


Symptoms

On R12.0.x:

Submit Offline Transactions concurrent request is NOT processing settlements. There is at least
one capture transaction in pending settlement status (iby_trxn_summaries_all.status = 11) but Submit Offline Transactions is not selecting this transaction for processing.

EXPECTED BEHAVIOR
Expect Submit Offline Transactions to select the transactions in pending settlement status and send it to backend payment system for processing.

STEPS
The issue can be reproduced at will with the following steps:
1. Create a manual credit card receipt in Receivables.
2. Run remittance to initiate settlement process. This will insert a capture record in
iby_trxn_summaries_all with trxntypeid =8 and status = 11).
3. Run Submit Offline Transactions concurrent request to complete settlement with payment system.
4. Transaction was not selected for settlement.

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