Instrument Type Selection in FV Process Definitions Where Multiple Types are Mapped to Same Table

(Doc ID 2309752.1)

Last updated on OCTOBER 06, 2017

Applies to:

Oracle Financial Services Hedge Management and IFRS Valuations - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Hedge Management and IFRS Valuations (HM/IFRS)

Goal

In HM 8.0.4, in the context of Fair Value (FV) Process Definitions, when trying to selectively process some instrument types, all of which are sourced from the same Instrument Table, the selectivity fails as it appears that all instruments in a given instrument table are processed, regardless of the instrument type.

ACTUAL BEHAVIOR

As long as there is a single instrument type mapped in the FV process for a given instrument table, all records in that table are getting processed.  When testing using different combinations of instrument type codes defined for loans and regardless of the selection, all records in loan table was processed.

EXPECTED BEHAVIOR

Expect that there will be no output in the table FCT_ACCOUNT_FAIR_VALUE as there are no records with instrument type code 984 in the instrument table selected.

Steps to reproduce:

1. Create 3 new instrument types, namely - Loan FVOCI, Loan FVTPL and Amortised Cost Loan with instrument type code as 983, 984 and 985 respectively.
2. Define a FV process selecting only instrument type Loan FVTPL (instrument type code 984). Afterwards, define a FV run using the same process.
3. Insert a single loan record with instrument type code 983 in FSI_D_LOAN_CONTRACTS.
4. Execute the FV run mentioned in step 2.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms