Element Entry Changes 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Element Entry Changes Report

edited Jul 6, 2020 3:39PM in Reporting and Analytics for HCM 2 comments

Summary

Copying an existing BI Publisher version

Content

Hi,

I'm trying to replicate a BI Publisher report that HR runs each month and submits to payroll. I'd like the report to show all changes to element entries made between a FROM DATE - TO DATE.

The element change must be on the same line - in OTBI they appear on separate lines which doesn't work. I also require 2 new columns (highlighted in Green), 1. a calculated column which I think I can do but also a % change column which I'm less sure off. I have attached a dummy record showing the Responsibility Allowance changing to NULL on the 1st Jul - this must be on one line - is this possible?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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