My Oracle Support Banner

Error: ORA-01400: Cannot Insert NULL Into ("W_PROJ_COMMITMENT_SNP_F"."SNAPSHOT_DT_WID") Received During Initial Data Loading (Doc ID 2669272.1)

Last updated on MAY 18, 2020

Applies to:

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

Symptoms

During initial data loading, mapping SILOS_SIL_PROJECTCOMMITMENTSNAPSHOT_FACT failed with error: "ORA-01400: cannot insert NULL.."

In the session log: SESS_<SESSIONID>_SILOS_SIL_PROJECTCOMMITMENTSNAPSHOT_FACT.xml file, found the below entries

<Field name="ErrorMessage" type="java.lang.String"><![CDATA

[ODI-1217: Session SILOS_SIL_PROJECTCOMMITMENTSNAPSHOT_FACT (21044500) fails with return code 1400.

ODI-1226: Step Run SIL_ProjectCommitmentSnapshot_Fact.W_PROJ_COMMITMENT_SNP_F fails after 1 attempt(s).

ODI-1240: Flow Run SIL_ProjectCommitmentSnapshot_Fact.W_PROJ_COMMITMENT_SNP_F fails while performing a Integration operation. This flow loads target table W_PROJ_COMMITMENT_SNP_F.

ODI-1228: Task SIL_ProjectCommitmentSnapshot_Fact.W_PROJ_COMMITMENT_SNP_F (Integration) fails on the target ORACLE connection BIAPPS_DW.

Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("<SCHEMA_PREFIX>"."W_PROJ_COMMITMENT_SNP_F"."SNAPSHOT_DT_WID")

Environment Info

  1. OBIA version - 11.1.10.2
  2. Source System and its version - EBS R12.1.3
  3. Modules Being Involved - Projects
  4. Mapping Name: SILOS_SIL_PROJECTCOMMITMENTSNAPSHOT_FACT

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.