OBIEE 11g: A Three-Way Merge with the OBIA 11.1.1.7.1 SLA Patch Results in an Inconsistent RPD (Doc ID 2147208.1)

Last updated on FEBRUARY 09, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 and later
Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

The OBIA 11.1.1.7.1 Financial Analytics SLA patch is applied as per OBIA 11g: How to find SLA Patch For Financial Analytics (Doc ID 1620355.1).  The patch instructions advises to "Do a three way merge of the customer RPD and the OracleBIApps.rpd provided in the patch".

The 3-way merge is done as below, but the Merged RPD contains only the content from the SLA Patch RPD:-
     Current = Custom/Production RPD (customized from the OOTB OBIA 11.1.1.7.1 RPD)
     Modified = SLA Patch RPD
     Original = OOTB OBIA 11.1.1.7.1 RPD

The 3-way merge is re-done as below (as advised by the OBIA Development Team):-
     Current = SLA Patch RPD
     Modified = Custom/Production RPD (customized from the OOTB OBIA 11.1.1.7.1 RPD)
     Original = OOTB OBIA 11.1.1.7.1 RPD

In the merge strategy dialogue:
   1. Choose the option "Modified" for all the rows, except for objects "Added to Current".
   2. Choose the option "Current" for objects "Added to Current".

Now the Merged RPD contains the content from both the Production RPD and the SLA Patch RPD, but the Global Consistency Check throws over 150 errors that are all related to logical tables that are not joined with other logical tables.

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