ORA-01438: value larger than specified precision allowed for this column Running T2T for FTP and ALM Applications (Doc ID 2012466.1)

Last updated on MAY 31, 2016

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Data Ingestion
Data Integration
Table to Table Extract Mapping (T2T)

Symptoms

On OFSAA 8.0.0, there is an issue with T2T_INVESTMENTS. The T2T_INVESTMENTS that populates FSI_D_INVESTMENTS has a derived column consisting of n_eop_bal which is NUMBER(22,3). However, this derived column is mapped to CUR_BOOK_BAL NUMBER(14,2). This triggers the T2T to fail with the following error:

ERROR
ORA-01438: value larger than specified precision allowed for this column.

Additionally these columns that are meant to store balances have to be number(22,3). Instead they are number(14,2).

LRD_BALANCE
DEFERRED_ORG_BAL
CUR_PAR_BAL
DEFERRED_CUR_BAL
CUR_NET_PAR_BAL_C
ORG_BOOK_BAL
CUR_NET_BOOK_BAL_C
ORG_PAR_BAL
AVG_NET_BOOK_BAL_C
ORG_NET_BOOK_BAL_C
ORG_NET_PAR_BAL_C
AVG_BOOK_BAL

The issue can be reproduced at will with the following steps:
1. Execute batch AAIPROD_T2T_FOR_INVESTMENTS for 31-Aug-2014

Cause

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