My Oracle Support Banner

ODI-1228: Task SIL_PositionDimensionHierarchy_Type1Update.W_POSITION_DH_BASE (Integration) fails on the target Database(BIAPPS_DW) with errorcode ORA-01407 (Doc ID 2354409.1)

Last updated on MARCH 20, 2019

Applies to:

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

Symptoms

On : 11.1.1.10.1 version, DataWarehouse

Load plan failed due to below error

ODI-1228: Task SIL_PositionDimensionHierarchy_Type1Update.W_POSITION_DH_BASE (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.BatchUpdateException: ORA-01407: cannot update ("BIApps_DW"."W_POSITION_DH"."BASE_LOGIN") to NULL
for this we have check data there is no null values are precedent in source system.


Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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