Go to primary content
Oracle® Retail Store Inventory Management Operations Guide
Release 15.0
E65670-03
Next
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