J_TE05_Deliverables_1.docx

DOCX document 109 KB Posted

Attached to
Minerals Revenue Management Support System Federal contract opportunity
Solicitation number
140D0420R0005
Issued by
Department of the Interior Departmental Offices Interior Business Center

About this file

Written by GovTribe AI ·

This draft request for proposal solicits operations and maintenance support services for the Minerals Revenue Management Support System. Key details include: the contractor shall provide ongoing support and enhancements to the MRMSS for the Office of Natural Resources Revenue, the performance period is a one year base period with four one-year options, and the contractor shall be responsible for operations and maintenance, development and enhancement, and deliverables such as continuity of operations plans, security documentation, system documentation, batch reporting, and email notifications. The due date for questions on the draft RFP is February 23, 2020. Interested offerors are encouraged to review the draft RFP and schedule reading room sessions with the contracting officers to facilitate submitting questions.

View the file

Other files for this federal contract opportunity

Other files attached to Minerals Revenue Management Support System, newest first.
File Type Posted
J_Attachment 1_PWS for O&M_Task Order 1_1.docx DOCX document
J_TE09_Baseline Compliance Requirements_1.docx DOCX document
J_TE11_QASP_1.docx DOCX document
J_TE10_Directives Laws Regulations_1.docx DOCX document
J_TE02_SME Skillsets_1.docx DOCX document
J_TE08_System Interconnects_Interfaces_1.docx DOCX document
J_Attachment 11_MRMSS_PPQ_1.pdf PDF
J_Attachment 3_NDA_Contractor to Sign_1.docx DOCX document
J_Attachment 6_Abbreviations and Acronyms_1.docx DOCX document
J_Attachment 8_Section L_1.docx DOCX document
J_Attachment 9_Section M_1.docx DOCX document
MRMSS Draft RFP_3 Feb 2020_1.pdf PDF
J_Attachment 7_Q&A Template_1.xlsx XLSX spreadsheet
J_TE07_SLA Monthly OandM Metrics_1.xlsx XLSX spreadsheet
J_TE06_References_Links_1.docx DOCX document
J_Attachment 4_COI Cert_Contractor to Sign_1.docx DOCX document
J_TE01_System Decomposition and System_1.docx DOCX document
J_Attachment 2_Transition (Statement of Objectives)_CLIN 0040_1.docx DOCX document
J_Attachment 5_Travel Request Form_1.docx DOCX document
J_TE04_Network Administration_Software_1.docx DOCX document
J_TE03_IT Hardware Inventory_1.docx DOCX document
J_Attachment 10_Pricing Model_1.xlsx XLSX spreadsheet
Show all 22

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Section J Technical Exhibit (TE05)

DELIVERABLES

Includes: O&M Deliverables, O&M Detail Design Deliverables, O&M Batch Report Deliverables / O&M Email Notifications Deliverables / O&M Batch Run Deliverables (Critical & Non Critical)

DELIVERABLE TABLE:

#
Deliverables
Frequency

OPERATIONS AND SUPPORT

1
Continuity of Operations
Yearly
2
Disaster Recovery Plan
Yearly
3
Disaster Recovery Steps
Yearly
4
Security Controls
Yearly minimum -- with any major change
5
MRMSS NIST Mapping
Yearly minimum -- with any major change
6
DOI Software Maintenance Inventory
Yearly minimum -- with any major change
7
Engagement hardware and Network Architecture
Yearly minimum -- with any major change
8
Failover Architecture
Yearly minimum -- with any major change
9
ONRR to AT&T Visio
Yearly minimum -- with any major change
10
MRMSS Asset Inventory Hardware
Quarterly minimum -- with any major change
11
MRMSS Asset Inventory Software
Quarterly minimum -- with any major change
12
MRMSS Configuration Management Plan
Yearly minimum -- with any major change
13
MRMSS Contingency Plan
Yearly minimum -- with any major change
14
MRMSS SSP Supplemental Documents
Yearly minimum -- with any major change
15
MRMSS System Description
Yearly minimum -- with any major change
16
MRMSS Technical Description
Yearly minimum -- with any major change
17
MRMSS Functional Diagram
Yearly minimum -- with any major change
18
ONRR to Hosting Provider Visio
Yearly minimum -- with any major change
19
MRMSS Technical Architecture Blueprint
Yearly minimum -- with any major change
20
MRMSS Vulnerability Management Process
Yearly minimum -- with any major change
21
Vulnerability Scans
Weekly
22
Vulnerability Remediation Plan
Monthly
23
Enterprise Nessus Scan Reponses
Weekly
24
STIGS
Quarterly
25
STIG Comparison Reports
Quarterly
26
POAM Status Report
Monthly
27
IT Security Plan
Yearly minimum -- with any major change
28
MRMSS Failover Architecture
Yearly minimum -- with any major change
29
MRMSS Network Design
Yearly minimum -- with any major change
30
Incident Reports
Event
31
Daily Batch Synopsis
Daily
32
Data Cleanup Status Reports
Monthly
33
COR Status Reports
Monthly
34
Meeting Minutes
2 Days after meeting
35
EVM Report - Operations and Support
Monthly
36
EVM Report - Release
Monthly
37
SLA Monthly Metrics
Monthly
38
Quarterly SLA Metrics
Quarterly
39
SLA Measurement Methods
Award/Modifications
40
QUASA Reports
Quarterly
41
QUASA ONRR Reports and Audit Procedures
Yearly minimum -- with any major change
42
QUASA System Administration Audit Report
Quarterly
43
Financial Audit Documentation Delivery
Yearly minimum -- with any major change
44
C&A and ICR Audit Support Documents
As needed per audit
45
Hosting Provider SOC Report
Twice Yearly
46
Personnel Report
Monthly
47
Security Metrics
Monthly
48
Continuous Monitoring Reports
Monthly

RELEASE DELIVERABLES

49
UAT Readiness Checklist
Before UAT
50
Specification Documents
Completion of Requirements
51
Requirement Traceability Report
Before UAT
52
Release Request Work Plan
Completion of Release
53
Deployment Work Plan
Before Deployment
54
Consolidated Release Spreadsheet
Completion of each phase
55
UAT SIR Summary Report
Completion of UAT
56
Unexecuted Test Scripts
End of First Week of System Test
57
Executed Test Scripts
Completion of System Test
58
UAT Status Report
Weekly during UAT
59
UAT meeting minutes
2 Days after meeting

SUPPLEMENTAL DELIVERABLES *NOTE - Each task order will outline in their specific contract which of the below deliverables are included.

60
Monthly EVM Reports
Monthly
61
Meeting Minutes
2 Days after meeting
62
Project Schedule
Beginning of the Project
63
Requirement Matrix
During Analysis
64
Project Management Plan
Beginning of the Project
65
Impact Analysis
Completion of Analysis
66
Detail Design
Completion of Design
67
Acceptance Test Readiness
Before UAT
68
Deployment Plan
Before Deployment
69
Master Test Plan
Beginning of System Test
70
Test Approach
Completion of Analysis
71
Executed Test Scripts
End of System Test
72
UAT SIR Summary Report
End of UAT
73
Implementation Plan
During UAT
74
Security System Test Documentation
End of System Test

DETAIL DESIGN DELIVERABLE TABLE:

