Release Overview

Release Date

July 22, 2022

Release Type

Minor

Summary of Changes

IFS Energy & Resources is pleased to announce the release of IFS Reporting 2.17. This release includes an enhancement to the nightly data extraction that allows portions of the ETL to run concurrently. The ETL process consists of a number of modules that extract specific types of data from the financial system. In previous versions of the IFS Reporting ETL, these modules ran serially, each process completing before another module started. The enhancements made in release 2.17 allow up to 3 modules to run in parallel. By making this change, organizations should see an improvement in the length of time it takes for the extraction process to run.

Compatibility Matrix

Product Certification

^COMPONENT	^{OS NAME}	^{OS VERSION}	^{OS EDITION}	^{OS ARCHITECTURE}	^{SUPPORT STATUS}	^{CERTIFICATION}	^TESTED	^NOTES

^COMPONENT	^{OS NAME}	^{OS VERSION}	^{OS EDITION}	^{OS ARCHITECTURE}	^{SUPPORT STATUS}	^{CERTIFICATION}	^TESTED	^NOTES
Application Server	Windows	Server 2019	Standard	X86_64	Supported	Supported	Y	Apache Tomcat 9, Windows SQL Server 2019, Jaspersoft v8.0.2 ETL Server - Windows Server 2019 (64-bit)

Interoperability Certification

TARGET PRODUCT	TARGET VERSION	CERTIFICATION STATUS

TARGET PRODUCT	TARGET VERSION	CERTIFICATION STATUS
IFS AFE	22.2.0.0	Certified
IFS BOLO	13.9.15.0	Certified
IFS Enterprise Upstream	13.06.00	Supported
IFS Excalibur	9.1.6.2	Certified
IFS iLandMan	2.11.8	Certified
IFS Land	5.22.0.0	Certified
IFS Merrick	4.7.0.1	Certified
IFS Workflow	1.8.0.0	Certified

Recommended System Requirements

Server Hardware

This section identifies the recommended hardware requirements for each server.

COMPONENT	MINIMUM	RECOMMENDED

COMPONENT	MINIMUM	RECOMMENDED
CPU	4 Core 2.5 GHz+	8 Core 2.5 GHz+
RAM	16 GB	32+ GB
Disk	250 GB	500 GB

As of release 2.10, the Budget and Forecast module in IFS Reporting will require additional disk space on your SQL server to accommodate the new dataset.

Note: The projected data volume for the Budget and Forecast module will approximate the volume of the Cost Center Summary table (FIN.FactCostCenterActivity).

As of release 2.10, the enhancement of the Cost Center Summary ETL in IFS Reporting will require additional disk space on your SQL server to accommodate the new dataset for IFS Excalibur customers. No changes are expected for IFS BOLO customers.

Note: The projected data volume for the Cost Center Summary ETL will approximate the volume of the Cost Center Summary table (FIN.FactCostCenterActivity).

As of release 2.13, the enhancement of the BOLO Data Schema in IFS Reporting will require additional disk space on your SQL server to accommodate any added extractions for IFS BOLO customers. By default, this supplementary extraction process is not enabled, but specific tables can be activated as needed. No changes are expected for IFS Excalibur customers.

Note: The projected data volume for the full BOLO SQL data extract will be approximately double that of the BOLO Unidata table size

Minimum System Requirements - Software

Server Machine:

COMPONENT	REQUIREMENT

COMPONENT	REQUIREMENT
Web Server	Tomcat 9
Database	SQL Server 2019
Programming Platform	OpenJDK 11
Web Browser	Google Chrome (Recommended) Firefox Internet Explorer (Should not be in Compatibility Mode) Microsoft Edge

Additional Reference Material

User Guides

You may find the following documents useful:

IFS Reporting Basic User Training Guide

This document provides an overview of basic IFS Reporting usage, including how to access IFS Reporting content, create and format Ad Hoc Views and Reports, and schedule Reports and Dashboards.

IFS Reporting Intermediate User Training Guide

This document provides in-depth instruction on advanced functionality for Ad Hoc Views, charts and dashboards, including calculated fields and measures, advanced chart formatting, and drill-down and drill-across hyperlinking in dashboards.

IFS Reporting Advanced User Training Guide

This document provides in-depth instruction on advanced functionality in IFS Reporting, including creating standard and virtual data sources, working with domains, calculated fields, filters, and derived tables, and determining resources that depend on a domain.

IFS Reporting Installation Guide

Installing and configuring IFS Reporting for a first-time user. See the P2 Store.

IFS Reporting Troubleshooting

Please see the Troubleshooting page.

Release Contents

Enhancements

MODULE	FEATURE	SUMMARY

MODULE	FEATURE	SUMMARY
Technical	Security	Updates have been made to secure the log4j files in Jasperserver
Technical	ETL	Previous versions of the nightly ETL process have extraction modules running individually, one after the other. The enhanced ETL in the 2.17 release allows for up to 3 modules to run concurrently, greatly improving the ETL processing time.

Issues Resolved

There were no issues resolved for IFS Reporting 2.17.

API Modifications

There were no API Modifications included in IFS Reporting 2.17.

Security Modifications

There were no Security Modifications included in IFS Reporting 2.17.

Seed Data Modifications

There were no Seed Data Modifications included in IFS Reporting 2.17.

Datamodel Modifications

There were no Datamodel Modifications included in IFS Reporting 2.17.

Metadata Modifications

There were no Metadata Modifications included in IFS Reporting 2.17.

Configuration Modifications

There were no Configuration Modifications included in IFS Reporting 2.17.

Modifications Affecting Upgrades

There were no Modifications Affecting Upgrades included in IFS Reporting 2.17.

Known Issues

SUPPORT ID	MODULE	SUMMARY	NOTES

SUPPORT ID

MODULE

SUMMARY

NOTES

00422570

Enterprise
Upstream

AFE number and description do not show on select reports

Issue: The following reports display an incorrect AFE Number and Description:

R 02.02 Oracle GL Balances and Account Activity Table
R 02.03 Oracle GL Transactions by Journal Table

Workaround: A workaround is scheduled for a future release.

00424920