/
Release Notes for IFS Reporting Version 2.9

Release Notes for IFS Reporting Version 2.9

Search the IFS Reporting Wiki

Release Overview

Release Date

August 7, 2020



Release Type

Minor



Summary of Changes

IFS Energy & Resources is pleased to announce the release of IFS Reporting 2.9. We have created a new and improved version of the Lease Operating Statement based on user feedback and client customizations. This new version allows users more options, including reporting on Accounting Period or Occurrence Date, as well as Company and Well Summary, and Well Detail – all in one report. Features such as adding an average column and displaying whole dollar amounts add further customization to the LOS.

This report essentially combines R 02.12 Lease Operating Crosstab and R 02.21 Well Detail Lease Operating Statement. R 02.12 Lease Operating Crosstab has been deprecated. For IFS Merrick customers, we have worked in collaboration with the IFS Merrick team to include a group of eight commonly used ProArt reports to the IFS Merrick out-of-the-box content. The look and feel of the reports are similar to ProArt, so users can continue running the standard, easy-to-use reports for oil, gas, and water volumes on a daily or monthly basis at different hierarchy levels. For IFS Excalibur customers, we have enhanced the Cost Center Summary ETL to include data in COST.CENTER.ACTIVITY in addition to the default COST.CENTER.DETAIL.

 

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 8.5, Windows SQL Server 2019, Jaspersoft v7.5,   ETL Server - Windows Server 2019 (64-bit), Java 8 JDK

Interoperability Certification

TARGET PRODUCT

TARGET VERSION

CERTIFICATION STATUS

TARGET PRODUCT

TARGET VERSION

CERTIFICATION STATUS

IFS AFE

20.3

Certified

IFS BOLO

13.8.16.0

Certified

IFS Enterprise Upstream

13.04.02

Supported

IFS Excalibur

9.1.0.0

Certified

IFS iLandMan

2.10.15

Certified

IFS Land

5.14.0.0

Certified

IFS Merrick

3.15.0.0

Certified

IFS Workflow

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

8 Core

RAM

16 GB

32+ GB

Disk

250 GB

500 GB

Note: The addition of the Budget and Forecasting module in IFS Reporting will require additional disk space on your SQL server to accommodate the new dataset. The projected data volume for the Budget and Forecast module will be approximately the volume of the Cost Center Summary table (FIN.FactCostCenterActivity).

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.

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

 

Minimum System Requirements - Software

Server Machine:

COMPONENT

REQUIREMENT

COMPONENT

REQUIREMENT

Web Server

Tomcat 8.5

Database

SQL Server 2019

Programming Platform

Java 8

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

ProArt

Daily Allocation Summary by Gathering System

This report displays allocated results for Oil, Gas, and Water information.

ProArt

Daily Gas Allocation Summary

This report displays Gas Production, Gas Sales, Lease Use, Gas Purchasing, and Lift & Injections information for each completion.

ProArt

Daily Production Report by Well

This report displays Oil Production, Gas Production (mcf and mmbtu) and Water Production information along with Daily Average, Targets, and Cumulative Data for each completion.

ProArt

Monthly Gas Allocation Summary

This report displays Gas Production, Gas Sales, Lease Use, Gas Purchasing, and Lift & Injections information for each completion from monthly data.

ProArt

Monthly Oil Allocation Summary

This report displays monthly allocated Oil information that contains Theoretical, Beginning & Ending Inventories along with the Productions and Gravity for a given month and selected gathering systems.

ProArt

Monthly Water Allocation Summary

This report displays monthly allocated Water information that contains Beginning & Ending Inventories along with the Productions and Water/Steam Injections for a given month and selected gathering systems.

ProArt

Monthly Allocation by Gathering System

This report displays monthly allocated information that contains Theoretical, Beginning & Ending Inventories with the Productions and Gravity for Oil, Gas, and Water totaled by gathering system.

ProArt

Monthly Allocation Summary by Completion

This report displays monthly allocated information that contains Theoretical, Beginning & Ending Inventories along with the productions and gravity for Oil, Gas, and Water totaled by completion.

Financial

R 02.21 Lease Operating Statement

Enhanced LOS with options based off Occurrence or Accounting Period, Company, Well Summaries, and Well Details. Further options include Averages, Whole Dollar Amounts, and the ability to customize a copy of the report with a company logo.

Financial

Enhanced Cost Center Summary ETL for IFS Excalibur users

Enhanced the Excalibur Cost Center Summary ETL process to include all shared data in COST.CENTER.ACTIVITY, in addition to the default COST.CENTER.DETAIL.

 

Issues Resolved

MODULE

SUMMARY

NOTES

MODULE

SUMMARY

NOTES

Technical

Fixed ETL in Financial Module

Issue: Check numbers in IFS Reporting were not matching what was expected from the financial system.

Resolution: Adjusted ETL logic to pull the Check Number from the CHECK.NO field on the Check file.

Technical

Fixed ETL in Financial Module

Issue: DOI records flagged as Reporting Decks failed to load.

Resolution: Updated ETL logic to include records that previously failed to load.

 

API Modifications

There were no API Modifications included in IFS Reporting 2.9.

 

Security Modifications

There were no Security Modifications included in IFS Reporting 2.9.

 

Seed Data Modifications

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

 

Datamodel Modifications

There were no Datamodel Modifications included in IFS Reporting 2.9.

 

Metadata Modifications

There were no Metadata Modifications included in IFS Reporting 2.9.

 

Configuration Modifications

There were no Configuration Modifications included in IFS Reporting 2.9.

  

Modifications Affecting Upgrades

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

 

Known Issues

MODULE

SUMMARY

NOTES

MODULE

SUMMARY

NOTES

Financial

Some data sources do not appear in the source selection window at domain creation

Issue: When creating a new domain, the selection of available data sources does not match the sources available in the library.

Workaround: The solution provider, Tibco is working on the issue. A workaround is provided:

  1. Right-click on the data source.

  2. In Properties, copy the URI of the resource.

  3. Paste the URI in the Create Domain data source field.

Financial

Transfer Order Report is not supported for IFS Excalibur customers

Issue: Due to the way Transfer Order IDs are currently extracted from IFS Excalibur, the R 01.05 Transfer Order Report is not supported for IFS Excalibur customers.

Workaround: A workaround is scheduled for a future release. 

Enterprise

Upstream

AFE number and description do not display 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. 

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. 

Email Notification

Email notifications not sending with no error message

Issue: The from address is hardcoded for ETL failure notifications and cannot be changed.

Workaround: Whitelist the no reply email.

 


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