#
DETAIL DESIGN DOCUMENTS
Frequency
1.
CIM Module
Each Release -- with any major change
2.
CPT Module
Each Release -- with any major change
3.
End Dates Batch Module
Each Release -- with any major change
4.
OWMS Module
Each Release -- with any major change
5.
RIV Calc Module
Each Release -- with any major change
6.
SPR Interface Module
Each Release -- with any major change
7.
Stats Reporting Module
Each Release -- with any major change
8.
IPT Module
Each Release -- with any major change
9.
RLS
Each Release -- with any major change
10.
SDC Module
Each Release -- with any major change
11.
Solids CPT Module
Each Release -- with any major change
12.
SQR and Industry Reports
Each Release -- with any major change
13.
BI Accounts Receivable
Each Release -- with any major change
14.
BI Accounts Payable
Each Release -- with any major change
15.
BI OMT
Each Release -- with any major change
16.
BI Production
Each Release -- with any major change
17.
BI Reference
Each Release -- with any major change
18.
BI Royalty
Each Release -- with any major change
19.
BI 00Solids
Each Release -- with any major change
20.
MART Homepage
Each Release -- with any major change
21.
Accounts Payable Module Parts 1, 2 & 3
Each Release -- with any major change
22.
Accounts Receivable Module Parts 1 & 2
Each Release -- with any major change
23.
Appeals Module
Each Release -- with any major change
24.
CAB Module
Each Release -- with any major change
25.
Customer Pages Module
Each Release -- with any major change
26.
CMP Reporting Module
Each Release -- with any major change
27.
Debt Collection User Training Guide
Each Release -- with any major change
28.
eCommerce Module
Each Release -- with any major change
29.
EP Billing Module
Each Release -- with any major change
30.
eSoA Module
Each Release -- with any major change
31.
Form 4444
Each Release -- with any major change
32.
General Ledger Module
Each Release -- with any major change
33.
Interest Workbench
Each Release -- with any major change
34.
Lease Account Balances
Each Release -- with any major change
35.
ORPS Module
Each Release -- with any major change
36.
PeopleSoft Archiving Process
Each Release -- with any major change
37.
Production Module
Each Release -- with any major change
38.
Reference Module
Each Release -- with any major change
39.
Royalty Reporting Module
Each Release -- with any major change
40.
Solids PR Module
Each Release -- with any major change
41.
TROR
Each Release -- with any major change
42.
Upload Download Module
Each Release -- with any major change
43.
OMT Parts 1 & 2
Each Release -- with any major change
44.
Shareplex
Each Release -- with any major change
45.
Security
Each Release -- with any major change
46.
WorkLoad Automation Agent (Autosys)
Each Release -- with any major change

BATCH REPORT TABLE:

#
JOB NAME
DESCRIPTION
1.
PUBLISH_AR20001
Daily Deposit Control
2.
PUBLISH_AR20002
Daily Payment Detail
3.
PUBLISH_AR21001
Daily Payment Predictor Detail
4.
PUBLISH_AR21002
Daily Payment Predictor Summary
5.
PUBLISH_CON_COMPARE
IDVS BLM Contract Comparison Batch and History Report
6.
PUBLISH_EINVOICE
Publishes zip file for eInvoice process
7.
PUBLISH_FIN2001
FIN 2001
8.
PUBLISH_FIN2001_WKND
FIN 2001 WKND
9.
PUBLISH_FLUID_DISCREP
IDVS Fluid Discrepancy Report
10.
PUBLISH_GLS7011
Journal Edit Error Report
11.
PUBLISH_GLS7011_WKND
Journal Edit Error Report
12.
PUBLISH_MISSING_LEASE
IDVS Missing Leases Report
13.
PUBLISH_MISSING_SOLID_LEASE
IDVS Missing Solid Lease Report
14.
PUBLISH_OIDVS_ERR_csv
OIDVS Discrepancy Report
15.
PUBLISH_OIDVS_ERR_spf
OIDVS Discrepancy Report
16.
PUBLISH_OIDVS_HIST_csv
OIDVS TIMS Contract Comparison Batch and History Report
17.
PUBLISH_OIDVS_HIST_spf
OIDVS TIMS Contract Comparison Batch and History Report
18.
PUBLISH_OIDVS_MISS_csv
OIDVS Missing Leases Report
19.
PUBLISH_OIDVS_MISS_spf
OIDVS Missing Leases Report
20.
PUBLISH_SOLID_DISCREP
IDVS Solid Discrepancy Report
21.
PUBLISH_UNRES_SOLID_DISCREP
IDVS History of Unresolved Discrepancy Report
22.
PUBLISH_UNRES_SOLID_DISC_BURST
IDVS History of Unresolved Discrepancy Report Bursted
23.
PUBLISH_ZAPINDTC
Indian Tribal Collections Report
24.
PUBLISH_ZAPINDTC_BURST
Indian Tribal Collections Report
25.
PUBLISH_ZAR7002
Generate Receivables - 2014 Royalty
26.
PUBLISH_ZAROPAY
Open Payments Report
27.
PUBLISH_ZAROPAY_FED
Open Payments Report - FED
28.
PUBLISH_ZAROPAY_IND
Open Payments Report - IND
29.
PUBLISH_ZBSYSASS
Billing System Assurance Report
30.
PUBLISH_ZDF400R1
STATE EOP Unbursted
31.
PUBLISH_ZDF400R1_BURSTED
STATE EOP Unbursted
32.
PUBLISH_ZDF400R1_BURSTED_PDF
STATE EOP Unbursted - PDF
33.
PUBLISH_ZDF400R2
STATE EOP Unbursted
34.
PUBLISH_ZDF400R2_BURST
STATE EOP Unbursted
35.
PUBLISH_ZDF400R2_BURST_PDF
STATE EOP Unbursted - PDF
36.
PUBLISH_ZDF416R1
EOP - County Summary
37.
PUBLISH_ZDF416R1_BURSTED
EOP - County Summary bursted
38.
PUBLISH_ZDF430R1
EOP - Dist/St/Cnty
39.
PUBLISH_ZDF430R1_BURSTED
EOP - Dist/St/Cnty bursted
40.
PUBLISH_ZDF440R1
Federal zdf440r1
41.
PUBLISH_ZDF600R1
Federal zdf600r1
42.
PUBLISH_ZDF610R1
Federal zdf600r1
43.
PUBLISH_ZDF615R1
Federal Disb. Sum by Dist Acc.
44.
PUBLISH_ZDF615R1_EOP
Generate Federal Disbursement Sum by Distributee
45.
PUBLISH_ZDF615R1_WKND
Federal Disb. Sum by Dist Acc.
46.
PUBLISH_ZDFBKUP8
SAS State/County Product Summary (807,809,815,823)
47.
PUBLISH_ZDFSDFLT
Forest Service File job
48.
PUBLISH_ZDI510R1
Indian Payables Preliminary Reconciliation
49.
PUBLISH_ZDI520R1
Indian D and D Job 6 (RPT)
50.
PUBLISH_ZDI530R1
Indian D and D Job 5 (RPT)
51.
PUBLISH_ZDI530R1_BURST
Indian D and D Job 4 (RPT)
52.
PUBLISH_ZDI530R2
Indian D and D Job 3 (RPT)
53.
PUBLISH_ZDI560R1
EOP Tribal Payment Method 2 Detail
54.
PUBLISH_ZDI560R2
EOP Tribal Payment Method 2 Summary
55.
PUBLISH_ZDI610R1
Indian D and D Job 5 (RPT)
56.
PUBLISH_ZDSYSASS
AP System Assurance Report
57.
PUBLISH_ZEPIFRPT_WEEKEND
Inspection Fee Report
58.
PUBLISH_ZEPIFUPL_WEEKEND
Inspection Fee Upload Report
59.
PUBLISH_ZEPIOR
IOR Report
60.
PUBLISH_ZEPIOR_WEEKEND
IOR Report Weekend
61.
PUBLISH_ZFANLUPD
Analyst Document Updates Monthly Summary
62.
PUBLISH_ZFCONWRN
Contract Warning Report
63.
PUBLISH_ZFFMPCON
FMP Confirmation Report
64.
PUBLISH_ZFFMPCON_BURSTED
FMP Confirmation Report Bursted
65.
PUBLISH_ZFFMPSYS
FMP System Assurance Report
66.
PUBLISH_ZFPRVOBL
Missing Obligations Systems Assurance
67.
PUBLISH_ZFRWCUST
ROW/RUE Customer Address Report
68.
PUBLISH_ZFSUBASU
Land Class and Lease to Agre Subdivisions Systems Assurance
69.
PUBLISH_ZFWELLCF
Well Confirmation Report
70.
PUBLISH_ZFWELLCF_BURSTED
Well Confirmation Report Bursted
71.
PUBLISH_ZGDLYACT
GL Daily Activity Report
72.
PUBLISH_ZGDLYACT_WKND
GL Daily Activity Report
73.
PUBLISH_ZGLAPASS
GL Assurance AP Report IND
74.
PUBLISH_ZGLARASS
GL Assurance AR Report IND
75.
PUBLISH_ZGLARASS_WKND
GL Assurance AR Report IND
76.
PUBLISH_ZLESTACT
Monthly Detail Estimate Activity Report
77.
PUBLISH_ZLESTACT_UNBURSTED
Monthly Detail Estimate Activity Report
78.
PUBLISH_ZLESTBAL
LAB Payor Balance Report
79.
PUBLISH_ZLESTBAL_UNBURSTED
LAB Payor Balance Report
80.
PUBLISH_ZPAGESUM
Management Aging Summary Report by Doc Type
81.
PUBLISH_ZPBATSUM
OGOR Daily Batch Summary
82.
PUBLISH_ZPBIARPT
OGOR to BIA - Create Report
83.
PUBLISH_ZPCNFOGR
OGOR Confirmation Report
84.
PUBLISH_ZPCNFOGR_BURSTED
OGOR Confirmation Report Bursted
85.
PUBLISH_ZPCNFPSR
PASR Confirmation Report
86.
PUBLISH_ZPCNFPSR_BURSTED
PASR Confirmation Report Bursted
87.
PUBLISH_ZPERRSTA
Production Monthly Error Statistics
88.
PUBLISH_ZPMISOPR
Missing Exception Operator Report
89.
PUBLISH_ZPMISOPR_BURSTED
Missing Exception Operator Report Bursted
90.
PUBLISH_ZPOGRLST
OGOR load stat
91.
PUBLISH_ZPOGROCC
OGOR Monthly Error Occurrence Report
92.
PUBLISH_ZPPSROCC
PASR Monthly Error Occurrence Report
93.
PUBLISH_ZPSTATS
Production Operator Reporting Statistics
94.
PUBLISH_ZPSYSASS
Production / Royalty System Assurance Report
95.
PUBLISH_ZPWORKLD
Production Operator Reporting Statistics
96.
PUBLISH_ZRBATSUM
2014 Daily Batch Summary
97.
PUBLISH_ZRCNFRPT
Royalty Confirmation Report
98.
PUBLISH_ZRCNFRPT_BURSTED
Royalty Confirmation Report Bursted
99.
PUBLISH_ZRDELORP
Royalty Delete Orphan Header Report
100.
PUBLISH_ZRDOCANL
2014 Suspended Documents
101.
PUBLISH_ZRMOBSUM
2014 Monthly Batch Summary
102.
PUBLISH_ZRREFERR
Reference Related Royalty Errors
103.
PUBLISH_ZRROYOCC
Payor Monthly Error Occurrence
104.
PUBLISH_ZRSTATS
2014 Payor Reporting Stats
105.
PUBLISH_ZTERMBAT
Terminator Batch
106.
PUBLISH_ZVSYSASS
Royalty / AR System Assurance Report
107.
PUBLISH_ZYTELEFAX
ZYTELEFAX
108.
PUBLISH_AP_ADJ_CHG_RPT
AP Adjustments Change Report
109.
PUBLISH_AP_ADJ_SUMM_RPT
AP Adjustments Summary Report
110.
PUBLISH_AP_THRESHOLD_RPT
AP Threholds Report
111.
PUBLISH_FED_AP_ADJ_LDI_RPT
AP Adjustments LDI Report
112.
PUBLISH_FED_LEASE_CORR_RPT
AP Lease Corrections Report
113.
PUBLISH_INSPFEE_ENC_UNBURST
Inspection Fees Enclosures Report
114.
PUBLISH_INV_LSE_RPT
Invalid Lease Report
115.
PUBLISH_ZFQIASRN
Quarterly Invalid Lease Report
116.
PUBLISH_IPAC_BIA
IPAC BIA Report
117.
PUBLISH_IPAC_BLM
IPAC BLM Report
118.
PUBLISH_IPAC_BOEM
IPAC BOEM Report
119.
PUBLISH_IPAC_BOR
IPAC BOR Report
120.
PUBLISH_IPAC_BSEE
IPAC BSEE Report
121.
PUBLISH_IPAC_CONTROL
IPAC CONTROL Report
122.
PUBLISH_IPAC_EPA
IPAC EPA Report
123.
PUBLISH_IPAC_FINAL
IPAC FINAL Report
124.
PUBLISH_IPAC_FOREST_SERVICE
IPAC FOREST SERVICE Report
125.
PUBLISH_IPAC_FWS
IPAC FWS Report
126.
PUBLISH_OST_BURSTED
OST Bursted
127.
PUBLISH_PND_LSE_RPT
Pending Lease Report
128.
PUBLISH_ZAPOSTR1
OSTR1 Report
129.
PUBLISH_ZAPOSTR3
OSTR3 Report
130.
PUBLISH_ZAPOSTR5
OSTR5 Report
131.
PUBLISH_ZAPOSTR6
OSTR6 Report
132.
PUBLISH_ZARSTACL
Stats for Clearing Report
133.
PUBLISH_ZARSTAHD
Stats for Hold Report
134.
PUBLISH_ZDCAGRPT
Debt Collection Aging Report
135.
PUBLISH_ZDCMETOB
Debt Collection Met Obligations Report
136.
PUBLISH_ZDCMHSM
Debt Collection Management Hold Summary Report
137.
PUBLISH_ZEPARC35
ARC 35 Interest Report
138.
PUBLISH_ZEPCMPFL
Compliance Data File
139.
PUBLISH_ZEPDWSTS
Interest Workbench Download Statistics Report
140.
PUBLISH_ZEPESNOR
Interest Estimates Exceeding Limit for Non-Reporting Report
141.
PUBLISH_ZEPFSTAL
Federal Statute of Limitations Report
142.
PUBLISH_ZEPNSTLS
Non Standard Leases Report
143.
PUBLISH_ZEPOPNIN
Open Invoices Report
144.
PUBLISH_ZEPPBNST
Prebills for Non Standard Leases Report
145.
PUBLISH_ZEPIBRCH
Interest Business Rules Change Report
146.
PUBLISH_ZEPINTDL
Daily Late Payment Interest Report
147.
PUBLISH_ZEPINTSL
Interest Summary Report
148.
PUBLISH_ZEPINVDF
Invoice Difference Report
149.
PUBLISH_ZEPNGBAL
Negative Estimate Balance Report
150.
PUBLISH_ZEPPREDF
Prebill Difference Report
151.
PUBLISH_ZEPSTASD
Prebill Set Aside Report
152.
PUBLISH_ZFRORUER
ROW RUE Error Report
153. p
PUBLISH_ZINTSCH_DAILYLP
Daily Late Payment Interest Exception Report
154.
PUBLISH_ZINTSCH_SENTPS
Sent to PS Interest Exception Report

