Changes since Execute 21.1.287

Schema Changes

  • We’ve added new fields (EB_PERMITTED and EB_NONOP_EMAIL) to the PARTNERS for future use by Quorum Electronic Balloting. In the interim, you are welcome to activate these fields and use them to track partner electronic balloting consent and contact addresses. 21.1.295 #334262
  • We’ve added new tables AFE_APPROVAL_PATH and AFE_REVIEW_PATH (and accompanying *_DOC, *_DOC_V, *_H tables) to support the new AFE path workflow functionality. 21.1.295 #334867
  • We’ve added new fields to the AFE_PARTNER table to track future Electronic Balloting status. These new fields are: EMAIL, EB_ID, EB_RESPONSE, EB_RESPONSE_DATE, EB_SENT_DATE, EB_COMMENT, and EB_VIEWED_DATE. All fields are inactive by default. 21.1.295 #334262
  • We’ve made changes to the structure and data of our behind-the-scenes AFE partner status table STATUS_AFE_PARTNER. These changes will pave the way for us to introduce additional partner statuses in the future. For example: “Consent (limit participation to my WI)” and “Consent (and will carry proportionate share)”. 21.1.295 #334262
  • New APPROVAL_PATH and REVIEW_PATH fields were added to the AFE to support the new Approval/Review functionality. These fields are inactive by default. 21.1.295 #334867
  • Added PARTNER.LOGO_BASE64 and USER.SIGNATURE_BASE64 fields to store images for forms use. 21.1.291

