My Oracle Support Banner

Interface Trip Stop Errors With ORA-20000: Source Requested Quantity ( 1 ) Does Not Match Ordered_Quantity ( 4 ) On Order Line (Doc ID 2827887.1)

Last updated on FEBRUARY 23, 2022

Applies to:

Oracle Shipping Execution - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On :  12.2.8 version, Open Interfaces & Public APIs

When attempting to order line status shows entered while the delivery status shows
Shipped/Run Interfaces and the following error occurs.

OBSERVATION
--------------------
Processing Message(s):
ATP Process resulted in no data
User-Defined Exception in Package OE_SCHEDULE_UTIL Procedure Load_Results_from_rec
User-Defined Exception in Package OE_SCHEDULE_UTIL Procedure Load_Results_from_tbl

ERROR
-----------------------

API Process_Stop_To_OM failed with an unexpected error
The unexpected error is ORA-20000: Source requested quantity ( 1 ) does not match ordered_quantity ( 4 ) on order line nnnn136
ORA-06512: at "APPS.WSH_CATCH_CCORRUP_DATA", line 17
ORA-04088: error during execution of trigger 'APPS.WSH_CAT
UNEXPECTED ERROR IN Process_Stop_To_OM
Unexpected error has occured. Oracle error message is
ORA-20000: Source requested quantity ( 1 ) does not match ordered_quantity ( 0 ) on order line nnnnn36
ORA-06512: at "APPS.WSH_CATCH_CORRUP_DATA", line 17
ORA-04088: error during execution of trigger 'APPS.WSH_CATCH_CORRUP_DATA'
Exiting WSH_SHIP_CONFIRM_ACTIONS.PROCESS_STOP_TO_OM - EXCEPTION:OTHERS
Rollback to savepoint l_interface_om
Process_Stop_To_OM l_return_status ==> U
Actual Departure Date of Trip Stop in batch xxxxxx is a future date
Actual Departure Date of Trip Stop is a future date ==> 11/17/2021 12:00:00 AM



STEPS
-----------------------
1. Responsibility: Order Management Super User
2. Order Organizer > Query Sales Order nnn779
3. Header: Booked
   Header WF: Close - Order Close - Wait For Line Notified
4. Line 1.1 > Awaiting_Shipping > Ordered Qty = 0 > Delivery Detail ID: nnnnn47
   Line WF:   Ship - Line, Manual Ship Notified
   Line 2.1 > Awaiting_Shipping > Ordered Qty = 4 > Delivery Detail ID: nnnnn47
   Line WF:   Ship - Line, Manual Ship Notified
5. Observer: Line 1.1 > Shows Sales Order Process Message(s) above
6. Interface Trip Stops Program > Shows ORA-06512: at "APPS.WSH_CATCH_C

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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