My Oracle Support Banner

FTP Propagation Process Fails When Run in Batch (Doc ID 2593293.1)

Last updated on OCTOBER 10, 2019

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.4 to 8.0.4 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 8.0.4
Oracle Financial Services Funds Transfer Pricing (FTP) 8.0.4

Symptoms

When running a production batch of FTP Processes, certain FTP Rate Propagation processes are failing when the update statement is executed.  The ofstp.xxxxxxx.log from $FIC_DB_HOME/log/FusionApps ends with the following code used for Rate Propagation:

Module Logging OFS calculation module data: update
update FSI_D_LEASES a
set (a.TRANSFER_RATE) = (select decode( NVL(a.TRANSFER_RATE, 0),
     0, decode (a.reprice_freq, 0, old.TRANSFER_RATE, decode (greatest
     (a.last_reprice_date, to_date ( '12/ 31/ 2018', 'MM/ DD/ YYYY')),
     to_date ( '12/ 31/ 2018', 'MM/ DD/ YYYY'), old.TRANSFER_RATE,
     a.TRANSFER_RATE )) , a.TRANSFER_RATE)
from FSI_D_LEASES_H old
where old.id_number = a.id_number
and old.as_of_date = to_date('12/ 31/ 2018', 'MM/ DD/ YYYY') )
where a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and a.COMMON_COA_ID = :COMMON_COA_ID
and ((a.ID_NUMBER < ' 12345'
or a.ID_NUMBER > ' 12345')))
and as_of_date = to_date('01/ 31/ 2019', 'mm/ dd/ yyyy')
and a.as_of_date = to_date('01/ 31/ 2019', 'MM/ DD/ YYYY')
and exists(select id_number
from FSI_D_LEASES_H old
where old.id_number = a.id_number
and old.as_of_date = to_date('12/ 31/ 2018', 'MM/ DD/ YYYY') )
and not exists (select product_id
from FSI_M_TRANSFER_PRICE_RULE t
where t.product_id = a.COMMON_COA_ID
and t.transfer_price_sys_id = 202614.000000
and t.data_source_cd = 2)

There is no additional SQL in the log after the update.  The Batch Task ends in a status of "Failed".

There are no errors reported anywhere.  There are no errors in FSI_PROCESS_ERRORS.

The nohup.out does not contain an error.  The FTP Process execution ends with the following:

successfully read all database details
Connection to the following database was successful: <USER>
Running TP, Process ID: 292568
ID_TYPE = 204


The issue occurs when filtering for just one ID_NUMBER.

This only occurs when the FTP Processes are run in a batch.  When they run the same process from the FTP Process user interface, it runs successfully.

There are some propagation processes that do run successfully.

Cause

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
Symptoms
Cause
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.