Questions on Staging Merchant - STG_MERCHANT_CARDS Columns
(Doc ID 2675862.1)
Last updated on MARCH 01, 2021
Applies to:Oracle Financial Services Profitability Management - Version 220.127.116.11.0 to 8.1.1 [Release 8 to 8.1]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Financial Services Data Foundation (FSDF)
Why are Account Manager Code and Line Code columns not available in STG_MERCHANT_CARDS table but available in other staging table such as STG_CASA?
User is looking to use V_ACCOUNT_MANAGER_CODE and V_LINE_CODE for STG_MERCHANT_CARDS but unable to find these columns.
V_SETTLEMENT_ACCT_NBR column for STG_MERCHANT_CARDS is currently VARCHAR2(25 CHAR), but account code column V_ACCOUNT_IDENTIFIER_CODE for DIM_ACCOUNT is VARCHAR2(50 CHAR).
Is it allowed to change column precision for V_SETTLEMENT_ACCT_NBR to VARCHAR2(50 CHAR).
In STG_MERCHANT_CARDS, definition of N_CUST_NET_REVENUE_AMT in table REV_TAB_COLUMNS_MLS is below:
"This stores the total revenue less the loss/expenses and taxes incurred for that account at customer level. It’s the sum of n_tot_comm_amt + n_fees + n_communication_charges + n_other_charges + n_other_party_charges - n_allocated_cost" These columns are not in STG_MERCHANT_CARDS except for N_FEES. Is there a reason why?
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