ROI Wrong Value For DESTINATION_TYPE_CODE In RCV_TRANSACTIONS Table For RETURN TO RECEIVING Transactions (Doc ID 1537634.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Using Receiving Open Interface ROI, when  incorrectly inserting in RCV_TRANSACTIONS_INTERFACE table a
RETURN TO VENDOR transaction for a direct delivery receipt in only 1 step
with
TRANSACTION_TYPE = RETURN TO VENDOR
PARENT_TRANSACTION_ID = (Transaction Id for DELIVER transaction)
DESTINATION_TYPE_CODE =  'RECEIVING'

(instead of DESTINATION_TYPE_CODE = 'INVENTORY' or 'EXPENSE')

then in
In RCV_TRANSACTIONS table the Destination_Type_Code is incorrect
Transaction_Type RETURN TO RECEIVING
Destination_Type_Code RECEIVING             ---should be INVENTORY (or EXPENSE)
 
(Destination_Context is correctly set to INVENTORY or EXPENSE)

Correct value should be inserted in DESTINATION_TYPE_CODE in rcv_transactions table for TRANSACTION_TYPE  RETURN TO RECEIVING

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

A) Enter and approve standard PO  
Shipment level: Receipt Routing = Direct Delivery
Destination type = Inventory
Receive/deliver it

PO_LINE_LOCATIONS_ALL
Receiving_Routing_Id 3

PO_DISTRIBUTIONS_ALL
Destination_Type_Code INVENTORY

B) Via ROI perform RETURN TO VENDOR transaction for a direct delivery receipt in only 1 step
TRANSACTION_TYPE = RETURN TO VENDOR
PARENT_TRANSACTION_ID = (Transaction Id for DELIVER transaction)
DESTINATION_TYPE_CODE =  'INVENTORY'
following instructions of <Note 360340.1>
 
Insert
. 1 record in RCV_TRANSACTIONS_INTERFACE table with
TRANSACTION_TYPE='RETURN TO VENDOR'
PARENT_TRANSACTION_ID=5177373 (Transaction Id for DELIVER  transaction)
for a positive quantity  indicating
DESTINATION_TYPE_CODE=  'INVENTORY'
RECEIPT_SOURCE_CODE='VENDOR' and SOURCE_DOCUMENT_CODE='PO'

. Run RVCTP  

. Run Receiving data collection script for the PO
there is
Transaction_Id 5177374
Transaction_Type RETURN TO RECEIVING
Quantity 1
Shipment_Header_Id 5104911
User_Entered_Flag N
Source_Document_Code PO
Destination_Type_Code INVENTORY  --this is correct!
Parent_Transaction_Id 5177373
Routing_Header_Id 3  
Destination_Context INVENTORY

and
Transaction_Id 5177375
Transaction_Type RETURN TO VENDOR
Shipment_Header_Id 5104911
User_Entered_Flag Y
Source_Document_Code PO
Destination_Type_Code RECEIVING
Parent_Transaction_Id 5177372
Routing_Header_Id 3
Destination_Context RECEIVING

This is correct

C)  Try RETURN TO VENDOR transaction for a direct delivery receipt in only 1 step
TRANSACTION_TYPE = RETURN TO VENDOR
PARENT_TRANSACTION_ID = (Transaction Id for DELIVER transaction)
DESTINATION_TYPE_CODE =  'RECEIVING' (incorrectly)
 
Insert
. 1 record in RCV_TRANSACTIONS_INTERFACE table with
TRANSACTION_TYPE='RETURN TO VENDOR'
PARENT_TRANSACTION_ID=5177373 (Transaction Id for DELIVER  transaction)
for a positive quantity = 2 indicating
DESTINATION_TYPE_CODE=  'RECEIVING'  

. Run RVCTP  

. Run Receiving data collection script for the PO
New transactions have
Transaction_Id 5177376
Transaction_Type RETURN TO RECEIVING
Quantity 2
User_Entered_Flag N
Destination_Type_Code RECEIVING             ---should be INVENTORY
Parent_Transaction_Id 5177373
Destination_Context INVENTORY

Transaction_Id 5177377
Request_Id 6064873
Transaction_Type RETURN TO VENDOR
Quantity 2
User_Entered_Flag Y
Destination_Type_Code RECEIVING
Parent_Transaction_Id 5177372
Destination_Context RECEIVING

Destination_Type_Code is incorrectly RECEIVING for RETURN TO RECEIVING transaction.

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