FTP Processes Fail to Assign Transfer Rates to a Batch in Prod When Same Batch Worked in Dev
(Doc ID 2663853.1)
Last updated on MAY 05, 2020
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
In production, FTP processes fails to assign rates for all rules in a Batch. The processes fail to update the Transfer Rate and Adjustment Rate columns.
These rules were migrated from Dev to Prod and this issue does not happen in Dev.
The following SQL is at the end of the FTP Process log for Task1:
Module Logging OFS calculation module data: select
select distinct a.ISO_CURRENCY_CD, a.PRODUCT_ID
from FSI_D_TERM_DEPOSITS a
where (((a.RECORD_COUNT <> (DECODE(((To_Char((a.AS_OF_DATE),
'YYYY')* 100)+ To_Char((a.AS_OF_DATE), 'MM' )),
((To_Char((a.ORIGINATION_DATE), 'YYYY')* 100)+
To_Char((a.ORIGINATION_DATE), 'MM' )), 1, 0)))))
and as_of_date = to_date('03/ 31/ 2020', 'mm/ dd/ yyyy')
and LEGAL_ENTITY_ID = 0099
order by a.ISO_CURRENCY_CD, a.PRODUCT_ID
The log ends soon after this SQL without selecting data from the instrument table.
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