My Oracle Support Banner

OBIA: CUSTOM_SDE_UNIVERSAL_ADAPTOR_CUSTOM_SDE_PARTYORGANIZATIONDIMENSION Fails (Doc ID 2387550.1)

Last updated on APRIL 17, 2018

Applies to:

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

Symptoms

OBIA 11g: Session Name
CUSTOM_SDE_UNIVERSAL_ADAPTOR_CUSTOM_SDE_PARTYORGANIZATIONDIMENSION fails with:

ODI-1217: Session
CUSTOM_SDE_UNIVERSAL_ADAPTOR_CUSTOM_SDE_PARTYORGANIZATIONDIMENSION
(300094700) fails with return code 20942.
ODI-1226: Step Custom_SDE_PartyOrganizationDimension.W_PARTY_ORG_DS fails
after 1 attempt(s).
ODI-1240: Flow Custom_SDE_PartyOrganizationDimension.W_PARTY_ORG_DS fails
while performing a Integration operation. This flow loads target table
W_PARTY_ORG_DS.
ODI-1228: Task Custom_SDE_PartyOrganizationDimension.W_PARTY_ORG_DS
(Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20942: Error while finding/removing
duplicates for these key columns
:INTEGRATION_ID,DATASOURCE_NUM_ID,SRC_EFF_FROM_DT => ORA-01408: such column
list already indexed
ORA-06512: at line 220

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!


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