My Oracle Support Banner

Incorrect Column Mapping in OFSAA 8.0.6 OOTB T2T_STG_LC_GUARANTEES for LC_CONTRACTS (Doc ID 2642935.1)

Last updated on FEBRUARY 26, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Table-to-Table (T2T)

Symptoms

On 8.0.6 version, mapping issue for OOTB T2T_STG_LC_GUARANTEES T2T for LC_CONTRACTS

In the STG_LC_CONTACTS table, the column N_TENOR_DAYS is mapped to the FSI_D_GUARANTEES columns: ORG_TERM_MULT (String of length 1) and AMRT_TERM_MULT (String of length 1).

Therefore, when N_TENOR_DAYS is calculated as CLOSURE_DATE - ISSUE_DATE, the computed values are large (exceeding the length of 1).

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.