Changes since Execute 21.1.316

Schema Changes

  • Several tables beginning with the name COSTWELL or COSTWELLCAT have been added to support the Rystad integration. 21.1.319 #358130
  • The ACCOUNTS and ACCOUNTS_H tables have a new COSTWELLCAT field to allow mapping accounts to Cost Well Categories. 21.1.319 #358130
  • A COSTWELL field has been added to the AFE and the AFE_H tables. This field is inactive by default. 21.1.319 #358130
  • A COSTWELL field has been added to the PROJECT and the PROJECT_H tables. This field is inactive by default. 21.1.319 #358130

Features️

  • Execute now integrates with Rystad Energy to bring their world-wide, industry data directly into the AFE and Capital Budgeting (Projects) workflow. A “Cost Well” entity has been added to serve as a capital-focused template for a well. AFEs and Projects linked to a Cost Well can display validation messages if the estimates or capital for project activities doesn’t align with the benchmark data in the Cost Well. #integration #well #afe #budget 21.1.319 #358130

    Rystad Integration

    The Rystad integration requires a subscription to Rystad Energy but there is no additional licensing required for Execute.

    At a high level, the integration allows Execute to:

    1. Query capital data from Rystad and load that data to a Cost Well entity (or a document if we’re using Execute lingo!)

    The input parameters used for the query and the resulting costs are written to tables on the Cost Well. The costs are organized in categories that we refer to as Cost Well Categories.

    1. For an AFE, the GL accounts are mapped to Cost Well Categories. Then, you can link a Cost Well to your AFE and validation messages appear if the AFE’s estimate is under or exceeds the costs in the Cost Well.

    1. For a Project, Cost Well Categories are mapped to project activity types. By linking a Cost Well to a Project, validation messages are displayed if your costs do not align with the mapped cost well category.

    This doesn’t replace the current detailed estimation process that our customers use today. This isn’t authoring the estimate. The goal is context and confidence, not replacing engineering judgment.

  • Introducing Databricks Data Selectors & Sync (Beta), a new feature that allows users to easily select and synchronize data with a Databricks environment (via the Databricks API). This is beta functionality and not yet suitable for production use. #integration #workflow #system 21.1.317 #356515

Enhancements

  • A sample plugin and xslt file for the integration with Quorum Cost Accounting has been added to the plugins repository. #integration #afe #plugins 21.1.319 #357564
  • A new alphabetical filter bar has been added to the Configuration page, making it easier for users to find specific configuration items. #ui 21.1.319 #357589
  • In the Quorum balloting server, once a partner submits an “Approved” response, they can no longer clear it. If the approval was submitted by mistake, the partner must contact the ballot operator to have the ballot resent and their response cleared. #ui #balloting 21.1.318 #356538
  • SharePoint authentication has been updated to use certificate-based authentication instead of username and password, aligning with modern SharePoint security standards. #integration #security #api 21.1.317 #356724
  • The BallotUpload process now properly cleans up its temporary files after streaming rendered forms, helping keep the system tidy and preventing unnecessary file buildup. #system #performance 21.1.317 #296318
  • The custom business rule configuration interface has been migrated from Angular to jQuery. #ui #system #security #admin 21.1.317 #350023
  • The Comments view has been migrated from Angular to jQuery. #ui #system #security 21.1.317 #350025
  • The Document Types management tool has been migrated from Angular to jQuery. #admin #ui #system #security 21.1.317 #350017
  • The reminder time selection interface has been migrated from Angular to jQuery. #ui #system #security #admin 21.1.317 #350024
  • Updated DataTables JavaScript from version 1.9.4 to 1.13 to address security concerns and improve compatibility. #security #system #ui 21.1.317 #352852
  • The marked.js library has been updated to the latest stable v12.x, bringing improved security, better performance, and new features to Markdown rendering across the application. This update affects areas like the MOTD banner, help text, and help page viewer, ensuring a smoother and safer user experience when viewing Markdown content. #security #performance #ui 21.1.317 #354511

