Deliver Transaction is Not Created Automatically After Receive Transaction Although Receipt Routing is Set to Direct Delivery (Doc ID 1965991.1)

Last updated on JUNE 06, 2024

Applies to:

Symptoms

Find for one Purchase Order line there is one receive transaction but no Deliver transaction although Receipt Routing is set to Direct delivery at shipment line level.

It is expected that Deliver transaction exists automatically, that it occurs immediately after receive.

Steps to reproduce the issue
Navigate to Receipt headers Summary form / Receipt Transaction Summary
See Receive / Deliver transactions

. For line 1 there is only one Receive transaction

. Receiving Data collection output (rcv11i script) shows :

In po_line_locations_all
LINE_NUM 1
LINE_LOCATION_ID 2993985
PO_HEADER_ID 382258
PO_LINE_ID 2994298
QUANTITY 48300
QUANTITY_RECEIVED 48300
SHIP_TO_ORGANIZATION_ID 0
RECEIVING_ROUTING_ID 3    -- Direct Delivery
ORG_ID 0
CLOSED_CODE CLOSED

In po_distributions_all
PO_DISTRIBUTION_ID 3001434
PO_HEADER_ID 382258
PO_LINE_ID 2994298
LINE_LOCATION_ID 2993985
QUANTITY_ORDERED 48300
QUANTITY_DELIVERED 0

In  rcv_shipment_lines
SHIPMENT_LINE_ID 2564398
SHIPMENT_HEADER_ID 1663042
QUANTITY_SHIPPED  48300
QUANTITY_RECEIVED 48300
UNIT_OF_MEASURE Each
SHIPMENT_LINE_STATUS_CODE FULLY RECEIVED
SOURCE_DOCUMENT_CODE PO
PO_HEADER_ID 382258
ROUTING_HEADER_ID 3

In rcv_transactions table there is
TRANSACTION_ID 5085358
TRANSACTION_TYPE RECEIVE
QUANTITY 48300
UNIT_OF_MEASURE Each
SHIPMENT_HEADER_ID 1663042
SHIPMENT_LINE_ID 2564398
USER_ENTERED_FLAG Y
SOURCE_DOCUMENT_CODE PO
DESTINATION_TYPE_CODE RECEIVING
PARENT_TRANSACTION_ID -1
PO_HEADER_ID 382258
PO_LINE_ID 2994298
PO_LINE_LOCATION_ID 2993985
ROUTING_HEADER_ID 3

There is NO DELIVER transaction with USER_ENTERED_FLAG = N and ROUTING_HEADER_ID =3 as expected.

Deliver transactions is not stuck in Transaction Status Summary (rcv_transactions_interface).

Changes

Cause

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