Release Overview

Release Date

October 21, 2022

Release Type

Minor

Summary of Changes

IFS Energy & Resources is pleased to announce the release of IFS Reporting 2.18. For BOLO customers, the ETL has been enhanced to select only recently created, updated and deleted records in four files. With this change, many customers will see an improvement in ETL performance.

Two bug fixes are included in this release. For P2 Land customers, the R 01.01 Division Order Report now has the ability to select properties and division orders when entering an Owner ID. Previously, the report would only show these options based on Property ID. For Excalibur customers, the association between inside owners and wells/leases was not always showing the expected relationship when using the Cost Center Summary domain. The ETL was updated to pull in the correct relational data.

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
P2 AFE	22.2.0.0	Certified
P2 BOLO	14.0	Certified
P2 Enterprise Upstream	13.06.00	Supported
P2 Excalibur	9.1.8	Certified
P2 iLandMan	2.11.10	Certified
P2 Land	5.23.0.0	Certified
P2 Merrick	4.9	Certified
P2 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 P2 Excalibur customers. No changes are expected for P2 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 P2 BOLO customers. By default, this supplementary extraction process is not enabled, but specific tables can be activated as needed. No changes are expected for P2 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	For BOLO customers, the ETL now extracts recently created, updated and deleted records in the following files: GL.DET, GL.POCCUR. CC.CONS, GL.PROJ.CONS, and GL.BUD.PROJ.CONS. This enhancement will improve the extraction and load times for the above files, increasing ETL performance.

Issues Resolved

MODULE	FEATURE	SUMMARY

MODULE

FEATURE

SUMMARY

Financial/
Excalibur

Financial

Issue: In the Cost Center Summary domain, some insider companies were not showing a relationship to cost centers and leases.

Resolution: The ETL was updated to reflect the correct well/least association with companies.

Land

Issue: Entering an owner number was not allowing a selection of Division Orders/Properties in the R 01.01 Division Order Report.

Resolution: The input control Select a Property/Division Order was updated to allow a drilldown selection when an owner number is entered in the Owner Number input control.

API Modifications

There were no API Modifications included in IFS Reporting 2.18.

Security Modifications

There were no Security Modifications included in IFS Reporting 2.18.

Seed Data Modifications

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

Datamodel Modifications

There were no Datamodel Modifications included in IFS Reporting 2.18.

Metadata Modifications

There were no Metadata Modifications included in IFS Reporting 2.18.

Configuration Modifications

There were no Configuration Modifications included in IFS Reporting 2.18.

Modifications Affecting Upgrades

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

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