How is the Column DIM_ACCOUNT.N_RCV_LEG_ACCT_SKEY Populated in OFSAA?

(Doc ID 2011172.1)

Last updated on JANUARY 11, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Data Foundation - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)

Goal

How is N_RCV_LEG_ACCT_SKEY get populated during DIM_ACCOUNT population? What is the logic to fill in this column?

Based on this column the T2Ts for below pickup records from Stage tables to load corresponding FSI tables.

T2T_SWAP_CONTRACTS_PAY
T2T_SWAP_CONTRACTS_RCV
T2T_OPTION_CONTRACTS_COLLAR_PAY
T2T_OPTION_CONTRACTS_COLLAR_RCV

Based on what column in STG_SWAPS_CONTRACTS and STG_OPTION_CONTRACTS is DIM_ACCOUNT.N_RCV_LEG_ACCT_SKEY get populated?

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