Oracle Fusion OTBI: The "Workforce Management - Accrual Real Time"."Front-Loaded Plan"."Annual Accrual" is showing double amounts (Doc ID 2246931.1)

Last updated on APRIL 07, 2017

Applies to:

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

Goal

You are seeing double amounts for the "Annual Accruals" when using a similar logical sql:

Select
"Workforce Management - Accrual Real Time"."Accrual Plan"."Accrual Plan Name" s_1,
"Workforce Management - Accrual Real Time"."Employee Plan Participation Details"."Enrolment End Date" s_2,
"Workforce Management - Accrual Real Time"."Employee Plan Participation Details"."Enrolment Start Date" s_3,
"Workforce Management - Accrual Real Time"."Employee Plan Participation Details"."Enrolment Status" s_4,
"Workforce Management - Accrual Real Time"."Worker"."Employee Display Name" s_5,
"Workforce Management - Work Relationship Real Time"."Legal Employer"."Name" s_6,
"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date" s_7,
"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Country" s_8,
"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Date Start" s_9,
"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Enterprise Hire Date" s_10,
"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Original Date Of Hire" s_11,
"Workforce Management - Work Relationship Real Time"."Worker"."Assignment Status Type" s_12,
"Workforce Management - Work Relationship Real Time"."Worker"."Assignment Type" s_13,
"Workforce Management - Work Relationship Real Time"."Worker"."Normal Working Hours" s_14,
"Workforce Management - Work Relationship Real Time"."Worker"."Person Number" s_15,
"Workforce Management - Work Relationship Real Time"."Worker"."Person Type" s_16,
DESCRIPTOR_IDOF("Workforce Management - Accrual Real Time"."Employee Plan Participation Details"."Enrolment Status") s_17,
DESCRIPTOR_IDOF("Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Country") s_18,
DESCRIPTOR_IDOF("Workforce Management - Work Relationship Real Time"."Worker"."Assignment Status Type") s_19,
DESCRIPTOR_IDOF("Workforce Management - Work Relationship Real Time"."Worker"."Assignment Type") s_20,
DESCRIPTOR_IDOF("Workforce Management - Work Relationship Real Time"."Worker"."Person Type") s_21,
TIMESTAMPDIFF(SQL_TSI_MONTH,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/12 s_22,
"Workforce Management - Accrual Real Time"."Employee Plan Participation"."Value" s_23,
"Workforce Management - Accrual Real Time"."Front-Loaded Plan"."Annual Accrual" s_24,
"Workforce Management - Work Relationship Real Time"."Work Relationship"."# Of Days Service" s_25
FROM "Workforce Management - Work Relationship Real Time"
WHERE
((DESCRIPTOR_IDOF("Workforce Management - Work Relationship Real Time"."Worker"."Assignment Status Type") = 'ACTIVE') AND (DESCRIPTOR_IDOF("Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Country") IN ('FR', 'IN', 'GB', 'US')) AND ("Workforce Management - Accrual Real Time"."Accrual Plan"."Accrual Plan Name" IN ('Vacation/Holiday', 'Vacation/Holiday-CP-France', 'Vacation/Holiday-UK', 'Vacation/Holiday-US')))

 

Solution

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