My Oracle Support Banner

FTP Process Failure ORA-01438: Value Larger Than Specified Precision Allowed for This Column Error for Breakage Charge Adjustment FTP Process (Doc ID 2675896.1)

Last updated on JUNE 05, 2020

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.7 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 Enterprise Performance Management (EPM)

Symptoms

On FTP 8.0.7.2, FTP Process fails when the Adjustment Rule has Breakage Charges Adjustment Method. The following error is thrown in the FTP engine .err file:

ERROR


Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
  oexn() SQL Function: [5] -
UPDATE Oracle Error: ORA-01438: value larger than specified
  precision allowed for this column Driver Function:
  drv_oci::Execute() SQL Statement:
update FSI_D_BREAK_FUNDING_CHARGES a
set TRAN_RATE_REM_TERM = :TRAN_RATE_REM_TERM, BREAK_FUNDING_RATE
  = :BREAK_FUNDING_RATE, BREAK_FUNDING_AMT = :BREAK_FUNDING_AMT,
  BREAK_FUNDING_MV = :BREAK_FUNDING_MV, BREAK_FUNDING_AMT_CHG =
  :BREAK_FUNDING_AMT_CHG, tp_average_life = :tp_average_life,
  tp_duration = :tp_duration
where a.rowid = :0


Module Logging OFS errors: (203055) Error Bound Parameters: :TRAN_RATE_REM_TERM =
  0.806183737713755 :BREAK_FUNDING_RATE = - 16620.6247595667
  :BREAK_FUNDING_AMT = 12224.4695106613 :BREAK_FUNDING_MV = -
  12298.0195106613 :BREAK_FUNDING_AMT_CHG = 12224.4695106613
  :tp_average_life = 0 :tp_duration = 0 :0 = AAAy+ QABDAAA8jKAAN
  SQL statement.


Module Logging OFS errors: (203055) Error Executing SQL statement.

Cause

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
Symptoms
Cause
Solution
References


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