Selecting stock orders and distributing on a wave is the core operation of Oracle Retail Warehouse Management System (RWMS). Highlighted in this blog are two very useful self help documents created in My Oracle Support.
When distribution is taking long time to complete the execution, below note should help with performance improvement in most cases:
What are the Recommendations on Frequency of Analyzing Tables and Rebuilding Indexes in RWMS Application? (Doc ID 362803.1)
Distribution is a complex process that must ensure compliance with numerous rules and business logics in order for the warehouse to be able to fulfill store demands. For troubleshooting purposes, Oracle has compiled a list of points to check against below note when a stock order to a store is not fulfilled as expected by distribution: What to Check When a Stock Order to a Store Does Not Get Distributed? (Doc ID 1410253.1).