My Oracle Support Banner

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

Last updated on MARCH 13, 2019

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.





Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.