Category: Oracle Fusion HCM

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 +

Expedite Peoplesoft Reports to Oracle HCM Migration Using Pre-Built Reports

Most of the big enterprises have started migrating their Peoplesoft system to Oracle Fusion HCM. After the migration process, one of the important challenges faced by the Users is that they would be not able to have the reports in Oracle Fusion HCM that they were previously using in Peoplesoft Environment. Oracle provides a bundle of pre-built reports which users can make use for viewing the required Payroll/HR/Compensation data from Fusion. In certain scenarios, users would like to have their existing PeopleSoft report replicated in Oracle Fusion HCM for requirements such as tax filing or other internal audit purposes. DataTerrainhas created a variety of pre-built Oracle HCM reports which are similar to Peoplesoft reports in report functionality and formatting features such as page breaks and totals. These reports can be quickly rolled out with minimal customization, saving significant time and cost. Some of the useful Peoplesoft reports that are already pre-built in Oracle Fusion HCM are: • PAY007 – Deduction in Arrears • PAY013(CN) – Employee Earnings Snapshot • TAX010FD – Tax Summary – Federal (can be run for a date range) • TAX010ST – Tax Summary – State (can be run for a date range) • TAX900 – Tax […]

Read More +

Balance Groups in Oracle Fusion HCM

Balances in HCM are amounts or hours that are aggregated based on Month, Quarter or Year. Balance Group and Balance Group Usages for the specific Balances can be created from the Payroll Calculation work area in the Oracle Fusion HCM environment. Oracle HCM Fusion provides us the option of using either Pre-defined balance groups or User-defined custom balance groups for our reports. Pre-defined Balance groups in HCM contain information about all the earnings and deductions but if we would like to see only the amounts or hours of a list of earnings. User-defined custom balance group can be created with the list of earnings that we require and use it in our custom extract to view only the values for those earnings. Data Terrain 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 +

Role based security of Oracle HCM in Cloud

Oracle HCM offers security in Cloud by providing Role-based security, Predefined HCM roles and Role types. There are various security-related tasks which can be performed on the Human Capital Management Cloud security consoles, such as Create and manage the custom job, abstract, and duty roles, compare roles and so on. In order to access the security console, one must hold IT Security Manager role by which Job Roles, duties and users can be implemented and managed. Role-Based Security -Users have roles through which they can gain access to functions and data, they can have any number of roles. Role Types – Oracle HCM has five types of roles such as data roles, abstract roles, job roles, aggregate privileges and duty roles. Role Based Access Control – This defines who can do what on which data. Predefined HCM Roles –Oracle HCM has many predefined roles such as benefits administrator, benefits manager, compensation manager, employee, line manager, etc. HCM cloud security also provides Role Inheritance by which a role can be inherited by other roles. There are few HCM business objects which are secured by default such as a person, organization, position, country, payroll, payroll flow, etc. Unless you grant access to […]

Read More +

Insight Driven HR Through Oracle HCM Reporting and Analytics

report conversion

With the role of HR changing to be a strategic partner in helping organizations achieve its goals, it needs to keep the workforce agile and drive the desired behavior and increase productivity through real-time insight. Oracle HCM Reporting and Analytics provides the following features, which help to create an insight-driven modern HR function. • Provide a complete view of people and operations in the business. • Analyzing the workforce which helps to identify risks and monitoring using demographics. • Enrich HR data with financial and operational data for a full view of business performance. • With appropriate roles, analytics and reports can be modified and -made available for use by others in the organization. • Centrally manage permissions for data security to govern blended data. 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. Reach us at connect@dataterrain.com or visit DataTerrain Inc.

Read More +