How to Create the TRNS Transaction Tables in the Profitability Analytics Repository (Doc ID 800505.1)

Last updated on APRIL 26, 2009

Applies to:

Oracle Financial Services Profitability Analytics - Version: 4.5.39
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5.39
FSIPFTALM.rpd
FSIPFT.rpd
OBIEE

Goal

In Oracle Financial Services Profitability Analytics, there is a set of transaction tables that exist in the ORCL 45 PFT MGR physical layer but do not exist in the OFSA database.  Does the OFSA database need to have these tables for use in Profitability Analytics?  How do you create the TRNS transaction tables?

Below is the list of transaction tables that do not exist in the OFSA database but do exist in the Oracle BI Physical layer:

FEM_CHECKING_TRNS
FEM_COMMERCIAL_LOANS_TRNS
FEM_CONSUMER_LOANS_TRNS
FEM_CREDIT_CARDS_TRNS
FEM_CREDIT_LINES_TRNS
FEM_INVESTMENTS_TRNS
FEM_LEASES_TRNS
FEM_MERCHANT_CARDS_TRNS
FEM_MORTGAGE_BACK_SEC_TRNS
FEM_MORTGAGES_TRNS
FEM_OFF_BALANCE_SHEET_TRNS
FEM_OTHER_SERVICES_TRNS
FEM_RETIREMENT_ACCOUNTS_TRNS
FEM_SAVINGS_TRNS
FEM_TERM_DEPOSITS_TRNS

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