TSFDETAIL.TSF_PRICE Populate Wrongly For Inter Company (IC) Transfer While Using RMSSUB_XTSF.CONSUME Package

(Doc ID 2276617.1)

Last updated on JUNE 22, 2017

Applies to:

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

Symptoms

TSFDETAIL.TSF_PRICE populate wrongly for IC transfer when using RMSSUB_XTSF.CONSUME Package Try using the RMSSUB_XTSF.CONSUME procedure to create the Transfers for E-Commerce Orders, notice the TSFDETAIL.TSF_PRICE populate wrongly if system have more than one Items in IC transfers.This procedure populate the average cost of first Items to the remaining Items.

Steps To Recreate:

1. Call the RMSSUB_XTSF.CONSUME procedure with more than one Items for Warehouse to Store transfer.
2. Check the Transfer type for the new transfer created by the package. Transfer type should be 'IC'.
3. Check the TSFDETAIL.TSF_PRICE for all the Items.
4. TSFDETAIL.TSF_PRICE populated same for all the Items but TSFDETAIL.TSF_PRICE should be AV_COST of each Items.

Changes

 

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