OBIA 11g - W_DAY_D Not being Loaded When To Date Set Beyond Year 2049
Last updated on JUNE 06, 2017
Applies to:Business Intelligence Applications Consumer - Version 188.8.131.52.1 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.
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