Batch Jobs

Job Name

Description

Batch Catalog Section

Agreement Renewal Notification

This job issues alerts to the Buyer or any member of the Buyer Team assigned to a Master Agreement or Contract transaction in order to notify users when a Master Agreement or Contract is expired. Notifications can also be sent at a specified number of days prior to the Master Agreement or Contract Expiration Date.

Procurement

Assembly Request Cleanup

The Assembly Request Cleanup process deletes records from the Assembly Request table (R_ASEM_REQ) as well as the matching entries on the Batch Job tables (BS_AGENT, BS_AGENT_LOG, and BS_AGENT_PARM) that are selected based on the items in the parameter tab.

Procurement

Catalog Indexing

The Shopper (SHOP) page allows users to enter a single search value and search against multiple columns on various source data objects. In order to accomplish this, the Catalog Indexing batch job adds a special index to each table that needs to be included in the search.

Please note: This job is not applicable when the database platform is IBM DB2 UDB because DB2 Net Search Extender (NSE) Administration commands cannot be directly called from an application. Please consult your System Administrator to inquire about the database update index task schedule and/or to request for the updates to be effected before the next scheduled iteration.

Procurement

Catalog Load Process

This job loads the vendor’s catalog file to the Catalog Maintenance table, and then attaches the Catalog File to the Master Agreement Commodity Line. The job also unzips all Catalog Picture files and attaches them as individual records to the Agreement Catalog Picture Attachment table and then attaches the zip file to the Master Agreement Commodity Line. Refer to the "Catalog Management" topic for more information on the Catalog functionality.

Procurement

Close Buysense PO's

This job closes buysense purchase orders so that a procurement-only environment can archive these purchase orders.

Procurement

Close Expired Agreement

Used to close Master Agreements that have expired before the date indicated in the Expiration Date parameter for the job.

Procurement

Contract Copy

This batch job copies Contract (CT) transactions using the baseline transaction copy command. It selects CT transactions to copy based on the selection criteria passed in the job parameters.

Procurement

Master Agreement Copy

This batch job copies Master Agreement (MA) transactions using the baseline transaction copy command. It selects MA transactions to copy based on the selection criteria passed in the job parameters.

Procurement

Deliver Ariba Information

This job sends XML files and catalog CIF files to buysense.

Procurement

Transaction Assembly

The Assembly functionality is available on the SO, PO, and MA Transaction Types. This process assembles specific transaction tabs, all of the attached Terms and Conditions, and all of the Supporting Transactions attached to the transaction within a single formatted PDF transaction.

The Assembly Process may be executed during the transaction’s Draft, Pending or Final phase on demand and it is executed automatically when the procurement transaction is submitted to final.

Procurement

Headquarters Unique ID Cleanup

This job manages auto-generated Address ID and Contact ID sequence numbers by Headquarters Account. This job removes all unused Headquarter IDs.

Procurement

Insurance Expiration Notification  

This job sends a notification email to the appropriate buyer when a record on the Insurance Certificate table is about to expire or has expired.

Procurement

Milestone Alerts

This job sends alerts to procurement buyers and managers according to the milestone rules on the Milestone table. The process searches for uncompleted milestones in open procurements when the Milestone rules indicate alerts are to be sent and the uncompleted milestone's Expected Completion Date meets the "number of days" threshold set for the buyer/buyer team or for the manager.

Procurement

Process MA Pending Table

This job assesses all pending Master Agreement Orders and Expenditures from the Pending Table against the specified MA. The process retrieves the records from the Pending table and updates the corresponding components on the MA.

Procurement

Procurement Folder Historical Update

This job sets the Historical Procurement Folder field to Yes, based on user defined parameters. The Run Mode parameter indicates whether the selected records are updated in the system or only listed in a report. Valid values are: 1 – “Report” or 2 – “Update”.

Procurement

Protest Action Alerts

This job sends alerts to buyers and buyer teams regarding incomplete protest actions that are flagged for an alert. Refer to the “Protest and Post Award Dispute Tracking Setup” topic for information on setting up the Protest tables. An alert is sent if all of the following are true:

• A Protest Action record has an Alert Date that is equal to or less than the current system date. (Note: The batch job calculates the Alert Date, and it is not visible on the Protest page. Alert Date = Estimated Completion Date – Alert Days)

• The value selected in the Protest Status field does not have the Final indicator selected.

• The Completed flag has not been selected for a Protest Action record.

• The Issue Alert flag is selected.

Procurement

Renew Agreements

This job creates modification Master Agreements (MA) and Contract (CT) for all Renewals (RN) effective on a given date.

Procurement

Update Department on Buyer and Manager Table

When a user’s home department is changed on the User Information (SCUSER) page in the Admin application, this job updates the Buyer (BUYR) and Manager (MANG) tables with the new home department value.

Procurement

Vendor Complaint Tracking

This job is used as part of the Protest area. This job determines which Vendors have failed to respond to the complaint and issues follow up notifications for them.

Procurement

Commodity and Stock Item Deactivation

This job is used to deactivate commodities that have been marked for de-activation on the Commodity table.

Procurement

Automated Volume Discount

This job is used to automatically create a new Draft Modifications of the MA transaction type based on the Auto-Volume Discount Information. This job first updates the Net Paid to Vendor based on the MA Pending Total (R_MA_PEND_TOT) records created by the AD/EFT and MD transactions. If the Net Paid to Vendor is increased beyond a volume discount tier threshold amount a trigger will be inserted to the new Volume Discount Trigger (VOL_DISC_TRIG) table. The job will then look at the VOL_DISC_TRIG table and create a new draft of the MA transaction with the volume discount amounts calculated, email the procurement analyst who has issued the MA transaction type, and put the information for the new draft into a report.

Procurement