Expression for FCAS.N_AMORT_METH_PDFC_CD is Incorrect in T2Ts Populating FCT_COMMON_ACCOUNT_SUMMARY
(Doc ID 2456023.1)
Last updated on AUGUST 14, 2020
Applies to:Oracle Financial Services Data Foundation - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Data Foundation (FSDF) 8.0.x version, for the Data Mapping T2Ts used to transfer data from the staging tables into FCT_COMMON_ACCOUNT_SUMMARY (FCAS) (ex. T2T_STG_INVESTMENTS_CAS), the expression for N_AMORT_METH_PDFC_CD is incorrect. The values in the expression incorrectly contain a space when they should be one word. See below:
''CASE WHEN (UPPER(STG_INVESTMENTS.V_AMORT_METH_PDFC_CD) ='STRAIGHT LINE') THEN 1 WHEN (UPPER(STG_INVESTMENTS.V_AMORT_METH_PDFC_CD) ='LEVEL YIELD') THEN 0 ELSE NULL END"
The values STRAIGHT LINE and LEVEL YIELD are two words with a space.
The same issue exists for all T2Ts that move data from a staging table into FCAS.
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