J_TE01_System Decomposition and System_1.docx

SECTION J

TECHNICAL EXHIBIT (TE01)

MRMSS SYSTEM DECOMPOSITION AND SYSTEM DESCRIPTION

RFP: 140D0420R0005: Operations and Maintenance Support Services for MRMSS Title: Minerals Revenue Management Support System (MRMSS) - Operations and Support / Development and Enhancement for the Office of Natural Resource Revenue (ONRR)

TE-01

1. MRMSS FINANCIAL System (MRMSS – Financial)

The MRMSS-Financial sub-system is a mix of customized software and heavily modified COTS products. Though not a part of the MRMSS-Financial sub-system; the following systems, OTCnet, ORPS, Upload/Download and Documentum interface with MRMSS. OTCnet allows imaging of paper checks into the MRMSS-Financial-system. Documentum is a repository containing copies of reports from the MRMSS-Financial/MRMSS Data warehouse (MDW) Sub-systems, as well as electronic copies of all checks. Another component of the MRMSS-Financial is the eCommerce Interface component. This component allows data to be entered or uploaded by the reporter to the MRMSS-Financial. There is a documents list page in eCommerce that displays the files submitted by each reporter. There are 3 types of data that can be reported: Royalties, OGORs and PASRs. The reporter can only view the documents associated with their reporter code. Reporters can create a report offline and then upload the entire report via the upload functionality. The other two types of data are FMPs and Wells, which are uploaded once a week.

Below is a summary of the frequency of when data is loaded or reported and average number of lines:

Data Reported

1.A Production

The MRMSS-FINANCIAL includes a customized Production module to meet the responsibility of processing, validating and storing Oil and Gas Operations Report (OGOR) and Production Allocation Schedule Report (PASR) production documents. The Production module will load, validate, process and store all production documents. In addition, it will provide the means for ONRR personnel to perform corrections and related functions to production documents.

The Missing Exceptions identifies all production documents for the report month for which they are due. This process also verifies all active missing exceptions in order to determine if updates have been made to production reference data since the previous execution of the missing exception process that can system resolve existing missing exceptions. .

The Production module design consists of the following batch processes:

· Load to OGOR Staging Tables Batch Process: This process loads all received and manually created OGOR, FMP and PASR production documents. ONRR can update these documents via online pages.

· OGOR Validation Batch Process: This batch executes a group of edits on OGOR documents to verify information submitted by the reporter. Invalid information results in creating suspended records, error records and history records. The validation step also updates reference data.

· OGOR Move Batch Process: This process moves all “Accepted” documents, purging these types of documents from the staging table

· Transmission Batch Process: The transmission batch processes will transmit relevant OGOR and PASR production information received and processed by ONRR to Bureau of Land Management (BLM), Bureau of Ocean Energy Management (BOEM), Bureau of Indian Affairs (BIA), Office of Special Trustee (OST), States or Tribes.

· Missing Production Batch Processes: The missing production batch processes identify production documents that are due to ONRR but have not been received. A separate batch process is developed to identify missing documents for each production document type.

1.B Royalty

The MRMSS-FINANCIAL includes a custom Royalty module to meet the responsibility of processing, validating, and storing 2014 royalty documents received from payors via eCommerce. It is the primary reporting tool used by Oil and Gas and geothermal lessors to pay contractual Financial obligations. The Royalty module in PeopleSoft® allows ONRR to load, validate, process and store 2014 documents. The edits in the Royalty Validation process (as well as in eCommerce and nightly batch) ensures the reasonableness of reported data and timely and accurate distribution of funds to state, federal, and Indian entities, geothermal counties, political subdivisions, and federal agencies. The Royalty Module serves as primary input into the Accounts Receivable and the Lease Account Balance modules.

The Royalty module design consists of the following batch processes:

· Royalty Load Batch: The Royalty 2014 Batch process is the primary batch for loading royalty information received into staging.

· Royalty Validation Batch: This will process header and detail lines against a set of required edits.

· Royalty Move Batch: This will move all Accepted detail lines, purging these types of lines from the staging table.

