Category: Oracle Fusion HCM

DataTerrain extends support to On-Premise reporting for Oracle cloud Apps

DataTerrain, a leader in Business Intelligence migration solutions, launched its Support services for customers who are looking to support oracle cloud applications (HCM and FSCM). DataTerrain has over 10 years of experience in Planning, Designing, Development, Tuning and supports a variety of Business Intelligence tools that specializes in reporting solutions. The DataTerrain team has in-depth, real-world expertise in Oracle HCM application and reporting. The BIAPPS solution which performs data warehousing and reporting helps the customer to overcome many other limitations faced with real-time reporting. It also helps to connect to external data sources and have complete control over the data warehouse, Meta-Data and the reporting layer. Customers also have the advantage of embedding their custom security by using this model. DataTerrain’s engineering team has complete knowledge on- the ETL model of BIAPPS to extract data from sources like PeopleSoft, Taleo, Oracle Cloud Apps (HCM, FSCM) and also from other custom sources to deploy it on-premise. Customers who rely on Oracle Data Integrator to perform the ETL operations can leverage DataTerrain’s expertise to customize and configure Oracle delivered OBIA package for performing the ETL from various sources. Customers can use Oracle’s RPD as meta-data on the on-premise data warehouse and deploy […]

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 +

HCM in the Cloud Drives Customer Success

Data driven tasks such as BI support and automated reporting are driven by advancements in OBIEE and HCM Cloud applications. Utilizing these resources has become a large part of business intelligence. See how BI report support in the cloud helps businesses to succeed.

Read More +

Prebuilt HCM Report to view Severance Payments

Severance Payment is compensation provided by the Employer on circumstances such as layoffs due to downsizing or mutual agreements to employment termination. Severances are paid to an employee as part of the Benefits package they receive. Severance pay generally may be distributed during every pay period or in one lump sum. Report Description: DataTerrain’s Prebuilt report displays gross YTD Severance Payments being done to the employees in a date range that we run the report for. This report can be run for the below parameters • Effective Date(or End Date) • Start Date • Organization • Employee This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist. Effective Date is a mandatory parameter and the report fetches the Severance Payments paid as per the date passed in it. Output: The output data will have Employee number, Payroll Name, Payroll Period(Month and Year), Severance Element name paid and the corresponding Gross YTD amounts for those elements. The 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 on […]

Read More +

Prebuilt HCM Report to view Payroll Summary

Payroll teams in an organization would like to view a summary report that provides information on the count of employees who is processed in payroll by each Earning/Deduction element. Report Description: DataTerrain’s Prebuilt report displays the count of employees processed in each payroll cycle based on each earning/deduction/tax element. This report fetches both the current payroll and the previous payroll counts thus can be used for auditing the difference between the last 2 payrolls. This prebuilt report can be run for the below parameters • Effective Date(or Current Payroll Process Date) • Start Date(or Previous Payroll Process Date) • Organization • Employee The effective date will be the current payroll’s process date and the start date entered will be the previous payroll process date, which is mandatory to be passed. This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist. Output: The output data will have both previous payrolls element names, count of employees processed in current and previous payrolls based on individual elements, current and previous hours worked and the variance between them. The output format of this report is Excel and it can also be rendered as PDF/CSV. Schedule: Payroll […]

Read More +

Prebuilt HCM Report to audit employee’s 401K Contribution Limit

401K is a popular retirement saving plan provided by the employer which helps employees to save for their retirement years. Every year, there is a contribution limit set for the 401K plan which will be deducted from the Employee’s payment. This deduction should be done as per the defined limit and any employee who has contributed over the limit should check these before their annual tax filing, failing which will invite penalties. ReportDescription: DataTerrain’s Prebuilt report helps the Employer and the Employee to get quickly the list of employees who have contributed more than the limit set for a year. Parameters: This report can be run for a date range so that Users can view the contributions that occurred in a particular date range, generally for a financial year. Parameters available in the report are listed below: • Effective Start Date/End Date • Person Number • Legal Employer • Payroll This report is available as a HCM Extract and BIP report. Based on User’s preference, it can be run from a Checklist or BI Publisher Catalog.Prebuilt HCM Report to audit employees 401K Contribution Limit Output: The output data will have details regarding the person number, latest assignment number and status, […]

Read More +