My Oracle Support Banner

Is it Recommended to Use Table Level DOP or Parallel DML With FTP or ALM (Doc ID 2356809.1)

Last updated on APRIL 28, 2021

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 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 Asset Liability Management (ALM)
Performance Tuning
Slow Performance

Goal

On FTP 8.0.4, it appears that enabling table level degree of parallelism (DOP) appears to cause failure of previously working FTP jobs.  Have set parallelism to 4 for some instrument tables to improve processing, but it is causing some tasks to fail. Is there a conflict with table level DOP? Is there an alternate way to set items to run in parallel?

$ cat ofstp.OFSA72_Task2_FTP_COR_20170731_16.err
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
  oexn() SQL Function: [4] -
SELECT Oracle Error: ORA-12838: cannot read/ modify an object
  after modifying it in parallel Driver Function:
  drv_oci::Execute() SQL Statement:
select a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID,
  a.PRODUCT_ID, a.COST_DRIVER_ID, a.LEGAL_ENTITY_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.cur_tp_per_adb,
  a.interest_rate_cd, a.last_reprice_date, a.margin,
  a.maturity_date, a.next_reprice_date, a.origination_date,
  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_floor_life,
  a.reprice_freq, a.reprice_freq_mult, a.teaser_end_date,
  a.tp_average_life, a.tp_duration, a.tp_effective_date
from PNCB_FSI_D_CORE_DEPOSIT 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('07/ 31/ 2017', 'mm/ dd/ yyyy')


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


Module Logging OFS errors: (203055)

OR

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [4] -
SELECT Oracle Error: ORA- 12838: cannot read/ modify an object
after modifying it in parallel Driver Function:
drv_oci::Execute() SQL Statement:
select a.node_map_id, a.prod_id, a.currency, a.LIQ_ADJ_NODE,
a.BASIS_ADJ_NODE, a.PRIC_ADJ_NODE, a.OTH_ADJ_NODE,
a.LIQ_ADJ_TP_NODE, a.BASIS_ADJ_TP_NODE, a.PRIC_ADJ_TP_NODE,
a.OTH_ADJ_TP_NODE
from fsi_process_node_map_tpadj a
where a.node_map_id = :node_map_id
order by a.prod_id, a.currency

Solution

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
Goal
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.