'Error While Loading the Page' Opening Simplified Batch Screen (Doc ID 1929508.1)

Last updated on MARCH 10, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 5.6 to 5.6 [Release 5]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 5.6

Symptoms

In Oracle Financial Services Profitability Management (PFT) 5.6, the user gets the following error on the Administration > Simplified Batch screen:

Error while loading the page

* Not able to execute the query for module Id_Type: BATCH_DEFINITION: infodom: <Infodom>
* Query: select fsi_m_object_definition_tl.short_desc "2", fsi_m_object_definition_b.creation_Date "4", fsi_m_object_definition_b.created_by "3",
fsi_m_object_definition_b.last_modified_date "6", fsi_m_object_definition_b.modified_by "5", DECODE(fsi_m_object_definition_b.access_cd, 'R',
tl1.lookup_description, 'W', tl1.lookup_description) "7", rev_segment_mast_v.v_segment_name "9", fsi_m_batch_master_view.timestamp "10", decode
(fsi_m_batch_master_view.batch_status, 'R', tl2.lookup_description, 'C', tl2.lookup_description, 'H', tl2.lookup_description, 'O', tl2.lookup_description, 'N',
tl2.lookup_description, 'P', tl2.lookup_description) "11", fsi_m_object_definition_b.object_definition_id "PrimaryKey", '201~'||
fsi_m_object_definition_b.object_definition_id || ':202~'||fsi_m_batch_master_view.batch_id||':200~'||fsi_m_object_definition_tl.long_Desc "DBToolText" from
FSI_M_OBJECT_DEFINITION_B, FSI_M_OBJECT_DEFINITION_TL, REV_SEGMENT_MAST_V, FSI_M_BATCH_MASTER_VIEW, FSI_M_BATCH_MAPPING, FSI_M_LOOKUP_TL tl1, FSI_M_LOOKUP_TL tl2
where fsi_m_object_definition_b.object_definition_id = fsi_m_object_definition_tl.object_definition_id and fsi_m_object_definition_b.id_type = 32 and
fsi_m_object_definition_b.deleted_flag = 'N' and REV_SEGMENT_MAST_V.V_SEGMENT_CODE=fsi_m_object_definition_b.folder_name and
REV_SEGMENT_MAST_V.V_DSNID='<Infodom>' and fsi_m_object_definition_b.object_definition_id=fsi_m_batch_mapping.app_sequence_id and
fsi_m_batch_mapping.icc_batch_id=fsi_m_batch_master_view.batch_id and fsi_m_object_definition_b.access_cd=tl1.lookup_cd and
fsi_m_batch_mster_view.batch_status=tl2.lookup_cd and tl1.category_id=66 and tl2.category_id=84 and tl1.lang_code='US' and tl1.lang_code='US';

The error prevents the screen from loading.

Steps to Reproduce:

  1. Go to Financial Services Applications
  2. Go to Administration > Simplified Batch

The error appears.

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