Trades Not Showing Up In Event Details Tab
(Doc ID 3065566.1)
Last updated on JANUARY 04, 2025
Applies to:
Oracle Financial Services Enterprise Case Management - Version 8.0.7 and laterInformation in this document applies to any platform.
Goal
The event details are only showing trades from the day of batch run. For example, for the batch of 2nd Dec, the event details is showing transactions only from 2nd DEC, even though Archival tables have transactions from older dates.
The insertion in FCC_TRADE_EVNT has a NOT EXISTS condition to see if the data already exists or not. This NOT EXISTS is only checking the trade_dt and not any key columns like trade_intrl_id. so, for 2nd DEC case, as there are some unrelated transactions from 27th Nov already in the FCC_TRADE_EVNT table, it's not inserting the ALL ACTUAL CORRECT transactions and only the new MIS DATE transactions are getting inserted.
Solution
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
| Goal |
| Solution |
| References |