FTP Process with Payment Schedule Records and Rate Propagation Fails with '(905002) Child died with signal 11.' (Doc ID 2654599.1)

Last updated on MARCH 04, 2024

Applies to:

Symptoms

In FTP 8.0.5, when attempting to run an FTP Process containing Payment Schedule records (AMRT_TYPE_CD in 800, 801, or 802) and Rate Propagation, it fails with error below in the ofstp.xxxxxx.log from $FIC_DB_HOME/log/FusionApps:

Module Logging OFS Access module data: /* 307: io_id_pschdl::GetID_PSCHDL*/

Module Logging OFS Access module data: select
select FSI_D_PAYMENT_SCHEDULE.id_number,
          FSI_D_PAYMENT_SCHEDULE.payment_date,
          FSI_D_PAYMENT_SCHEDULE.instrument_type_cd,
          FSI_D_PAYMENT_SCHEDULE.amount,
          FSI_D_PAYMENT_SCHEDULE.identity_code
from FSI_D_PAYMENT_SCHEDULE
where FSI_D_PAYMENT_SCHEDULE.instrument_type_cd = 140.00000
          and id_number = ' xxxxxxx'
          and FSI_D_PAYMENT_SCHEDULE.identity_code = 20190731.00000
order by FSI_D_PAYMENT_SCHEDULE.payment_date 


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

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

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

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

Module Logging OFS errors: (905002) Child died with signal 11. 

Module Logging OFS errors: (905001) Child dumped core.

In Common Object Maintenance > Process Tuning, multi-processing is enabled for Funds Transfer Pricing with Number of Processes > 1.

Cause

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