View Log Link Does Not Appear in FTP Process Summary Screen After Execution of Process

(Doc ID 1595546.1)

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)

Symptoms

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

ERROR

[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.

Changes

 New FTP 6.1 instalation.

Cause

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