My Oracle Support Banner

SWIFT OrderReference Number Duplication Validation Not Working (Doc ID 2592796.1)

Last updated on OCTOBER 03, 2019

Applies to:

Oracle FLEXCUBE Investor Servicing - Version 12.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.4.0.0.0 version, Implementation Support

ACTUAL BEHAVIOR
---------------
SWIFT OrderReference Number Duplication validation not working

While capturing RedemptionOrderV04-setr.004.001.04 through SWIFT, two duplicate transactions(i.e with the same Order Reference Number is sent at the same time from external Queue to FCIS) and we see that message(both messages) is in mstb_dly_msg_in for processing.
System picks ups both the messages for processing at the same time as the incoming messages have the same keystring in mstb_jobtbl

EXPECTED BEHAVIOR
-----------------------

a)System stops the second duplicate transaction with duplicate order reference number with the error related to duplicate order reference number.
b)System generates separate OIS for the second message to external system with the error message for duplicate reference number

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1.Send two SWIFT - RedemptionOrderV04-setr.004.001.04 with the same OrderReference Number to FCIS but different Master Ref at the same time
2.It is observed that
(a)two duplicate transactions are generated
(b)Duplicate Order Reference Number is not validated by System
(c)No OIS Message is generated for the duplicate Message

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue,
System is not validating for Duplicate Order Reference Number and creating Two duplicate transactions for the same Order Reference Number
No OIS Message is generated for the duplicate transaction and no Logging for the duplicate transaction in SwiftTxnDetLogTbl

Changes

 

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
Changes
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.