My Oracle Support Banner

Routing Rules Are Not Working Correctly For Credit Card Transactions After Submit Offline Transactions Is Run (Doc ID 1452743.1)

Last updated on FEBRUARY 03, 2022

Applies to:

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


Authorization of a Credit card transaction is routing through one Payment system while the setlement is being routed through another Payment system which is resulting in a settlement error at Payment processor site.

After executing the program Submit Offline Transactions, the BEPKEY associated with the settlement transaction is changed and an incorrect key is attached.

This would be visible in table IBY_TRXN_SUMMARIES_ALL, while running a command like the following:

 select * from IBY_TRXN_SUMMARIES_ALL where TANGIBLEID = '&TransactionTangibleID';

Normally, the value of the BEPKEY column should be the same for the authorization record (TRXNTYPEID = 2) and for the settlement (TRXNTYPEID = 8).  In this case, the values are the same before running Submit Offline Transactions, but they are become different after the program has completed.





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.