OFSA TP Process Fails With ORA- 01455: converting column overflows integer datatype Error (Doc ID 1459273.1)

Last updated on MARCH 04, 2016

Applies to:

Oracle Transfer Pricing - Version 4.5.39 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

On Oracle Transfer Pricing (TP) 4.5.39, when attempting to run a TP Process on FEM_CHECKING the following error occurs:

ERROR
Oracle/TP
Version 4.5.39
Copyright (c) Oracle Corporation, 1995-2000
All rights reserved worldwide.

Connection to the following database was successful: fdm1
Running TP, Process ID: 4373148 Configuration ID: 4363084
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [12] - ofetch(), ofen()
SQL Function: [4] - SELECT
Oracle Error: ORA-01455: converting column overflows integer datatype

Driver Function: drv_oci::FetchNext()

SQL Statement: select a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID, a.RM_COA_ID, a.MARKET_SEGMENT_CD, a.CHANNEL_CD, a.SEG_VALUE_ID, a.RT_FTP_COA, a.id_number, a.identity_code, a.cur_net_rate, a.percent_sold, a.matched_spread_c, a.transfer_rate, a.tran_rate_rem_term, a.accrual_basis_cd, a.amrt_term, a.amrt_term_mult, a.amrt_type_cd, a.cur_par_bal, a.cur_tp_per_adb, a.cur_gross_rate, a.cur_payment, a.deferred_cur_bal, a.deferred_org_bal, a.interest_rate_cd, a.last_reprice_date, a.margin, a.margin_gross, a.margin_t_rate, a.maturity_date, a.neg_amrt_eq_date, a.neg_amrt_eq_freq, a.neg_amrt_eq_mult, a.neg_amrt_limit, a.neg_amrt_amt, a.net_margin_cd, a.next_payment_date, a.next_reprice_date, a.org_par_bal, a.org_payment_amt, a.org_term, a.org_term_mult, a.origination_date, a.issue_date, a.pmt_adjust_date, a.pmt_chg_freq, a.pmt_chg_freq_mult, a.pmt_decr_cycle,a.pmt_decr_life, a.pmt_freq, a.pmt_freq_mult, a.pmt_incr_cycle, a.pmt_incr_life, a.prior_tp_per_adb, a.rate_cap_life, a.rate_chg_min, a.rate_chg_rnd_cd, a.rate_chg_rnd_fac, a.rate_decr_cycle, a.rate_floor_life, a.rate_incr_cycle, a.rate_set_lag, a.rate_set_lag_mult, a.remain_no_pmts_c, a.reprice_freq, a.reprice_freq_mult, a.teaser_end_date, a.t_rate_int_rate_cd, a.last_payment_date, a.int_type, a.adjustable_type_cd, a.lrd_balance, a.instrument_type_cd, a.compound_basis_cd, a.iso_currency_cd from FEM_CHECKING a where a.as_of_date = :as_of_date and a.RT_FTP_COA = :RT_FTP_COA and a.ORG_UNIT_ID = :ORG_UNIT_ID and (((a.AS_OF_DATE = (To_Date( To_Char((2011 + (12) * Power(10, 6)+ (31) * Power(10, 4)), '99G99G9999', 'NLS_NUMERIC_CHARACTERS = "/"'), 'MM/DD/YYYY')))) and ((a.CUR_PAR_BAL < 0.00 or a.CUR_PAR_BAL > 0.00)) and ((a.COMMON_COA_ID < 1203049999 or a.COMMON_COA_ID > 1203049999)))
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:


The issue can be reproduced at will with the following steps:
1. Run TP Process ID: PRU_CHK_NC.FTP on the server.

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