My Oracle Support Banner

Unable To Report On Termed Employee Salary from Salary Details Real Time (Doc ID 2557092.1)

Last updated on JANUARY 31, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Goal

When running a report that includes fields "New Salary", ""Previous Salary", and "Annualized Salary" for terminated employees, theses fields are blank even though information is populated on terminated employee's Manage Salary screen. See attached for the report and the Manage Salary screen for the highlighted employee.

Customer is using the following query


set variable LOGLEVEL = 2,PREFERRED_CURRENCY='User Preferred Currency 1',ENABLE_DIMENSIONALITY=1;SELECT
0 s_0,
"Workforce Management - Worker Assignment Real Time"."Department"."Department Name" s_1,
"Workforce Management - Worker Assignment Real Time"."Job Legislation Data_United States Job Information"."Job Legislation Data_PER_JOBS_LEG_EFF_HRX_US_JOBS__FLSA_STATUS_v" s_2,
"Workforce Management - Worker Assignment Real Time"."Job"."Job Name" s_3,
"Workforce Management - Worker Assignment Real Time"."Worker Assignment Details"."Normal Hours" s_4,
"Workforce Management - Worker Assignment Real Time"."Worker"."Employee Hire Date" s_5,
"Workforce Management - Worker Assignment Real Time"."Worker"."Employee Name" s_6,
"Workforce Management - Worker Assignment Real Time"."Worker"."Person Number" s_7,
"Workforce Management - Worker Assignment Real Time"."Worker"."Termination Date" s_8,
DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Real Time"."Job"."Job Name") s_9,
"Compensation - Salary Details Real Time"."Salary"."Annualized Salary" s_10,
"Compensation - Salary Details Real Time"."Salary"."Current Salary" s_11,
"Compensation - Salary Details Real Time"."Salary"."Previous Salary" s_12,
"Workforce Management - Worker Assignment Real Time"."Worker Assignment"."Full-Time Equivalent" s_13
FROM "Workforce Management - Worker Assignment Real Time"
 

Solution

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
Goal
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.