Last updated on MAY 02, 2017

Applies to:

Goal

On : 11.1.11.1.0 version, Global Payroll


Have a couple of standard reports given by Oracle. If they get into edit mode for the report and try to see the data model, the name would be : globalReportsDataModel.

In the business scenario, would need to add few more columns to the existing standard report. Say for example in the below reports would need to add more columns since its a specific requirement.

Report - Payroll - Exception Report Employees with 0 Net Amount(Net Outside the Range Report)
Report - Payroll - Third Party Payment Register
Report - Payroll - Gross-to-Net Payroll Report
Report - Payroll - Deductions Detail Report


Basically the below things arise because we are moving from EBS to Fusion. So we are trying to compare the mentioned seeded reports in EBS to Fusion cloud which are available.

For example in the seeded report : Report - Payroll - Third Party Payment Register, below are the columns which are not present in the seeded one available

Check Date
Check Number
Payment Method
Attachment Number
Date Earned
Void Payment Method
Run Type Name
Bank Account Name
Bank Account Number
Bank Account Type
Bank Branch
Bank Name
Bank Transit Code

We need these and the question is what would be the best way to achieve it.
 

Solution