My Oracle Support Banner

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)

Symptoms

On FTP 8.0.7, standard FTP process is failed.  There do not appear to be any errors.

ACTUAL BEHAVIOR
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
from FSI_D_LOAN_CONTRACTS
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.

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.