My Oracle Support Banner

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

Last updated on AUGUST 15, 2019

Applies to:

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


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.



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

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