'Error While Loading the Page' in Allocation Specification Screen (Doc ID 1500606.1)

Last updated on MARCH 04, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 6.0 to 6.0 [Release 6]
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 to 7.3 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 6.0, you get an error opening the Allocation Specification screen.  When you click on Allocation Specification, the following error appears in the screen:

Error while loading the page

* Not able to execute the query for module Id_Type: ALLC_SPEC_PFT: infodom: <Infodom Name>
* Query:SELECT distinct 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_alloc_type_mls.alloc_type
"8",fsi_m_object_definition_b.last_modified_date "6",fsi_m_object_definition_b.modified_by "5", DECODE
(fmlt.lookup_cd, 'R', fmlt.lookup_description, 'W', fmlt.lookup_description) "7",
REV_SEGMENT_MAST_V.V_SEGMENT_NAME "9", DECODE
(brv.v_batch_status,fmlkptl.lookup_cd,fmlkptl.lookup_description, null,'BLANK') "10",
fsi_m_object_definition_b.object_definition_id "PrimaryKey", '200~' || fsi_m_object_definition_tl.long_desc || '@201~' ||
fsi_m_object_definition_b.object_definition_id "DBToolText", fsi_m_object_definition_tl.short_desc
||'&folder='||fsi_m_object_definition_b.folder_name "TaskName", fdi.as_of_date "ErrorDate" from
fsi_m_object_definition_b,fsi_m_object_definition_tl, fsi_m_allocation_rule, fsi_alloc_type_mls, fsi_data_identity fdi,
REV_SEGMENT_MAST_V, fsi_m_lookup_tl fmlt,batch_run_view brv, fsi_m_lookup_tl fmlkptl  where
fsi_m_object_definition_b.object_definition_id = fsi_m_object_definition_tl.object_definition_id  and TO_CHAR
(fdi.description(+)) = TO_CHAR(fsi_m_object_definition_b.object_definition_id) and NVL((SELECT MAX(ROWID)
FROM fsi_data_identity fdid WHERE fdid.description =fdi.description AND NVL(fdid.END_TIME,SYSDATE) =NVL
((SELECT MAX(END_TIME) from fsi_data_identity fdid WHERE fdid.description
=fdi.description),SYSDATE)),CHARTOROWID('AAAFd1AAFAAAABSAA/')) = NVL(fdi.ROWID,CHARTOROWID
('AAAFd1AAFAAAABSAA/')) and fsi_m_object_definition_b.id_type = 0 and fsi_alloc_type_mls.alloc_type_cd =
fsi_m_allocation_rule.allocation_type_cd and fsi_m_allocation_rule.allocation_sys_id =
fsi_m_object_definition_tl.object_definition_id 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 Name>' and fsi_m_object_definition_b.access_cd = fmlt.lookup_cd and
fmlt.category_id = 66 and fmlt.lang_code = 'US' and fsi_alloc_type_mls.mls_cd = 'US' and brv.app_batch_run_id(+) =
fdi.batch_name and fmlkptl.category_id = 1005 and NVL(brv.v_batch_status,fmlkptl.lookup_cd) = fmlkptl.lookup_cd  and
fmlkptl.lang_code ='US' and fsi_m_object_definition_tl.lang_cd= 'US'  AND fsi_m_object_definition_b.folder_name =
'<Folder Name>'

The error prevents users from creating and running Allocations.

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