AccountDailyProfile-Trade.xml has logic defect regarding as off trades
(Doc ID 2634284.1)
Last updated on FEBRUARY 03, 2020
Applies to:Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.
On : 8.0.6 version, Data Ingestion
There is a condition in AccountDailyProfile-Trade.xml bdf that includes as off trades . (TRADE TRD
JOIN KDD_PRCSNG_BATCH_CONTROL KPBC ON
-- Condition has been added to include past As-of Trades
((TRD.LAST_DATA_DUMP_DT = KPBC.DATA_DUMP_DT AND TRD.TRADE_DT <= KPBC.DATA_DUMP_DT)
-- Condition has been added to include future As-of Trades
(TRD.TRADE_DT = KPBC.DATA_DUMP_DT AND TRD.LAST_DATA_DUMP_DT < KPBC.DATA_DUMP_DT))
AND KPBC.EOD_PRCSNG_BATCH_FL = 'Y'
The issue is that if there is an as of trade that comes in, it overwrites the previous record instead of adding to it. As an example if 1 trade comes in for a trade date that already exists in acct_trade_smry_daily and there was a previous record that existed for that trade date that had trade_ct = 2 for that trade date, when the new record comes in the trade_ct for that day will be 1, not 3.
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