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