OBIA - ETL task failing ORA-01438: value larger than specified precision allowed for this column (Doc ID 859859.1)

Last updated on JANUARY 30, 2017

Applies to:

Siebel Financial Analytics - Version 7.9.5.1 [AA 1448] to 7.9.6.3 [AN 1900] [Release V7]
Information in this document applies to any platform.
Currency Check 03-Sep-2014

Symptoms

Statement of what the issue is
OBIA 7.9.5. with EBS 11.5.10 Financials GL

Informatica mapping

SDE_ORA_GLBalanceFact_Full

is failing while trying to insert 16 digit number in BALANCE_ACCT_AMTcolumn of W_GL_BALANCE_FS table (size of column is 15 digits)

Informatica ETL Task fails with error:

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

Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_GL_BALANCE_FS(LEDGER_ID,BUSN_AREA_ORG_ID,GL_ACCOUNT_ID,BALANCE_DATE,DB_CR_IND,BALANCE_ACCT_AMT,BALANCE_LOC_AMT,ACTIVITY_ACCT_AMT,ACTIVITY_LOC_AMT,ACCT_CURR_CODE,LOC_CURR_CODE,INTEGRATION_ID,DATASOURCE_NUM_ID,TENANT_ID,X_CUSTOM,BALANCE_TYPE_FLAG,TRANSLATED_FLAG,SUMMARY_ACCOUNT_FLAG,LAST_UPDATE_DATE,AUX1_CHANGED_ON_DT,AUX2_CHANGED_ON_DT) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
WRITER_1_*_1> CMN_1761 Timestamp Event: [Mon Jun 22 18:29:04 2009]
WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Mon Jun 22 18:29:04 2009]
WRITER_1_*_1> WRT_8114
Row # [1] in bad file

WRITER_1_*_1> CMN_1053 : Rowdata: ( RowType=0(insert) Src Rowid=6436 Targ Rowid=6436
LEDGER_ID (LEDGER_ID:Char.80:): "83"
BUSN_AREA_ORG_ID (BUSN_AREA_ORG_ID:Char.80:): "1"
GL_ACCOUNT_ID (GL_ACCOUNT_ID:Char.80:): "106757"
BALANCE_DATE (BALANCE_DATE:Date:): "12/31/2007 00:00:00"
DB_CR_IND (DB_CR_IND:Char.10:): "DEBIT"
>>> BALANCE_ACCT_AMT (BALANCE_ACCT_AMT:Double:): "2580381846712650"

Data includes amounts in Indonesian rhupia: 1 USD = 10,330.0000 IDR so makes for extremely large numbers

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