Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Customer Support
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Help Center (docs.oracle.com)
• Conventions

1 Introduction

• Volume 1 - Batch Overviews and Designs
• Volume 2 - Message Publication and Subscription Designs
• Batch Schedule
• Batch Wrapper Overview

2 Administration Batch

• Program Summary
• Archive and Truncate Purge History Tables (batch_archive_purge_hist.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • I/O Specifications
  • Design Assumptions
• Daily Purge of Foundation Data (daily_purge_job)
  • Schedule
  • Design Overview
  • Restart Recovery
  • Key Tables Affected
  • I/O Specification
• Daily Purge of Foundation Data (dlyprg)
  • Schedule
  • Design Overview
  • Restart Recovery
  • I/O Specification
  • Design Assumptions
• Forecast Roll Up Refresh Views (refreshmview.ksh)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
• Increment Virtual Business Date (dtesys)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • I/O Specification
  • Design Assumptions
• Load Spreadsheet Templates (ld_iindfiles.ksh and loadods.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Pre/Post Helper Processes for Batch Programs (prepost)
  • Schedule
  • Design Overview
  • Restart/Recovery
• Purge Aged Competitive Pricing Data (cmpprg.pc)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Competitive Pricing Data (comp_pricing_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Asynchronous Job Tables (async_job_status_retry_cleanup.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Input/Out Specification
• Purge Dashboard Working Tables (rms_oi_purge.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Export Data (data_export_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• Purge Export Data (export_stg_purge.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Forecast Data (fcstprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Forecast Data (forecast_data_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Job Auditing Logs (job_audit_logs_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Manage Admin Records (admin_api_purge.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • I/O Specifications
• Purge Notifications (raf_notification_purge.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Retain Item Forecast History (rms_oi_forecast_history.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Tax Event Purge (tax_event_purge_job)
  • Scheduling
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Input/Output Specification
• Tax Event Purge (taxevntprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Truncate Table Script (trunctbl.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions

3 Foundation Data Maintenance

• Apply Pending Cost Component and ELC Changes to Purchase Orders (batch_ordcostcompupd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Apply Pending Item Cost Component Updates (batch_itmcostcompupd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Apply Pending Rate Changes to Expense Profiles (batch_expprofupd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Apply Pending Up-Charge Cost Component Changes to Departments (batch_depchrgupd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Build Diff Ratios Based on Sales History (dfrtbld)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • I/O Specification
  • Output File Layout
  • Design Assumptions
• Like Store Batch Processing (likestorebatch)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Process Pending Merchandise Hierarchy Changes from External Systems (cremhierdly)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Cost Component Exceptions (elc_except_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Cost Component Exceptions (elcexcprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Price History Data (prchstprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Performance Considerations
  • Design Assumptions
• Purge Aged Price History Data (price_hist_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
• Purge Aged Store Ship Schedule (activity_sched_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Store Ship Schedule (schedprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Inactive Currency Rates (currency_rates_purge_job)
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Manage Admin Records (admin_api_purge)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • I/O Specification
• Rebuild Dynamic Item Lists (itmlrbld)
  • Design Overview
  • Schedule
  • Restart/Recovery
  • Design Assumptions
• Rebuild Dynamic Location Lists (lclrbld)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Rebuild Dynamic Location Lists (loc_list_rebuild_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Reclassify Items in Merchandise Hierarchy (reclsdly)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Refresh Address Materialized View (refmvlocprimaddr)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Refresh Currency Conversion Materialized View (batch_rfmvcurrconv)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Refresh Localization Materialized View (refmvl10entity)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • I/O Specification
• Rollup of Supplier Data (supmth)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Store Add Asynchronous Process (CORESVC_STORE_ADD_SQL. ADD_STORE)
  • Business Overview
  • Key Tables Affected
  • Design Assumptions
    • Queue Creation
  • Design Overview - Process Steps
  • Package Impact
    • Function Level Description - ADD_STORE
    • Function Level Description - ENQUEUE_STORE_ADD
    • Function Level Description - ENQUEUE_STORE_ADD_RETRY
    • Function Level Description - NOTIFY_STORE_ADD
  • Operations and Monitoring
    • Running entire Store-Add as Batch in Case of AQ Issues
    • Building Schedule Dependencies between Async Process and other Batches
    • Monitoring Progress of Store-Add Processes
• Store Add Asynchronous Process (straddbatch.ksh)
  • Business Overview
  • Key Tables Affected
  • Design Assumptions
    • Queue Creation
  • Design Overview - Process Steps
  • Running entire store-add as batch in case of AQ issues
  • Building Schedule Dependencies between Async process and other batches
  • Monitoring Progress of Store-Add Processes
• Update Allocation and Transfer Based on Changes to Up-Charges (batch_alloctsfupd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Update ELC Components (batch_compeffupd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions

4 Item Maintenance

• Program Summary
• Daily Purge of Item-Location Data (item_loc_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
• Global Tax Solution Builder (gtsbuilder)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Mass VAT Updates for Items/Locations (vatdlxpl)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Item Induction Staging Tables (itm_indctn_purge.ksh)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
• Scheduled Item Maintenance (sitmain)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions

5 Purchase Order

• Program Summary
• Apply Deal Discounts to Purchase Orders (orddscnt)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Auto Close Purchase Orders (ordautcl)
  • Schedule
  • Design Overview
    • Category 1
    • Category 2
    • Category 3
  • Restart/Recovery
  • Design Assumptions
• Auto Close Purchase Orders (order_auto_close_job)
  • Schedule
  • Design Overview
    • Category 1
    • Category 2
    • Category 3
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Build Purchase Orders for Vendor Generated Orders (vrplbld)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Generate Pre-Issued Order Numbers (genpreiss)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Open To Buy Data (otb_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Open To Buy Data (otbprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Purchase Orders (order_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Purchase Orders (ordprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge PO Induction Staging Tables (po_indctn_purge.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Scale Purchase Orders Based on Supplier Constraints (supcnstr)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Locking Strategy
  • Design Assumptions
• Update Retail Values on Open Purchase Orders (ordupd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Write Purchase Order Information to Purchase Order History Tables (order_revision_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Write Purchase Order Information to Purchase Order History Tables (ordrev)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions

6 Deals

• Program Summary
• Calculate Actual Impact of Billback Deals (dealact)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Calculate Weekly/Monthly Income Based on Turnover (dealinc)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Calculates/Update Forecasted Values for Deals (dealfct)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Close Expired Deals (deal_close_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
• Close Expired Deals (dealcls)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Daily Posting of Deal Income to Stock Ledger (dealday)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Deal Calculation Queue Insert Multithreading (batch_ditinsrt.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Insert into Deal Calculation Queue (ditinsrt)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Closed Deals (deal_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
• Purge Closed Deals (dealprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Closed Deals Actuals Item/Location (deal_actuals_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
• Update OTB After Deal Discounts (discotbapply)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Schedule

7 Contracts

• Program Summary
• Apply Type A, C and D Contracts to Orders Created by Replenishment (cntrprss)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Contract Maintenance and Purging (cntrmain)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Contract Maintenance and Purging (contract_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Create Replenishment Orders for Item/Locations on Type B Contracts (cntrordb)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions

8 Cost Changes

• Program Summary
• Cost Change Purge (ccprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Cost Change Purge (cost_change_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Process Scheduled Ownership Change Data (ownership_change_process)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Processed and Aged Ownership Change Data (ownership_change_purge)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Supplier Cost Change Extract (sccext)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions

9 Future Cost

• Future Cost Events
• Future Cost Engine Run Type Configuration
  • Synchronous
  • Asynchronous
  • Batch
• Future Cost Engine Concurrency Control
• Future Cost Engine Error Handling
• Future Cost Engine Threading/Chunking
• Future Cost Process
• Program Summary
• Execute Batch Calculation/Recalculation of Future Cost Values (fcexec)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Future Cost Table Maintenance (future_cost_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • Key Tables Affected
  • I/O Specification
• Prepare Threads for Batch Calculation/Recalculation of Future Cost Values (fcthreadexec)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Pricing Cost Refresh (rms_oi_pricecostrefresh.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Cost Events (cost_event_purge_job)
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Cost Events (costeventprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Use Pending Price Changes to Drive Recalculation of Pricing Cost for some Franchise Item/Locations (fc_pricechg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• WAC Refresh (rms_oi_wacvarrefresh.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions

10 Invoice Matching

• Program Summary
• Close Aged Shipments to Prevent them from Matching Open Invoices (invc_ship_close_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
• Close Aged Shipments to Prevent them from Matching Open Invoices (invclshp)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Invoices (invoice_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
• Purge Aged Invoices (invprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions

11 Replenishment

• Replenishment Sub Processes
  • Manage Replenishment Attributes
  • Calculate Recommended Order Quantities
  • Build Orders and Transfers
  • Cleanup Replenishment Data
• Approve Replenishment Orders (rplapprv)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Build Replenishment Orders (rplbld)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Calculate Net Inventory (replroq.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Calculate ROQ for Profitable Investment Buys (ibcalc)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Determines Eligible Investment Buy Opportunities (ibexpl)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Multithreading Wrapper for reqext (batch_reqext.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Buyer Worksheet Results (buyer_wksht_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Investment Buy Results (investment_buy_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Replenishment Results (replenishment_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Replenishment Results (rplprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Store Orders Results (store_orders_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Replenishment Attribute History (rplathistprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Replenishment Results History by Month (rplprg_month)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Scheduled Replenishment Induction Staging Tables (repl_indctn_purge.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Recalculate Maximum Levels for Floating Point Replenishment (repladj)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• ROQ Calculation and Distribution for Item/Locs Replenished from WH (reqext)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• ROQ Calculation and Distribution for Item/Locs Replenished from Supplier (rplext.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Locking Strategy
  • Performance Considerations
  • Design Assumptions
• Split Replenishment Orders Among Suppliers (supsplit)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Sync Replenishment Franchise Orders (repl_wf_order_sync.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Truck Splitting Optimization for Replenishment (rplsplit)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Update Replenishment Calculation Attributes (rplatupd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Update Replenishment Calculation Attributes by Item/Locrilmaint)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Update Replenishment Order Taxes (batch_rplapprvgtax.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Update Replenishment Size Profile (replsizeprofile)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions

12 Inventory

• Program Summary
• Adjust Inventory for Wastage Items (wasteadj)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Customer Orders (customer_order_purge.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Customer Orders (customer_orders_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Security Considerations
• Purge Aged Inventory Adjustments (inv_adj_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Inventory Adjustments (invaprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Refresh End of Day Inventory Snapshot (refeodinventory)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions

13 Transfers, Allocation, and RTV

• Program Summary
• Close Mass Return Transfers (mrtupd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Close Overdue Transfers (transfer_close_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Close Overdue Transfers (tsfclose)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Close Transactions with no Expected Appointments, Shipments or Receipts (doc_queue_close_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Close Transactions with no Expected Appointments, Shipments or Receipts (docclose)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Create Book Transfers for Allocations Between Warehouses in the Same Physical Warehouse (allocbt)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Create Return to Vendor for Mass Return Transfer (mrtrtv)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Create Transfers for Mass Return Transfer (mrt)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Detail Receive Damaged or Tampered with Cartons (tamperctn)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Mass Return Transfers and RTV (mrt_purge_job)
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Mass Return Transfers and RTV (mrtprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Returns to Vendors (rtv_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Returns to Vendors (rtvprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Transfers (transfer_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge Aged Transfers (tsfprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Reconcile Received Dummy Carton IDs with Expected Cartons (dummyctn)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Stage Regular Price Changes on Open Allocations/Transfers so Publishing Sends New Retail to Subscribing Applications (distropcpub)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • I/O Specification
  • Design Assumptions

14 Sales Posting

• Program Summary
• Archive Successfully Posted Transactions (salesuploadarch.ksh)
  • Schedule
  • Design Overview
  • Performance Considerations
  • Design Assumptions
• Main Processing of Staged Sale/Return Transactions (salesprocess.ksh)
  • Schedule
  • Design Overview
  • POSU Chunking
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • I/O Specification
  • Design Assumptions
  • Financial Transactions
• Purge Aged Archived POSU Transactions (salesuploadpurge.ksh)
  • Schedule
  • Design Overview
  • Performance Considerations
  • Design Assumptions
• Purge FILE_UPLOAD_STATUS and FILE_UPLOAD_ERRORS Tables (file_upload_errors_purge.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • I/O Specification
  • Design Assumptions

15 Sales History

• Program Summary
• Monthly Sales History Rollup By Department, Class And Subclass (hstbldmth)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Monthly Sales History Rollup By Diffs (hstbldmth_diff)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Locking Strategy
  • Design Assumptions
• Monthly Stock on Hand, Retail and Average Cost Values Update (hstmthupd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • I/O Specification
• Purge Aged Sales History (history_purge_job)
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
• Purge Aged Sales History (hstprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Sales History by Diff (hist_diff_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
• Purge Aged Sales History by Diff (hstprg_diff)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Weekly Sales History Rollup by Department, Class, and Subclass (hstbld)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Weekly Sales History Rollup by Diff (hstbld_diff)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
  • Key Tables Affected
• Weekly Stock on Hand and Retail Value Update for Item/Location (hstwkupd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • I/O Specification
  • Design Assumptions

16 Stock Count

• Program Summary
• Calculate Actual Current Shrinkage and Budgeted Shrink to Apply to Stock Ledger (stkdly)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Create Stock Count Requests Based on Schedules (stake_sched_explode_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumption
• Create Stock Count Requests Based on Schedules (stkschedxpld)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumption
• Explode Stock Count Requests to Item Level (stkxpld)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumption
• Process Stock Count Results (stockcountprocess.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumption
• Purge Aged Stock Count (stkprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumption
• Purge Aged Stock Count (stock_count_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumption
• Stock Count Snapshot Update (stkupd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumption
• Update Stock On Hand Based on Stock Count Results (stkvar)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumption

17 Stock Ledger

• Program Summary
• Append Stock Ledger Information to History Tables (salapnd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Daily Rollup of Transaction Data for Stock Ledger (saldly)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumption
• End Of Half Rollup of Data/Calculations for Stock Ledger (saleoh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• End of Year Inventory Position Snapshot (nwpyearend)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• External Transaction Data Process (trandataprocess.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Monthly Rollup of Data/Calculations for Stock Ledger (salmth)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge of Aged End of Year Inventory Positions (nwp_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Purge of Aged End of Year Inventory Positions (nwppurge)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Stock Ledger History (salprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Stock Ledger History (stkledgr_hist_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Stage Stock Ledger Transactions for Additional Processing (salstage)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Stock Ledger Table Maintenance (salmaint)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • I/O Specification
• Stock Ledger Table Maintenance (stock_ledger_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • Key Tables Affected
  • I/O Specification
• Weekly Rollup of Data/Calculations for Stock Ledger (salweek)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions

18 Franchise Management

• Program Summary
• Apply Supplier Cost Change to Franchise Orders (wf_apply_supp_cc.ksh)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Franchise Customer Staging Purge (fcustupldpurge)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Franchise Order Close (wf_orders_close_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Franchise Order Close (wfordcls)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Franchise Order Purge (wf_orders_purge_job)
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Franchise Order Purge (wfordprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Franchise Return Close (wf_returns_close_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Franchise Return Close (wfretcls)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Franchise Return Purge (wf_returns_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Franchise Return Purge (wfrtnprg)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Process Cost Buildup Template Upload (fcosttmplprocess)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Process Uploaded Franchise Customers and Customer Groups (fcustomerprocess)
  • Schedule
  • Design Overview
  • Restart/Recovery
    • Commit Points
  • Design Assumptions
  • Program Flow
• Purge Staged Cost Template Data (fcosttmplpurge)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Staged Cost Template Data (wf_cost_template_purge_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions

19 Sales Audit

• Import Process
  • Preparing for Import
  • Importing Data
  • Import Processing Programs
• Auditing Processing Programs
  • Sales Audit Processing Programs
• Export Process
  • Full Disclosure and Post-export Changes
  • Export Programs
• Calculate Totals Based on Client Defined Rules (sa_totals_calc_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Calculate Totals Based on Client Defined Rules (satotals)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Complete Transaction Import Processing (saimptlogfin)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Create Store Day for Expected Transactions (sastdycr)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Evaluate Transactions and Totals based on Client Defined Rules (sa_rules_eval_job)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Evaluate Transactions and Totals based on Client Defined Rules (sarules)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Extract Totals and Rules (sa_rules_total_extract)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Generate Next Sequence for Escheatment Processing (saescheat_nextesn)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Get Reference Data for Sales Audit Import Processing (sagetref)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • I/O Specification
    • File Name: Item File
    • File Name: Waste Data File
    • File Name: Reference Item Data
    • File Name: Primary Variant Data File
    • File Name: Variable Weight UPC Definition File
    • File Name: Valid Store/Day Combination File
    • File Name: Codes File
    • File Name: Error Information File
    • File Name: Store POS Mapping File
    • File Name: Tender Type Mapping File
    • File Name: Merchant Code Mapping File
    • File Name: Partner Mapping File
    • File Name: Supplier Mapping File
    • File Name: Employee Mapping File
    • File Name: Banner Information File
    • File Name: Currency Information File
    • File Name: Promotion Information File
    • File Name: Warehouse Information File
    • File Name: Inventory Status Information File
  • Design Assumptions
  • A Note about Primary Variant Relationships
• Migrate Totals and Rules (sa_rules_total_upload)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Pre/Post Helper Processes for ReSA Batch Programs (saprepost)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Prevent Duplicate Export of Total Values from ReSA (sapreexp)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Processing to Allow Re-Upload of Deleted Transactions (saimptlogtdup_upd)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Aged Store/Day Transaction, Total Value and Error Data from Sales Audit (sapurge)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Design Assumptions
• Purge Into History Tables (b8d_sa_purge)
  • Schedule
  • Design Overview
  • Restart/Recovery
  • Key Tables Affected