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)
On : 220.127.116.11 version, Calculation Engine
Funds Transfer Pricing Rule (FTP) process failed and getting the core file in $FIC_DB_HOME/bin.
[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
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,
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')
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.
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