E1: 42; Batch Ship Confirm (R42500/R47500) Allows Order with No Inventory to be Ship Confirmed (Doc ID 3037846.1)

Last updated on JULY 29, 2024

Applies to:

Symptoms

Batch Ship Confirm (R42500/R47500) Allows Order with No Inventory to be Ship Confirmed and sales order status to be updated to ship confirmed status.

STEPS TO REPRODUCE:

1. Order Type S2 (Phone Sales) does not exist in UDC 40/IU (Inventory Update Type).
   1. This order type will not relieve inventory at the time of Shipment Confirmation (P4205).
   2. This order type relieves inventory at the time of Sales Update (R42800).
2. Order Type S2 with Line Type S does exist in the Order Activity Rules (P40204)
3. Item Availability Inquiry (P41202) shows that Item NI230 has zero inventory on-hand.
4. Setup a version of Sales Order Entry (P4210) with Availability Checking turned off and with the S2 Order type.
5. Create a Sales order for the S2 Order Type for 10 of the Item with no inventory using the version with no availability checking.
6. Create a Ship Confirm (P4205) version for S2 order type with the following processing options set on the Edits tab
   1. Option #1 (Check Availability) = 1
   2. Option #2 (Ship from Negative) = 1 (Do not ship if on-hand is zero or negative
   3. Option #3 (Prevent Overshipping) = 1 (Do not overship)
7. Create Inbound Processor (R47500) Version that calls the Ship Confirm (P4205) for the S2 Order Type.
8. Create a Batch Ship Confirm (R42500) version that calls the Inbound Processor (R47500) Version
9. Run the Batch Ship Confirm (R42500) version to process the S2 order with the item with no inventory on-hand.
   1. Enter Order Number and Order Type in the data selection.
10. Check submitted jobs. R42500 and R47500 both ran.
11. Check Item Availability Inquiry (P41202).
    1. Quantity on-hand did NOT go negative
    2. Quantity was committed
    3. Quantity Available went negative
12. Check Item Ledger (P4111)
    1. Quantity was NOT subtracted in Item Ledger
13. Sales Order Status did advance.
    1. Quantity did NOT go on backorder.
    2. Quantity shows as shippable.
14. Work Center Message issues the Quantity Exceeds Available Warning (2716) but it allows the Ship Confirm transaction.

Changes

Cause

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