Not Able to See the View Log Screen from FTP 5.2.2 for Cash Flow Edits (Doc ID 1332780.1)

Last updated on JUNE 23, 2011

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version: 5.2 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.2

Symptoms

On Oracle Financial Services Funds Transfer Pricing (FTP) 5.2.2, when attempting to see the View Log Summary screen from an executed Cash Flow Edits rule, the successfully executed batch is not visible. Instead the screen shows Component Type: Profitability Management.

Also, the query used is for FSI_MESSAGE_LOG instead of the correct FSI_PROCESS_ERRORS:

SELECT *
FROM
(SELECT a.*,
rownum RN
FROM
( SELECT DISTINCT TO_CHAR(di.as_of_date,'DS') asofdate,
TO_CHAR(dt.msg_timestamp,'DS') mdate,
TO_CHAR(dt.msg_timestamp,'HH:MM:SS') mtime,
dt.msg_timestamp ts,
ct.FOLDER_NAME,
ct.ID_TYPE,
tl.SHORT_DESC,
dt.PROCESS_ID,
ct.CREATED_BY,
dt.BATCH_RUN_ID,
ic.V_BATCH_STATUS,
di.as_of_date
FROM fsi_message_log dt,
FSI_M_OBJECT_DEFINITION_B ct,
FSI_M_OBJECT_DEFINITION_TL tl,
BATCH_RUN_VIEW ic,
fsi_data_identity di
WHERE upper(TO_CHAR(di.as_of_date, 'DS')) = upper('1/31/2011')
AND lower(ct.FOLDER_NAME) = lower('OFSAA52SEG')
AND ct.ID_TYPE IN (0)
AND dt.process_id LIKE '%200489%'
AND dt.process_id =ct.OBJECT_DEFINITION_ID
AND dt.process_id =tl.OBJECT_DEFINITION_ID
AND ic.app_batch_run_id = dt.BATCH_RUN_ID
AND di.batch_name = dt.BATCH_RUN_ID
ORDER BY as_of_date DESC
)a
WHERE rownum <= 0
)
WHERE RN >= 0]

EXPECTED BEHAVIOR
Expect to be able to see the Cash Flow Edit results in View Log after running Cash Flow Edits from FTP.

STEPS
The issue can be reproduced at will with the following steps:
1. Create a new FTP Cash Flow Edit
2. Run the FTP Cash Flow Edit
3. Click the VIEW LOG screen

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