My Oracle Support Banner

[6691] 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)

Symptoms

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.

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


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