· Raw Royalty Data Transmission to Tribes Batch: This process will create a transmission file containing all 2014 documents in original form prior to processing by ONRR. The transmission is sent to the applicable Indian Tribes.

· Confirmation Reports are created for Royalty Payors and for ONRR to view discrepancies. are

1.C Reference

The MRMSS-FINANCIAL includes a customized Reference Data module to meet the requirements of processing, validating and storing contractual instruments. The Reference module provides the foundational data to the FINANCIAL system, as it maintains the contracts, mines, and facilities data necessary for all the other modules. When contracts are created in Reference, the data for a given contract is in multiple tables. Therefore, when a contract is inactive, all data for that contract is set to inactive. This module holds all the contractual information for every lease/agreement in the system.

The Reference Data module design consists of the following batch process:

· Reference Batches: The Reference batch processes will process data from outside agencies into the MFINANCIAL. New records are created, updated and modified through these batch processes. Error correction is accomplished through online staging panels where incoming data can be corrected before returning to the batch process for acceptance into the MFINANCIAL.

· Terminator Batch - This batch terminates deficient terminable leases and flags the nominally deficient terminable leases.

1.D Accounts Receivable

ONRR uses PeopleSoft® Financials for Government and Education (PeopleSoft®) - Accounts Receivable (AR) to track customers obligations for rent, bonus (includes deferred bonus), royalty (RIV), and bills. PeopleSoft® stores customer information, generates receivables, stores payments, matches payments to receivables. ONRR uses a receivable in two different ways: (1) money owed to ONRR (Debit), and (2) money ONRR owes to someone else (credit). The following are sources of income and generate account receivables in the MRMSS-FINANCIAL: (1) Royalty Document (2014) – income for gas and oil (solids minerals can also be noted on the 2014), (2) Lease – Fees for Leases, (3) Courtesy Notices – A notice to a customer to keep a lease (a renewable lease), (4) Solids P&R – income from natural minerals, (5) ROW/RUE – Right of Way/Right of Use Lease, and (6) CAMP Submissions – Used to ensure that companies comply with the rules of their contracts. A customer can pay item, credit an item or write off an item.

ONRR uses the delivered AR functionality along with customizations. Below are the main batches of AR.

· ONRR generates receivables manually or from an interface (Royalty, Solids P&R, Reference, and Billing). The data flows through Accounts Receivable using the following processes or by manually updating the data via AR PeopleSoft® webpages. Generate Receivables Interface: This program will generate royalty, rent and bonus receivables in PeopleSoft® AR from the reference and royalty data in a nightly batch process

· AR Load Process Batch – This process loads billing pending receivables.

· AR Update Batch – This process posts all pending receivables to customer accounts. This batch runs during the day and at night.

· Lockbox Process Batch – Loads file payments into staging.

· Payment Interface Batch – This process loads the payment files from staging to other application tables.

· Payment Predictor Batch: This process applies outstanding payments to outstanding items.

· Debt Collection Module: This toolset creates and tracks aging of debts and collections from Industry. This includes reporting, and online tools to track outstanding debts and confirm collection.

1.E Accounts Payable:

ONRR uses PeopleSoft® -Accounts Payable (AP) functionality to generate and track voucher and payment information used to disburse money to ONRR recipients.

ONRR uses the delivered PeopleSoft® Accounts Payable functionality with heavy customizations to meet their disbursement requirements. The primary function is to generate Payables. This function involves generating payable detail lines (PDLs) at the level of detail represented on the Explanation of Payment (EOP), applying automated business rules (ABR) to those payable detail lines regarding status for distribution and giving authorized ONRR personnel an opportunity to make any manual adjustments necessary (AP Adjustments). This function updates the Royalty and Receivable records to ensure that all the data is synchronized properly.

Distribution & Disbursement

ONRR uses a custom-developed Distribution & Disbursement module to distribute and report revenues owed by holders of mineral leases on Federal and Indian lands. This module is used in conjunction with the PeopleSoft® delivered Accounts Payable module to meet ONRR’s distribution and disbursement business needs. Payables are generated for receivables at different times during the month. For Indians, payables and distributions are generated twice monthly. For federal, payables are generated on average three times and distributions once monthly.

