E1: 42: Ship Confirm Allows Inventory To Go Negative (Doc ID 2090099.1)

Last updated on JULY 12, 2021

Applies to:

Symptoms

Shipment Confirmation (P4205)

Batch Shipment Confirmation (R42500)

Even though the Edits Tab Processing Option #2 (Ship from Negative On-hand Quantity) is set to 1 = Do not ship from location, the program is allowing a quantity that exceeds the on-hand quantity to be shipped without issuing an error and this results in a negative quantity in inventory. This only occurs if there are two lines with the same item number and location ship confirmed at the same time. This also will only occur if Availability Checking is Turned Off and Inventory is Not Hard Committed prior to the ship confirm step in the sales order process. This will also only occur if the user ignores the warning message (2716) that does appear at ship confirm to indicate that the quantity exceeds the available.

The issue can be reproduced at will with the following steps:

1. Item Availability Inquiry (P41202) shows 6 units available in the primary location.
2. Setup a version of Sales Order Entry (P4210) with availability checking turned OFF.
3. Create a sales order (P4210) with two lines with the same item, each line with 4 units.
4. The client does not run Commitments (R42997) or Pick Slip Print (R42520) to split the line.
5. Perform Shipment Confirmation (P4205) of the two lines together using Confirm Shown Rows Form Exit.
6. The warning message (2716) does appear that the quantity exceeds the available but the user ignores the warning and completes the transaction anyway.
7. There is no hard error issued to prevent the inventory from going negative.
8. Item Availability Inquiry (P41202) shows -2 units are now available (6-8= -2)

Cause

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