My Oracle Support Banner

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

Last updated on SEPTEMBER 26, 2018

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


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

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
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.