Go to primary content
Oracle® Retail Merchandising Cloud Services Batch Schedule
Release 16.0.21
Exxxx-0x
  Go To Table Of Contents
Contents

Previous
Previous
 
 

1 Introduction to Merchandising Batch Processing

This chapter is a brief introduction to Oracle Retail batch processing. It defines basic terms and concepts, describes batch processing phases, and explains how to interpret the batch schedule program list.

Batch Processing

Batch processing is the execution of a group of batch programs (jobs). The results are returned without user intervention. Batch programs are commonly used for the following reasons:

  • To process large volumes of transaction data

  • To interface with external systems

  • To perform internal maintenance

Batch programs can process very large quantities of data quickly and efficiently. Batch programs can perform some updates that could be performed through online transactions, but much more quickly and with less impact on system performance. Batch processing is usually scheduled for times when systems are idle or least busy.

Batch programs can be run automatically using batch scheduler software. The batch scheduler allows batch jobs to be set up in a specific order, with restrictions attached to any program as needed. If an error occurs with a batch program, an administrator must correct the error and manually rerun the batch program that failed.

Types of Batch Programms

Oracle Retail batch programs are of several types:

  • Upload programs bring data from external systems into the Oracle Retail database. For example, the sales upload program uploads daily transactions that occur at the point of sale (POS) for processing by the Oracle Retail Management System (RMS).

  • Download programs extract data from RMS and format it so it can be used by external systems. For example, the posdnld program extracts new and changed information about an item/location for downloading to the point of sale.

  • System maintenance programs perform tasks such as updating the system date. For example, the dtesys program increments the system date at the end of each batch cycle.

  • Functional maintenance programs process data specific to a functional area. For example, the mrt.pc program creates individual transfers for an approved Mass Return Transfer.

Batch Window

Because of the impact on production systems, it is not always possible to run batch programs during business hours; however, there is a window of opportunity during each day or night when online systems are not being used. This time frame is the batch window. For example, a retailer with stores throughout the continental U.S. might require its online systems to be available from 8 AM Eastern Standard Time, when its East Coast offices open, until 9 PM Pacific Standard Time, when its West Coast stores close. This allows an eight-hour batch window for processing all batch jobs.

Batch Schedule and Phases

Order is critical when running batch programs. Some tasks need to be performed before others. A batch schedule ensures that every time batch processing is performed, the correct tasks are performed in the proper order.

The batch schedule is a program list with batch phases and pre/post dependencies for each batch job. For each individual user, the schedule is a suggested starting point for the installation. Some programs are specific to products that may not be installed, so these programs may not be used at all.

The total batch schedule is divided into phases. Each phase must be completed before the next phase can begin. Within a phase, there may also be programs that depend on the completion of another program within that phase, so programs within each phase may need to be run in a particular order.

Merchandising Batch Schedule

The integrated Merchandising batch schedule combines the batch schedules of all Merchandising applications into a single schedule program list. The batch program list (later in this document) shows the batch dependencies among the Merchandising applications.

The integrated Merchandising batch schedule combines the batch modules for the following applications:

  • Oracle Retail Merchandising System (RMS)

  • Oracle Retail Trade Management (RTM)

  • Oracle Retail Sales Audit (ReSA)

  • Oracle Retail Invoice Matching (ReIM)

  • Oracle Retail Price Management (Pricing)

  • Oracle Retail Allocation

Program List

The columns of the program list provide details about each batch program, as follows:

Table 1-1 Program List Details

Column Description

Program name

Name of the program or script

Functional area

Functional area of the application for which the batch program is run

Threaded

Whether the program is threaded (Y/N)

Driver

Program driver

Phase

Phase during which the program is run

Pre-dependency

Programs that must be completed before the program can be run

Post-dependency

Programs that must be completed before the program can be run

Timing

How often the program is run (for example, daily, weekly, monthly, ad hoc)

Restart/Recovery

Whether the program uses restart/recovery (R=Yes, N=No)

Run Parameters for Program

Command syntax to run the program


For example, the following shows the information in the program list about an RMS phase 3 program named dealday:

Table 1-2 Program List - dealday

Column Description

Program Name

dealday

Functional Area

Deals

Threaded

Y

Driver

Location

Phase

3

Pre-dependency

dealinc, dealfinc, prepost dealday pre

Post-dependency

prepost dealday post, salmnth

Timing

Monthly

Restart/Recovery

R

Usage

dealday userid/passwd


The program list is grouped in the following order:

  • RMS, RTM, and ReSA programs

  • Pricing programs

  • ReIM programs

  • Allocation programs

  • RMS extracts for Retail Predictive Application Server (RPAS)

The extracts for RPAS are programs that are part of the RMS application.