Standand FTP Process Fails With No Errors
(Doc ID 2546489.1)
Last updated on SEPTEMBER 24, 2019
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)
On FTP 8.0.7, standard FTP process is failed. There do not appear to be any errors.
FTP process is failed. Clicked the failed link, it just says No Data Found in View Log indicating no errors are written to FSI_PROCESS_ERRORS.
'Show Significant Calculation SQL' log file ends with the query on the instrument records:
Module Logging OFS calculation module data: select
select a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID,
a.PRODUCT_ID, a.LEGAL_ENTITY_ID, a.CUSTOMER_ID, a.id_number,
a.HOLIDAY_CALC_OPTION_CD, a.ORIG_OFFSET_BAL, a.LRD_OFFSET_BAL
where a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and a.PRODUCT_ID = :PRODUCT_ID
and as_of_date = to_date('03/ 31/ 2019', 'mm/ dd/ yyyy')
and LEGAL_ENTITY_ID = -1
The issue can be reproduced at will with the following steps:
1. Run FTP process.
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