Category: Human Capital Management

DataTerrain provides customized Oracle HCM Payroll and Audit reports

DataTerrain, a leader in Business Intelligence migration solutions, announced that it has extended its Oracle HCM Payroll and Audit report creation for the latest version 19C. DataTerrain has over 10 years of experience in Planning, Design, Development, Tuning, supports a variety of Business Intelligence tools and specializes in reporting solutions. The DataTerrain team has in-depth real-world expertise in Oracle HCM application and specifically in reporting. The Payroll and Audit processes are highly complex and are not limited to providing accurate, efficient, and transparent processes in the face of massive differentiation, it also complies with local, national, and international rules in a rapidly changing, hyper regulatory environment. DataTerrain’s report creation framework starts with an analysis phase, which involves understanding the existing source report and creating a functional description document. This would be followed by the actual report development and validation. DataTerrain has customized the payroll reports by including additional details like Month-to-Date values in Employee Active Payroll Balance Report and has modified the design of report templates (like Sub Totals and Grand totals) The audit reports have been enhanced to capture Missing Employee Information like Bank Information and also identifies the changes occurred for Employee details in various Departments, Location, Manager, […]

Read More +

Creating BICC extracts from Oracle Fusion Application Products for data extraction

To extract data from a Fusion Applications Cloud data source, you use the BI Cloud Connector (BICC) Console to schedule a once-only or regular data load, known as a Cloud Extract.BI Cloud Connector provides the option to extract Fusion Data to both Universal Content Management (UCM) and Cloud Storage Service. • Within BICC the public view object(PVO) is associated with the Oracle BI Applications (OBIA) offering. Each offering (Finance, HCM, SCM, etc.) contains multiple seeded PVOs. Each PVO within an offering extracts data from a group of tables. • For example, if you select HCM offering for the extract, it includes a view object named ‘oracle.apps.hcm.action.publicView.analytics.ActionReasonsPVO’ as one of its PVOs. This view object extracts data from tables PER_ACTION_REASONS_TL and PER_ACTION_REASONS_B. • The other PVOs seeded within Oracle HCM offering will extract data from a different group of tables. • To add more data sources to seeded PVOs, you can use Cloud Extract Configuration and Extraction UI. There are two options when adding a data store; Fact Group or Dimension Group. • Once the extract has been configured, you need to schedule using the ‘Manage Extract Schedules’ option. • The file created by the Fusion BI Cloud Connector tool can […]

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 +

Oracle HCM Fast Formulas

OBIEE

Oracle Fast Formula is a tool to write formulas using English words and basic mathematical functions to perform calculations or comparisons. You can use information from your database in formulas without learning the database structure or a programming language. • Fast Formula is an easy way to customize the existing functionality in Fusion Benefits and it hides the complexity of accessing the database tables and columns. • Formulas can take input from a Global window, a database, or a process, such as a payroll run and they return values or messages. • Different formula types are used across various parts of Fusion HCM applications such as Payroll, Benefits Human Resources HCM Extracts, Compensation Management, Absence Management and Oracle Time and Labor. • Formulas are made up of several different components. These can include assignment statements, different types of input including database items, functions, nested expressions, and conditions. • Fast formulas can be used across various Fusion HCM products to perform payroll calculations, define rules for paid time off (PTO) accruals, calculate absence duration, edit rules for object group population for elements or people and so on. • There are predefined formulas for some specific purpose such as accrual plans, tax […]

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 view Personal and assignment data

Report Description: DataTerrain’s Prebuilt report is designed to fetch personal and assignment related data of suspended/terminated and transferred employees in order to verify the transactions that are to be carried out appropriately such as ending or moving deductions as per the Assignment Action of each employee. . This report can be run for the below parameters • Effective Date • Start date 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 the data related to Employees and their assignment. 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. 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. Sample output:

Read More +

DataTerrain launches conversion solution from SAP Business Object reports to Jaspersoft

DataTerrain a leader in Business Intelligence migration solutions, announced the launch of reports conversion solution for customers who are migrating from SAP BO reports to Jasper platform. DataTerrain’s conversion solution enables customers with SAP BO reports migrating accurately to Jasper Platform. The converted reports work seamlessly with Jasper domain. The conversion framework includes the analysis phase, which examines all the BO source elements, identifies the missing elements, that can be used for pinpointed analysis to narrow down the report migration issues. DataTerrain’s experts can help recommend solutions for the compatibility issues and resolve them. The conversion solution also includes the conversion of native functions and complex formula logics embedded in BO reports and provide an equivalent solution to achieve the same in Jasper. Customers can take advantage of DataTerrain’s reports conversion solution to preserve years of efforts in designing the report sections/layouts and migrating to Jasper reports. DataTerrain’s technical team provides experience and expertise to build the BO reports to equivalent Jaspersoftreports. Customers can engage in DataTerrain’s conversion Services under a Fixed-cost basis for any type or number of reports basis. There are NO long-term contracts required and we can be utilized for a specific project to a broader spectrum […]

Read More +