Logical Column Error while Merging EFPA RPD (Doc ID 2273768.1)

Last updated on JUNE 05, 2017

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 8.0.2 version

When attempting to merge OFS_PFT_PACK.rpd with customized rpd using OBIEE 11.1.1.9 admin tool, the following errors occurs.

Error:
Following objects did not merge properly:
Logical Column "Core"."Dim - Date"."First Period of Enterprise Quarter Flag"
Logical Column "Core"."Dim - Date"."First Period of Enterprise Year Flag"
Logical Column "Core"."Dim - GL Balance Details"."Accounted Currency Code"
Logical Column "Core"."Dim - Competitor Hierarchy"."Fixed Hierarchy Level"
Logical Column "Core"."Dim - Competitor Hierarchy"."Level 1 Competitor Id"
Logical Column "Core"."Dim - Service Request Status"."Source Id"
Logical Column "Core"."Dim - Service Request Status"."ROW_WID"
Logical Column "Core"."Dim - Agreement Status"."Agreement Status Key"
Logical Column "Core"."Dim - Agreement Status"."Agreement Status Type"
Logical Column "Core"."Dim - Project Hierarchy"."Fixed Hierarchy Level"
Logical Column "Core"."Dim - Project Hierarchy"."Program Hierarchy Key"
Logical Column "Core"."Dim - Date Project Calendar"."Row Wid"
Logical Column "Core"."Dim - Date Project Calendar"."Project Calendar Wid"
Logical Column "Core"."Dim - Asset Status"."Source Id"
Logical Column "Core"."Dim - Asset Status"."ROW_WID"
Logical Column "Core"."Dim - Agreement Status"."Source Id"
Logical Column "Core"."Dim - Agreement Status"."ROW_WID"
Logical Column "Core"."Dim - Task Hierarchy"."Level12 Task Number"
Logical Column "Core"."Dim - Task Hierarchy"."Level12 Task Name"


Steps:
1. Merge custom merged rpd with OFS_PFT_PACK.rpd keeping OFS_PFT_PACK.rpd as a current repository
2. Found Logical Column errors.
3. Check consistency on both rpds and found warning messages.





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