My Oracle Support Banner

AMRT_TERM_MULT and ORG_TERM_MULT Mappings Have Incorrect Data Type in T2T_STG_LC_GUARANTEES (Doc ID 2542315.1)

Last updated on MARCH 24, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6 to 8.0.7.1.0 [Release 8]
Oracle Financial Services Data Foundation - Version 8.0.6 to 8.0.7 [Release 8]
Oracle Financial Services Profitability Management - Version 8.0.6 to 8.0.7 [Release 8]
Oracle Financial Services Asset Liability Management - Version 8.0.6 to 8.0.7 [Release 8]
Oracle Financial Services Funds Transfer Pricing - Version 8.0.6 to 8.0.7 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 8.0.6, for a T2T Data Mapping definition, in the seeded T2T_STG_LC_GUARANTEES, used to load data into FSI_D_GUARANTEES, there are two Source to Target column mappings, for AMRT_TERM_MULT and ORG_TERM_MULT, with inconsistent data types.

N_TENOR_DAYS on STG_LC_CONTRACTS is mapped incorrectly to AMRT_TERM_MULT and ORG_TERM_MULT.

AMRT_TERM_MULT and ORG_TERM_MULT are defined as CHAR(1) and will contain a value of 'D', 'M', or 'Y'.

N_TENOR_DAYS is defined as NUMBER(5,0).  It is not compatible with the term columns.

Note:  The T2T execution can fail with the error "ORA-12899: value too large for column" because N_TENOR_DAYS contains values like 60, 90, 210, etc.

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
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.