Aucerna Execute 2020 Updates

Below is a list of available updates to Aucerna Execute 2020. These updates contain bug fixes and minor feature additions. It is recommended that you always upgrade Aucerna Execute to the latest available update.

Installation:

Review the list of Aucerna Execute 2020 Known Issues.

Update 10 (2023-02-02)

Operational Scheduling
BUG Resolved an issue where the importing $0 activities from Enersight could cause the import to fail. (231016)
Download Aucerna Execute 2020.10.1.0

Update 9 (2022-10-13)

Budgeting and Forecasting
NEW Added the ability to turn off the automatic creation of Wells when importing Projects from Val Nav or Enersight. (175310)
NEW Added new columns to make reporting on capital and differentiating between forecast and actuals much easier: "Monthly Capital - AFE Gross/Net Actuals" and "Monthly Capital - Is Actual?". (157846)
BUG Fixed issue where Projects would sometimes get stuck in Due for Forecast filter. (160160)
BUG Make things much less confusing and fixed up permissions on "Update Actuals Closed Date" to be available to Accruals Admins and admins with Manage Project Configuration. (155660)
BUG Massive reduction in warnings when pushing capital to Enersight by restricting the data sent to capital for static/scheduled activities only. (156073)
BUG Fixed issue where advanced workflows created against Projects would raise an error in the automated workflow status sync job. (156814)
AFE
NEW Added new NetEstimateForAccountFilter and GrossEstimateForAccountFilter functions in calculated fields. (157107)
BUG Fixed issue where removing an account that was referenced by AFEs that you could not see (based on view rights) would cause an error. (154748)
Operational Scheduling
NEW Added new option on Enersight Import to remove unscheduled activities from Execute that are no longer found in Enersight. This makes it much easier to keep the two systems in sync. (161131)
NEW Improvements to behaviour when dragging activities on a schedule that do not have an assigned primary resource. (111424)
NEW Allow adjustment of timeout for Enersight integrations to better support extra-large projects. (158410)
Well Delivery
BUG Fixed issues where data would occasionally not be saved properly when using the task completion form in advanced workflows. (156372)
System
NEW Added support for managing a user's groups from the user's permissions tab. (156148)
BUG Fixed issue where bulk updates of document flags (green, red, etc.) would leave the document locked. (159355)
BUG Fixed issue where trying to configure fields for the User document would show two name fields (one the users actual name and the other the timezone's name). (155460)
BUG Removed weird "Group User" label that showed up when removing a group from a user in the user's permissions tab. (156147)
BUG Blasting into the future, Execute now correctly treats user input like "Jan 8" as "Jan 8 of the current year" rather than "Jan 8, 2001". (156183)

Update 8 (2022-02-14)

Budgeting and Forecasting
BUG Significant improvements to performance of the "AFEs" tab on Capital Projects. (154509)
AFE
BUG Resolved issue where the user description was not visible on Review and Approval status tabs. This change makes it much easeier to tell who is who in larger organizations. (154490)
Operational Scheduling
BUG Fixed issue deleting/clearing numeric values from the Operational Scheduling data grid. (155044)
BUG Fixed issue deleting/clearing date values from the Operational Scheduling data grid. (155077)
System
BUG Fixed issue where calculated fields would crash when the formula tried adding negative days to a date. (155305)

Update 7 (2022-01-19)

Budgeting and Forecasting
BUG Fixed issue where deleting a Project Activity would raise an "Object reference" error if a custom table was configured on the Account document type. (152280)
AFE
BUG Fixed issue using data loader to load AFEs with more than nine versions (revisions/supplements). (152363)

Update 6 (2022-01-07)

Operational Scheduling
BUG Fixed issue where "Schedule Project(s)" would fail if the list of projects included any projects with an empty Project Number. (149480)
Budgeting and Forecasting
BUG Fixed issue where historical capital detail rows would show in the Capital Summary report if they were captured in an Approved Snapshot. (118324)
BUG Fixed potential crash when generating Bulk Forcast Upload sheets containing specific columns (such as "Budget Capital"). (149373)
BUG Fixed issue where including the Project Monthly Capital Report's Activity Date column in an Excel Template Report would incorrectly render the date in UTC. (149906)
RTx / Jobs
BUG Fixed issue where RTD to RTx migration would fail in the presence of some audit log events. (132584)
BUG Fixed error where RTx copy would sometimes fail on slow networks. (143894)
BUG Fixed several formatting issues with markdown text used in Workflow Task descriptions making it easier to embed helpful reference material like tables or images. (147716)
AFE
BUG Resolved issue where AFE Project Allocation report type was unavailable without a Budgeting & Forecasting license. (135673)
NEW Add new "Gross Estimate for Account Group" and "Net Estimate for Account Group" functions to calculated fields to allow formulas to work with specific parts of an AFE estimate (i.e. Extract the Drilling portion from a Drilling & Completion AFE). (136343)
NEW For those of you who add up your AFE estimates to see where you are on your capital program, we've added new "Release of Funds" functionality to streamline the end-of-project process of adjusting the AFE estimate down to match AFE spend, and getting it approved. (136463)
BUG Fixed issue on slower networks where AFE could sometimes be routed for review despite validation errors. (144028)
BUG Fixed error where Field Cost entry screen would get stuck on "Please Wait" when it included AFEs with specific AFE Number formats (such as N1234567). (148297)
BUG Fixed behaviour of Approved Estimate fields during revisions and supplements. (150373)
NEW Introduced optional new, more restrictive, AFE visibility rules that limit reviewer/approver visibility to during their turn / phase. (151563)
System
BUG Fixed issue where users were unable to type in Report Calculated Column editor. (141090)
NEW When building calculated fields involving date/time operations, there is now a list of available timezones to choose from. (141108)
BUG Fixed issue where "StartSyncronization" API wasn't correctly enforcing permissions. (148389)
BUG Fixed issue where pages would fail to load if your browser was set to a non-English preferred language. ¡Lo sentimos mucho! (149842)
BUG Fixed issue where the New Field Wizard would incorrectly allow creating a field called "ID" (a database reserved name). (150076)
BUG Resolved multiple issues with the new grid component in Operational Schededuling.

Update 5 (2021-09-03)

Operational Scheduling
NEW Integration with Enersight now allows unscheduling a well in Execute and having it revert back to dyanmically scheduled in Enersight. (105777)
NEW Upgraded Schedule data grids to a new Excel-style grid with substantially better performance and helpful features like user configurable frozen row/column headers. (119751)
BUG Fixed issue where the red "today" line in OpSched would sometimes overlap other content when printing a schedule. (124239)
BUG Fixed issue that prevented creating a custom field permission on schedule documents. (131563)
Budgeting and Forecasting
NEW Added "Project Activity Owner" to the bulk user reassign tool to make role changes/reorganizations a bit quicker. (67891)
BUG Fixed minor issue where "Export Projects" would fail if not configured. Now the menu-item won't show if it hasn't been configured. (123422)
BUG The new "All Snapshots" report now better handles archived Projects. (128024 / 128881)
BUG Fixed issue where users could edit project data on historical project snapshots. (128025)
RTx / Jobs
NEW Added Workflow Task owner to the bulk user reassign tool to make role changes/reorganizations a bit quicker. (100219)
BUG Fixed issue migrating from RTD to RTx if Coordinate Name field was inactive. (123539)
BUG Fixed sample "Schedule RTx Sync" plugin so that it doesn't reference legacy Project RTx field. (123712)
AFE
BUG Fixed error where new API to import actuals would incorrectly fail if the AFE was locked for editing by another user. (128179)
BUG Ensure consistent processing of older primary attribute based approval rules when they were imported with a duplicate order. (128271)
BUG Improved error reporting on QByte export under certain invalid configuration conditions. (131946)
System
No news is good news!

Update 4 (2021-07-08)

Operational Scheduling
NEW Added a new "Fix Activity Names" button under the Schedule's "more" menu to update activity names to reflect changes in linked Project name. (122106)
BUG Resolved issue where changes to the Browse Page number of records shown would inadvertently affect the Schedule's Data tab's number of records shown. (122122)
BUG Fixed issue where re-import of Operational Schedule from Enersight would overwrite the Job attached to a schedule activity (clearing it out). (123424)
Budgeting and Forecasting
BUG Resolved issue where Approved Project snapshot was introducing additional rows in the Capital Summary report. (118324)
NEW Introduced a new "Project Snapshot" report type which allows users to report on historical snapshots in the Project browse screen. (121562)
RTx / Jobs
BUG Fixed issue where setting a date to blank on a workflow task would sometimes cause an "UNDEFINED TEMPLATE" error. (122344)
AFE
BUG Fixed critical issue where a custom AFE view wasn't being honoured when not using PAA-based create rights. This issue would potentially allow users to see AFEs they shouldn't have access to. (123419)
BUG Resolved issues with PAA-based approval/review rules where changing the rule order would only show the top 100 rows (making it really difficult to move rule 101 up to the top). Also enabled bulk update from Excel for rule order to make major rule reworking a piece of cake. (123765)
BUG Improved error reporting when using Data Loader to update System Review or Approval rules. (124187)
BUG Resolved issue where inactive positions in PAA-based approval/review rules would incorrectly show with Tier 0. (124198)
BUG Re-enabled support for catch-all wild-card rules (any, any, any) in PAA-based approval/review rules making migration from earlier versions of AFE Navigator simpler. (124199)
BUG Resolved issue where Field Cost Entry screen was incorrectly rounding inputs to the nearest cents. (124314)
NEW Added a new API to allow 3rd party systems to easily push updated AFE actuals into Aucerna Execute. (124365)
NEW Resolved issue where a divide-by-zero in a formula field would break form printing. (127442)
BUG Fixed spelling mistake in Closed Reason pop-up dialog. (128086)
NEW Added new "AFE Close" custom business rule so that administrators can fine-tune when users are able to mark an AFE as closed. (97337)
System
NEW Added ability to load field help text using the bulk field loader. (109288)
BUG Added timezone support to Truncate function in calculated fields to provide more predictable behaviour. (115459)
BUG System was incorrectly generating "BulkWorkflowSynchronizer" and "WorkflowInstanceDeleteSynchronizer" logs even when not workflows were defined. (116283)
BUG Fixed weird issue where "Document Description" field on AFE configuration would be too short when empty. (121531)
BUG Attachment comment field now correctly highlights embedded URLs. (121735)
BUG Upgraded language translation library to avoid "deprecation" warning on JavaScript debug console. (121986)
BUG Fixed issue where bulk user re-assign would fail when User's display identifier wasn't just the name. (122151)

Update 3 (2021-05-11)

Operational Scheduling
NEW Enhancement to SIMOPS validation plugin to catch overlap between two activities of the same type (i.e. no overlapping Drilling Activities). (120921)
BUG Fixed issue where 1 day activities could not be exported to Enersight. (120647)
BUG Print to Excel wasn't correctly sorting output rows. It is now! (120893)
BUG Fixed issue where special characters in Activity Name (such as an apostrophe) would prevent printing to Excel. (120918)
BUG Fixed issue where split activity would fail if any activity-level calculated fields are defined. (120920)
BUG Prevent export to Enersight from connecting twice to Enersight concurrently (reducing resource usage somewhat). (121446)
Budgeting and Forecasting
NEW Optional enhancement to the Project AFE Account Filtering behaviour to allow for cases where one account can potentially be mapped to multiple Capital Activities (never on the same project). (119065)
NEW Added URL of Enersight instance being used for integration to aid in trouble shooting. (120867)
BUG Capital with 0 duration is skipped when exporting to Enersight to avoid an import error. (113862)
RTx / Jobs
BUG Fixed issue where "task due for you" type email notifications would be sent to an assigned user even though the task was already automatically completed by the system. We all need fewer emails, and this gets rid of some unnecessary ones.(116369)
BUG Fixed minor issue in help text for Workflow data loaders that was incorrectly describing how to add a text section. (118348)
BUG Fixed issue where service would fail to start after using the "Purge RTDs" feature when migrating from RTD to RTx. (118429)
AFE
BUG Fixed incompatibility between Execute 2020 and our Peloton WellView/SiteView integration. Note that this does require additional steps to implement. If you wish to use the WellView/SiteView integration, please contact Aucerna Execute support. (114268)
BUG Fixed issue where the legacy reporter would fail for environments where the PARTNERID for the Primary Parent Company was not "1". (120865)
System
NEW Added automatic highlighting of URLs in text fields throughout the system. This is super handy for links to supporting documentation in external systems. (104505)
NEW Automated pruning of log files in the logs folder. Aucerna Execute now keeps only the 500 most recent log files of each type (each synchronization and integration is a unique log type) stored in the logs folder. This prevents issues where frequent running synchronizations would exhaust system resources. (115361)
NEW Fixed issue in the "either" function in the calculated fields where an empty string was treated as a value rather than a null-value as intended. (115829)
NEW Added support for list field filtering within Custom Tables. (120636)
BUG Fixed issue where add rows from Excel would have inconsistent results when trying to import a row with an error. The system now skips adding rows with errors to give an opportunity to resolve the error and load the whole row. (118494)
BUG Resolved issue where filtering in attachment fields in a custom table would fail to return any results. (119756)

Update 2 (2021-03-15)

Operational Scheduling
BUG More predictable behaviour when syncing schedule dates onto Projects when an activity exists in multiple master schedules and the activity in one of those schedules has no start date. (108083)
BUG Now correctly enforce timing lock on Projects when activities for that Project are scheduled (in Operational Scheduling). (112513)
BUG Resolved issue where exporting schedule data to Enersight would fail when Project Activity wasn't associated to a Val Nav cost type (which should be totally fine), or if the linked capital activity's duration was blank. (113533)
BUG When manually scheduling a Project (using "Add Project to Schedule"), any newly created schedule activities would be locked until the next service restart. (115367)
BUG When manually scheduling a Project (using "Add Project to Schedule"), users can now see more than 100 projects. (115715)
NEW Ability to move scheduled projects between pads. (101692)
Budgeting and Forecasting
BUG Improvements to error reporting when removing / changing project activities that are in-use to link AFEs to Projects. Resolved issue where AFE Allocation report would fail to run if there were incorrectly mapped AFEs. (111345)
BUG Fixed issues where "-" would sometimes show in historical / unused months in capital forecasts. (112105 / 114811)
BUG Prevent the deletion of Project Activities that are mapped to AFE Accounts. (112198)
BUG Fixed "Update Forecasts" screen so that switching reports automatically selects the first project in the list, rather than trying to re-select the first project from the first list. (112380)
BUG Fixed issue where inactive fields were incorrectly showing on the Project's Capital Summary grid. (113279)
BUG Fixed issue where update from 2019 to 2020 wouldn't copy Project History. (113321)
RTx / Jobs
BUG Changing a workflow task from a sub-workflow task, to a "normal" task would fail to be propagated to in-flight workflow instances. (113861)
BUG Ensure parent task name is visible when viewing Task detail. (114887)
NEW Added ability (in user.config) to hide RTx approval tab. (115018)
AFE
BUG Resolved issue using Data Loader to load historical corrections (C1) if the base AFE was internally rejected. (111145)
BUG Resolved issue where calling the "OpenAFE" API would fail with an exception when trying to load a deleted AFE, rather than returning a nice error message. (113620)
BUG Fixed problem where exporting Details to Excel from the AFE's Budget tab would create an Excel sheet that couldn't be opened in Excel. (114740)
BUG Fixed problem where APPROVED_NET_ESTIMATE column would incorrectly report 0 on approved AFEs. (114803)
System
BUG Fixed online help (F1) to point to the 2020 documentation, rather than the old 2019 document. Ooops! (112100)
BUG Properly enforce column size limits when adding new fields from the bulk field importer. These extraordinarily lengthy field labels were causing database upgrade issues. (112377)
BUG Fixed issue where a trailing slash would break an OData URL. (112789)
BUG Fixed issue with database upgrade incorrectly marking PROJECTS.ENERSIGHT_PROPID field as part of the primary key (and thus making it not nullable). (113263)
BUG Fixed an issue where the "Users in Group" block would get stuck on the screen in environments with no defined user groups. (113621)
BUG Fixed issue where including a dollar sign in a report title would prevent the report from being exported to Excel. (113687)
BUG Fixed "User Has Privilege Flag" plugin. (114814)
BUG Resolve issue where database queries would incorrectly execute Explain Plans (decreasing database performance).
NEW Sites and Wells-type documents can be made hidden. (113529)