EMAIL NOTIFICATIONS TABLE

#
Notification
Frequency

PRODUCTION

1.
Batch synopsis
Daily
2.
ARUPDATE
Every Half Hour Daily (7:00 to 5:00pm)
3.
ARUPLATE1_INFO
Daily
4.
ARUPLATE_MT_INFO
Daily
5.
ARUPLATE_MT2_INFO
Daily
6.
Payment_Predictor_Report
Daily
7.
Daily Solids Synopsis Report PROD
Daily
8.
Updated_Bills_YYYYMMDD
Daily
9.
Daily_Data_Load_Summary
Daily (twice a day)
10.
OGOR Staging Counts For YYYYMMDD
Daily
11.
PROD Missing Billing Specialist YYYYMMDD
Weekly on Monday’s
12.
Records in ZAR_ORPS_STG Have not Reconciled
Daily
13.
Production eCommerce ORPS Report Daily Email
Daily
14.
Production eCommerce ORPS Report Monthly Email
Monthly
15.
Monthly Royalty Validation – MMYYYY
Monthly
16.
PeopleSoft After Hours Access Log
Daily
17.
PAYMENT_POST_COMPLETE
Monthly
18.
VOUCHER_FED_Succeeded
Monthly

UAT

19.
DOIUAT: Users
Daily
20.
UAT Batch Synopsis
Daily
21.
ARUPDATE
Daily

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-05

NON-CRITICAL BATCH RUNS FOR MRMSS

NON-CRITICAL BATCH RUNS FOR MRMSS

