My Oracle Support Banner

FAQ: Troubleshooting Stuck Pick Release and Shipping Transactions (Doc ID 863761.1)

Last updated on JULY 13, 2019

Applies to:

Oracle Shipping Execution - Version 11.5.10.0 to 12.2.1 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
Pick Release, Ship Confirm, Interface Trip Stops, Shipping Transactions Form


Purpose

To provide assistance and guidance in the resolution of some common Shipping transactions like Pick Release and Interface Trip Stops.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 1. OVERVIEW
 2. PICK RELEASE ISSUES
     2.1.   Pick Release Completes With Insufficient Available Quantity error 
         2.1.1. Sufficient on-hand quantity exists, but there is no quantity to reserve or transact 
         2.1.2  No subinventory picking order is defined, and no subinventory is specified on the order lines or on the Pick Release form, inventory tab, pick from subinventory field
         2.1.3   No default stage subinventory
         2.1.4. Item is Locator Controlled, no locator specified during pick release, and no default locator exists
         2.1.5. No open period exists for pick release
         2.1.6. Improper set-up of the Sales Order Key Flexfield in Inventory
         2.1.7. Partial shipment did not occur, because order line or lines are in a ship set
         2.1.8. An invalid subinventory was specified on the sales order line
         2.1.9. In the Pick Release form, a subinventory was defined in the Pick From subinventory field
         2.1.10.  There may be an issue in Inventory Allocations
     2.2.   Pick Release "Succeeds" but no order lines are pick released
         2.2.1. Subinventory specified as Release Criteria
         2.2.2. Specified date ranges exclude the order being picked
         2.2.3. Delivery detail has already been assigned to a delivery
         2.2.4. Pick Release using a Pick Release rule picks nothing, same criteria specified without the pick release rule succeeds
 3. SHIP CONFIRM ISSUES
     3.1  Ship Confirm errors with 'The action cannot be performed because the selected records could not be locked. '  This may also happen when attempting to auto-create a delivery for a delivery detail.
     3.2 Interface Trip Stop problems
 
     3.3. Activity instance ship_line is not a notified activity
     3.4. No delivery detail found
     3.5. Inventory Interface could not process some of the lines in the batch as they are in error status
     3.6. Interface Trip Stop Fails With Error in Routine WSH_INTERFACE.PROCESS_DETAILS, Oracle Error - 1 User-Defined Exception
     3.7. Your Change Invalidates the Customer Item Number on the Line
     3.9. Interface Trip Stop Completes Successfully But Delivery Detail Status Update Is Delayed
     3.10. ITS Error: No Serial Records Found For Transaction_Temp_Id
     3.11. ITS Error:  No Open Period Found for Date Entered
     3.12  ITS errors not resolved by the above suggestions
 4. ERRORS WITH SHIPPING REPORTS
     4.1  Error  at Ship Confirm: "The document category has no valid sequence"
 5.  SHIPPING EXCEPTIONS
 6. WORKFLOW CONSIDERATIONS
 7. DATA ISSUES
 9. RESOURCES
 9.1. Diagnostics
 9.2. INV/SHIP Profiles for Data Analysis
 9.3. Demos/White Papers/Troubleshooting Notes
 10   Training
References

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