My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Payments - Version 12.0.1 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
Submit Offline Transactions Concurrent Request


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.

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

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.


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.