The disbursement function generates the PeopleSoft® vouchers from the payable detail lines (PDL) in order to generate payments and update the General Ledger (via journal vouchers (JVs). This area also includes processing to update the payable detail line (PDL) records with the disbursement information for tracking and reporting. Based on the payable detail lines (PDLs), accepted Royalty data, and Reference data information, the Explanation of Payment (EOP) is created.

The processes associated with Accounts Payable and Disbursements are listed below:

· Genpay Batch: This process generates a payable (Paid Detail Lines - PDLs),

· ABR Batch: This process applies pre-defined business rules (ABR) to the PDL.

· Vouchers Batches: These processes use the PDL to create vouchers.

· Refunds Batch (part of AR): Creates refund vouchers from AR.

· Pay Cycle – Selects payments, runs Late Disbursement Interest (LDI), create payments.

· Payment Post: Creates accounting entries for GL.

· EOP Batches: Then generate Explanation of Payment (EOP) and run the final reports.

· Flexible disbursements: Modernization of fund distribution to counties, states, tribes, and Treasury, allowing ONRR to create AP Adjustments each month.

1.F Exception Processing

The MRMSS-FINANCIAL includes a customized Exception Processing module to generate the exception lines that feed the delivered PeopleSoft® Billing module. Exception Processing identifies all Financial terms, interest and Indian over-recoupment exceptions and provides the detail information required to research, modify, verify and issue bills.

The Exception Processing Module consists of several batch processes and tools:

· Interest Batch: includes Late Payment Interest, which calculates interest on receivables paid late and estimate interest which creates interest data for estimates which are stored in LAB

· IOR Batch: This batch generates Indian Over Recoupments exceptions.

· Financial Term Batch, this batch generates Financial term exceptions based on obligation data.

· Inspection Fee Batch: This batch generates other (OTH) exceptions, based on a file received from OEMM.

· Interest workbench: Java based tool that allows for calculation of Interest obligations. Works in conjunction with the PeopleSoft® Interest module.

1.G Billing

ONRR uses PeopleSoft® Billing to create, modify and generate bills in printed or electronic format. Bills originate from exceptions detected by the Exception Process, or by manual entry directly into Billing. The invoices created in the billing module are configured such that they update the Accounts Receivable Item table at the line level (thereby updating customer balances).

ONRR uses PeopleSoft® delivered Billing functionality along with customizations to meet all business needs. Currently, we have bill attachments, which include a letter and detail reports that accompany the invoice.

1.H General Ledger

ONRR uses the PeopleSoft® General Ledger module to track the accounting journals resulting from activity entered throughout the PeopleSoft® system. The General Ledger module is a repository for all accounting information originating in the Accounts Receivable, and Accounts Payable, as well as in the General Ledger module.

We process journals using both suspense and error processing functionality.

There are two primary ways to generate journals, one is through AR Journal Generator and the other through AP Journal Generator. These are two separate batch jobs. ONRR can also update the journals online. Once the journals are created, they can be edited and posted.

1.I Lease Account Balance

The MRMSS-FINANCIAL includes a customized Lease Account Balance (LAB) module to track the status of lease related Financial obligations. The Lease Account Balance module processes and stores all transactions contributing to the following Lease Account Balance types: Estimates, Indian Recoupment, Rent, Minimum Royalty, Advanced Royalty, Bonus, Right of Way, Gas Storage Agreements and Well Fee Financial obligations. In addition, the Lease Account Balance module provides the means for ONRR personnel to view all lease account balances on-line.

The Lease Account Balance module design consists of the following batch process:

· Lease Account Balance Batch: This process will collect all pending LAB transactions and update existing or create new Lease Account Balances, as appropriate.

1.J Appeals Tracking System (ATS)

The Appeals Tracking System (ATS) is within the PeopleSoft® Financial Component and interfaces with the Financial System AR CAMP tables. Based on a bill number in the Appeals Tracking System, the bill is located in the AR and the bill status is set to in-dispute. Queries and reports for ATS are run using Web Center Portal.

ATS is designed to allow for tracking appeals during their entire lifecycle by system-assigned docket numbers. Users may enter aging, extension and closure milestones. AD Due Date and Department Due dates are automatically calculated, complying with the Federal Oil and Gas Royalty Simplification and Fairness Act (RSFA).

1K. eCommerce

The eCommerce solution allows industry users and ONRR users to submit the production and royalty reports online and receive real-time validation on the documents. Production reporting consists of submission of Form MMS- 4054- Oil and Gas Operations Report (OGOR) and Form-4058- Production Allocation Schedule Report (PASR). Royalty reporting consists of submission of Form MMS-2014- Report of Sales and Royalty Remittance (2014). If ONRR needs to make adjustments, they can submit a CMP 2014 Once the user is in eCommerce the application displays the Documents List by default. Through the use of a tabbed view the user can navigate efficiently between different functional areas of the application. Most user activity will occur in this area, where users can view, edit, delete, copy, print, and export MMS-2014, CMP-2014, OGOR, and PASR documents. The validation functionality checks each document, verifying the accuracy and reasonableness of the data. If there are data issues or combinations that are not allowed, edits will trigger. The validation functionality triggers a rule engine called Oracle Business Rules (OBR), which triggers 100’s of edits for each type of document OGOR, PASR, and 2014. The user has to correct any fatal edits in order to submit the document to ONRR. If the user cannot correct the edit or needs the document submitted even with edits that are triggered, they can request ONRR to perform an override. The override request page is accessible from any of the document (MMS-2014, OGOR, PASR) pages.

The eCommerce website is developed in .NET and supports a wide range of data formats as well as connectivity, access, transport and security options:

· Data formats: TXT, CSV, and XML

· Connectivity: Internet, dial-up, frame relay and leased lines

· Access: Event-driven and store-and-forward mailbox capabilities

· Availability is 5am to 7pm

The eCommerce website also provides industry users with navigation capability from the eCommerce website to the following related ONRR applications: Lease Account Balance (LAB), eStatement of Account (eSOA), and Online Rental Payments (ORPs). A link to eCommerce is accessible in Web Center Portal. The eCommerce solution provides ONRR with administrative reporting capabilities such as transaction summary information.

· ONRR users Online Rental Payments: Allows payment of Rental Obligations online and connects to Pay.gov

· Internal Reporting Generating System (IRGS): This Interface allows Form 2014 data to be entered, error corrected and ultimately submitted to the MRMSS.

1.L Electronic Statement of Accounts (eSOA) System

ONRR requires prompt payment and reporting on rents and mineral royalties due, as stated in the terms of each lease. When industry does not provide accurate payment-to-revenue report matching information, ONRR staff must determine how to match payments manually, often requiring contact with industry payors. This process is labor-intensive, completely manual, and further complicated because payors cannot access and actively monitor their account status.

The online Statement of Account application’s (e-SoA) primary goal is to make Statement of Account pages available electronically to MRMSS FINANCIAL Accountants and industry payors. The e-SoA application will allow users to add annotations to help aid and expedite reconciliation of open payments and receivables. These pages will allow industry reporters real-time access to run their Statement of Account to play a more interactive role in matching payments to the appropriate receivable and will help ONRR reduce accounts receivable balances.

1.M LAB Inquiry (Lease Account Balance)

The Lease Account Balance (LAB) module in the MRMSS – FINANCIAL is a website created with .NET Technology suite. The website is accessible to external industry users. It is used to by industry to track and display the status of lease related Financial obligations. It processes and stores all transactions associated with the following LAB account types: Estimates, Indian Recoupment, Rent, Advanced Royalty, Minimum Royalty, Bonus, Right of Way, Gas Storage and Well Fees. The LAB module captures general header level information as well as the related details of transactions.

1.N Upload/Download System

1. The upload/download system is a component interface using the .NET technology suite and excel spreadsheet templates. The system provides users with the ability to download rows of data from the MRMSS-FINANCIAL staging tables into excel spreadsheets. Based on established business rules and edits, users can make modifications and error corrections to selected fields. Users can upload the modified lines to be validated and processed by the Financial System in the same manner as staging lines from other sources. Users access is restricted to the various upload/download modules they have been approved to have access to via the MARF process. The upload/download spreadsheet templates are currently accessed through CITIRX. The modules that current have the upload/download functionality available are FMP, Well, Reference, Royalty, OGOR, PASR. Deposit Upload and Missing Exceptions.

1.O ORPS (Online Rental Payment System)

ORPS is a toolset that allows industry users to pay their rent to ONRR online. User access the ORPS website through eCommerce and select the lease number(s) to pay. ORPS electronically sends data about the selected lease(s) to Pay.gov (a site external to the MRMSS). The data sent to Pay.gov consists of the amount paid, customer ID, and agency tracking number. A payor makes the actual rental payment in Pay.gov. The ORPS website and Pay.gov communicate electronically to reduce errors from manual intervention. The payment is posted in Pay.gov and a file is created, manually retrieved by ONRR employees, and placed on a common drive. The ORPS website file is also placed on a common drive, where it is accessible to ONRR. Pending items for online payments are created at the time payments are received, rather than in advance. The batch process payment predictor processes and applies the values in the files to payments. The technology to accomplish this contains some listener services, XML files, and the ORPS web page created with the .NET Technology suite. The ORPS tool is used to reduce rental payment errors because the payor code, amount paid, and other required fields are transmitted and populated programmatically through the Pay.gov and ORPS process. This tool also helps reduce Late Disbursement Interest (LDI), because the payment application processing time is faster than the previous manual processes.

1.P Web Center Portal (and Hyperion)

Provides a centralized location for Financial reports to be published, users to gain access to the various MRMSS application, and run SQR and queries.

1. MRMSS Compliance and Data Mining Tools

2.A Queries and Reporting (Triggered by Hyperion in the Web Center Portal)

Data Mining Tools allow ONRR users, customers and business partners to access ONRR data through Internet Explorer. Users can access interactive HTML reports and print, download, or email them in multiple formats. With built in security, report categorization, automatic versioning and archiving, these tools provide a complete Web-based report distribution and management solution.

Data Mining Tools are on virtual servers that deliver secure, reliable access to ONRR. The entire set of tools and servers is fully integrated with a common user interface, data standard and security model to ensure fast deployment and adoption across ONRR – the Web Center Portal.

2.B Data Mining Tools currently provide ONRR with the following functionality:

Allows development and deployment of analytical applications with the following functionality:

· Provides capabilities and centralized solution administration for developers, DBAs and system administrators

· Enables advanced drill-anywhere ad-hoc and analytic capabilities

· Delivers query, analysis, reporting, and development without direct administration of data sources

· Allows users to build queries and perform analysis without creating data models or accessing the database.

· Enables users to schedule queries to process on a regular basis or during convenient off-hours, and then distribute the results across a network or to an intranet.

· Ensures secure access to Server for all users, with database repository and user-level security

Data Mining Tools User Community

2.C Oracle Business Intelligence Enterprise Edition (OBIEE) - MART

To help the MRMSS become a more efficient system, with greater emphasis on data driven fact-based decision making, ONRR implemented Oracle’s Business Intelligence Enterprise Edition (OBIEE), which ONRR named the MRMSS Analytics Reporting Tool (MART). ONRR’s desire is to realize the following benefits as a result of more wide-spread use of Business Intelligence (BI) and Analytics include:

· Reduced risk to ONRR’s organization goals and objectives

· Compliance with Office of Inspector General (OIG) and Government Accounting Office (GAO) mandates for improved system and procedural controls

· More efficient and predictable Royalty collection and Disbursement cycles

· Improved accuracy of audit and risk functions

· Reduced time to problem recognition and audit cycles

· Improved and timelier insights and remediation into ONRR operational inefficiency

MART is a reporting and analytical tool, which ONRR uses to display and slice and dice Financial and reference data in graphical and chart formats. The reports show trends in ONRR’s data, allow users to see information at a high level and drill into details, and has alerts that notify users when certain thresholds or criteria are met in ONRR’s data. Access to the OBIEE system and dashboards can be controlled at an individual or group level using OUD roles. The dashboards are currently available to ONRR users, and can be made available to industry, STRAC, and additional external entities.

2.D Office Workload Management System (OWMS)

The OWMS automates many of the tasks involved in tracking and managing Native American Inquiry Resolution and Outreach programs. The system allows users to load information about work activities and to retrieve it in various ways. The system helps serve the Native American mineral owners by giving the OWMS user access to information about customer questions and problems, including built-in management reports.

The basic system is divided into two modules:

· Inquiry Resolution

· Outreach

The OWMS is a web-based application that uses the .NET technology suite. Navigation of the application is driven by the use of menu buttons, data grids, labels and pushbuttons, appearing on all pages of the application. Security of the application is ensured by assigning each user to an OUD role. Only the authorized roles can edit or update data. The OWMS employs a combination of database edits and form edits to ensure that data integrity is preserved throughout the system. Only authorized ONRR ACM employees have access.

2.E Compliance Information Management (CIM)

CIM manages cases, sub-cases, findings and collections applicable to various compliance activities (i.e. – audits and compliance reviews). Much of the information provided in CIM can now be found in Operations Management Tool (OMT).

The CIM application is web-based and uses the .NET technology suite. Navigation of the application is driven by the use of menu buttons, data grids, labels and pushbuttons, appearing on all pages of the application. Security of the application is ensured by assigning each user to a role. There are several OUD roles involved in the application. Only the authorized roles can edit or update data. The CIM employs a combination of roles, database edits and form edits to ensure that data integrity is preserved throughout the system.

2.F Compliance Program Tool (CPT)

The CPT is a series of web-based applications that use the .NET technology suite developed to support the Compliance Review processes within ONRR for Oil and Gas. These applications basic functionality is as follows:

· Basic workload management - create, view and monitor changes/progress at the assignment level for each ONRR staff.

· Analytical Tools - A series of analytical tools (Specialty Tests, Weighted Average Calculator and Price Formulas) which allow users to generate results based on user-defined parameters, royalty and production data, and other data stored in the MDW.

· Analytical and Reporting capabilities – See Statistical Reporting

Common features:

· Navigation of the application is driven by the use of menu buttons, data grids, labels and pushbuttons, appearing on all pages of the application.

· Export and print capabilities.

· Input of user defined information at various levels of detail used in the generation of grids.

· Row Level Security is applied to specific applications to ensure each user has access to proper data. CPT contains a level of security based on OUD roles established and then assigned to a user.

2.G Solids Compliance Program Tools (SCPT)

The Solids Compliance Program Tools (SCPT) is a toolset based in the .NET technology suite. It incorporates the ACM’s (Audit and Compliance Management) Solids mineral analytical processes and helps reduce manual effort by users. The outputs of the Solids CPT toolset are used in the ACM’s Solid minerals high-level compliance processes.

The SCPT toolset is used to:

· Improve compliance efficiency by reducing manual, labor-intensive checks and automating these manual checks where possible.

· Assist users in reducing time for completing compliance analysis by performing edits at the time of data entry.

· Provide tools that help Compliance specialists perform advanced analysis.

· Allows Solids compliance work to be accessed in and completed in a more standardized and centralized data storage tool that the previous offline tools.

2.H Solids Production and Reporting (P&R)

Solid minerals mine and lease production and royalty data are reported on the Form MMS-4430, Production and Royalty Report (P&R). Solid minerals such as coal, gold, copper production and royalty are reported by operators/reports in a web-based application that uses the .NET technology suite. Solid mineral reporters access their P&R via entry of a User Id and password combination, which is unique to each reporting entity. This security feature provides reporters access only to the P&R for their particular mine. Just as the oil/gas production and royalty reports feeds into the MRMSS, so does the P&R tool.

Once accessed, the P&R automatically pre-populates specific un-editable reference data such as the mine name, mine number, product, lease, numbers and their respective royalty rates, any lease level obligations due and the amount. The pre-population of this data reduces data-entry and eliminates the need for error correction or courtesy notices for lease level obligations. The P&R also carries over the previous month’s ending inventory values. The reporter enters production and royalty values into easily identifiable fields.

Other features of the P&R include the Value/Volume Adjustment tools. When used, these tools automatically calculate and re-allocate the value/volume numbers across the leases in the mine. These tools provide a net change to value and volume, thus eliminating the need to reverse out original lines and re-enter corrected data. This feature also prevents arithmetic errors and ensures the accuracy of the production and royalties reported.

Upon completion of the P&R, the reporter submits the report by clicking on the “Submit” button. Built in edits detect any invalid reported data. An error message displays requiring the reporter to correct the error. Once successfully submitted, the P&R is stored in CAMP tables.

2.I Indian Price Tests (IPT)

The Indian Price Test Module uses CAMP tables and is utilized by ACM to test the compliance of reporters with the Indian Gas Rule covering Index and Major Portion Pricing and the application of Alternative Dual Accounting. The tool summarizes reported 2014 Indian Gas Royalty lines for each payor, compares them to an independently computed Gas Rule value and generates liability reports used in subsequent collection efforts.

The ACM process:

· Calculates the major portion/index price for properties in a designated area (Indian Reservation)

· Determines the price adjustment for properties for which the payors have elected Alternative Dual Accounting (rather than actual dual accounting)

· Compares the computed price to that reported by the payor on Form 2014 and generates several Liability Reports. These Liability Reports are manually sent to the under-reporting payors. Crystal Reports software is used to create the reports.

The IPT is a web-based application that uses the .NET technology suite. Navigation of the application is driven by the use of menu buttons, data grids, labels and pushbuttons, appearing on all pages of the application. Security of the application is ensured by assigning each user to an OUD role. Only the authorized roles can edit or update data. The IPT employs a combination of roles, database edits and form edits to ensure that data integrity is preserved throughout the system.

access to the application.

2.J Supplemental Data Capture (SDC)

SDC is a custom .NET application that allows ONRR personnel to enter data specific to Compliance Asset Management activities. These are typical add/delete/modify data entry screens for energy industry submitted data, pricing information and miscellaneous compliance data. It is accessed only by ONRR personnel. There are seven (7) separate tabs in SDC that capture data within the MRMSS. Varying levels of access to the tabs and pages is controlled through OUD groups.

2.K Enterprise Guide Statistical Analysis Service (SAS) The Stripper Royalty Rate Reduction Calculation is a SAS program that allows ONRR users to determine if a lease can be granted a reduced royalty rate based on production at a well basis. There are two calculations performed with this application. Access is through the Oracle Hyperion Portal and is currently limited to ten (10) users.

2.L Operations Management Tool (OMT) OMT is a set of tools that allows ONRR users to perform case management activities including audits and compliance reviews. It allows ONRR users to track their compliance and audit activities and store associated documentation.

OMT is java-based and is used for reporting and workflow using applications including SOA (service-oriented architecture), BPM (business process management), and Oracle ADF (Application Development Framework).

2.M Identity Access Management (I&AM)

ONRR implemented Oracle’s Identity Access Management suite of tools as the primary approach for implementing policies and technology that ensure the proper users have access to the appropriate applications in the MRMSS. It addresses the need to ensure the correct user access in an increasingly rigorous compliance organization. I&AM identifies, authenticates, and authorizes individuals into the appropriate MRMSS application based on the dynamic and static roles that are assigned to their user. With the use of (1) security questions, (2) One Time Password (OTP), (3) security image, and (4) the PIV card access the MRMSS system has a multi factor authentication process to accessing any part of the MRMSS system.

In addition to the security benefit, ONRR has also implemented Single Sign On (SSO) decreasing the number of clicks a user performs when logging into any of the MRMSS applications. In addition, IAM allows for ONRR to set patterns/trends of users who are attempting to log into the system, identifying possible threats or attacks. Also, the certification process with these tools, allows ONRR to know who is assigned to each of the OUD roles, performing a real time audit, and revoking access if necessary.

ONRR has implemented the below suite of Oracle I&AM products:

· OIM – Oracle Identity Manager Console – allows for Accenture to be able to manually review, update, delete users and their access.

· OAM – Oracle Access Management - enterprise-level security application that includes Web single sign-on; identity context, authentication and authorization; policy administration; testing; logging; and auditing.

· OAAM – Oracle Adaptive Access Manager –provides access control services to web and other online applications

· OUD – Oracle Unified Directory – is an all-in-one directory solution (LDAP) with storage, proxy, and synchronization capabilities.

image1.png