My Oracle Support Banner

FA OTBI - Absence OTBI Report Showing Wrong Values (Doc ID 2156656.1)

Last updated on OCTOBER 01, 2018

Applies to:

Oracle Fusion Absence Management Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

Absence Real Time Subject Area the 'Leave Duration' data appears with incorrect values.

Using query like...

SELECT

"Workforce Management - Absence Real Time"."Absence Plan"."Plan UOM" s_1,
"Workforce Management - Absence Real Time"."Absence Type"."Absence Type Name" s_2,
"Workforce Management - Absence Real Time"."Assignment Absences Details"."Absence Status" s_3,
"Workforce Management - Absence Real Time"."Assignment Absences Details"."Approval Status" s_4,
"Workforce Management - Absence Real Time"."Assignment Absences Details"."Date End" s_5,
"Workforce Management - Absence Real Time"."Assignment Absences Details"."Date Start" s_6,
"Workforce Management - Absence Real Time"."Business Unit"."Business Unit Name" s_7,
"Workforce Management - Absence Real Time"."Department"."Department Name" s_8,
"Workforce Management - Absence Real Time"."Legal Employer"."Name" s_9,
"Workforce Management - Absence Real Time"."Location"."Worker Location Name" s_10,
"Workforce Management - Absence Real Time"."Time"."Calendar Year" s_11,
"Workforce Management - Absence Real Time"."Worker"."Assignment Category" s_12,
"Workforce Management - Absence Real Time"."Worker"."Assignment Name" s_13,
"Workforce Management - Absence Real Time"."Worker"."Assignment Status Type" s_14,
"Workforce Management - Absence Real Time"."Worker"."Employee First Name" s_15,
"Workforce Management - Absence Real Time"."Worker"."Employee Hire Date" s_16,
"Workforce Management - Absence Real Time"."Worker"."Employee Last Name" s_17,
"Workforce Management - Absence Real Time"."Worker"."Manager Name" s_18,
"Workforce Management - Absence Real Time"."Worker"."Person Number" s_19,
DESCRIPTOR_IDOF("Workforce Management - Absence Real Time"."Absence Plan"."Plan UOM") s_20,
DESCRIPTOR_IDOF("Workforce Management - Absence Real Time"."Assignment Absences Details"."Absence Status") s_21,
DESCRIPTOR_IDOF("Workforce Management - Absence Real Time"."Assignment Absences Details"."Approval Status") s_22,
DESCRIPTOR_IDOF("Workforce Management - Absence Real Time"."Worker"."Assignment Category") s_23,
DESCRIPTOR_IDOF("Workforce Management - Absence Real Time"."Worker"."Assignment Status Type") s_24,
"Workforce Management - Absence Real Time"."Assignment Absences"."Leave Duration" s_25
FROM "Workforce Management - Absence Real Time"
WHERE
("Assignment Absences Details"."Date Start" > date '2015-11-01')

 

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.