Update Time Dimension Job Completed In Warning - cannot insert NULL into ("BSC"."BSC_SYS_PERIODICITIES_TL"."SOURCE_LANG") (Doc ID 1939610.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials Intelligence - Version 12.0.1 to 12.1.2 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, DBI Common Components

When attempting to run the Update Time Dimension job (FII_TIME_C module), the following error occurs.

ERROR
-----------------------
Error in load_dbi_ent_cal ORA-01400: cannot insert NULL into ("BSC"."BSC_SYS_PERIODICITIES_TL"."SOURCE_LANG") 09/30/2014 14:45:24
  
Error in load_dbi_cal_into_bsc_full ORA-01400: cannot insert NULL into ("BSC"."BSC_SYS_PERIODICITIES_TL"."SOURCE_LANG") 09/30/2014 14:45:24
  
Error in load_dbi_cal_into_bsc ORA-01400: cannot insert NULL into ("BSC"."BSC_SYS_PERIODICITIES_TL"."SOURCE_LANG") 09/30/2014 14:45:24
Exception happens in BSC_DBI_CALENDAR.load_dbi_cal_into_bsc ORA-01400: cannot insert NULL into ("BSC"."BSC_SYS_PERIODICITIES_TL"."SOURCE_LANG")


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Update Time Dimension job
2. Job ends in warning

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