FTP Process Remains Stuck in Ongoing With FTP Debug Log Ending on Instrument Table Select (Doc ID 3020279.1)

Last updated on MAY 02, 2024

Applies to:

Symptoms

On FTP 8.0.5, there is an existing FTP Process on FSI_D_LOAN_CONTRACTS which is stuck in on-going and appears to be stopped. The FTP Debug log ends with the following:

Module Logging OFS calculation module data: Thread: 1 Table: FSI_D_LOAN_CONTRACTS, ISO_CURRENCY_CD:INR,
PRODUCT_ID:400005

Module Logging OFS Access module data: /*cl_ids.cpp :: BOOL TP_Context::FindTP(const FTPKey& Key) */

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.ALM_COA_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.avg_book_bal,
a.matched_spread_c, a.HOLIDAY_ROLLING_CONVENTION_CD,
a.HOLIDAY_CALENDAR_CODE, a.HOLIDAY_CALC_OPTION_CD,
a.transfer_rate, a.charge_credit_trate, 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.PRODUCT_ID = :PRODUCT_ID
and (((a.ORIGINATION_DATE < TO_DATE('04/ 01/ 2022', 'MM/ DD/
YYYY')
or a.ORIGINATION_DATE > TO_DATE('04/ 01/ 2100', 'MM/ DD/ YYYY')))
and ((a.SALES_CHANNEL < 'TWO'
or a.SALES_CHANNEL > 'TWO')))
and as_of_date = to_date('03/ 31/ 2024', 'mm/ dd/ yyyy')

Module Logging OFS Access module data: /* mTP_Context->ProcData.calc_adj =

Module Logging OFS Access module data: /* GetTRateCol() */

Additional Details:
1.This is a newly created environment (database), and data migration was performed from production environment. This task was successful when we performed test run.
2.The LOANS transfer pricing rule execution works initially, but then abruptly stops showing database sessions and logs.
3.The rule was successful for Dec month data.
4.It was running on the application server as we have run many times so we have killed the batches on application server.
5.Data sets are not same, but the process is same from production.

Note: We are testing this data sets for new implementation given by business for some columns e.g. Reprice frq,Reprice frq mult,next reprice date,maturity date.

Have tried the following solutions:
1. Restarted all services.
2. Created a copy of the rule and tried running the same.
3. Other transfer pricing rules for LOANS are getting executed successfully.
4. Did a database bounce.

Changes

Cause

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