Batch Controls
It is important to properly manage the order and frequency with which batch processes are run. Below is a list of batch jobs which, if scheduled, must be configured in the order listed. These are recommended settings, not requirements, based on your configuration of the system and your business practices.
To find the details for batch controls, reference the Batch Control record and then look at the maintenanceObject Parameter.
Refer to Defining Batch Controls in the Oracle Utilities Application Framework documentation for information on controlling the order in which the processes run, scheduling processes, and other details.
Scheduled Monitor Processes
Batch controls are listed here in the general sequence that they should be run:
Batch Control
Description
Suggested Freq.
W1-ACTRR
Activity Resource Requirement
Users can indicate a future ‘Reservation’ date on Material Requirements and the system will try to reserve the material when that date becomes current.
Run several times a day.
W1-ACT
Activity MO Periodic Monitor Process
Updates the activity Held For Parts flag based on availability in inventory. The monitor can be scheduled to re-evaluate the Held for Parts flag on all active activities against inventory quantity changes causes by stock re-order, material issue or return.
This monitor also auto-activates approved activities based on the Activation Date/Time on an activity which defines a future activation date. The system will activate the activity once it is both approved and the ‘Activation Date’ becomes current.
Daily. Available inventory changes by the hour, however your implementation should avoid running this batch job too often, as it places a heavy burden on the system.
W1-APVRQ
Approval Request Periodic Monitor Process
Manages transitioning of approval requests and routing them to the appropriate approvers. For example, if the current approver times out due to not responding in the alotted amount of time, this processing moves the approval request to the next approver.
Daily. Approver time out is defined as number of days.
W1-ASSET
Asset Periodic Monitor Process
Monitors preventive maintenance triggers to create the related work orders.
This monitor also creates PM Forecast records for the Asset. Your implementation can define the number of days to generate the future forecast, or planning horizon. For example, 1825 days would be 5 years of PM forecasts for all triggers. The planning horizon is controlled by a parameter on the W1-ASTMNTMON algorithm.
Daily.
W1-ASTYP
Asset Type Monitor Process
Calculates asset type average cost statistics.
Daily.
W1-BCHDR
Blanket Contract Header Monitor Process
Transitions blanket contracts that are awaiting activation to Active when future blanket contracts become current.
Daily.
W1-BSRR
Batch Stock Reorder Monitor Process
Creates the purchasing documents based on reorder review records.
Daily. (after W1-SID)
W1–CKLST
Activity Checklist Monitor Process
Monitors the Activity Checklist by looking at all instances of the Checklist MO whose current state has monitor algorithms defined and, if so, invokes those monitor algorithms.
Associated algorithm checks that all Mandatory Checklist Line Items are completed prior to allowing the Checklist to enter the Complete state.
Daily.
W1–CKLTY
Activity Checklist Type Monitor Process
Monitors all instances of the MO whose current state has monitor algorithms defined and, if so, invokes those monitor algorithms.
Daily.
W1-COMIN
Inbound Communication Periodic Monitor Process (both ODM and WAM)
If an external system sends inbound communications to WAM, e.g. to complete activity, this batch job needs to be run to process those inbound communications. Base BO’s have a deferred monitor algorithm on the initial state, which moves the inbound communication to the next state and is only executed when the batch is run. The reason why that monitor is a deferred is to avoid error(s) upon creation of the message.
As often as needed.
W1-COSTM
Cost Center Periodic Monitor Process
Calculates monthly and year to date statistics per cost center.
Note that users can also click a button online to calculate the statistics on demand.
Daily.
W1-CRSHF
Crew Shift Periodic Monitor Process
Maintains crew shift status.
Daily.
W1-CUCTR
CU Contractor Bid Periodic Monitor Process
Moves CU Contractor Bids through various lifecycle states including activating the bid once it reaches its effective date and expiring it once the expiration date is reached.
Daily.
W1-FIXAS
Fixed Asset Extract
For use with construction work management functionality: An external Fixed Asset Management system which manages the depreciation of fixed assets can interface with Oracle Utilities Work and Asset Management to retrieve fixed assets. This batch code creates a flat file to send these fixed assets to the external system. This batch code must also be referenced on the Construction Parameter Work Order Master Configuration to complete the following for fixed assets:
send fixed assets to an external system
to add a retired fixed asset entry to the general process table
to add an accept or return line entry to the general ledger for fixed assets
to add a cancel line entry to the general ledger for a stock item that is a capital spare
Daily.
W1-FTM
Financial Transaction Periodic Monitor Process
Invokes monitoring rules associated with the current state of financial transactions. All monitoring rules throughout the financial transaction's business object's inheritance chain are considered.
By default, the process periodically monitors financial transactions whose current state is not associated with a batch code.
Batch parameters govern whether the processing is further restricted by batch code, business object and status.
This processing also transitions objects from Created status to Populate GL Details to Frozen, as applicable. If the system encounters errors, the object is transitioned to Error. For example the GL number might not be able to be generated because of an incorrect cost center/expense code combination. There is a monitor on the error state to try again.
The error state creates a To Do. Users can always manually try to freeze the FT. However if the issue that caused the error has been fixed, the monitor will take care of the FT and To Do before users take actions.
The W1-GLDL process, GL Download Extract, extracts and downloads the general ledger details.
Hourly.
W1-GAUPL
Batch Attachment Upload
This batch control uploads data from a .csv file that is stored in the application as an attachment. This batch control is designed specifically for the Batch Loader Request process and has some format requirements for the data in the file:
Information cell in the Excel spreadsheet is treated as a formula. Reformat the cell to Text and remove the “=” sign that was automatically added by Excel.
Batch Loader Request can be accessed by navigating to Menu, click Tools, and then click Request.
For each data row in the file, this batch creates a generic inbound sync request record which acts as a staging record. Submit batch F1–SYSRQ to create the records in the application.
As needed.
W1-GBUPL
Batch File Upload
This batch control uploads data from a .csv file on the server. This batch control is designed specifically for the Batch Loader Request process and has some format requirements for the data in the file:
Information cell in the Excel spreadsheet is treated as a formula. Reformat the cell to Text and remove the “=” sign that was automatically added by Excel.
Batch Loader Request can be accessed by navigating to Menu, click Tools, and then click Request.
For each data row in the file, this batch creates a generic inbound sync request record which acts as a staging record. Submit batch F1–SYSRQ to create the records in the application.
As needed.
W1-GLDL
GL Download Extract
Extracts and downloads the general ledger details by creating a flat file.
The GL batch control code is defined in the Financial Master Configuration.
Daily.
W1-MNTSC
Maintenance Schedule Periodic Monitor Process
Calculate preventive maintenance statistics. This batch job must run in order to generate the statistics that are displayed on the Analytics tab in the PM Schedule portal.
Daily.
W1-MNTTR
Maintenance Trigger Periodic Monitor Process
Calculate failure statistics.
Daily.
W1-MTRDP
Material Disposition Monitor Process
Closes material dispositions after the assets have been processed (e.g. the new asset has been installed and the old asset have been either repaired and returned to a storeroom or retired).
Daily.
W1-ODCTR
ODC MO Periodic Monitor Process
Posts approved direct charges to create financial transactions and to the general ledger.
Daily.
W1–RTM
Resource Type Maintenance Object Monitor Batch Process
Monitors the Resource Types (Craft, Stock Item, Equipment, and Other) in order to maintain the Average Unit Price (AUP) field on the Stock Item, NOT the Stock Item Detail.
The AUP on the Stock Item is the average unit price for that stock item across all storerooms.
Daily.
W1-SFWKT
Shft Wkly Templt Periodic Monitor Process
Creates new shifts based on templates.
Daily.
W1-SID
Stock Item Detail MO Periodic Monitor Process
Causes the stock item detail to monitor itself to check it’s reorder levels and creates the reorder review as necessary.
This batch control also monitors lot expiration dates.
Note that W1–SID is the batch job for reorder review, not W1–RR. W1–RR is the standard monitor batch control delivered with the reorder review maintenance object, however, it does not perform the processing of creating reorder review records.
Daily.
W1-SSWO
Svc Sched WO MO Periodic Monitor Process
ODM only— this monitor is only relevant to activity generators in ‘Template’ state.
Create activity generator, from a template, based on the schedule defined on service history.
Daily.
W1-STAT
Statistic Monitor Process
Calculates home page statistics.
Daily.
W1-TMST
Timesheet MO Periodic Monitor Process
Posts approved timesheets to create financial transactions and entries in the general ledger.
Daily or weekly (if time period on timesheets is weekly).
W1-WD
Work Design MO Periodic Monitor Process
This process monitor keeps the resources on the Template Construction Work Order up to date.
Daily.
W1-WO
Work Order MO Periodic Monitor Process
Causes the system to automatically close completed work orders after the indicated number of days after completion.
This is relevant for auto close and service schedules.
Daily.
W1-WRNTY
Warranty Periodic Monitor Process
This process monitors the warranty BO’s active status to update the warranty to an “expired” status when the terms of the warranty is reached and to create a To Do when the warranty is about to expire.
Daily.
General Monitor Processes
Monitor controls are available in the base package so that if your implementation does add monitor algorithms to a business object for the related maintenance object, the batch control already exists to run. As delivered, the maintenance object instances current state does not reference a monitor process.
 W1-ACPTL
 Accept Line MO Periodic Monitor Process
 W1-ACTRR
 ARR MO Periodic Monitor Process
 W1-ASCLS
 Assessment Class Periodic Monitor Process
 W1-ASGRP
 Assessment Group Periodic Monitor Process
 W1-ASCDU
 Asset Current Disposition Update
 W1-BCLIN
 Blanket Contract Line Monitor Process
 W1-BUYER
 Buyer MO Periodic Monitor Process
 W1-CEVT
 Completion Event MO Periodic Monitor Process
 W1-CMSYN
 Composite Sync Request
 W1-SICER
 Composite Sync Request - Error
 W1-CFG
 Configuration Periodic Monitor Process
 W1-CFGRP
 Config Report MO Periodic Monitor Process
 W1-CVNR
 Create Vendor from Characteristic
 W1-CREW
 Crew MO Periodic Monitor Process
 W1-EMP
 Employee MO Periodic Monitor Process
 W1-EU
 EU MO Periodic Monitor Process
 W1-IA
 IA MO Periodic Monitor Process
 W1-INVHD
 Invoice Header Monitor Process
 W1-INVAP
 Invoice AP Extract Batch
 W1-MNTEV
 Maintenance Event Monitor
 W1-MNTMG
 Maintenance Manager MO Periodic Monitor Process
 W1-MSRMT
 Measurement Periodic Monitor Process
 W1-MTRQH
 Material Request Header Monitor Process
 W1-MTRQT
 Material Request Template Monitor
 W1-MTRTH
 Material Return Header Monitor Process
 W1-ODCDT
 ODC Detail MO Periodic Monitor Process
 W1-PIMSR
 Physical Inventory Count Line Periodic Monitor Process
 W1-SIOER
 Ongoing Sync Request - Error
 W1-SIOPE
 Ongoing Sync Request - Pending
 W1-PLANR
 Planner MO Periodic Monitor Process
 W1-POHDR
 PO Header Monitor Process
 W1-POLNE
 Purchase Order Line Periodic Monitor Process
 W1-PRHTR
 PR Header MO Periodic Monitor Process
 W1-PRJ
 Project MO Periodic Monitor Process
 W1-RCPTH
 Receipt Header MO Periodic Monitor Process
 W1-RCPTL
 Receipt Line MO Periodic Monitor Process
 W1-RTM
 Resource Type MO Periodic Monitor Process
 W1-RPINV
 Reprocess Invoice
 W1-RTNL
 Return Line MO Periodic Monitor Process
 W1-SVHST
 Service Hist MO Periodic Monitor Process
 W1-SYRQI
 Inbound Sync Request MO Monitor Process
 W1-SRSER
 Sync Request Seeder - Error
 W1-TMPW
 Template WO MO Periodic Monitor Process
 W1-TMPWO
Template WO MO Periodic Monitor Process
Retrieves all the template activity resources for the template work order and updates the unit price on the template activity resource.
Run process as needed.
 W1-TSDTL
 Timesheet Detail MO Periodic Monitor
 W1-VNDRL
 Vendor Location Periodic Monitor Process
 W1-WR
 Work Request MO Periodic Monitor Process