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

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