OTBI: Can't Report On Leave Duration Between Two Different Year/Months
Last updated on OCTOBER 12, 2017
Applies to:Oracle Fusion Application Toolkit Cloud Service - Version 22.214.171.124.0 and later
Oracle Fusion Absence Management Cloud Service - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
If an absence is recorded between 2 Continuous dates, and you want to report on the number of Absence days in a specific time period using the ‘Month’ or ‘Calendar Year’ columns, it is grouping all of the Absence days with the Start Date.
e.g. someone has recorded absence between 31/12 and 28/01 with leave duration 21 days.
Reporting should be:
- 1 Day absence in 2015
- 20 days absence in 2016
However at this point the report will return 21 days leave in 2015.
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