My Oracle Support Banner

Issue In Scenario IML-MvmtFundsWoTrade-dINST.114000020 (Doc ID 2512649.1)

Last updated on NOVEMBER 10, 2019

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 6.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 6.1.1 version, Scenarios

ACTUAL BEHAVIOR
---------------
Issue in Scenario IML-MvmtFundsWoTrade-dINST.114000020

We are in the process of migrating from 6x to 8.0.6 code. I could find there is an issue with the balance position summary table join.

The 8x code is just joining based on the account id as below without any date conditions. In the 6x code it is selecting the last data dump date in the join. I believe that this join was missed in the 8x version of code.

inner join @BUSINESS@.ACCT_BAL_POSN_SMRY abps on a.ACCT_INTRL_ID = abps.ACCT_INTRL_ID


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.