Datatype Format Mismatch When Remap ADJUSTABLE_TYPE_CD in T2T
(Doc ID 2432608.1)
Last updated on AUGUST 07, 2018
Applies to:Oracle Financial Services Data Foundation - Version 8.0.6 and later
Oracle Financial Services Profitability Management - Version 8.0.6 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6 and later
Oracle Financial Services Asset Liability Management - Version 8.0.6 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On : 8.0.6 version, Metadata Issues
When trying to reinstate mapping of T2T for STG_TD_CONTRACTS for FSI_ADJUSTABLE_TYPE_MLS_V.ADJUSTABLE_TYPE_CD to FSI_D_TERM_DEPOSITS.ADJUSTABLE_TYPE_CD the following error occurs.
 Datatype format mismatch
 Add Transformation Object and Map them to the destination columns. Destination Data Type: Number Source Data Type: String
Steps to Replicate:
1. T2T for STG_TD_CONTRACTS has the following map information and was removed inadvertently.
FSI_ADJUSTABLE_TYPE_MLS_V.ADJUSTABLE_TYPE_CD maps to FSI_D_TERM_DEPOSITS.ADJUSTABLE_TYPE_CD.
2. Error when trying to reinstate the mapping, added FSI_ADJUSTABLE_TYPE_MLS_V back to the source entities,
and selected the V_ADJUSTABLE_TYPE_CD attribute to map to FSI_D_TERM_DEPOSITS.ADJUSTABLE_TYPE_CD.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!