Category: Oracle Reports

Jaspersoft Built-in System Parameters

Report parameters are used in many different ways inside a report. They can be used in the where condition of an SQL query, or to provide additional data to the report. Parameters are the best communication channel between the report engine and the execution environment. Jaspersoft Reports provides some built-in parameters that the user may read but cannot modify or delete. The following are some of the major built-in parameters of Jaspersoft: • REPORT_PARAMETERS_MAP – it contains the parameter values defined by the user. • REPORT_CONNECTION – holds the JDBC connection used to run the SQL query. • REPORT_MAX_COUNT – allows the users to limit the records from the data source. • REPORT_LOCALE – contains the resource bundle desired locale • REPORT_TIME_ZONE – Sets the time zone used to fill the report. • REPORT_TEMPLATES – This is an optional collection of styles (JRTemplate) that can be used in addition to those defined in the report. • IS_IGNORE_PAGINATION – User can switch the pagination system on and off with this parameter. 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 […]

Read More +

Prebuilt HCM Report to Audit Employee’s Payroll Hours

Tracking the correct number of working hours of each employee is a significant step in the process of calculating the payments in an Organization. Employees may have worked over the standard hours set for payroll or some would have worked less than the expected standard working hours. The differences between the standard hours and actual hours the employee worked must be recorded properly in order to avoid over/underpayments. Report Description: DataTerrain’s Prebuilt report lists the employee’s assignment, payroll details along with actual hours he worked and the standard working hours corresponding to his payroll. This prebuilt report can be run for the below parameters Effective Date(or End Date) Start Date Payroll Name Organization Employee This report can be run for a date range or a particular effective date based on User’s preference. This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist but if required, this can be created as a BI Publisher report too. Output: The output data will have both Actual hours worked and the standard working hours of each employee. The output format of this report is Excel and it can also be rendered as PDF/CSV. Schedule: Payroll Team […]

Read More +

How Increased Productivity in the Cloud Pays Off

HCM in the cloud can help your organization increase productivity. Our BI support team shows you how to use report conversion software to create and manage business analytics within your organization. Peoplesoft reports play a large part in BI; Here’s how.

Read More +

Auditing & Monitoring in Jaspersoft

In the world of Business Intelligence, that deals with a huge amount of data, Auditing and Monitoring are necessary in order to analyze who is using the data, how much data is used and frequency of usage. Jaspersoft Server licensed edition provides Auditing and Monitoring features in the built-in form of domains, views and reports. Users can turn on and off auditing and monitoring from Config level. The following are some of the Jaspersoft Auditing and Monitoring features and usage. • Auditing and monitoring settings can be configured from the file,applicationContext-audit.xmllocated in the WEB-INF. By default, the auditing and monitoring subsystem is off. • The audit data can be moved to separate database tables through a mechanism called “Archiving”. • Adhoc views can be created using Audit Domain and Audit Reports, Audit Archive Domain and Archived Audit Reports that are available in the Jaspersoft Server. • Audit reports contain information about general and repository events, user events, role events, as well as report events. • Monitoring reports only contain information about report events. Monitoring can be done using the Domain, views and reports available in Jaspersoft server under /Public/Monitoring folder. Views and reports can be created on top of Monitoring […]

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 +