Go to primary content
Oracle® Retail Store Inventory Management Operations Guide
Release 14.1
E52928-02
Next
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Review Patch Documentation
Related Documents
Review Patch Documentation
Documentation Accessibility
Customer Support
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
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
server.cfg
Wireless Configuration
wireless.cfg
jndi.cfg
Jps-config.xml
Log4j.xml
External Service Integration Configuration
ext-services.cfg
service_flavors.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
AutoReplenishCapacity Batch
Usage
AutoTicketPrint 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
StoreSequenceImport 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
PurgeItemHierarchy Batch
Usage
PurgeItemRequests Batch
Usage
PurgeItemTickets Batch
Usage
Primary Tables Involved
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
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