My Oracle Support Banner

ALMBI Transformation Fails with 'ORA-01438: Value Larger than Specified Precision Allowed for this Column' (Doc ID 2011560.1)

Last updated on MAY 20, 2021

Applies to:

Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


For Oracle Financial Services Asset Liability Management Analytics (ALMBI) 6.1, when you run the ALM Results Transformation program, ALM_BI_TRANSFORMATION, results are not getting loaded.  In FSI_PROCESS_RUN_HISTORY, BI_TRANSFORM_STATUS is null for the PROCESS_SYS_ID and rows are missing from the target table FCT_AGG_CONS_CCY_ALM_MEASURES.

The following error message exists in FSI_MESSAGE_LOG for the process:

Insert Failed from FSI_O_CONSOLIDATED_MASTER to FCT_AGG_CONS_CCY_ALM_MEASURES: SQLCODE:-1438 SQLMSG:ORA-01438: value larger than specified precision allowed for this column

This error prevents the ALM_BI_TRANSFORMATION program from inserting rows.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.