Features️

  • Introduced new Approval/System Review paths, which provide another great option for creating and managing your business rules. Approval/Review paths are intended to be very simple to build and understand. As a bonus, they also better support integration with 3rd-party systems that don’t share Execute’s concept of Approving Position. #afe 21.1.295 #334867

    AFE Approval/Review Paths

    This release introduces a new out-of-the-box way to define approval rules in Execute called AFE Approval Paths, and the same for system review called AFE Review Paths.

    What are they?

    Paths are a new option for modeling approval/review rules in Execute.

    This feature introduces two new document types (“AFE Approval Path” and “AFE Review Path”) that can be used to define different paths of individuals an AFE can flow through for approval and review.

    For the remainder of this document, we’ll talk about Approval Paths but, for the most part, Review Paths are the same (except they don’t have $ limits).

    Here is a sample Approval Path that defines a three-approver approval path for completion AFEs.

    Next, an Approval Path is selected for an AFE (using the AFE’s new APPROVAL_PATH field). This selection can be entirely manual (which may be a great low-setup-effort option), “smart-manual” (using list filters to limit selection to valid approval paths that the user can then choose from - i.e. here are the three options for drilling AFEs), or “full-auto” (using a list filter setup to always identify a single Approval Path for each AFE with no user interaction needed).

    When releasing the AFE for approval, Execute will look at the Approval Path linked to the AFE and add those approvers to the AFE.

    A couple of key notes, however…

    • Approval Paths specify individuals and not positions. This makes building the rules far easier for those of you who think in these terms. Execute does require positions, however, so we automagically create them as required.
    • These are meant to be a simpler option, not a replacement for Blockly. While they have a bunch of great functionality (maximum approval authority, tiers, and exclude-if-over-max), they can’t do everything that the more powerful Blockly rules can.

    Why are they?

    Our current approval rules are great, but there are a few aspects of them that are problematic for some customers.

    1. They are complex. Some companies struggle with describing their approval rules as “individual positions with a blockly-based should-I-approve-this-AFE rule”.
    2. Many companies think of approvals as “Bob is authorized to approve up to $2M”, which is difficult to model in Execute’s Blockly-based rules where, instead, you need to add a rule to the person after Bob that says “Bob’s boss sees everything above $2M”.
    3. Some companies really struggle to think in terms of approving positions. They think in terms of individual people.
    4. Some companies have their approval rules defined in another system and want to leverage that. It is very difficult to automate the creation / management of the current Execute approval rules.

    So…

    Approval Paths give another option which will be easier to work with and maintain for some companies.

    As a bonus. Because Approval Paths are simple “Documents” in Execute…

    • You can report on them
    • You can update them with Browse Edit mode
    • You can import them / update them from Excel
    • You can load them with Data Loaders
    • You can load/update them automatically with Document Sync
    • You can easily create/manage them with our APIs

    How do I turn them on?

    1. You should enable the APPROVAL_PATH field on the AFE and, somehow, provide a mechanism for it to be set.
      • (Easiest) Add the field to an AFE custom tab and have someone fill it in. If that’s too open, you can always use list filters to limit which Approval Paths can be picked based on attributes of the AFE (the default is filtering by AFE Type).
      • (Harder) Automate the selection. Make the APPROVAL_PATH editability Never Except Batch and ensure the Blockly List Filters are set up to always identify a single Approval Path for each AFE (Execute will then automagically attach it).
    2. You need to give your admin user the “Manage AFE Approval Paths” privilege.
    3. You need to add some Approval Path documents. (NOTE: the default setup filters approval paths by AFE Type, so make sure to create Approval Paths for each AFE Type)

    FAQ

    What AFE amount does this approve on? Gross? Net?

    This feature honors our standard setting “Approval Amount Type” which allows you to select between approving on Gross, Net, or Net on Non-op.

    Can I ensure that AFEs have at least one approver with sufficient authority?

    You sure can using the new “Require Sufficient Approval Path” setting.

    When set, the system will prevent the release of the AFE for approval if the Approval Path doesn’t have an approver with sufficient approval authority.

    How can I limit which Approval Paths are selected?

    The easy answer here is List Filters. By default we ship with a basic list filter that only shows Approval Paths where the Approval Path’s AFE Type matches that of the AFE (actually, we’re a bit fancier and allow for “wildcard” approval paths which show up for every AFE Type!).

    Here is the default list filter rule on the AFE’s Approval Path field.

    If you wanted to further segment your rules, perhaps based on AFE Area, you can add an Area list field to the Approval Path document (don’t forget to add an Area dropdown field to the Approval Path General custom tab), and then update your list filter like so:

    How many approvers can I have in a path?

    We’ve created 15 approver fields (meaning the max is 15), but we’ve only made the first seven fields active initially. If you need more than 7, you can just enable additional fields on the Approval Path document.

    Does this support approving tiers? (Parallel Approvals)?

    It sure does! The “Share Tier” fields mean that the approver shares the same approving tier as the user above. So this example here:

    Would yield these approvers on an $1,500 AFE.

    Does this mean that Blockly Approval Rules are going away?

    Absolutely not. Blockly rules were created for a reason and are better at modeling certain types of approval rules. This new option is better for other types.

    If there are no positions… how does out of office work?

    There are positions, actually.

    While approving positions are not part of the Approval Path rules we build, they are a requirement of Execute’s approval engine. To make this work, we automatically create positions for each approver. By default, these positions are named after the approver (i.e. user “Jimbo Jones” will automatically get a position created called “Jimbo Jones”).

    If you’d like to see a more traditional position name on the AFE’s approval tab, you can add a new custom field CUSTOM/APPROVING_TITLE to the user and fill that in. From that point onward, the newly created position rules will be named like “{Approving Title} - Jimbo Jones”.

    So, for out of office, our normal functionality applies. If “Blair Contracts” is out on vacation and delegates to “System Admin”, you’d see a record like this. You can clearly see who was supposed to approve it, and who actually did approve it.

    How do I handle wildcard rules (“any area”)?

    It depends, but if you are using list filters and/or release validation rules to restrict which Approval Paths are selected for an AFE, you can build that logic into the rule.

    For example, a simple list filter like this would require that the AFE’s AFE Type match the Approval Path’s AFE Type (no wild cards).

    But by adjusting it slightly, we can allow for an empty AFE Type on the Approval Path document to apply to AFEs of every type.

    Can I use this and Blockly Position Rules?

    You sure can! When releasing an AFE for approval, any approvers from the new-style Approval Paths are added first, followed by any approvers added by Blockly.

    This allows you to add high-level approval rules (“President sees everything over $5M”) in Blockly and avoid adding them to every Approval Path… if you want… (of course, doing so makes reviewing the rules more difficult).

    You may also choose to use Approval Paths in general, but use Blockly Position Rules for specific AFE Types that are too complex for Approval Paths.

  • We’ve added a new setting, “Allow User Delegation”, which allows users to delegate their AFE/Job review and approval duties. We’ve left this functionality off by default because we know that it doesn’t make sense for some organizations that want strict control over who a user selects to approve/review on their behalf. For environments that need this, however, it’s a quick flip of a setting and users will find the new option under their user menu in the top-right of their screen. #afe 21.1.295 #334871

    Out of Office Delegation

    A frequently requested feature is now available: users can delegate their own review or approval when they’re away—without needing to go through a system administrator.

    To enable this functionality, simply toggle the new setting:

    Once enabled, users will see a new “Out of Office” option under their user menu (top right):

    From there, users will be guided through a simple delegation wizard, similar to the one currently used by administrators.

    Note: This feature is best suited for environments where users are trusted to choose appropriate delegates. At this time, there is no rule system in place to validate that the selected delegate has the necessary approval or review authority.

  • Execute has great little “+” icons next to list fields which are a quick shortcut allowing an authorized user to create a new value for that list and automatically select it. Just the thing when you go to create a new AFE, but realize nobody got around to adding that newly acquired asset to the list in Execute. This release improves upon this functionality by defaulting to the new record type’s first tab (rather than our currently non-user-friendly approach of generating a tab using the alphabetical list of all fields on the record). In addition, administrators can create a special “Quick Add” tab to streamline the experience. #system 21.1.295 #335025

    Improved Quick Add Experience

    In Execute, list fields typically include a + icon that lets users quickly create and select a new record of that type.

    Historically, the Quick Add pop-up form wasn’t exactly elegant—it displayed all fields on the new record in alphabetical order, which wasn’t always helpful.

    In this release, Quick Add now defaults to using the first (default) tab defined for that document type. It will only fall back to the alphabetical view if no custom tabs are available.

    So now, adding a Pad from your Well looks a whole lot cleaner:

    And if I’d like further control, you can create a special “Quick Add” custom tab and really dial it in!

