My Oracle Support Banner

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 8.0.7.2.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)

Goal

Question 1:
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.


Question 2:
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).

Question 3:
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?

 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.