Category: Oracle Fusion HCM

Prebuilt HCM Report to view Active employees with no Net/Gross Pay

At times, in an Organization, few employees do not receive pay for a particular pay period but still are active on the Payroll. An Employee may be on a break for a particular pay period due to various reasons such as illness or planned absence. HR and Payroll team has to keep track of the list of employees who are not receiving pay during a pay period for tracing any inaccuracies in payment processing. DataTerrain’s Prebuilt report: The Prebuilt report Active No Pay will provide the Users with a list of active employees who has no NET Amount and Gross Amount for any given payroll period. Users can run this report with the below parameters, 1. For an Organization 2. For a single Person 3. For a Date Range 4. For a Payroll This report is built both as an HCM Extract and a BIP report, hence it can be run from the ‘CheckList’ section or from the BI Publisher Catalog, Users can use either Extracts or BIP report respectively, as per their preference. Output: The output data lists the active employees and his organization, assignment details, pay period start/end dates, Gross and NetPay amounts. The output format of this […]

Read More +

Customizing Oracle’s Fusion HCM Reports

Oracle has delivered a set of seeded reports, as a part of the installation package, for the Fusion HCM users to view the data from the Fusion System. Once Users start using these reports, they would have a need to modify the reports to include more information or have few other filters additionally for easier Audit/Tax Filing purposes. Some of the usual modification requests from the users are: 1. Adding/Removing sub-totals/Grand-Totals from the existing output. 2. Few reports have only Excel output but Users require it as Text output, which also is possible. 3. Addition/Deletion of columns from the existing report as per User’s needs. 4. Parameters/Static Filters can be added to the HCM Extracts/Reports as per User’s specification. Apart from modifications, users will also need report enhancement such as: 1. In the ‘Statutory Deduction Register’ report, the existing ‘Summary’ layout produces incorrect sub-totals for the Base Amount Current/Taxable Wages value. 2. Users wanted to concat the Employee number, Name and SSN in the ‘Employee Active Payroll Balance report’ as similar to ADP Report so that they can do a quick compare of these 2 reports for their internal audit. 3. ‘Payroll Deduction report’ displays the deduction elements but Users […]

Read More +

PreBuilt HCM Report to View Tax Errors

Report Description: DataTerrain’s Prebuilt report is designed to capture Tax related error conditions such as • Invalid SSN • Negative Gross amounts • The conditions that were available in the Oracle HRMS report “Unacceptable Tax Balance report” to list out the employees with issues in their balances. This report can be run for the below parameters • Effective Date • Person • Organization This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist. Effective Date is a mandatory parameter. Output: The output data will have Employee number, Employee Name, SSN and the reason for the errorThe output format of this report is Excel and it can also be rendered as PDF/CSV. Schedule : HR/Payroll Team can also schedule the report to get it delivered weekly/bi-weekly and use it for a regular audit. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers worldwide. We are flexible in working hours and do not need any long term binding contracts.

Read More +

How to Block Email Delivery if Oracle HCM report returns no data

Oracle HCM customers mostly setup E-mail delivery for their custom/pre-built BI and OTBI reports. There would be a requirement where the report should be delivered to the End User only if it satisfies criteria. Usually, we can add these criteria to the BI Query/OTBI Filter section and restrict the report from displaying the data but we should also block the Email Delivery of this report or else the End User will receive an empty attachment which would be an inconvenience. We can use Event Triggers in BI and Rowcount in OTBI to restrict this blank file delivery to End User’s mailbox. In the BI report, create an “EventTrigger” of “Schedule” Type in the data model and specify the criteria which decide the row count of the report. BI report will initially check whether these criteria return any rows and if not, the report is not scheduled at all. Similarly in the OTBI report, on the report properties, under ‘More’, we can schedule it conditionally by providing the row count condition under the ‘Condition’ tab. We can set the schedule based on the condition row count is not zero in order to block the Email delivery. DataTerrain with years of experience […]

Read More +