Enhancements

  • Support for importing recurring/rental costs from WellView. Currently this behavior is off by default but it can be opted in if you rely on these costs. We will be enabling this by default in a future release. #peloton #integration 21.1.295 #335145
  • We’ve turned off the old (and we’re talking really old) linked files to attachments migration. This feature was slowing down startup in some environments and at this point we think everybody who would switch over already has. If it’s needed, it’s a mere setting tweak away. #attachments 21.1.295 #335525
  • It took us a couple of years to roll out the rename of WellEz to On Demand Well Operations within Execute, but we finally did it. Hilariously, however, we did so two weeks before we decided to stick with WellEz after all. This update brings back the much loved WellEz name. #integration #wellez 21.1.295 #335780
  • We’ve made some backend changes to pave the way for the coming Quorum Electronic Balloting service, which will modernize the balloting process and use a heck of a lot less paper. #afe 21.1.295 #334262
  • The AFE Estimate loaders now support loading phase-based AFE estimates, which is pretty nifty, if you need them! #afe #admin 21.1.295 #336870
  • Added a new “Capital Actuals” column to Schedule Activity report types. #opsched 21.1.293 #333238
  • We’ve added an optional flag to prevent pushing historical forecast start dates to Val Nav. #budget 21.1.293 #333842
  • System restart requests are now added to the audit log. #system 21.1.293 #333843
  • We’ve trimmed the columns down in the list of available columns when using Import/Update Multiple from the Browse Screen to just the updatable columns. This keeps the list much shorter (making it easier to find the column you are looking for), and speeds everything up. In addition, we no longer prefix column names with the Additional Storage Table name since that was never something end-users should be exposed to. #system 21.1.292 #333626
  • Execute has a great integration with Quorum’s On Demand Well Operations (ODW) software, ensuring alignment between field staff and head office. Unfortunately, we were a tad retro and still referred to it as WellEz, which hasn’t been its name for a couple of years. We’ve updated the occurrences of WellEz within AFE Navig… err… Execute to reflect our new product naming. #integration 21.1.291 #258545
  • We have continued upgrading the various column selection screens throughout the application (workflow definition tasks, field cost entry and AFE wells) to make them more consistent and eliminate a legacy component. #system 21.1.291 #317218
  • Execute will now ensure that we don’t exceed database-level maximum row-size constraints when adding columns to custom tables. #system 21.1.291 #330990
  • While the ASCII arrow (=>) in our new column selection screens would appeal to the computing hipsters in the crowd, we figured we should replace it with a proper icon instead. #reporting 21.1.291 #332237
  • We’ve added two new fields to Execute to make building/maintaining your printed forms a bit easier (for us, if we’re being honest). Partners now have a “logo” field, and users now have a “signature” field, which can be used instead of baking your various logos and signatures directly into the forms themselves. This makes things a bit easier to maintain over the long haul. #reporting 21.1.291 #332291
  • Additional configuration flags are now included in the startup logs to assist with troubleshooting and support. #system 21.1.291 #332294
  • We’ve improved the scrollbars when viewing the diagram on really wide workflow definitions. #workflow 21.1.291 #333081

