How to Map ATM_CARD_FLG and PHONE_TRANSACTIONS_FLG for FSI_D_CASA (Doc ID 1999287.1)

Last updated on APRIL 14, 2015

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 to 8.0.0 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

How to Map ATM_CARD_FLG and PHONE_TRANSACTIONS_FLG for FSI_D_CASA in Release 8.0.0.

There is a change in Data Type in Release 8.0.0 that has not been reflected in T2T Mapping. This is noted in Bug 20554020 - T2T for CASA Failing with Invalid Number Error

In Release 7:
STG_D_CASA.F_ATM_FACILITY is CHAR(1 CHAR)
STG_D_CASA.F_TB_FACILITY is   CHAR(1 CHAR)

FSI_D_CASA.ATM_CARD_FLG is CHAR(1 CHAR)
FSI_D_CASA.PHONE_TRANSACTIONS_FLG is CHAR(1 CHAR)

In Release 8.0
STG_D_CASA.F_ATM_FACILITY is CHAR(1 CHAR)
STG_D_CASA.F_TB_FACILITY is   CHAR(1 CHAR)

FSI_D_CASA.ATM_CARD_FLG is NUMBER
FSI_D_CASA.PHONE_TRANSACTIONS_FLG is NUMBER

Solution

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