My Oracle Support Banner

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.

Symptoms

On : 8.0.6 version, Data Ingestion

ACTUAL BEHAVIOR
---------------
AccountDailyProfile-Trade.xml

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)
  OR
  -- 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.

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.