Incorrect CUR_PAYMENT and CUR_PAR_BAL Mapping in ALM T2T for INVESTMENTS
Last updated on AUGUST 14, 2017
Applies to:Oracle Financial Services Asset Liability Management - Version 8.0.0 to 8.0.4 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Table to Table (T2T) Data Extract Mapping
On OFSAA 8.0.1 in ALM, there appear to be incorrect mappings in the seeded T2T_INVESTMENTS.
Two fields appear to be incorrect:
N_AMOUNT_P (which represents principal for LRM) is mapped to CUR_PAYMENT in the ALM T2T. This should come from some other field - not sure what on Investments.
N_EOP_BAL_LCY is mapped to CUR_PAR_BAL for ALM - should not be data in LCY, these should be in original currency like the N_EOP_BAL field
The issue can be reproduced at will with the following steps:
1. Open T2T_INVESTMENTS, check the T2T mapping for CUR_PAYMENT and CUR_PAR_BAL.
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