Category: Oracle Fusion HCM

How to use Oracle HCM Report to view Pre and Post Tax Insurance Deduction

Payroll tax

Report Description:DataTerrain’s Pre-built report gives the paycheck details of each employee including Pre and Post tax deduction. This report can be run for the below parameters● Effective Date● Start Date● Payroll● Consolidation Group● Process Configuration Group● Payroll Statutory Unit● Tax Reporting Unit● Department● Location● Payroll Relationship Group● Person Name● ProcessThis Pre-built report is available as an HCM Extract and hence it can be run from the Checklist.Output: The output data will have Deduction Element Classification, Element Description, Element Name, Deduction Amount for given pay period range.The output format of this report is Excel and it can also be rendered as PDF/CSV.Schedule: 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 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Overview of HCM Spreadsheet Data Loader

Oracle HCM Data Loader

Oracle HCM Spreadsheet Data Loader (HDL) is useful for loading data to HCM stage tables using an Excel Spreadsheet. Predefined spreadsheets are available for most of the objects and Users can define their own spreadsheets for any object as per requirement. HDL also offers similar features of data loading whereas Spreadsheet Data Loaders have their own advantages: Spreadsheet Data Loader templates are easy to use. Based on business requirement, spreadsheets can be tailor-made. Errors are reported in the spreadsheet template itself where we can fix and review them. In scenarios such as loading element entry for an element, spreadsheet is a better option. Loading data can be done through spreadsheets and can be maintained using .dat files.The process of uploading data using HCM Spreadsheet Data Loader consists of Import and Load stages. During the import process, the data gets uploaded to the HCM Data Loader Stage Tables and during the load process, the imported data is finally loaded to the Oracle HCM Cloud Application Tables.Spreadsheet Data Loader feature has below prerequisites: HCM Integration Specialist role is mandatory for using the spreadsheet feature. Under Setup and Maintenance, the HCM Data Loader Scope value should be set to Full in the Configure […]

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 +