My Oracle Support Banner

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 FEBRUARY 23, 2019

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

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
References


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