My Oracle Support Banner

Incorrect WAC Calculation For Catch Weight Items Receipts (Doc ID 2189303.1)

Last updated on OCTOBER 07, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.1 to 13.1.9 [Release 13.1]
Information in this document applies to any platform.


An incorrect weighted average cost (WAC) is being calculated at item level for  receipts/transfers for catch weight items.

It should use rather the nominal case weight of actual supplier delivering the goods

Steps To Recreate:
1. Create a catch weight pack of 4 for catch weight item using 2 suppliers each with different net weight.
2. Create an order with 25 unit of pack and approve it.
3. Ship and receive the order.
4. Note that the total cost posted in TRAN_DATA is with the nominal case weight of the primary supplier rather than the nominal case weight of actual supplier delivering the goods.




To view full details, 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 a vibrant support community of peers and Oracle experts.