OFSAA FSDF Stage Investment Transaction and Transaction Summary V_GAAP_CODE and N_LOAD_RUN_ID Missing Columns

(Doc ID 2321350.1)

Last updated on OCTOBER 25, 2017

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.4 and later
Oracle Financial Services Profitability Management - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Data Foundation (FSDF) previously known as Oracle Financial Services Data Warehouse (FSDW)
Oracle Financial Services Profitability Management (PFT)

Goal

The following columns appear to be missing:

STG_INVESTMENT_TXNS_SUMMARY:
v_gaap_code
n_load_run_id

STG_INVESTMENT_TXNS
v_gaap_code
n_load_run_id
v_account_number << without v_account_number how do you associate the transaction to the account record?

Are these columns missing for a reason?

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