Error While Running BC Standard Cashflow Edits ORA-01438: Value Larger Than Specified Precision (Doc ID 282773.1)

Last updated on SEPTEMBER 15, 2009

Applies to:

Oracle Financial Services Applications (OFSA) - Version: 4.5
Oracle Financial Data Manager - Version: 4.5
This problem can occur on any platform.

Symptoms

While running the Standard Cashflow Edits in Oracle Balance and Control (BC) the following errors are found in the log file:

ERROR

UPDATE Oracle Error: ORA- 01438: value larger than specified
precision allows for this column Driver Function:
drv_oci::Execute() SQL Statement:
update COMMERCIAL_LOAN_FIMIS a
set adjustable_type_cd = :adjustable_type_cd, accrual_basis_cd =
:accrual_basis_cd, amrt_term = :amrt_term, amrt_term_mult =
:amrt_term_mult, amrt_type_cd = :amrt_type_cd, as_of_date =
:as_of_date, compound_basis_cd = :compound_basis_cd, cur_book_bal
= :cur_book_bal, cur_gross_rate = :cur_gross_rate,
cur_net_par_bal_c = :cur_net_par_bal_c, cur_net_rate =
:cur_net_rate, cur_payment = :cur_payment, cur_par_bal =
:cur_par_bal, deferred_cur_bal = :deferred_cur_bal,
deferred_org_bal = :deferred_org_bal, int_type = :int_type,
interest_rate_cd = :interest_rate_cd, issue_date = :issue_date,
last_payment_date = :last_payment_date, last_reprice_date =
:last_reprice_date, lrd_balance = :lrd_balance, maturity_date =
:maturity_date, neg_amrt_eq_date = :neg_amrt_eq_date,
neg_amrt_eq_freq = :neg_amrt_eq_freq, neg_amrt_eq_mult =
:neg_amrt_eq_mult, neg_amrt_limit = :neg_amrt_limit,
net_margin_cd = :net_margin_cd, next_payment_date =
:next_payment_date, next_reprice_date = :next_reprice_date,
org_payment_amt = :org_payment_amt, org_par_bal = :org_par_bal,
org_term = :org_term, org_term_mult = :org_term_mult,
origination_date = :origination_date, percent_sold =
:percent_sold, pmt_adjust_date = :pmt_adjust_date, pmt_chg_freq =
:pmt_chg_freq, pmt_chg_freq_mult = :pmt_chg_freq_mult,
pmt_decr_life = :pmt_decr_life, pmt_decr_cycle = :pmt_decr_cycle,
pmt_freq = :pmt_freq, pmt_freq_mult = :pmt_freq_mult,
pmt_incr_cycle = :pmt_incr_cycle, pmt_incr_life = :pmt_incr_life,
rate_cap_life = :rate_cap_life, rate_chg_min = :rate_chg_min,
rate_chg_rnd_cd = :rate_chg_rnd_cd, rate_chg_rnd_fac =
:rate_chg_rnd_fac, rate_decr_cycle = :rate_decr_cycle,
rate_floor_life = :rate_floor_life, rate_incr_cycle =
:rate_incr_cycle, rate_set_lag = :rate_set_lag, rate_set_lag_mult
= :rate_set_lag_mult, remain_no_pmts_c = :remain_no_pmts_c,
reprice_freq = :reprice_freq, reprice_freq_mult =
:reprice_freq_mult, teaser_end_date = :teaser_end_date,
t_rate_int_rate_cd = :t_rate_int_rate_cd
where a.rowid = :0

Module Logging OFS errors: (203055) Error Bound Parameters: :adjustable_type_cd = 30
:accrual_basis_cd = 3 :amrt_term = 0 :amrt_term_mult = D
:amrt_type_cd = 700 :as_of_date = 11/ 30/ 2003 :compound_basis_cd
= 200 :cur_book_bal = 2240985.53 :cur_gross_rate = 5
:cur_net_par_bal_c = 2240985.53 :cur_net_rate = 5 :cur_payment =
0 :cur_par_bal = 2240985.53 :deferred_cur_bal = 0
:deferred_org_bal = 0 :int_type = 2 :interest_rate_cd = 999
:issue_date = 01/ 01/ 1900 :last_payment_date = 11/ 03/ 2003
:last_reprice_date = 05/ 26/ 2003 :lrd_balance = 2240985.53
:maturity_date = 01/ 31/ 3000 :neg_amrt_eq_date = 01/ 01/ 1900
:neg_amrt_eq_freq = 0 :neg_amrt_eq_mult = M :neg_amrt_limit = 0
:net_margin_cd = 0 :next_payment_date = 01/ 31/ 3000
:next_reprice_date = 01/ 31/ 3000 :org_payment_amt = 0
:org_par_bal = 2240985.53 :org_term = 363871 :org_term_mult = D
:origination_date = 11/ 03/ 2003 :percent_sold = 0
:pmt_adjust_date = 01/ 01/ 1900 :pmt_chg_freq = 0
:pmt_chg_freq_mult = M :pmt_decr_life = 0 :pmt_decr_cycle = 0
:pmt_freq = 363871 :pmt_freq_mult = D :pmt_incr_cycle = 0
:pmt_incr_life = 0 :rate_cap_life = 0 :rate_chg_min = 0
:rate_chg_rnd_cd = 0 :rate_chg_rnd_fac = 0 :rate_decr_cycle = 0
:rate_floor_life = 0 :rate_incr_cycle = 0 :rate_set_lag = 0
:rate_set_lag_mult = M :remain_no_pmts_c = 1 :reprice_freq = 0
:reprice_freq_mult = D :teaser_end_date = 01/ 01/ 1900
:t_rate_int_rate_cd = 0 :0 = AACVZKABrAAARM6AAJ SQL statement.

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