Pricing Management Pricing Screen Shows 'Error while loading the page' After New TPOL 5.2.2 Installation (Doc ID 1311764.1)

Last updated on APRIL 07, 2011

Applies to:

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

Symptoms

On Oracle Financial Services Pricing Management, Transfer Pricing Component (PRICEMGMT) 5.2.2, after new installation, when attempting to navigate to Pricing Management -> Assumption Specifications -> Pricing the following error occurs:

ERROR
Error while loading the page.

Not able to execute the query for module Id_Type: PRICING_MGR: infodom: OFSAADEV
Query: SELECT FSI_M_OBJECT_DEFINITION_TL.SHORT_DESC "1",
DIM_RELATIONSHIP_MANAGER_TL.RELATIONSHIP_MANAGER_NAME "2",
DIM_FINANCIAL_ELEMENTS_TL.FINANCIAL_ELEM_NAME "3",FSI_CURRENCY_MLS.CURRENCY_NAME "10",
FSI_M_LOOKUP_TL.LOOKUP_DESCRIPTION "11", /*FSI_M_PRICIN_DETAILS.STATUS_CD "11",*/
FSI_M_OBJECT_DEFINITION_B.CREATED_BY "5", FSI_M_OBJECT_DEFINITION_B.CREATION_DATE "6",
FSI_M_OBJECT_DEFINITION_B.MODIFIED_BY "7", FSI_M_OBJECT_DEFINITION_B.LAST_MODIFIED_DATE_BY "8",
FSI_M_OBJECT_DEFINITION_B.OBJECT_DEFINITION_ID "PrimaryKey", '200~'||
FSI_M_OBJECT_DEFINITION_TL.LONG_DESC "DBToolText" FROM
FSI_M_PRICING_DETAILS,FSI_M_OBJECT_DEFFINITION_B,
FSI_M_OBJECT_DEFINITION_TL, FSI_CURRENCY_MLS, DIM_RELATIONSHIP_MANAGER_TL,
DIM_FINANCIAL_ELEMENTS_TL, (select * from FSI_M_LOOKUP_TL where FSI_M_LOOKUP_TL.CATEGORY_ID =
159) FSI_M_LOOKUP_TL WHERE FSI_M_OBJECT_DEFINITION_B.DELETED_FLAG != 'Y' AND
FSI_M_OBJECT_DEFINITION_B.OBJECT_DEFINITION_ID =
FSI_M_OBJECT_DEFINITION_TL.OBJECT_DEFINITION_ID AND FSI_M_PRICING_DETAILS.PRICING_SYS_ID =
FSI_M_OBJECT_DEFINITION_B.OBJECT_DEFINITION_ID AND FSI_M_PRICING_DETAILS_CCY_CD =
FSI_CURRENCY_MLS.ISO_CURRENCY_CD AND FSI_M_PRICING_DETAILS.RELATIONSHIP_MANAGER_CD =
DIM_RELATIONSHIP_MANAGER_TL.RELATIONSHIP_MANAGER_ID AND
FSI_M_PRICING_DETAILS.PRODUCT_ID = DIM_FINANCIAL_ELEMENTS_TL.FINANCIAL_ELEM_ID AND
FSI_M_PRICING_DETAILS.STATUS_CD = FSI_M_LOOKUP_TL.LOOKUP_CD(+) AND
fsi_m_object_definition_b.folder_name = 'ADMIN'

The following tables appear to be missing:

DIM_RELATIONSHIP_MANAGER_TL
DIM_RELATIONSHIP_MANAGER_ATTR
DIM_RELATIONSHIP_MANAGER_B

STEPS
The issue can be reproduced at will with the following steps:
1. Merge Pricing Management Pricing Manager Transfer Pricing Component 5.2.2.erwin file from <Patch: 11890368> 5.2.2 PRICING MANAGEMENT (TP COMPONENT) - DATA MODEL with existing OFSAA Data Model.
2. Install Pricing Management via <Patch: 11870345> p11870345_52_Linux-x86-64.zip
3. Navigate to Pricing Management -> Assumption Specifications -> Pricing

Changes

Install Pricing Management 5.2.2.

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