[6691] Datatype Format Mismatch When Remap ADJUSTABLE_TYPE_CD in T2T
(Doc ID 2432608.1)
Last updated on APRIL 24, 2023
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.0.6 and laterOracle 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
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Symptoms
On 8.0.6, 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.
Error:
[6691] Datatype format mismatch
[6855] 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.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |