RTV Cancellation Not Sending Stock Adjustment To SIM (Doc ID 2914720.1)

Last updated on DECEMBER 15, 2022

Applies to:

Goal

In RFM 14.1.3.2

RTV Cancellation not sending stock adjustment to SIM

When cancelling an Return To Vendor already approved in RFM, RFM is not sending a Reason code for inventory adjustment to restore stock in SIM.
What is happening nowadays is:

IN package FM_STOCK_REVERSAL_SQL, function CLOSE_RTV, RFM is changing the RTV status to 20 (Cancelled) which sends a RTV cancellation to RIB and subsequently to SIM, but this cancellation is not processed in SIM because RTV is already dispatched.

When sending reason codes to origin (SIM), RFM package FM_SIM_INTEGRATION at function CALL_INVENTORY_ADJ_WS uses the function FM_UTILS.GET_MODE_TYPE_INVADJ to get mode_type for reason code that will be sent to SIM in order to restore the stock.
But the function GET_MODE_TYPE_INVADJ uses the cursor C_CHECK_DNF_ADJINV which only searches for DNF and STOCK.

As we can see, there is no mapping of RTV reason codes to be sent to SIM in order to restore the stock.
And the RTV cancellation in RTV_HEAD is not working because SIM does not process the message, once this cancellation is only a status update and does not reverse the stock because RTV is already dispatched.
 

Solution

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