R12: Duplicate Shipment Numbers In Purchase Order Shipment Line (Doc ID 2094819.1)

Last updated on MARCH 02, 2023

Applies to:

Symptoms

When two users simultaneously create shipments for a given PO line using the "Purchase Order" menu, it let user create the shipments with same number.

Expected Behavior

Though two users simultaneously create shipments for a given PO line using the Purchase order menu,
shipments should not be created with the same number.

Steps to reproduce:

  1. Login to application with two different users login credentials
  2. Both users - Navigate to: Purchase orders > Purchase Orders
      find an existing PO (F11 -- enter PO# Ctrl-F11)
  3. Both users - select a same line -- click on shipments -- click on new row (At this time it will auto display the next available shipment number, which would be same for both users)
  4. Both users - enter necessary shipment and distribution details
  5. First user save it, then second user save it.
  6. At this point database would store two shipments with same shipment number. This breaks reports and procurement processes.

Cause

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