ALM 5.1 Cash Flow Edits Interface Errors on AIX (Doc ID 1265885.1)

Last updated on DECEMBER 28, 2010

Applies to:

Oracle Financial Services Asset Liability Management - Version: 5.1 and later   [Release: 5 and later ]
IBM AIX on POWER Systems (64-bit)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.1
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.1

Symptoms

On Asset Liability Management (ALM) 5.1, when attempting to access the Cash Flow Edits, the following error occurs:

ERROR
Not able to execute the query for module Id_Type: CFE_ALM: infodom: INFODOM
Query:select NAME "1", FSI_CASH_FLOW_EDITS_MASTER.FOLDER "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 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 FSI_CASH_FLOW_EDITS_MASTER.FOLDER = 'INFODOM1' AND FSI_CASH_FLOW_EDITS_MASTER.LEAF_NUM_ID = '4'

STEPS
The issue can be reproduced at will with the following steps:
Financial Services Applications -> Asset | Liability Management -> ALM Processing -> Cash Flow Edits

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