View Log Link Does Not Appear in FTP Process Summary Screen After Execution of Process
Last updated on OCTOBER 04, 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 Oracle Financial Services Funds Transfer Pricing (FTP) 6.1, after running an FTP process, no view log link appears.
The FTP process completes with errors (FSI_PROCESS_ERRORS table contains rows with errors for the process ID). A View Log link is expected in the status field inside the Standard Process screen, however it never appears. The Status field is empty.
The following error can be found in ftpapp.log (weblayer side):
ORA-00942: table or view does not exist
[25-10-13 17:54:09 PM] ~ INFO ~ FTP ~ FTPUtil :: getProcessStatus() : query ::::::::::::SELECT DISTINCT LOOKUPTL.LOOKUP_DESCRIPTION FROM FSI_M_LOOKUP_TL LOOKUPTL WHERE LOOKUPTL.CATEGORY_ID = 87 AND LOOKUPTL.LANG_CODE = ? AND LOOKUPTL.LOOKUP_CD = CASE WHEN (SELECT STATUS FROM FSI_M_TP_PROCESS_RULE TP WHERE TP.TP_PROCESS_SYS_ID = ?) = 1 THEN NVL((SELECT V_BATCH_STATUS FROM BATCH_RUN_VIEW B, FSI_PROCESS_RUN_HISTORY R WHERE B.V_BATCH_RUN_ID = R.BATCH_RUN_ID AND EXECUTED_ON IN (SELECT MAX(R.EXECUTED_ON) FROM FSI_PROCESS_RUN_HISTORY R WHERE R.PROCESS_SYS_ID = ?) AND R.PROCESS_SYS_ID = ?), '1') ELSE '0' ENDSYSID === 200005
[25-10-13 17:54:09 PM] ~ ERROR ~ FTP ~ ERR FTPUtil :: getProcessStatus() : ORA-00942: table or view does not exist
Steps to reproduce
The issue can be reproduced at will with the following steps:
1. Install FTP 6.1 application
2. Execute a TP Standard process which should end with errors.
3. Check the Status of the process for the View Log link.
New FTP 6.1 instalation.
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