RTV Retrieving Incorrect Unit Cost (Doc ID 1902674.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle Retail Merchandising System - Version 12.0.11 and later
Information in this document applies to any platform.

Symptoms

The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

The unit cost is used to evaluate the cost of the Return to Vendor (RTV) goods. The cost values on RTV tables are written in supplier currency, but all TRAN_DATA records are written in location currency.

In this case, the following options are available for RTV unit cost:

1. Use the unit cost on the RTV message if defined. It is in location currency.
Otherwise,
2. Use RTV_DETAIL.unit_cost if exists. It is in supplier currency.
Otherwise,
3. Use the last receipt cost if exists. It is in location currency.
Otherwise,
4. Use item's WAC at the location. It is in location currency.

There is no unit cost defined in the RTV message or an existing RTV record in rtv_detail so option 1 and 2 do not apply.
So left with option 3 but if one has multiple receipts on the same day with different unit costs, the issue is that is not getting the last receipt's unit cost.  

Currently it is selecting max(sh1.receive_date) on the shipment (sh1) table and should probably also include the sequence to get the latest. 

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