Error While Loading the Page Error Accessing Cash Flow Edits from FTP 5.2 (Doc ID 1276635.1)

Last updated on MARCH 06, 2014

Applies to:

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

Note: This issue is ONLY applicable for FTP 5.2 version and is resolved in FTP 5.2.2 and higher.


On Funds Transfer Pricing (FTP) 5.2 when attempting to navigate to Cash Flow Edits, the following error occurs:

Error while loading the page.

Not able to execute the query for module Id_Type: CFE_ALM: infodom: OFSAEPM
Query: select NAME "1", REV_SEGMENT_MAST_V.V_SEGMENT_NAME "3", FSI_CASH_FLOW_EDITS_MASTER.CREATED_DATE "9", FSI_CASH_FLOW_EDITS_MASTER.CREATED_BY "8", fsi_process_run_history.EXECUTED_ON "73", fsi_process_run_history.EXECUTED_BY "74", FSI_CASH_FLOW_EDITS_MASTER.CASH_FLOW_EDIT_SYS_ID "PrimaryKey", '200~'||FSI_CASH_FLOW_EDITS_MASTER.DESCRIPTION ||':201~'|| FSI_CASH_FLOW_EDITS_MASTER.CASH_FLOW_EDIT_SYS_ID "DBToolText", fsi_m_object_definition_tl.short_desc ||'&folder='||FSI_CASH_FLOW_EDITS_MASTER.FOLDER "TaskName",fsi_process_run_history.LAST_RUN_AS_OF_DATE "ErrorDate", decode(fsi_process_run_history.process_sys_id,NULL,'BLANK','viewlog') "71" from FSI_CASH_FLOW_EDITS_MASTER, fsi_process_run_history,fsi_m_object_definition_tl, REV_SEGMENT_MAST_V where FSI_CASH_FLOW_EDITS_MASTER.CASH_FLOW_EDIT_SYS_ID = fsi_process_run_history.process_sys_id(+) and FSI_CASH_FLOW_EDITS_MASTER.CASH_FLOW_EDIT_SYS_ID = fsi_m_object_definition_tl.object_definition_id(+) and REV_SEGMENT_MAST_V.V_SEGMENT_CODE = FSI_CASH_FLOW_EDITS_MASTER.FOLDER and REV_SEGMENT_MAST_V.V_DSNID = 'OFSAEPM' AND FSI_CASH_FLOW_EDITS_MASTER.FOLDER = 'EPMGRPSEG' AND FSI_CASH_FLOW_EDITS_MASTER.LEAF_NUM_ID = '4'

==> Found that the FSI_PROCESS_RUN_HISTORY table does not exist.

Asset Liability Management (ALM) 5.2 is not installed.

The issue can be reproduced at will with the following steps:
1. Navigate to Financial Services Applications -> Funds Transfer Pricing -> FTP Processing -> Cash Flow Edits


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