Oracle Fusion Middleware (MOSC) READ-ONLY

MOSC Banner

Payroll Exception Report : SQL Query for HCM Fusion

edited August 2020 in Oracle Fusion Middleware (MOSC) READ-ONLY 2 commentsAnswered

I have a business requirement to build a report : Payroll Exception Report

Input Parameter will be MON-YYYY (ex. July-2020), output should show before-after difference/change in Salary, Grade, Designation, Bank Account when compared with last month payroll run (ex. Jun-2020)

Output For ex: Before Salary= 10000 | Current Salary=12000 || Before Bank Account = 4576282782 | Current Bank Account= 00875684698 || Before Designation = Manager | Current Designation = Manager ||

Is there is Standard Report for this requirement ?

If no, can someone assist me with the SQL Query for getting above ?

P.S. I am in 20B version of Fusion Application

Thanks

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center