#
Area
Module
Batch Name
Batch Description
Frequency
1.
DW
OMT
OMT_DATA_MINING
Populate DM exception and Work management data
Daily
2.
DW
OMT
OMT_DATA_MINING_REFRESH
Refresh the omt_wrk_mgmt_dm_mv materialized view to reflect the changes on DM and Work management
Daily
3.
FM
Billing
BILLING_SPEC_FW
Billing Specialist file watcher
Daily
4.
FM
Billing
BILLING_SPEC_UPLD
Billing Specialist Upload Batch
Daily
5.
FM
Billing
BILLING_SPEC_ARCH
Billing Specialist file archive
Daily
6.
FM
Billing
BILLING_UPDATE_LAST_RUN
Counts Lines in Billing
Daily
7.
FM
Billing
BILLS_COUNT
Count and generate email for updated bills
Daily
8.
FM
Billing
INT_REPORT_POST_BILL
Interest Report Post Billing
Daily
9.
FM
Billing
BILL_SPEC_TITLE_POST
Billing Specialist Title Page
Daily
10.
FM
Billing
IBR_APP_CHG_RPT
IBR Application Changes Report
Daily
11.
FM
Billing
EINVOICE_ZIPPACK
Generates zip file for eInvoice publishing
Daily
12.
FM
Billing
PRINT_INV_PKG
Print Invoice Package
Daily
13.
FM
Billing
FW_ARCHINV_I
Watch for previous day's I-* file
Daily
14.
FM
Billing
FW_ARCHINV_F
Watch for previous day's F-* file
Daily
15.
FM
Billing
ARCHINV
Archive Printable Invoices
Daily
16.
FM
Royalty
ECOMM_DATAPURGE
eCommerce Data Purge
Daily
17.
FM
Royalty
ECOMMERCE_CMP_DATAPURGING
Purge eCommerce CMP Tables
Daily
18.
FM
Reference
BLM_MISS_RPT
BLM Missing Report
Weekly
19.
FM
AR
UPDATE_PY_LBX_SQL
Update data source from ONL to LBX payments
Daily
20.
FM
Billing
DAILY_INT_LP
Daily Late Payment Interest
Daily
21.
FM
Billing
WB_EXCEP_RPT_DAILYLP
Workbench Interest Exception Report - Nightly for Daily LP
Daily
22.
FM
Billing
WB_EXCEP_RPT_SENTPS
Workbench Interest Exception Report - Nightly for Daily LP
Daily
23.
FM
Billing
WB_INV_ADJ_DIFF_RPT
Workbench Invoice Adjustment Differences Report
Daily
24.
FM
Billing
WB_PBIL_DIFF_RPT
Workbench Prebill Differences Report
Daily
25.
FM
Billing
WB_DWNLD_STATS_RPT
Workbench Download Status Report
Daily
26.
FM
AR
PS_PGG_SERV_TAO_COUNTER_RESET
Resets the counter in PS_PGG_SERVICE_TAO to 1
Daily
27.
FM
Royalty
2014BSUM
2014 Daily Batch Summary
Daily
28.
FM
Royalty
REFROYERR
Reference Releated Royalty Errors
Daily
29.
FM
Royalty
ECOMM_LESS_ALL_CNT1
eComm RVLA Job
Daily
30.
FM
Royalty
ECOMM_LESS_ALL
eComm RVLA Job
Daily
31.
FM
Royalty
ECOMM_LESS_ALL_CNT2
eComm RVLA Job
Daily
32.
FM
AR
AR_INV_ENTRY_RSN
Populate Missing Billing Entry Reason Script
Daily
33.
FM
AR
CURDATE
Get CURDATE
Daily
34.
FM
AR
ARUPLATE1_RUN_TIME
SQL Aruplate1 Run Time
Daily
35.
FM
AR
FED_PP_RUN_TIME
SQL Fed Payment Predictor Run Time
Daily
36.
FM
AR
IND_PP_RUN_TIME
SQL Indian Payment Predictor Run Time
Daily
37.
FM
AR
ARUPLATE2_RUN_TIME
SQL ARUplate2 Run Time
Daily
38.
FM
AR
FED_PP2_RUN_TIME
SQL Fed Payment Predictor2 Run Time
Daily
39.
FM
AR
ARUPLATE3_RUN_TIME
SQL Aruplate3 Run Time
Daily
40.
FM
AR
ARUPDATE_WKND_RUN_TIME
SQL Aruplate Weekend Run Time
Daily
41.
FM
AR
PP_RPT_FED_LEA
SQL Aruplate Fed Payment Predictor - LEA
Daily
42.
FM
AR
PP_RPT_FED_ROY
SQL Aruplate Fed Payment Predictor - ROY
Daily
43.
FM
AR
AUTOSYS_AR_PP_RPT
SQL Autosys Exception Report
Daily
44.
FM
Batch
Nightly_Batch_Alarm_Monitor
Monitors the status of the Nightly_Batch Alarms
Daily
45.
FM
Batch
Nightly_Batch_Alarm_Mon_Late
Monitors the status of the Nightly_Batch Alarms
Daily
46.
FM
Batch
Alert_NightlyWrapup_Done
Call re: start of the NightlyWrapup
Daily
47.
DW
REFRESH_DESIG_AREA_GROUP
DWRF_GRP_HDR refresh in CAMP
Daily
48.
DW
IBMP_Calc
Performs a calculation based off of the 2014 data
Daily
49.
OBI
Mview
NB_OBI_MVIEW_REFRESH
OBIE materialized views and stats. Runs at the end of batch.
Daily
50.
OBI
Mview
MVIEW_OBI_REFERENCE
Materialized view refresh for the Reference (Group 3) sql statements.
Daily
51.
OBI
Mview
MVIEW_OBI_PRODUCTION
Materialized view refresh for the Production sql statement.
Daily
52.
OBI
Mview
MVIEW_OBI_ACCTSPAY
Materialized view refresh for the Accounts Payable sql statements.
Daily
53.
OBI
Mview
MVIEW_OBI_OMT
Materialized view refresh for OBI OMT
Daily
54.
OBI
Mview
NB_OBI_MVIEW_ROYALTY
Materialized view refresh for the OBIE royalty jobs including ZRY_ROY_REVN_MV, REA_MV and ZRY_ROY_AGREE_NBR_MV
Daily
55.
OBI
Mview
MVIEW_OBI_ROY_REVN
Materialized view refresh for ZRY_ROY_REVN_MV
Daily
56.
OBI
Mview
OMT_OBI_TASK_MV
Populate date for the OBI Task mview
Daily
57.
OBI
Mview
MVIEW_OBI_ROY_REA
Materialized view refresh for ZRY_ROY_AGREE_NBR_MV and OBICUST_REA_MV
Daily
58.
FM
Batch
JOB_DURATION
Run Job duration Script
Daily
59.
FM
Batch
JOB_FAILURES
Run Job failures Script
Daily
60.
FM
Batch
MOVE_STATS
Move stat files to daily folder
Daily
61.
FM
Debt
IDENTIFY_MET_OBLIGS
Identify Met Financial Obligations Report
Daily
62.
FM
Debt
INSTALL_AGMT_MON
Installment Agreement Monitor Report
Daily
63.
FM
Debt
MET_OBLIG_SUCCESS
Sets NB_DEBT_REPORTS box to successful without running IDENTIFY_MET_OBLIGS
Daily
64.
FM
Debt
INSTALL_DFLT_RPT
Installment Default Report
Daily
65.
FM
AP
INDPAYRECBD
Indian Payables Preliminary Reconciliation
3 times per week
66.
FM
AP
NETNEGDTLRPT
Net Negative Lease Detail Report
3 times per week
67.
FM
AR
PAYPREWF
Payment Predictor Workflow
Daily
68.
FM
AR
SLACCTBAL
Solids Lease
Daily
69.
FM
AR
LEAACTBAL
Lease Account Balance
Daily
70.
FM
Debt
ARCNDMON_RC
Script to update the Receivables Condition Monitor Run Control with current date
Daily
71.
FM
Debt
ARCNDMON
Receivables Condition Monitor
Daily
72.
FM
Solids
IND_SOLIDS_DAILY_REPORT
Indian Daily Breakdown and Totals
Daily
73.
FM
Solids
IND_SOLIDS_MONTHLY_REPORT
Indian Monthly Breakdown and Totals
Daily
74.
FM
Solids
IND_SOLIDS_YEARLY_REPORT
Indian Yearly Breakdown and Totals
Daily
75.
FM
Solids
FED_SOLIDS_DAILY_REPORT
Federal Daily Breakdown and Totals
Daily
76.
FM
Solids
FED_SOLIDS_MONTHLY_REPORT
Federal Monthly Breakdown and Totals
Daily
77.
FM
Solids
FED_SOLIDS_YEARLY_REPORT
Federal Yearly Breakdown and Totals
Daily
78.
FM
AR
AR20001F
Daily Deposit Control - Federal
Daily
79.
FM
AR
AR20002F
Daily Payment Detail - Federal
Daily
80.
FM
AR
AR21001F
Daily Payment Predictor Detail - Federal
Daily
81.
FM
AR
AR21002F
Daily Payment Predictor Summary - Federal
Daily
82.
FM
AR
AR20001I
Daily Deposit Control - Indian
Daily
83.
FM
AR
AR20002I
Daily Payment Detail - Indian
Daily
84.
FM
AR
AR21001I
Daily Payment Predictor Detail - Indian
Daily
85.
FM
AR
AR21002I
Daily Payment Predictor Summary - Indian
Daily
86.
DW
Royalty
HISTDB2014ACCPTDTL
History Database 2014 Accepted Detail Update
Daily
87.
DW
AP
HISTDBAPNIGHTLY
History Database AP Nightly Update
Daily
88.
FM
AR
NB_HOLD_CODE
Item Hold Code
Daily
89.
FM
GL
JRNL_GL_ASSURANCE_AP_FED
GL Assurance AP report Fed
Daily
90.
FM
GL
JRNL_GL_ASSURANCE_AP_IND
GL Assurance AP report Ind
Daily
91.
FM
GL
GL_DAILY_ACT_RPT
GL Daily Activity Report
Daily
92.
FM
GL
GL_DAILY_ACT_RPT_IND
GL Daily Activity Report IND
Daily
93.
FM
GL
JRNL_ENTRY_DTL_RPT
Jrnl Entry Detail Report
Daily
94.
FM
GL
FIN2001_FED
FIN2001 AP, AR, ONL FED
Daily
95.
FM
GL
FIN2001_IND
FIN2001 AP, AR, ONL IND
Daily
96.
FM
AR
ROY_AR_SYSTEM_ASSURANCE
Royalty / AR System Assurance Report
Daily
97.
FM
GL
JRNLEDITERR
Journal Edit Error Report
Daily
98.
FM
Reference
DELINACON
Delete Inactive Contracts
Daily
99.
DW
Mview
cmp_cust_id_mv_refresh
Cust ID Materialized View Refresh
Daily
100.
DW
Royalty
cmp_2014_update
2014 Update
Daily
101.
DW
Royalty
cmp_post_actuals_2014
Post Actuals 2014
Daily
102.
DW
Solids
cmp_post_actuals_solids
Post Actuals Solids
Daily
103.
DW
cmp_roll_in_adjustments
Roll in Adjustments
Daily
104.
DW
DWCP_CHECK_ADJ
cmp_check_adj
Daily
105.
FM
AP
FED_AP_ADJ_CHG_RPT
AP Adjustment Change Report
3 times per month
106.
FM
AP
FED_AP_ADJ_SUMM_RPT
AP Adjustment Summary Report
3 times per month
107.
FM
AP
FED_AP_ADJ_LDI_RPT
AP Adjustment Summary Report
3 times per month
108.
FM
AP
FED_THRESHOLD_RPT
Threshold Monitoring Report
3 times per month
109.
FM
AP
FED_LEASE_CORR_RPT
Federal Lease Correction RPT
3 times per month
110.
FM
AP
FEDDISBDISTA
Federal Disb. Sum by Dist Acc.
3 times per month
111.
FM
AP
FED_AP_ADJ_SCRIPT
FED AP Adjustment Run Control Script
3 times per month
112.
FM
AP
ANALYZE2_PS_ZAP_PDL_TEMP2
Analyze sysadm.ps_zap_pdl_temp2 script
3 times per month
113.
FM
AP
STATE_EOP_ZDF400R1_BURST
Generate STATE EOP Bursted
Monthly
114.
FM
AP
FED_EOP_ZDF400R2
EOP - Geothermal County D&D
Monthly
115.
FM
AP
FED_EOP_ZDF400R2_BURST
Geothermal County Bursted
Monthly
116.
FM
AP
FEDDISBDISTR
Federal Disb. Sum by Distrib.
Monthly
117.
FM
AP
FED_DISBDISTA
Generate Federal Disbursement Sum by Distributee
Monthly
118.
FM
AP
FED_EOP_ZDF600R1
Generate Federal zdf600r1
Monthly
119.
FM
AP
FED_EOP_ZDF440R1
Generate Federal zdf440r1
Monthly
120.
FM
AP
SAS_BACKUPRPT
SAS State/County Product Summary (807,809,815,823)
Monthly
121.
FM
AP
STATE_EOP_ZDF400R1_UNBURST
Generate STATE EOP Unbursted
Monthly
122.
FM
AP
ZDF430R1
EOP - Dist/St/Cnty
Monthly
123.
FM
AP
ZDF416R1
EOP - County Summary
Monthly
124.
FM
AP
ZDF430R1_BURSTED
EOP - Dist/St/Cnty bursted
Monthly
125.
FM
AP
ZDF416R1_BURSTED
EOP - County Summary bursted
Monthly
126.
FM
AR
TROR_DATA_RETRIEVAL_1
Retrieves data for TROR
Monthly
127.
FM
AR
TROR_DATA_RETRIEVAL_2_3
Retrieves data for TROR
Monthly
128.
FM
GL
GL_OPEN_PAYMENTS_RPT
Open Payments Report
Monthly
129.
FM
Reference
ZFRORUER
ZFRORUER
Monthly
130.
FM
Reference
ROWRUECUS
ROW/RUE Customer Address Report
Monthly
131.
FM
Debt
DEBT_AGING
Debt Collection Aging Report
Monthly
132.
FM
Debt
MGMNT_HOLD_SUMM
Management Hold Summary Report
Monthly
133.
FM
Royalty
2014_STG_CNT
2014 Staging Counts (Before Update)
Monthly
134.
FM
Royalty
2014_VAL_FLAG_UPD
2014 Validation Flag Update
Monthly
135.
FM
Royalty
2014_VAL_FLAG_EMAIL
2014 Validation Flag Update email
Monthly
136.
FM
AP
ZAPOSTR1
SF1081 to OST Comparison by Deposit Ticket, Dist Code & Payment ID Report
Quarterly
137.
FM
AP
ZAPOSTR3
Reconciliation by Deposit Ticket Summary Report
Quarterly
138.
FM
AP
ZAPOSTR5
Reconciliation Accomplishments Report
Quarterly
139.
FM
AP
ZAPOSTR6
Missing SF1081 Data Report
Quarterly
140.
FM
Reference
QUART_INV_CON_SCRIPT
FED Quarterly Invalid Contracts Rpt Script
Quarterly
141.
FM
Reference
QUART_INV_CONTRACTS
Reference Quarterly Invalid Contracts Rpt
Quarterly
142.
FM
Reference
INV_LSE_RPT
Invalid Lease Report
Quarterly
143.
DW
OMT
OMT_ADD_BASIN_VWASP_UNIT_PRICE
Populate EMAO Data into unit price table
Daily
144.
FM
AR
ZARSTACL_FED_OG
Federal O&G Stats for Clearing Report
Quarterly
145.
FM
AR
ZARSTACL_IND_OG
Indian O&G Stats for Clearing Report
Quarterly
146.
FM
AR
ZARSTACL_FED_SOLIDS
Federal Solids Stats for Clearing Report
Quarterly
147.
FM
AR
ZARSTACL_IND_SOLIDS
Indian Solids Stats for Clearing Report
Quarterly
148.
FM
AR
ZARSTACL_FED_RIK
RIK Stats for Clearing Report
Quarterly
149.
FM
AR
ZARSTAHD_FED_OG
Federal O&G Hold Report
Quarterly
150.
FM
AR
ZARSTAHD_IND_OG
Indian O&G Hold Report
Quarterly
151.
FM
AR
ZARSTAHD_FED_SO
Federal Solids Hold Report
Quarterly
152.
FM
AR
ZARSTAHD_IND_SO
Indian Solids Hold Report
Quarterly
153.
FM
Royalty
RMONCONF_WEEKEND
Royalty Confirmation Report
Weekly
154.
FM
AR
NET_AR
Net Accounts Receivable
Weekly
155.
FM
AR
NET_ARUpdate
Net AR's ARUpdate
Weekly
156.
FM
GL
GL_DAILY_ACT_RPT_WKND
GL Daily Activity Report
Weekly
157.
FM
GL
GL_DAILY_ACT_RPT_IND_WKND
GL Daily Activity Report
Weekly
158.
FM
GL
JRNL_GL_ASSURANCE_AR_FED_WKND
GL Assurance AR Report FED
Weekly
159.
FM
GL
JRNL_GL_ASSURANCE_AR_IND_WKND
GL Assurance AR Report IND
Weekly
160.
FM
GL
JRNLEDITERR_WKND
Journal Edit Error Report
Weekly
161.
FM
GL
FIN2001_IND_WKND
FIN2001 AP, AR, ONL IND
Weekly
162.
FM
GL
FIN2001_FED_WKND
FIN2001 AP, AR, ONL FED
Weekly
163.
FM
Reference
PND_LSE_RPT
Pending Lease Report
Monthly
164.
FM
AP
INDPM02SUM
EOP Tribal Payment Method 2 Summary
Monthly
165.
FM
AP
INDPM02DTL
EOP Tribal Payment Method 2 Detail
Monthly
166.
FM
Billing
BILLING_SYSTEM_ASSURANCE_RPT
Billing System Assurance Report
Monthly
167.
FM
AP
ZDI620R1
Cum Schedule of Dist and Payment Info
Monthly
168.
FM
Billing
COMPLIANCE_DATA_FILE
Compliance Data File
Monthly
169.
FM
Reference
PENDING_CON_SCRIPT
Monthly Invalid Contracts Rpt Script
Monthly
170.
FM
Reference
PEND_CONTRACTS_RPT
Reference Pending Lease Report
Monthly
171.
FM
Reference
CONTWARN
Contract Warning Report
Monthly
172.
FM
Reference
WELLCONF
Well Confirmation Report
Monthly
173.
FM
Production
OGOR_MISS_EXC
OGOR Missing Exception Report
Monthly
174.
FM
Production
OGOR_MONTHLY_ERR_OCC
OGOR Montly Error Occurrence Report
Monthly
175.
FM
Production
ZPSTATS
Production Operator Reporting Statistics
Monthly
176.
FM
Production
ZPAGESUM
Management Aging Summary Report by Doc Type
Monthly
177.
FM
Production
PASR_MONTHLY_ERROR_OCC
PASR Monthly Error Occurrence Report
Monthly
178.
FM
Production
PASR_MISS_EXC
PASR Missing Exception Batch
Monthly
179.
FM
Production
ZPWORKLD
Production Workload Report
Monthly
180.
FM
Production
ZPOGRLST
OGOR Load Stat
Monthly
181.
FM
Production
ZPSYSASS
Production / Royalty System Assurance Report
Monthly
182.
FM
Production
EXC_OPER_REP_MISS
Missing Exception Operator Report
Monthly
183.
FM
Reference
FMPCONFRPT
FMP Confirmation Report
Monthly
184.
FM
Reference
FMPSYSASS
FMP System Assurance Report
Monthly
185.
FM
Reference
ZFPRVOBL
Missing Obligations Systems Assurance
Monthly
186.
FM
Reference
ZFSUBASU
Land Class and Lease to Agree Subdivisions Systems Assurance
Monthly
187.
FM
Royalty
ZRDELORP
Royalty Delete Orphan Header Report
Monthly
188.
FM
Royalty
ZFANLUPD
Analyst Document Updates Monthly Summary
Monthly
189.
FM
Royalty
2014SUSDOC
2014 Suspended Documents
Monthly
190.
FM
Royalty
ZRSTATS
2014 Payor Reporting Stats
Monthly
191.
FM
Royalty
2014MSUM
2014 Monthly Batch Summary
Monthly
192.
FM
Royalty
2014ERROCC
Payor Monthly Error Occurrence
Monthly
193.
FM
AP
ZAPINDTC
Indian Tribal Collections Report
Monthly
194.
FM
AP
BURST_ZAPINDTC
Indian Tribal Collections Report
Monthly
195.
FM
LAB
ZLESTACT_UNBURSTED
Monthly Detail Estimate Activity Report
Monthly
196.
FM
LAB
ZLESTBAL_UNBURSTED
LAB Payor Balance Report
Monthly
197.
FM
LAB
ZDSYSASS
AP System Assurance Report
Monthly
198.
FM
LAB
LEAACTBAL_WKND
Lease Account Balance
Monthly
199.
FM
Billing
PBIL_SET_ASIDE_RPT
Prebill Set Aside Report
Monthly
200.
FM
Billing
INT_NEW_STAT_PND
Run script to isolate bankrupt payors
Monthly
201.
FM
Billing
MONTHLY_INTEREST_REPORT_INT2
Interest Report
Monthly
202.
FM
Billing
ARCHIVE_PREBILL_RPTS
Print Prebill Package
Monthly
203.
FM
Billing
BILL_SPEC_TITLE_PRE
Billing Specialist Title Page - Prebill
Monthly
204.
FM
Billing
PREV_BILLED_DOC_RPT
Previously Billed Documents Report
Monthly
205.
FM
Billing
PBIL_NSTD_LEASE_RPT
Listing of Prebills with Nonstandard Leases Report
Monthly
206.
FM
Billing
NSTD_LEASE_RPT
Listing of NonStandard Leases Report
Monthly
207.
FM
Billing
NEG_EST_BAL_RPT
Negative Estimate Balance Report
Monthly
208.
FM
Billing
FED_STATUTE_LIMIT_RPT
Federal Statute of Limitations Report
Monthly
209.
FM
Billing
INV_SUMM_RPT
Invoice Summary Report
Monthly
210.
FM
Billing
EST_EXCEED_LIMIT_RPT
Leases with Estimates Exceeding Time Limit for Non Reporting of Royalties Report
Monthly
211.
FM
Billing
PBIL_OPEN_INV_RPT
Prebill Open Inventory Listing Report
Monthly
212.
FM
Billing
GEO_CR_RVW_RPT
Geothermal Credit, Review for Int Adj Report
Monthly
213.
FM
Billing
ARC_35_REPORT
ARC 35 Interest Report
Monthly
214.
FM
LAB
ZLESTACT_BURSTED
Monthly Detail Estimate Activity Report
Monthly
215.
FM
LAB
ZLESTBAL_BURSTED
LAB Payor Balance Report
Monthly
216.
FM
Reference
LOAD_IDVS_SCRIPT
Load BLM filename script
Monthly
217.
FM
Reference
IDVS_CON_COMPARE
Contract Comparison Batch and History Report
Monthly
218.
FM
Reference
IDVS_MISSING_LEASE
Missing History Report
Monthly
219.
FM
Reference
IDVS_FLUID_DISCREP
Fluid Discrepency Report
Monthly
220.
FM
Reference
IDVS_SOLID_DISCREP
Solid Discrepency Report
Monthly
221.
FM
Reference
IDVS_MISSING_SOLID_LEASE
Missing Solid Lease Report
Monthly
222.
FM
Reference
IDVS_UNRES_SOLID_DISCREP
History of Unresolved Discrepancy Report
Monthly
223.
FM
Reference
IDVS_UNRES_SOLID_DISC_BURST
History of Unresolved Discrepancy Report Bursted
Monthly
224.
FM
Reference
ARCHIVE_IDVS_SCRIPT
Archive IDVS Script
Monthly
225.
FM
Production
OGOR_CONF_RPT2
OGOR Confirmation Report
Monthly
226.
FM
Production
PASR_CONF_RPT2
PASR Confirmation Report
Monthly
227.
FM
Reference
LOAD_OIDVS_SCRIPT
Load OEMM filename script
Monthly
228.
FM
Reference
OIDVS_CON_COMPARE
Contract Comparison Batch and History Report
Monthly
229.
FM
Reference
COPY_HIST_TO_COLD
Copies the OIDVSHIST spf files to the /DOIRPTOUTPUT/cold/ folder
Monthly
230.
FM
Reference
OIDVS_MISSING_LEASE
Missing Leases Report
Monthly
231.
FM
Reference
OIDVS_DISCREP
Discrepency Report
Monthly
232.
FM
Reference
ARCHIVE_OIDVS_SCRIPT
Archive BLM File Script
Monthly
233.
FM
Billing
INT_NEW_STAT_PND_FIN
Run script to isolate bankrupt payors
Monthly
234.
FM
Billing
FIN_NEW_STAT_PND
Run FIN Flag Script prior to FIN Term
Monthly
235.
FM
Billing
FIN_FLAG_SQL_Script
Run FIN Flag Script prior to FIN Term
Monthly
236.
FM
Billing
MONTHLY_INT_FIN_REPORT_INT2
Interest Report
Monthly
237.
FM
AP
FEDDISSBDISTA_WKND
Federal Disb. Sum by Dist.Acc
Monthly
238.
FM
AP
KUUKPIK_VOUCHER_DEL
Voucher delete scripts
Monthly
239.
FM
AP
NPRAR_GOMESAR_DEL
Delete NPRAR GOMSAR
Monthly
240.
FM
Billing
INSPECTION_FEE_REPORT
Inspection Fee Upload Report
Monthly
241.
FM
Billing
INSPFEE_ENCLOSURE_BURST
Publish zepifenc to brio
Monthly
242.
FM
Billing
INSPFEE_ENCLOSURE_UNBURST
Inspection Fee Enclosure Unbursted
Monthly
243.
FM
Billing
INSP_FEE_ARCHIVE
Inspection Fee file archive
Monthly
244.
FM
Production
OGRBIA_LOAD
OGOR to BIA - Load (Populates Temp Tables)
Monthly
245.
FM
Production
OGRBIA_RPT
OGOR to BIA - (Creates Report)
Monthly
246.
FM
Production
OGRBIA_FILE
OGOR to BIA - (Creates Flat File)
Monthly
247.
FM
Production
OGRBIA_ARCHIVE
Archives OGOR to BIA Transmission Files
Monthly
248.
FM
AP
FS_FLAT
Forest Service File job
Monthly
249.
FM
AP
NPR_A_853A_DELETE_SCRIPT
NPR Script
Monthly
250.
FM
AP
KUUKPIK_GOMESA
Gomesa Script
Monthly
251.
FM
AP
INSERT_LDI_APZ
Insert LDI
Monthly
252.
FM
AP
FED_LDI_PDL_UPDATE
PDL Update
Monthly
253.
FM
AP
GL_PAYPOST_CSH_ACCT
GL Script
Monthly
254.
FM
AP
GL_PAYPOST_RFND_DEPTID
GL Script
Monthly
255.
FM
AP
ZDI520R1
ZDI520R1
Twice per month
256.
FM
AP
ZDI530R1
ZDI530R1
Twice per month
257.
FM
AP
ZDI530R1_BURST
ZDI530R1_BURST
Twice per month
258.
FM
AP
ZDI530R2
ZDI530R2
Twice per month
259.
FM
AP
ZDI610R1
ZDI610R1
Twice per month
260.
FM
AP
GENEOPFED_FEDDISBDISTA
ZDF615R1 EOP
Monthly
261.
FM
Debt
DUNNING
Daily Dunning
Daily
262.
FM
AP
IPAC_FINAL_PROCESS
IPAC Final
Monthly
263.
FM
AP
IPAC_FINAL_MONTHLY
IPAC Final
Monthly
264.
FM
AP
IPAC_CONTROL_REPORT
IPAC Reports
Monthly
265.
FM
AP
ZYOSTHYB
OST File
Twice per month
266.
FM
AP
ZYBIACST
BIA Customer File
Twice per month

