My Oracle Support Banner

Interface Trip Stop Program Completing In Error For Return To Vendor Transactions -The transaction quantity XX in primary unit of measure exceeds the available quantity XX (Doc ID 2764907.1)

Last updated on APRIL 05, 2021

Applies to:

Oracle Inventory Management - Version 12.2.7 and later
Information in this document applies to any platform.
INV_TXN_MANAGER_PUB: *** SQL error ORA-01403: no data found

Symptoms

Return To Vendor Transactions are Successfully Interfaced in WSH but the transactions are stuck in Pending Status in the Shipping Transaction Form.

The ITS program completes in error.

There are transactions in Shipping Side which are completed, but the Next Step being shown as Run Interfaces.


Sufficient on hand exist in the source sub inventory
PO_INTERFACE_ERROR shows
The transaction quantity 155 in primary unit of measure exceeds the available
quantity 34
From somewhere system is picking up 34 quantities

Below is the ITS error Log

[27-JAN-21 04:26:52]
po.plsql.RCV_WSH_INTERFACE_PKG.RCV_WSH_INTERFACE_PK.1436: Checking for
completely processed WDDs
[27-JAN-21 04:26:52]
po.plsql.RCV_WSH_INTERFACE_PKG.RCV_WSH_INTERFACE_PK.1437:
-------------------------------------------
[27-JAN-21 04:26:52]
po.plsql.RCV_WSH_INTERFACE_PKG.RCV_WSH_INTERFACE_PK.1440: Picking RT
interfaced WDDs
[27-JAN-21 04:26:52]
po.plsql.RCV_WSH_INTERFACE_PKG.RCV_WSH_INTERFACE_PK.1451: Picking MMT
interfaced WDDs
[27-JAN-21 04:26:52]
po.plsql.RCV_WSH_INTERFACE_PKG.RCV_WSH_INTERFACE_PK.1478: l_case_5_status
=> S
[27-JAN-21 04:26:52]
po.plsql.RCV_WSH_INTERFACE_PKG.RCV_WSH_INTERFACE_PK.1487: Leaving
interface_to_rcv : p_delivery_id => 367308, p_return_status => E
Return status after calling RCV API ==> E
Entering WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (WSHDDSHB.pls
120.35.12020000.16) (01/27/2021 04:26:52 AM)
p_batch_id ==> 416637
flag ==> FALSE
Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (01/27/2021 04:26:52
AM, 0 seconds)
Number of records fetched by get_details is ==> 1
NEW TRANSACTION_HEADER : 4413972
Number of records fetched by l_get_picking_ln_id_csr is ==> 0
Entering WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV (WSHDDSHB.pls
120.35.12020000.16) (01/27/2021 04:26:52 AM)
batch_id ==> 416637
P_TRANSACTION_HEADER_ID ==> 4413972
No of record fetch ==> 0
l_bulk_batch_size ==> is NULL
l_def_inv_online ==>
No Delivery Detail Found ==> is NULL
Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV (01/27/2021
04:26:52 AM, 0 seconds)
Interface_Detail_To_Inv l_inv_inter_status ==> S
Entering WSH_SHIP_CONFIRM_ACTIONS.PROCESS_INV_ONLINE (WSHDDSHB.pls
120.35.12020000.16) (01/27/2021 04:26:52 AM)
p_batch_id ==> 416637
P_TRANSACTION_HEADER_ID ==> 4413972
Number of rows updated ==> 0
Current Time is ==> 01/27/2021 04:26:52 AM
RIGHT BEFORE CALLING MTL_ONLINE_TRANSACTION_PUB.PROCESS_ONLINE
TIMEOUT VALUE: 1200
Calling program unit MTL_ONLINE_TRANSACTION_PUB.PROCESS_ONLINE
[27-JAN-21 04:26:52] INV_TXN_MANAGER_PUB: -----Inside
process_Transactions-------.trxhdr=4413972
[27-JAN-21 04:26:52] INV_TXN_MANAGER_PUB: Inv Batch size:0
[27-JAN-21 04:26:52] INV_TXN_MANAGER_PUB: MTI Rows cnt before Validation=0
[27-JAN-21 04:26:52] INV_TXN_MANAGER_PUB: *** SQL error ORA-01403: no data
found

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
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.