Using Online Mode All Receipts are Stuck Pending In RCV_TRANSACTIONS_INTERFACE Table (Doc ID 1148273.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 05-Jun-2014***

Symptoms

In a new implementation find it is not possible to receipt any item from a Purchase order when Profile Option RCV: Processing Mode is set to On-line.

In Immediate or Batch mode, receive and deliver transactions are successfully processed.

In rcv_transactions_interface table the records have
TRANSACTION_TYPE RECEIVE
PROCESSING_STATUS_CODE PENDING
PROCESSING_MODE_CODE ONLINE
PROCESSING_REQUEST_ID
TRANSACTION_STATUS_CODE PENDING
SHIPMENT_HEADER_ID filled
SOURCE_DOCUMENT_CODE PO 
TO_ORGANIZATION_ID    101
DESTINATION_TYPE_CODE    INVENTORY



Steps
1. Set profile Option RCV: Processing Mode to Online
2. Navigate to Receiving / Receipts form RCVRCERC 
3. Query the PO
4. Enter receiving information. Save
5. Navigate to Transaction Status Summary form and all receipts are pending status and no errors.
 

The Receiving Transaction Manager has been bounced as per <Note 731070.1> All Receiving Transactions Fail but problem persists.
RCVCOTRX.pld has also been recompiled

When following instructions of <Note 299497.1> to debug the issue, fnd_log_messages just shows

12-JUL-2010 14:29:10    #event_name#WHEN-VALIDATE-RECORD*formname*RCVRCERC
12-JUL-2010 14:29:10    end
12-JUL-2010 14:29:10    Calling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT: p_access_mode=>S,p_org_id=>81
...

12-JUL-2010 14:29:13    Retrieving Receiving Controls from PO Shipment...
12-JUL-2010 14:29:13    p_line_location_id = 804
12-JUL-2010 14:29:13    Retrieving Receiving Controls from Item Master...
12-JUL-2010 14:29:13    p_item_id = 2001
12-JUL-2010 14:29:13    p_org_id = 101
12-JUL-2010 14:29:13    Retrieving Receiving Controls from Supplier Setup...
12-JUL-2010 14:29:13    p_vendor_id = 1002
12-JUL-2010 14:29:13    Retrieving Receiving Controls from Default Setup...
12-JUL-2010 14:29:13    Assigning default values to any unassigned values...
12-JUL-2010 14:29:13    p_order_type_lookup_code is null
12-JUL-2010 14:29:13    p_purchase_basis is null
12-JUL-2010 14:29:13    Looking up routing name...
12-JUL-2010 14:29:13    x_routing_id = 0
12-JUL-2010 14:29:13    End of subprogram.

...
12-JUL-2010 14:29:51    #event_name#WHEN-NEW-ITEM-INSTANCE*formname*RCVRCERC
12-JUL-2010 14:29:51    end


There is no inventory debug log generated

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