After New Installation of Profitability Manager 5.2, Receiving Errors on Allocation Summary Page (Doc ID 1302921.1)

Last updated on MARCH 10, 2011

Applies to:

Oracle Financial Services Profitability Management - Version: 5.2 and later   [Release: 5 and later ]
Information in this document applies to any platform.
PFT
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.2

Symptoms

On Oracle Financial Services Profitability Management (OFSPM) 5.2.1, when attempting to navigate to the Allocation Summary screen:Financial Services Applications -> Profitability Management -> Rule Specification, the following error occurs:

ERROR
Error while loading the page.

o Not able to execute the query for module Id_Type: ALLC_SPEC_PFT: infodom: BDCEPMERM
o 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(fsi_m_object_definition_b.access_cd,'R','Read Only', 'W', 'Read / Write') "7",
 REV_SEGMENT_MAST_V.V_SEGMENT_NAME "9", 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",DECODE(fdi.batch_name, null, 'BLANK', fdi.batch_name,fdi_batch_name) "10" 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 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(fdi.end_time,sysdate) = 
nvl((SELECT max(end_time) from fsi_data_identity fdid WHERE fdid.description = fdi.description),sysdate) 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 = 
'BDCEPMERM' AND fsi_m_object_definition_b.folder_name = 'BDCEPMERM'

The REV_SEGMENT_MAST_V is discovered to be missing from the Atomic Schema.

STEPS
The issue can be reproduced at will with the following steps:
1. New installation of OFSPM 5.2.1
2. Login to OFSAA and navigate toFinancial Services Applications -> Profitability Management -> Rule Specification.
3. Query the Atomic schema for the REV_SEGMENT_MAST_V

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