Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments 

Preface

• Audience
• Related Documents
• Documentation Accessibility
• Customer Support
• 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
• SIM JNDI Configuration
  • jndi.cfg
• Batch Configuration
  • batch.cfg
  • jndi.cfg
  • Jps-config.xml
  • Log4j.xml
• Common Configuration
  • common.cfg
• PC Client Configuration
  • client.cfg
• date.cfg
  • Editing date.cfg
  • jdni.cfg
  • Log4j.xml
• Server Configuration
  • ldap.cfg
• schema.user.role.attribute.end.date=endTimestampserver.cfg
• Wireless Configuration
  • wireless.cfg
  • jndi.cfg
  • Jps-config.xml
  • Log4j.xml
• External Service Integration Configuration
  • ext-services.cfg
  • jndi_providers.xml
  • service_flavors.xml
  • services_rsl.xml
• RIB Integration Configuration
  • remote_service_locator_info_ribclient.xml
  • retail_service_config_info_ribclient.xml
  • injectors.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
  • AutoReceiveFinisherDeliveries Batch
    • Usage
  • AutoReceiveTransfers Batch
    • Usage
  • AutoReceiveWarehouseDeliveries Batch
    • Usage
  • CleanupShelfReplenishment Batch
    • Usage
  • ClearancePriceChange Batch
    • Usage
    • Backup
    • File Layout
    • Threading
  • CloseProdGroupSchedule Batch
    • Usage
    • Error Handling and Logging
  • DeactivateOldUsers Batch
    • Usage
  • DexnexFileParser Batch
    • Usage
  • ExtractUnitAmountStockCount Batch
    • Usage
    • Primary Tables Involved
    • Threading
  • ExtractUnitStockCount Batch
    • Usage
    • Primary Tables Involved
    • Threading
  • FulfillmentOrderPickReminders Batch
    • Usage
  • FulfillmentOrderReminders Batch
    • Usage
  • GenerateItemQRCodeTicket Batch
    • Usage
  • ItemPriceToHistory Batch
    • Usage
  • ItemRequest Batch
    • Usage
    • Threading
  • PosTransactionImport Batch
    • Usage
    • Batch Detail
    • Threading
    • Error Handling, Logging, and File Archiving
  • PosTransactionRetry Batch
    • Usage
  • PriceChangeExtractRetry Batch
    • Usage
  • ProblemLineStockCount Batch
    • Usage
    • Threading
  • PromotionPriceChange Batch
    • Usage
    • Backup
    • File Layout
    • Threading
    • Error Handling and Logging
  • RegularPriceChange Batch
    • Usage
    • Backup
    • File Layout
    • Threading
    • Error Handling and Logging
  • RetailSaleAuditImport Batch
    • Usage
    • Batch Detail
    • Threading
    • Error Handling, Logging and File Archiving
  • ReturnNotAfterDateAlert Batch
    • Usage
  • StockCountAuthorizeRecovery Batch
    • Usage
  • ThirdPartyStockCountImport Batch
    • Usage
    • Primary Tables Involved
    • Integration Assumptions
  • TransfersOverdue Batch
    • Usage
  • UINAttributesImport Batch
    • Usage
  • WastageInventoryAdjustments Batch
    • Usage
  • WastageInventoryAdjustmentPublishJob Batch
    • Usage

5 Data Purge

• Data Purge Logging
• Summary of SIM Purge List
• Purge Scheduling Notes
• Purge Details
  • PurgeAdHocStockCount Batch
    • Usage
  • PurgeAll Batch
    • Usage
  • PurgeAudits Batch
    • Usage
  • PurgeBatchImpExp Batch
    • Usage
  • PurgeCompletedUINDetail Batch
    • Usage
  • PurgeDeletedUsers Batch
    • Usage
  • PurgeDSDreceivings Batch
    • Usage
  • PurgeFulfillmentOrders Batch
    • Usage
  • PurgeInvalidUserRoles Batch
    • Usage
  • PurgeInventoryAdjustments Batch
    • Usage
  • PurgeInventoryAdjustTemplate Batch
    • Usage
  • PurgeItem Batch
    • Usage
  • PurgeItemBaskets Batch
    • Usage
  • PurgeItemPrice Batch
    • Usage
  • PurgeItemRequests Batch
    • Usage
  • PurgeItemTickets Batch
    • Usage
  • PurgeLockings Batch
    • Usage
  • PurgePriceChangeWorksheet Batch
    • Usage
  • PurgePriceHistories Batch
    • Usage
  • PurgePurchaseOrders Batch
    • Usage
  • PurgeReceivedTransfers Batch
    • Usage
  • PurgeRelatedItems Batch
    • Usage
  • PurgeResolvedUINProblems Batch
    • Usage
  • PurgeSalesPosting Batch
    • Usage
  • PurgeShelfReplenishment Batch
    • Usage
  • PurgeStagedMessage Batch
    • Usage
  • PurgeStockCounts Batch
    • Usage
  • PurgeStockReturns Batch
    • Usage
  • PurgeStoreItemStockHistory Batch
    • Usage
  • PurgeTemporaryUINDetail Batch
    • Usage
  • PurgeUINDetailHistories Batch
    • Usage
  • PurgeUserCache Batch
    • Usage
  • PurgeUserPasswordHistory Batch
    • Usage
  • PurgeWHDReceivings Batch
    • Usage

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

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

C Appendix: SIM Integration Connection Troubleshooting

• RSL-to-RPM Connections
• RSL-to-RMS Connection
• SIM Message Publishing
• SIM Message Subscribing

Index