Interface Trip Stop Fails with Error - "Validating transaction type 1 failed", For Return To Vendor Transactions (Doc ID 2951979.1)

Last updated on MAY 29, 2023

Applies to:

Symptoms

Problem Statement
The shipping integration for return to vendor transactions is not relieving inventory

Interface trip stop is failing with the below ERROR
-----------------------
po.plsql.RCV_WSH_INTERFACE_PKG.INTERFACE_TO_RCV.RCV_WSH_INTERFACE_PK.2923: Inserted MTI with transaction_interface_id : XXXXXXXX
INV_TXN_MANAGER_PUB: -----Inside process_Transactions-------.trxhdr=XXXXXXX
..
INV_TXN_MANAGER_GRP: Validating transaction source 0 failed
INV_TXN_MANAGER_GRP: Validating transaction type 1 failed
INV_TXN_MANAGER_GRP: Validating transaction action 0 failed
..
INV_TXN_MANAGER_PUB: All records failed after line validation
po.plsql.RCV_WSH_INTERFACE_PKG.INTERFACE_TO_RCV.RCV_WSH_INTERFACE_PK.2669: INV transaction failed
po.plsql.RCV_WSH_INTERFACE_PKG.INTERFACE_TO_RCV.RCV_WSH_INTERFACE_PK.2671: l_msg_data : All records failed after line validation

Replication Steps
1. Login to Oracle Applications
2. Navigation) Purchasing -> Receiving -> Returns -> Create a new Return to vendor transaction without a purchase order. A return order is created.
3. Navigation) Order Management -> Shipping Transactions -> Query for the Return order and Create delivery
4. Perform the ship confirm.
5. Interface Trip stop concurrent program is launched and program completes in the above Error.

Cause

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