CRITICAL BATCH RUNS FOR MRMSS

CRITICAL BATCH RUNS FOR MRMSS

#
Area
Module
Batch Name
Batch Description
Frequency
267.
FM
AR
ZGLTRANSFER_NIGHT
ZGL Transfer - Identifies Pymt Application Transfers
Daily
268.
FM
AR
ORPS_RECONCILIATION_PROGRAM
ORPS Reconciliation
Daily
269.
FM
Reference
WELLPROC
Well Batch Processing
Daily
270.
FM
Reference
FMPDATPRC
FMP Batch Processing
Daily
271.
FM
Production
OGORINACT
OGOR Inactivate
Daily
272.
FM
Reference
WELLPROC2
Well Batch Processing #2
Daily
273.
FM
Production
OGORVALID
OGOR Validation
Daily
274.
FM
Production
OGORBMOV
OGOR Move
Daily
275.
FM
Production
OGORARCH
OGOR Archive
Daily
276.
FM
Production
PRDROYSTS
Production/Royalty Payor Statistics
Daily
277.
FM
Production
PASRVALID
PASR Validation
Daily
278.
FM
Production
PASRBMOV
PASR Move
Daily
279.
FM
Production
OGORSUM
Ogor Daily Batch Summary
Daily
280.
FM
Production
OMMOTRAN
OGOR Transmission to OMM
Weekly
281.
FM
Production
OMMPTRAN
PASR Transmission to OMM
Weekly
282.
FM
Production
OMMARCHIVE
Archives OMM Ogor and Pasr Transmission Files
Weekly
283.
FM
Production
BLMOTRAN
OGOR Transmission to BLM
Weekly
284.
FM
Production
BLMARCHIVE
Archives BLM OGOR Transmission Files
Weekly
285.
FM
AR
ARPAYPRE_FED_SETUP
AR Payment Predictor (FED) - Setup
Daily
286.
FM
AR
ARPAYPRE_FED
AR Payment Predictor
Daily
287.
FM
AR
ARPAYPRE_FED2_SETUP_LEA
AR Payment Predictor (FED) - Lease Setup2
Weekly
288.
FM
AR
ARPAYPRE_FED2
AR Payment Predictor (FED) #2
Weekly
289.
FM
AR
ARPAYPRE_IND_SETUP
AR Payment Predictor (IND)
Daily
290.
FM
AR
ARPAYPRE_IND
AR Payment Predictor INDIAN
Daily
291.
FM
Billing
PREPRCFIN
Preprocessing and Finalization
Daily
292.
FM
Billing
GENINVFILE
Generate Invoice Files
Daily
293.
FM
Billing
CANPMBILL
Cancel PM02 Bills
Daily
294.
FM
Billing
CURRCONV
Currency Conversion
Daily
295.
FM
Billing
LOADAR
Load Accounts Receivable
Daily
296.
FM
Production
OGORVALFLAGS2
SQL to set Ogor Value Flags to Y
Daily
297.
FM
Reference
LEASEPRC
Lease Processing
Weekly
298.
FM
Reference
BLM_CUST_FW
Watch for new BLM_CUST_LOAD file
Daily
299.
FM
Reference
BLM_CUST_FILE
BLM Customer File
Weekly
300.
FM
AR
GENRECLEA
Generate Receiveables Lease & CN
Daily
301.
FM
Production
OBR_CONTROLS_PASR
Control job for PASR Validation
Daily
302.
FM
Royalty
OBR_CONTROLS_ROYALTY
Control job for 2014 Validation
Daily
303.
FM
Production
OBR_CONTROLS_OGOR
Control job for OGOR Validation
Daily
304.
FM
Production
AE_INITIATOR_PASR
App Engine to kick of the OBR process for PASR
Daily
305.
FM
Royalty
AE_INITIATOR_ROY
App Engine to kick of the OBR process for Royalty
Daily
306.
FM
Production
AE_INITIATOR_OGOR
App Engine to kick of the OBR process for OGOR
Daily
307.
FM
AR
GENREC_ORPS
ORPS Receivable
Daily
308.
FM
Royalty
2014COMBINE
Combine 2014 Documents
Daily
309.
FM
Royalty
2014VALID
2014 Validation - COBOL
Daily
310.
FM
Royalty
2014MOVE
2014 Move
Daily
311.
FM
AR
SET_ASIDE_MTWS_SQL
Sets aside the Maitenance Worksheets
Daily
312.
FM
AR
ARUPLATE1
AR Update
Daily
313.
FM
AR
ARUPLATE2
AR Update - Late #2
Daily
314.
FM
AR
ARUPLATE3
AR Update #3
Daily
315.
FM
AR
SET_TO_POST_MT_SQL
Sets aside the Maitenance Worksheets
Daily
316.
FM
AR
ARUPLATE_MT
AR Update
Daily
317.
FM
AR
ZARMTDST
Create Accounting Entries for MT-01 Groups
Daily
318.
FM
AR
ARUPLATE_MT2
AR Update
Daily
319.
FM
AR
GENREC2014
Generate Receivables - 2014 Royalty
Daily
320.
FM
AR
GENRECPR
Generate Solids Receivables - P&R
Daily
321.
FM
AP
GENPAY_IND_SOLIDS_INFORMATICA
Set up Solids piece prior to GENPAY
3 times per week
322.
FM
AP
GENPAYABLE_I
Generate Payables for Indian Only
3 times per week
323.
FM
AP
APLABCREATE_I
Creates AP LAB lines for PDLs
3 times per week
324.
FM
AP
APPLYBRULE_I
Apply Business Rules Indian only
3 times per week
325.
FM
AR
ARLOADLAB
AR Load LAB
Daily
326.
FM
AR
ARAGING
Accts Receiveable Aging
Daily
327.
FM
Debt
DEBT_ROY_DTL
Royalty Detail Batch Job
Daily
328.
FM
GL
GL_ACCTG_SCRIPT_BEFORE
GL Acctg Script runs before Journal Generators
Daily
329.
FM
GL
Cache_Writeoff
Cache Writeoff (SIR 1462)
Daily
330.
FM
GL
SPC_Credit
SPC Credit (SIR 1470)
Daily
331.
FM
GL
Foreign_Base_Amt
Foreign Base Amt (SIR 1322)
Daily
332.
FM
GL
UPDATE_POST_DT
End of Month update post date
Monthly
333.
FM
GL
JRNLGEN1
Journal Generator 1 - Template APDEFN
Daily
334.
FM
GL
JRNLGEN2
Journal Generator 2 - Template APDEFN_ADD
Daily
335.
FM
GL
JRNLGEN3
Journal Generator 3 - Template ARDEFN
Daily
336.
FM
GL
JRNLGEN4
Journal Generator 4 - Template ARDIRJRNL
Daily
337.
FM
GL
JRNLGEN5
Journal Generator 5 - Template ARREVALUE
Daily
338.
FM
GL
JRNLGEN6
Journal Generator 6 - Template EGAPDEFN
Daily
339.
FM
GL
JRNLGEN7
Journal Generator 7 - Template EGARDJDEFN
Daily
340.
FM
GL
JRNLGEN8
Journal Generator 8 - Template EGAROIDEFN
Daily
341.
FM
GL
JRNLGEN9_RIK
Journal Generator 9 - Template RIK Accrual
Daily
342.
FM
GL
GL_ACCTG_SCRIPT_AFTER
GL Acctg Script runs after Journal Generators
Daily
343.
FM
GL
JRNLEDIT_AR
Journal Edit - AR
Daily
344.
FM
GL
JRNLPOST_AR
Journal Post AR
Daily
345.
FM
GL
JRNLEDIT_AP
Journal Edit - AP
Daily
346.
FM
GL
JRNLPOST_AP
Journal Post AP
Daily
347.
FM
Billing
IOR
Indian Over Recoupment
Monthly
348.
FM
Billing
INT_NEW_STAT_PND_IOR
Run script to isolate bankrupt payors
Monthly
349.
FM
Billing
EP_TO_BILLING
EP to Billing Interface
Monthly
350.
FM
Billing
INTERFACE_ID_UPDATE
Run interface id update script
Monthly
351.
FM
Billing
EP_BILLING_INTERFACE
EP Billing Interface
Monthly
352.
FM
Billing
BILL_THRESHOLDS
Evaluate Billing Thresholds
Monthly
353.
FM
Billing
MONTHLY_INT_IOR_REPORT_INT2
Interest Report running with IOR
Monthly
354.
FM
Billing
EP_IOR_REPORT_RUN
process zepior
Monthly
355.
FM
AP
GENPAY_SOLIDS_INFORMATICA
Set up Solids piece prior to GENPAY
3 times per month
356.
FM
AP
GENPAYABLE2
Generate Payables
3 times per month
357.
FM
AP
FED_AP_ADJUSTMENTS
AP Adjustment Batch Processing
3 times per month
358.
FM
AP
FED_THRESHOLD_MONITOR
Threshold Monitoring for Federal PDLs
3 times per month
359.
FM
AP
FED_LEASE_CORR
Federal Lease Correction SQR
3 times per month
360.
FM
AP
APLABCREATE_F
Creates AP LAB lines for PDLs
3 times per month
361.
FM
AP
APPLYBRULE2
Apply Business Rules
Monthly
362.
FM
Reference
TERMINATOR
Terminator Batch
Monthly
363.
FM
Reference
ZFROWRUE
ZFROWRUE
Monthly
364.
FM
GL
GL_ACCTG_SCRIPT_BEFORE_WKND
GL Accounting Script
Weekly
365.
FM
GL
JRNLGEN3_WKND
Journal Generator 3
Weekly
366.
FM
GL
JRNLGEN4_WKND
Journal Generator 4
Weekly
367.
FM
GL
GL_ACCTG_SCRIPT_AFTER_WKND
GL Accounting Script
Weekly
368.
FM
GL
JRNLEDIT_AR_WKND
Journal Edit - AR
Weekly
369.
FM
GL
JRNLPOST_AR_WKND
Journal Post - AR
Weekly
370.
FM
Billing
INT_EST
Interest EP Batch Estimate
Monthly
371.
FM
Billing
INT_LP
Interest EP Batch Late Pay
Monthly
372.
FM
Billing
INT_PC_INT
Payor Calculated Interest
Monthly
373.
FM
Billing
EP_TO_BILLING_INT_EST
EP to Billing Interface Estimate
Monthly
374.
FM
Billing
INTERFACE_ID_UPDATE_INT_EST
Run interface id update script estimate
Monthly
375.
FM
Billing
EP_BILLING_INTERFACE_INT_EST
EP Billing Interface Estimate
Monthly
376.
FM
Billing
BILL_THRESHOLDS_INT_EST
BILL_THRESHOLDS_INT_EST
Monthly
377.
FM
Billing
FIN_BATCH_PROCESS_WEEKEND
Financial Batch Process
Monthly
378.
FM
Billing
EP_TO_BILLING_WEEKEND
EP to Billing Interface
Monthly
379.
FM
Billing
INTERFACE_ID_UPDATE_WEEKEND
Run interface id update script
Monthly
380.
FM
Billing
EP_BILLING_INTERFACE_WEEKEND
EP Billing Interface
Monthly
381.
FM
Billing
BILL_THRESHOLDS_WEEKEND
Evaluate Billing Thresholds
Monthly
382.
FM
AP
ZAPDUEDT
Update Due Date
Monthly
383.
FM
AP
GENVRFED
FED Generate Voucher
Monthly
384.
FM
AP
PAYMENTS
Update payments script
Monthly
385.
FM
AP
APPBVCHR
Voucher Edits
Monthly
386.
FM
AP
ZINTFVCH
Record Payment
Monthly
387.
FM
AP
VRPOSTFED2
Voucher Post - FED01
Monthly
388.
FM
AP
FED_OFF_CYCLE_DISB
Off cycle Disbursement
Monthly
389.
FM
Billing
OTH_NEW_STAT_PND
Run script to isolate bankrupt payors
Monthly
390.
FM
Billing
INSPECTION_FEE_UPLOAD
Inspection Fee Upload Process
Monthly
391.
FM
Billing
EP_TO_BILLING_IF
EP to Billing Interface
Monthly
392.
FM
Billing
INTERFACE_ID_UPDATE_IF
Run interface id up script
Monthly
393.
FM
Billing
EP_BILLING_INTERFACE_IF
EP Billing Interface
Monthly
394.
FM
GL
SF1081
SF1081 Batch
Daily
395.
FM
GL
ZYTELEFX
Daily Telefax Report
Daily
396.
FM
AR
DAYTIME-ARUPDATE
ARUPDATE
Daily
397.
FM
AR
PAYPOSTFED_1
Payment Post - MAN
Monthly
398.
FM
AP
PAYPOSTFED_2
Payment Post - VEFT
Monthly
399.
FM
AP
PAYPOSTFED_3
Payment Post - Other
Monthly
400.
FM
AP
AP_GENEOP
Indian Generate EOP
Twice per month
401.
FM
AP
AP_PSTPYMNT
Indian Payment Post
Twice per month
402.
FM
AP
AP_PSTVCHR
Indian Post Voucher
Twice per month
403.
FM
AP
GENEOPFED_WKND
Federal Generate EOP
Monthly
404.
FM
AP
ZDFNVCHR
Negative Federal Vouchers
Monthly
405.
FM
AP
AR_REFUND
Refunds
Monthly
406.
FM
AP
ZAPAPADJ
AP Adjustments
Monthly

File details come from the government source that posted it. Updated .