1. Operations Guide, Volume 1 - Batch Overviews and Designs
  2. Franchise Management
  3. Franchise Order Close (wfordcls)

Franchise Order Close (wfordcls)

Module Name

wfordcls.pc

Description

Franchise Order Close

Functional Area

Franchise Management

Module Type

Admin

Module Technology

ProC

Catalog ID

RMS391

Wrapper Script

rmswrap_multi.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This batch program is used to close the Franchise orders if the conditions below are met:

  • Franchise Order is not in Input (I) or Requires Credit Approval (R) status.

  • All the transfers associated with the franchise order are in closed/deleted status.

  • All the allocations associated with franchise order are in closed status.

  • All the purchase orders associated with franchise order are in closed status.

  • Store orders associated with franchise order do not have a null processed date or a need qty > 0.

Restart/Recovery

The logical unit of work for this module is defined as a unique franchise order number. The restart franchise order view is used for threading. This batch program uses table-based restart/recovery. The commit happens in the database when the maximum commit counter is reached.

Design Assumptions

N/A