OBIA 11g Incremental Load Getting Failed With ORA-01427 for SDE_PSFT_91_ADAPTOR_SDE_PSFT_INTERNALORGANIZATIONDIMENSION (Doc ID 1966499.1)

Last updated on AUGUST 09, 2016

Applies to:

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

Symptoms

The Load plan is configured via biapps CM.  You are implementing OOTB(BIapps Project) No customization has been done for these interfaces (everything is as Oracle delivered) You are running HCM data load.

The Incremental Load failed with ORA-01427  

SDE_PSFT_91_ADAPTOR_SDE_PSFT_INTERNALORGANIZATIONDIMENSION_DEPARTMENTHIERARCHY_HCM
SDE_PSFT_91_ADAPTOR_SDE_PSFT_PERSISTEDSTAGE_HRPERSONLEGDIMENSION_VISA :

[ODI-1217: Session SDE_PSFT_91_ADAPTOR_SDE_PSFT_PERSISTEDSTAGE_HRPERSONLEGDIMENSION_VISA (4383180) fails with return code 1427. ODI-1226: Step SDE_PSFT_PersistedStage_HRPersonLegDimension_Visa.W_PSFT_HR_PSN_VISA_PS fails after 1 attempt(s). ODI-1240: Flow SDE_PSFT_PersistedStage_HRPersonLegDimension_Visa.W_PSFT_HR_PSN_VISA_PS fails while performing a Integration operation. This flow loads target table W_PSFT_HR_PSN_VISA_PS. ODI-1228: Task SDE_PSFT_PersistedStage_HRPersonLegDimension_Visa.W_PSFT_HR_PSN_VISA_PS (Integration) fails on the target ORACLE connection BIAPPS_DW. Caused By: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at
 ...


Full load the load is running fine with out any error.

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