How to Merge Of Fixes For DocID:2277658.1 And DocID:2226325.1 for 'IKM BIAPPS Oracle Slowly Changing Dimension’?

(Doc ID 2329652.1)

Last updated on NOVEMBER 17, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 and later
Information in this document applies to any platform.

Goal

 DocID:2277658.1 And DocID:2226325.1 address two different issues with 'IKM BIAPPS Oracle Slowly Changing Dimension’.  This note is intended to answer the question on how to merge these two fixes.

 

OBIA: SIL_PositionDimensionHierarchy returns: ORA-01427: Single-row Subquery Returns More Than One Row (Doc ID 2226325.1)

OBIA 11.1.1.10.1: SIL_EmployeeDimension.W_EMPLOYEE_D and SIL_PositionDimensionHierarchy.W_POSITION_DH fails with "ORA-00001: Unique Constraint" Violated (Doc ID 2277658.1)

Solution

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