Transfer Pricing Process Failed with Illegal Instruction (Coredump) (Doc ID 2030261.1)

Last updated on AUGUST 08, 2016

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 6.1.1.1 version, Calculation Engine

Funds Transfer Pricing Rule (FTP) process failed and getting the core file in $FIC_DB_HOME/bin.

Error:
[LOG] Starting up.....
ClsUSmsConnect::ClsUSmsConnect, Forming Login Info statement
successfully read all database details
Connection to the following database was successful: OFSAUAT
Running TP, Process ID: 200171
Illegal instruction(coredump)

ofstp debug log file shows below at the end:
Module Logging OFS Access module data: /*Update Statement: update FSI_D_CASA set transfer_rate = 11.828616, matched_spread_c = cur_net_Rate - 11.828616, charge_credit_trate = cur_book_bal * (1- nvl(percent_sold,0)/100) * decode ( accrual_basis_cd, 1 ,30/360, 2 ,0.0861111, 3,0.0849315, 4 ,30.0/365.0 , 5,0.0821918, 6 ,0.0849315,1) * 0.118286 where PRODUCT_ID = 100442001.000000 and iso_currency_cd = 'USD' and as_of_date = to_date('05/31/2015','mm/dd/yyyy') */

Module Logging OFS Access module data: select
select a.rowid, a.id_number, a.identity_code, a.iso_currency_cd,
a.percent_sold, a.avg_book_bal, a.charge_credit_trate,
a.charge_credit_ocost, a.transfer_rate
from FSI_D_CASA a
where a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and a.PRODUCT_ID = :PRODUCT_ID
and as_of_date = to_date('05/ 31/ 2015', 'mm/ dd/ yyyy')

Steps
1. Run Funds Transfer Pricing process.

2. The batch shows failed but no error in FSI_PROCESS_ERRORS nor in ofstp debug log.

3. Run Funds Transfer Pricing process via the command line and it shows Illegal instruction (coredump) and core dump file is created at $FIC_DB_HOME/bin directory.

Changes

 

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