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

2 Technical Architecture

• SIM Technology Stack
• Advantages of the Architecture
• SIM Technical Architecture Diagrams and Description
  • Client Tier
  • Middle (Server) Tier
    • Data Access Objects (DAO)
    • Java Database Connectivity (JDBC)
  • Database Tier
• Distributed Topology

3 Backend System Configuration

• Supported Oracle Retail Products/Environments
• Configuring SIM Across Time Zones
  • Setup RIB Interface GMT Parameter
• GUI based System and Store Configuration
• Configuration Files
  • jndi.cfg
• batch.cfg
  • Jps-config.xml
  • Log4j.xml
• common.cfg
• client.cfg
• date.cfg
  • Editing date.cfg
  • jdni.cfg
  • Log4j.xml
• Server Configuration
  • ldap.cfg
• server.cfg
• Wireless Configuration
  • wireless.cfg
  • jndi.cfg
  • Jps-config.xml
  • Log4j.xml
• External Service Integration Configuration
  • ext-services.cfg
• RIB Integration Configuration
  • remote_service_locator_info_ribclient.xml
  • mps-boot.xml
• Port Configuration
• Configuring the Transaction Timeout for SIM
• Logging Information
  • Default Location of Log Files
    • Server Log Files
    • Client Log Files
  • Changing Logging Levels
    • Editing log4j.xml
• Activity Locking

4 Batch Processes

• Running a Batch Process
• Scheduler and the Command Line
• Return Value Batch Standards
• Batch Logging
• Summary of SIM Batch List
• Batch Process Scheduling Notes
• Batch Details
  • AutoReceiveTransfer Deliveries Batch
    • Usage
    • Key Tables
    • Restart/Recovery
  • AutoReplenishCapacity Batch
    • Usage
  • 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
  • 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
  • TransfersNotAfterDateAlert 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

5 Data Purge

• Data Purge Logging
• Summary of SIM Purge 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
  • PurgeBatchImpExp 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
  • PurgeDSDreceivings 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
  • PurgePurchaseOrders 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
  • PurgeStockReturns Batch
    • Usage
    • 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

• DexnexFileParser 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

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

C Appendix: SIM Integration Connection Troubleshooting

• SIM Message Publishing
• SIM Message Subscribing