My Oracle Support Banner

Excel Upload Fails with ORA-01400: Cannot Insert NULL into ("Atomic"."FSI_D_LOAN_CONTRACTS"."PRODUCT_ID") (Doc ID 1382824.1)

Last updated on DECEMBER 15, 2011

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2 and later   [Release: 7 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), you are trying to use the Excel Upload function to load data from an Excel spreadsheet into an instrument table (ex. FSI_D_LOAN_CONTRACTS).  When the you go to Excel Utilities > Excel Upload, select a Mapping and execute the load, the following error appears on the screen:

Failed to upload data into FSI_D_LOAN_CONTRACTSError is:Failed Executing Batch: error occurred during batching:
ORA-01400: cannot insert NULL into ("<Atomic>"."FSI_D_LOAN_CONTRACTS"."PRODUCT_ID")

The same error appears in the Excel Upload log in /<ftpshare directory>/STAGE/ExcelUpload/logs:

[ETL-EXCELUPLOAD]Error is Failed Executing Batch: error occurred during batching: ORA-01400: cannot insert NULL into ("<Atomic>"."FSI_D_LOAN_CONTRACTS"."PRODUCT_ID")

The log also lists many insert statements with null values like the following:

[ETL-EXCELUPLOAD]batchQuery[counter]Insert into FSI_D_LOAN_CONTRACTS(AS_OF_DATE,IDENTITY_CODE,ID_NUMBER,ISO_CURRENCY_CD,ISSUE_DATE,ORG_TERM,ORG_TERM_MULT,
ORIGINATION_DATE,MATURITY_DATE,INTEREST_RATE_CD,MARGIN,AMRT_TERM,AMRT_TERM_MULT,AMRT_TYPE_CD,ACCRUAL_BASIS_CD,
ADJUSTABLE_TYPE_CD,COMPOUND_BASIS_CD,CUR_BOOK_BAL,CUR_NET_PAR_BAL_C,CUR_PAR_BAL,CUR_GROSS_RATE,CUR_NET_RATE,
INT_TYPE,CUR_PAYMENT,PMT_FREQ,PMT_FREQ_MULT,PMT_CHG_FREQ,PMT_CHG_FREQ_MULT,LAST_PAYMENT_DATE,NEXT_PAYMENT_DATE,
REMAIN_NO_PMTS_C,REPRICE_FREQ,REPRICE_FREQ_MULT,LAST_REPRICE_DATE,NEXT_REPRICE_DATE,ORG_BOOK_BAL,ORG_PAR_BAL,
ORG_PAYMENT_AMT,ACCOUNT_OFFICER_CD,CIF_KEY,RATE_CAP_LIFE,RATE_DECR_CYCLE,RATE_FLOOR_LIFE,RATE_INCR_CYCLE,
COMMON_COA_ID,PRODUCT_ID,ORG_UNIT_ID,GL_ACCOUNT_ID) Values(null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,
null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,
null,null,null,null,null,null)

The first 4 insert statements contain correct values and the rest contain all nulls.

Steps to Reproduce:
  1. Go to Unified Metadata Manager
  2. Go to Data Entry Forms and Queries > Excel Upload
  3. Click on Excel Upload
  4. Select an Excel File and Mapping and click Upload
The error appears on the screen.

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
  Cause
  Solution

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