E1: 42: 47: Is there a Program /Report to Identify & Recalculate Shippable (SOQS) And Backorder (SOBK) Quantity on Sales Orders After Inventory Becomes Unavailable or a Way to Reverse Inventory? (Doc ID 2911744.1)

Last updated on SEPTEMBER 09, 2024

Applies to:

Goal

Is there a program to identify all sales orders that can no longer be sourced if there is not enough available/on hand inventory? Does the program write a report showing which sales orders and items will not have enough to be sourced and also update the sales order shippable (SOQS) and backorder (SOBK) quantity fields? Can inventory be 'reserved' so it cannot be taken by another transaction?

There is a recurring problem with Sales Order and Inventory management that if another inventory transaction takes place it essentially removes the on hand/ available from committed sales orders. A report is needed to identify affected sales orders or inventory needs to be 'reserved'.

Steps to Duplicate:
1. Enter a sales order with soft committed items or take an existing order and release it from backorder as there is now enough available in the system.
2. Issue (P4112) out inventory or perform a Physical/ Cycle Count which replaces inventory counts, or Ship Confirm another order with the same item.
3. The sales order that is soft committed no longer has enough inventory to be sourced and cannot be easily identified in the system.
4. At the next step in the sales order process, the Pick Slip Print (R42520), the sales order is put on backorder again.
5. The sales order is high priority and needs to be identified as an order that no longer has enough inventory in the system to be sourced. 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.