Bugs

  • Fixed an issue where some file attachments would fail to appear, due to a file being locked. A service restart would be required to bring them back and no errors were shown on the Attachments tab to indicate that there was a problem. Now an error message is displayed on the Attachments tab and further information regarding the locked file can be found in the server log or the support package. . #attachments 21.1.319 #358257
  • Resolved an error when generating a forms package per partner, when the forms are configured to print only for certain partners. #forms 21.1.319 #353941
  • Workflow diagrams will now generate if a task name in a sub-workflow, or the sub-workflow name, includes an ampersand (’&’). #workflow #ui 21.1.319 #356452
  • Field paths displayed on the Required Fields tab in the Discipline configuration page now include the slashes. #ui 21.1.319 #349687
  • Fixed an issue where the application’s built-in emails were failing. #email 21.1.319 #358794
  • Addressed a performance issue when loading Wells using the spreadsheet loaders. #well #loader #performance 21.1.319 #356132
  • Fixed an issue where data selectors would not load data to select. #ui #integration 21.1.318 #357323
  • Fixed an issue where the Send to Partners modal had a very narrow column for the list of selectable forms. #ui #balloting 21.1.318 #357243
  • Fixed date parsing error when setting the Out of Office period when the date format on the server is set to display days first. #api #system 21.1.318 #355591
  • Fixed the searching and sorting in the tasks grid of a workflow definition. #workflow #ui 21.1.318 #357326
  • Reverted the data tables library change from version 21.1.317. #system #ui 21.1.318
  • Improvements to error message reporting when the Integration Agent encounters a TLS certificate error. #security #integration #system 21.1.317 #353967
  • The AFE Project Allocation Report now correctly allocates actuals and field costs in systems where an account-level filter is not in use. #afe #reporting #budget 21.1.317 #351841
  • Fixed an issue where the Auto-release process was not updating the ‘Next Reviewing Position’ and ‘Next Approving Position’ fields. #workflow #system 21.1.317 #355395
  • Fixed a critical issue where selecting blocks in Blockly was not working in the latest versions of Chrome and Edge. #ui #system 21.1.317 #356620
  • Fixed an issue where the browse reports screen incorrectly showed a calculated field edit icon next to every field. #reporting #ui 21.1.317 #355095
  • Fixed an issue where very long field names could break the Excel sheets downloaded from the browse screen. #reporting #attachments #system 21.1.317 #353469
  • Fixed an issue where Custom Tab Text Sections did not support multiple line input, allowing users to now enter and display text across several lines as intended. #ui #system 21.1.317 #295772
  • If you set your preferred date format to ‘mmm dd yyyy’ (a reasonable choice), you can now actually enter dates in that format like you’d expect. #ui #system 21.1.317 #349499
  • Fixed an issue where emails appeared distorted or improperly formatted when viewed in Gmail Web, ensuring a cleaner and more consistent email display for users. #email #ui 21.1.317 #353687
  • Error messages now display correctly without incorrect HTML escaping, making it easier to understand issues when they occur. #ui #system 21.1.317 #353996
  • Fixed errors occurring when copying data from PostgreSQL to MSSQL using the database tool, ensuring smoother and more reliable data transfers between these systems. #integration #system 21.1.317 #355211
  • The Job Report dropdown in the Schedule Editor now only displays Global reports, making it easier to find the right report without clutter from other report types. #ui #reporting #opsched 21.1.317 #306212
  • The response date for a partner now correctly clears when the status is removed, ensuring your data stays accurate and up to date without any extra clicks. #workflow #ui 21.1.317 #354221
  • Fixed an issue where slashes in text sections and separators within the workflow task modal would hide the text or separator. #workflow #ui 21.1.317 #353990
  • We’ve resolved a performance issue affecting workflow reporting, so generating your reports should now be faster and smoother, even when handling large data sets. #workflow #reporting #performance 21.1.317 #355718
  • Workflow tasks now correctly disable fields when you don’t have edit rights. #workflow #ui #security 21.1.317 #354592
  • Workflow task reminders now correctly send notifications even when the underlying workflow definition was deleted. #workflow #email #system 21.1.317 #355065
Ready to update?
  • For Quorum-hosted Aucerna Execute environments, email an upgrade request to Execute Support.
  • For on-prem instances of Execute:
    • Always ensure you have a recent backup of your Execute database before updating.
    • Download the installer from the Client Portal.