Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Employment Position History Report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Employment Position History Report

12
Views
1
Comments
edited Aug 3, 2018 1:47PM in General Transactional Reporting (OTBI) 1 comment

Summary

Grouping data

Content

I am creating a BI Report that basically lists out all the Jobs an employee has had during their employment, so of course my initial grouping is EMPLID. (Sample XML File is attached) My issue is that if an employee starts with JOBCODE1, goes to JOBCODE2, then back to JOBCODE1 and then JOBCODE3 the report has to put out 4 lines. In addition the report needs to calculate the length of time in each position. It does this by using the EFFDT from the first line of each JOBCODE and the EFFDT from the last line of the JOBCODE calculate

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!