FTP Batch Failure With No Fatal Errors in FSI_PROCESS_ERRORS and No Errors in Log (Doc ID 2807349.1)

Last updated on APRIL 26, 2023

Applies to:

Symptoms

When running an FTP Batch with Cash Flow Transfer Pricing methods, some Tasks fail.  There are no errors but the the log file ends with a select against the instrument table:

Module Logging OFS Access module data: select
select a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID,
a.PRODUCT_ID,  a.LEGAL_ENTITY_ID, a.ACTIVITY_ID,
a.CUSTOMER_ID, a.id_number, a.identity_code,
a.instrument_type_cd, a.as_of_date, a.cur_net_rate,
a.ADJ_EFFECTIVE_DATE, a.org_term, a.org_term_mult, a.pmt_freq,
a.pmt_freq_mult, a.org_book_bal, a.percent_sold,
a.adjustable_type_cd, a.cur_book_bal, a.matched_spread_c,
a.HOLIDAY_ROLLING_CONVENTION_CD, a.HOLIDAY_CALENDAR_CODE,
a.HOLIDAY_CALC_OPTION_CD, a.transfer_rate, 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.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_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.lrd_balance, a.compound_basis_cd,
a.iso_currency_cd, a.tp_average_life, a.tp_duration,
a.tp_effective_date, a.RESIDUAL_AMOUNT, a.MATURITY_AMOUNT,
a.AMORT_METH_PDFC_CD, a.EXPECTED_BAL, a.EXPECTED_BAL_GROWTH_PCT,
a.OFFSET_PERCENT, a.MINIMUM_BALANCE, a.BEHAVIOUR_TYPE_CD,
a.BEHAVIOUR_SUB_TYPE_CD, a.DEVOLVEMENT_STATUS_CD,
a.HOLIDAY_ROLLING_CONVENTION_CD, a.HOLIDAY_CALENDAR_CODE,
a.HOLIDAY_CALC_OPTION_CD, a.ORIG_OFFSET_BAL, a.LRD_OFFSET_BAL
from FSI_D_LOAN_CONTRACTS a
where a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and a.COMMON_COA_ID = :COMMON_COA_ID
and (a.transfer_rate=0
or a.transfer_rate is null)
and as_of_date = to_date('08/ 31/ 2021', 'mm/ dd/ yyyy')

There is nothing after this SQL in the log.

There are no errors in the nohup.out from $FIC_DB_HOME/bin.

There are no fatal errors in FSI_PROCESS_ERRORS.

Cause

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