/
Release Notes for IFS Reporting Version 2.20

Release Notes for IFS Reporting Version 2.20

Owned by Dustin Smith (Unlicensed)

Search the IFS Reporting Wiki

Release Overview

Release Date

April 21, 2023

 

Release Type

Minor

 

Summary of Changes

IFS Energy & Resources is pleased to announce the release of IFS Reporting 2.20. This release includes updates to the ETL, which now queries three additional files for change records (DIV, MDECK, REPORT.RESOLVE.DECK), enhancing the performance of the extraction process. For EU clients, four adhoc-based reports have been included for JVA analysis. This release also contains security updates and resolved report issues for IFS Land and Merrick reports. Please see section 2.2 for more details.

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 2022

Standard

X86_64

Supported

Supported

Y

Apache Tomcat 9, Windows SQL Server 2019, Jaspersoft v8.1.1  ETL Server - Windows Server 2022 (64-bit)

Interoperability Certification

TARGET PRODUCT

TARGET VERSION

CERTIFICATION STATUS

TARGET PRODUCT

TARGET VERSION

CERTIFICATION STATUS

IFS AFE

22.2.0.0 

Supported

IFS BOLO

13.9.23.0

Certified

IFS Enterprise Upstream

13.06.01

Supported

IFS Excalibur

9.1.13

Certified

IFS iLandMan

2.12.10

Certified

IFS Land

5.24.0.0 

Certified

IFS Merrick

4.10.01

Certified

IFS Workflow

1.6.1

Supported

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

ETL

For BOLO customers, the ETL now extracts recently created, updated and deleted records in the following files: DIV, MDECK, REPORT.RESOLVE.DECK. This enhancement will improve the extraction and load times for the above files, increasing ETL performance.  

Financial

EU reports

For EU clients, 3 JVA reports have been updated and added to the content offering:

  • R 03.01 JVA Cost Subledger Transactions by Party Table Report

  • R 03.02 JVA Gross Charges by Report Center Table Report

  • R 03.03 JVA PDJ Transactions in Error Table Report

  • R 03.04 JVA PDJ Transactions to be Distributed Table Report

Issues Resolved

MODULE

SUMMARY

NOTES

MODULE

SUMMARY

NOTES

Merrick

Monthly Gas Allocation Summary Report Total for Buyback on the Meters Not Summing Correctly

Issue: Buyback totals were not calculating correctly.

Resolution: Calculation was corrected.

Financial

Land Division Order Report Integrated with EU and Cannot be Run as a Standalone Report; A New Division Order Report Was Created to Resolve This

Issue: R 01.01 Divisoon Order Report integreates EU views.

Resolution: R 01.03 Stand-alone Division Order Report created

API Modifications

There were no API Modifications included in IFS Reporting 2.20.

Security Modifications

There were no Security Modifications included in IFS Reporting 2.20.

Seed Data Modifications

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

Datamodel Modifications

There were no Datamodel Modifications included in IFS Reporting 2.20.

Metadata Modifications

There were no Metadata Modifications included in IFS Reporting 2.20.

Configuration Modifications

There were no Configuration Modifications included in IFS Reporting 2.20.

Modifications Affecting Upgrades

Due to major changes in the IFS Reporting Engine, a uninstall of the current reporting engine is required prior to installing version 2.20.

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

Enterprise
Upstream

Proxy Errors Occur In GL Validation Reports

Issue: When three or more accounts are listed on a transaction, the following reports produce a proxy error:

  • R 05.25 Revenue GL Validation by Control Group Crosstab

  • R 05.26 Revenue GL Validation by Process ID Crosstab

Workaround: Development is working on this issue. 

 

Copyright© 2024 IFS AB. Copying prohibited. All rights reserved.