Contents

Title and Copyright Information

Send Us Your Comments 

Preface

• Audience
• Review Patch Documentation
• Documentation Accessibility
• Related Documents
• Review Patch Documentation
• Customer Support
• Review Patch Documentation
• Review Patch Documentation
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Introduction

• Overview
• Batch Jobs
• Data Purge

2 Batch Overview

• Running a Batch Process
• Scheduler and the Command Line
• Batch Job Exit Code
• Batch Logging
  • Changing Logging Levels
• Transaction Timeout

3 Batch Jobs

• Summary of SIM Batch List
• Batch Process Scheduling Notes
• Batch Details
  • AutoReceiveTransfer Deliveries Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • AutoTicketPrint Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • CleanupShelfReplenishment Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • ClearancePriceChange Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • CloseDSDReceivings Batch
    • Usage
    • Key Table
    • Restart/Recovery
  • CloseProdGroupSchedule Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • CloseTransferDeliveries Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • CloseTransfers Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • CloseVendorReturn Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • DeactivateOldUsers Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • DexnexFileParser Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • ExtractUnitAmountStockCount Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • ExtractUnitStockCount Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • FulfillmentOrderPickReminders Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • FulfillmentOrderReminders Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • GenerateItemQRCodeTicket Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • InventoryExtract Batch
    • Export File Layout
    • Usage
    • Export File Location
    • Export File Name
    • Key Tables
    • Restart/Recovery
  • ItemPriceToHistory Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • ItemRequest Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PosTransactionImport Batch
    • Usage
    • Batch Detail
    • Threading
    • Error Handling, Logging, and File Archiving
    • Key Tables
    • Restart/Recovery
  • PosTransactionRetry Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PriceChangeExtractRetry Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • ProblemLineStockCount Batch
    • Usage
    • Threading
    • Key Tables
    • Restart/Recovery
  • PromotionPriceChange Batch
    • Usage
    • Backup
    • File Layout
    • Threading
    • Error Handling and Logging
    • Key Tables
    • Restart/Recovery
  • RegularPriceChange Batch
    • Usage
    • Backup
    • File Layout
    • Threading
    • Error Handling and Logging
    • Key Tables
    • Restart/Recovery
  • RetailSaleAuditImport Batch
    • Usage
    • Batch Detail
    • Threading
    • Error Handling, Logging and File Archiving
    • Key Tables
    • Restart/Recovery
  • ReturnNotAfterDateAlert Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • StockCountAuthorizeRecovery Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • StoreSequenceImport Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • ThirdPartyStockCountImport Batch
    • Usage
    • Key Tables
    • Restart/Recovery
    • Integration Assumptions
  • TransferNotAfterDateAlert Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • TransfersOverdue Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • UINAttributesImport Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • WastageInventoryAdjustments Batch
    • Usage
    • Key Tables
    • Restart/Recovery

4 Data Purge

• Data Purge Logging
• Summary of SIM Purge Program List
• Purge Scheduling Notes
• Purge Details
  • PurgeAdHocStockCount Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeAll Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeAudits Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeBatchLog Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeClosedTransfers Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeCompletedUINDetail Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeDeletedUsers Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeFulfillmentOrders Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeInvalidUserRoles Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeInventoryAdjustments Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeInventoryAdjustTemplate Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeItem Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeItemBaskets Batch
    • Usage
    • Restart/Recovery
  • PurgeItemPrice Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeItemHierarchy Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeItemRequests Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeItemTickets Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeLockings Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgePriceChangeWorksheet Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgePriceHistories Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeRelatedItems Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeResolvedUINProblems Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeSalesPosting Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeShelfReplenishment Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeStagedMessage Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeStockCounts Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeStoreItemStockHistory Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeTemporaryUINDetail Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeUINDetailHistories Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeUserCache Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeUserPasswordHistory Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • PurgeVendorReturns Batch
    • Usage
    • Key Tables
    • Restart/Recovery

A Appendix: Batch File Layout Specifications

• Dexnex Import File Layout Specification
  • File Structure – 894 Delivery
• ThirdPartyStockCountParser Import File Layout Specification
• ClearancePriceChange Import File Layout Specification
• RegularPriceChange Import File Layout Specification
• PromotionPriceChange Import File Layout Specification
• POS Sale Transaction Import File (SIMT-LOG) Specification
• RetailSaleAuditImport SIM-ReSA File Specification
• UINAttributeImport File Specification
• Stock Count Results Export File Specification
• StoreSequenceDataParser Import File Layout Specification
• Inventory Extract Export File Specification

B Appendix: Setup Auto-Authorized Third-Party Stock Count

C Appendix: Unit and Amount Stock Counts Export

• Export File Layout
• Export File Location
• Export File Name