Category: Human Capital Management

Pre-Built HCM Report to Audit Job Changes of Employees

Oracle HCM

In general, HR Audit reports are critical to have a clear review and comply to standards of how the workforce is utilized in an Organization. The Prebuilt HCM Job Audit report has excellent functionalities to tracks all changes that occurred in an Employee’s Assignment/Job during a date range that we run the report for. This Prebuilt report can be run for a date range or by default for the past 30 days which could be scheduled and delivered to a FTP Server/Email as per the User’s requirement. Enhancements such as adding new parameters or conditions to this report is simple. The output type, by default, is Excel which is also customizable to any other format. DataTerrain’s Pre-built reports usually are built in the below 3 reporting formats: 1. HCM Extract 2. BI Publisher Data model reports 3. OTBI Some Users prefer to run the report from CheckList which would require the report to be built as Extract and some run directly from BI Publisher Catalog for which reports should be BIP/OTBI. We have developed this report in both an HCM Extract report and BI Publisher Data model report which users can make use of as per their needs. The Pre-built […]

Read More +

Suffixes help identify the purpose of Oracle HCM tables

You would see lot of tables in Oracle Fusion HCM Cloud, but you might wonder what is the purpose of the tables that end with the following suffixes such as _ALL, _TL, _VL, _V, _F, _VL, _A and so on. Below is a description provided for each of these tables: • _ALL table holds all the information about different operating units in Multi-Org environment. • _TL are tables corresponding to another table with the same name. These tables provide multiple language support. For each item in the table without _TL there can be many rows in the _TL table, but all with different values in the LANGUAGE column. • _B tables are the BASE tables. Data is stored in the table with all validations. It is supposed that these table will always contain the perfect format data. • If anything happens to the BASE table data, then it is a data corruption issue. • _F tables are date tracked tables, which occur in HR and Payroll. These table will have the two date columns – EFFECTIVE_START_DATE and EFFECTIVE_END_DATE – which together with the primary key identifies a row uniquely. • _V tables are the views created based on the base […]

Read More +

How Cloud-Based Systems Help Automate and Improve Financials

DataTerrain has developed cloud based systems of Business Intelligence services that have been shown to increase return on investments and financial planning of organizations around the globe. Learn more about our BI systems in this new post.

Read More +

Pre-built – HCM Report to Track Payroll and TRUs

The Prebuilt Multi-Org Transfer Report has excellent functionalities to tracks all changes that occurred in an employee that has transferred between TRUs (Tax Reporting Unit) and/or Payrolls. This Prebuilt report can be run for an effective date or organization name or employee number which could be scheduled and delivered to an FTP Server/Email as per the user’s requirement. Enhancements such as adding new parameters or conditions to this report are simple. The output type, by default, is Excel which is also customizable to any other format. DataTerrain’s Prebuilt reports usually are built in the below 3 reporting formats: 1. HCM Extract 2. BI Publisher Data model reports 3. OTBI Some users prefer to run the report from CheckList which would require the report to be built as Extract and some run directly from BI Publisher Catalog for which reports should be BIP/OTBI. We have developed this report in both an HCM Extract report and BI Publisher Data model report which users can make use of as per their needs. The Pre-built Multi Org Transfer Report captures the following major functionalities and it is customizable: The existing seeded Payroll Activity Report or Employee Active Balance Report do not list out employees […]

Read More +

Prebuilt HCM Report to audit changes in Payment methods

In Fusion, Personal Payment methods of employees are defined when payroll is created. Each employee can have more than one payment method associated with him. If no personal payment method is added to an employee, he will receive his pay by the default payment method of their payrolls. These personal payment methods do not change often for employees. The changes in the employee’s personal payment methods should be checked recurrently in order to prevent the payment being transferred to any incorrect bank accounts which can happen during phishing attacks. Report Description: DataTerrain’s Prebuilt report lists the changes in the personal payment methods of the employees in the past 7 days. This report takes the current date as the input and gets the payment changes in the last one week’s period. This report can also be modified to run for a date range so that Users can view the changes that occurred in a particular date range. This report is built as a BIP report and hence it can be run from the BI Publisher Catalog. Output: The output data will have details regarding the old and new bank branch number, account numbers if the personal payment method has changed. The […]

Read More +

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 +