Category: Oracle Fusion HCM

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 ‘’ 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


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 +

DataTerrain launches automated conversion solution to Cognos

DataTerrain a leader in Business Intelligence migration solutions, announced the launch of reports conversion solution for customers who are migrating from legacy platforms to Cognos platform and support both 10.x and 11.x versions. DataTerrain’s conversion solution to Cognos includes both the reports and the Framework Manager. DataTerrain’s automation tool, which forms the core of the conversion solution enables the customers with legacy BI platforms like BRIO, Discoverer, Oracle 10g to migrate to Cognos. The converted metadata (Framework Manager) works seamlessly in the Cognos platform and supports Adhoc reports. The analysis component of the automation tool examines all the elements, identifies the missing elements and provides a detailed log that can be used for pinpointed analysis to narrow down report migration issues. The converted reports work seamlessly in Cognos. The conversion framework includes the analysis phase, which thoroughly reviews all the source elements, identifies the missing elements, that can also be used for pin pointed analysis to reduce the report migration issues.DataTerrain’s experts can provide solutions for the compatibility issues and resolve them. Customers can take advantage of DataTerrain’s conversion solution to preserve years of efforts in designing the reports and metadata while migrating to Cognos. DataTerrain’sconversion Services are offered under […]

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 +