ORA-01438: value larger than specified precision allowed for this column Running T2T for FTP and ALM Applications
Last updated on JANUARY 05, 2018
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)
Table to Table Extract Mapping (T2T)
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:
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).
The issue can be reproduced at will with the following steps:
1. Execute batch AAIPROD_T2T_FOR_INVESTMENTS for 31-Aug-2014
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms