My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.