Bugs

  • Resolved an issue where foreign keys on Postgres-based Execute databases were missing “on delete cascade”. #system 21.1.295 #299474
  • Resolved an issue where fields in a Blockly loop variable would fail to show the nice field name. #system 21.1.295 #326878
  • Restored the helpful “User Has Permission” and “User In Group” features that allowed you to build custom business rules based on the user’s permissions. #system 21.1.295 #332811
  • Resolved an issue where users were unable to add new attachments using our legacy Linked Files behavior. #afe 21.1.295 #334654
  • Resolved an issue where referencing DOCUMENT_ID in custom business rules could cause the rule to break. #system 21.1.295 #334940
  • Resolved an issue where frozen column headers were inadvertently showing up on the Execute dashboard (and looking rather broken while doing it). #dashboard 21.1.295 #335045
  • Resolved an issue where creating a specially named attachment and then deleting it would break attachments for that parent record (all attachments mysteriously disappear). We won’t mention the specific naming here because the temptation to try it is probably too great :) #attachments 21.1.295 #335282
  • Resolved an issue where Blockly rules on a workflow task would sometimes “jump tabs” when making edits and switching back and forth between completion rules, assigned to rules, etc. #workflow 21.1.295 #335624
  • Resolved an additional issue with loop variable numbering in Blockly. #system 21.1.295 #336479
  • Resolved an issue where invalid Blockly rules could be saved if the loop iterator variables had a name conflict. #system 21.1.295 #336583
  • Resolved an issue where drop-down fields in Blockly rule editors would occasionally fail to load. #system 21.1.295 #336601
  • Resolved an issue with the item# counter failing to increment when building loops in Blockly. #system 21.1.295 #336773
  • If the terms “MAWL” and “GOA” are meaningful to you, this update fixes the issue with historical approvers breaking the approval rules. #afe 21.1.295
  • We now prevent the bulk field importer from loading empty formula fields as these are invalid and cause other issues in the system. #system 21.1.293 #333745
  • We’ve added the “Document Id (match on)” back to Update multiple from Excel from the Browse screen. #reporting 21.1.293 #334756
  • Resolved a terrible issue where removing a task from a workflow definition could cause all other task dependencies in that workflow definition to be cleared out (requiring you to manually add them back to each task). #workflow 21.1.291 #250285
  • Resolved an issue where deleting a task and rolling out the updated workflow definition would raise mysterious “The given key…” warnings for any instances where that task had already been completed. #workflow 21.1.291 #264449
  • Cleaned up a minor issue with our new column selectors where it was showing the underlying document type “RTX” instead of a nice use-facing “Job” in the breadcrumbs. #reporting 21.1.291 #328492
  • We’ve fixed a frustrating issue with the workflow task editor that caused changes to the graphical rules (completion rule, activation rule, etc.) to be lost when switching tabs. #workflow 21.1.291 #332743
  • To our users who prefer to see their dates in the format “dd/mm/yyyy”, we are deeply sorry. For YEARS, it seems, we’ve had an issue in our date entry controls where a user whose preferred date format was set to “dd/mm/yyyy” would see the month and day flip-flop each time they clicked into a date control (for dates where the day was also a valid month). #system 21.1.291 #332951
  • Adding insult to injury for those who prefer the “dd/mm/yyyy” date format, we discovered that format would break the “Workflow” tab. This has been resolved. #system 21.1.291 #333059
  • Resolved an issue where changes made to a Blockly rule after using the “Code Editor” mode were not saved properly. #system 21.1.291 #333156
  • Fixed an issue where Audit events (such as an admin force approving an AFE) were not showing on the Change Tracking tab as intended. Note that the changes made were always captured in the change history, and the audit event itself was still captured and visible in the global audit log. #system 21.1.291 #333327
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.