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-ERPFA ERP 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