Internal Sales Order Shipments Are Stuck In RCV_TRANSACTIONS_INTERFACE For Online Transactions (Doc ID 1386797.1)

Last updated on SEPTEMBER 04, 2014

Applies to:

Oracle Inventory Management - Version 12.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 04-SEP-2014***

INV_TXN_MANAGER_PUB - INVTXMGB.pls


Symptoms

In Oracle Inventory Applications, Internal Order shipment transactions were getting stuck in Receiving Interface table with status PENDING / ONLINE / PENDING

ERROR
---------
INTERFACE_TRANSACTION_ID GROUP_ID PROCESSING_STATUS_CODE PROCESSING_MODE_CODE TRANSACTION_STATUS_CODE INTERFACE_SOURCE_CODE
54289234 31663088 PENDING ONLINE PENDING ORDER ENTRY
54289235 31663088 PENDING ONLINE PENDING ORDER ENTRY
54289236 31663088 PENDING ONLINE PENDING ORDER ENTRY
54289237 31663088 PENDING ONLINE PENDING ORDER ENTRY
54289238 31663088 PENDING ONLINE PENDING ORDER ENTRY
...
...

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Ship confirm both Internal order shipments and Sales order.
(Test the cases when both SO and ISO transactions are part
of the same delivery and when they are not)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms