OBIA 11g - W_DAY_D Not being Loaded When To Date Set Beyond Year 2049 (Doc ID 2125393.1)

Last updated on JUNE 06, 2017

Applies to:

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

Symptoms

Problem with the loading of W_DAY_D.  When receivables are 30 years in the future, no data is loaded into the table. 

For example, set the from date to '98 and set the to date to '50.  Review of the SQL shows the from date as 1998 but the to date is showing as 1950, not the desired 2050.  Since the from date is less than the to date ODI loads zero rows.

 

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