My Oracle Support Banner

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

Last updated on MARCH 24, 2019

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 5.2 to 5.2.2 [Release 5]
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
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




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.