Getting ORA-01438 Precision Error Running PA OFSA 4.5 Allocation (Doc ID 200490.1)

Last updated on OCTOBER 01, 2013

Applies to:

Oracle Profitability Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5
Oracle Performance Analyzer (PA) - Version: 4.5

Checked for relevance on 01-Oct-2013.

Symptoms

When attempting to run an allocation, the following errors are returned:

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

(203055) Error Bound Parameters: :FINANCIAL_ELEM_ID = 15230 : ORG_UNIT_ID = 9 ... :ytd_01 = 0 :month_02 = 128424060928.43

Error happens on insert into temporary table for ledger_stat allocation.

insert into ALLOC_100075_3ea0 (
FINANCIAL_ELEM_ID,ORG_UNIT_ID,GL_ACCOUNT_ID,COMMON_COA_ID,BDI_LOB_ID,ident
ity_code,year_s,accum_type_cd,consolidation_cd,iso_currency_cd,month_01,ytd_01,m
onth_02,ytd_02,month_03,ytd_03,month_04,ytd_04,month_05,ytd_05,month_06,ytd_06,m
onth_07,ytd_07,month_08,ytd_08,month_09,ytd_09,month_10,ytd_10,month_11,ytd_11,m
onth_12,ytd_12)
values ( :FINANCIAL_ELEM_ID, :ORG_UNIT_ID, :GL_ACCOUNT_ID, :COMMON_COA_ID, :
BDI_LOB_ID, :identity_code, :year_s,
:accum_type_cd, :consolidation_cd, :iso_currency_cd, :month_01, :ytd_01, :
month_02, :ytd_02, :month_03, :ytd_03, :month_04,
:ytd_04, :month_05, :ytd_05, :month_06, :ytd_06, :month_07, :ytd_07, :month_08,
:ytd_08, :month_09, :ytd_09, :month_10,
:ytd_10, :month_11, :ytd_11, :month_12, :ytd_12 )
(203055) Error Bound Parameters:
:FINANCIAL_ELEM_ID = 15150
:ORG_UNIT_ID = 884
:GL_ACCOUNT_ID = 0
:COMMON_COA_ID = 200000
:identity_code = 171
:year_s = 2002
:accum_type_cd = D
:consolidation_cd = 100
:iso_currency_cd = 002
:month_01 = 0
:ytd_01 = 0
:month_02 = 175601844094.08
:ytd_02 = 175601844094.08

The invalid balance in error message is greater than $99,999,999,999. 9999.

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