Weighted average cost (WAC) Gets Null When reciever cost adjustment (RCA) Is Done For Cancelled Items

(Doc ID 1641564.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

If as an example you created 3 items, then approved the order. When cancelling 1 item within the order and performing  Receiver Cost Adjustment (RCA) in ReIM the weighted average cost (WAC) becomes NULL. for this item in the ITEM_LOC_SOH table.

Steps to reproduce :

 

Set - BACKPOST_RCA_RUA_IND to 'Y'
 
 1. Create PO (more then 1 item)
 
 ITEM QTY COST
 1        10     1
 2        20     2
 3        30     3
 
 2. Ship Order
 
 ITEM QTY COST
 1        10     1
 2        20     2
 
 3. Receive Order
 
 ITEM QTY COST
 1        10     1
 2        20     2
 
 4. Cancell Item 3 in PO
 
 ITEM QTY COST
 1        10     1
 2        20     2
 3        0     3
 
 5. Create Invoice
 6. On Detail screen click Default from Order
 7. Change unit cost for Item 3
 
 ITEM QTY COST
 1    10   1
 2    20   2
 3    30   4
 
8. Perfrom RCA for Item 3
9. Run reimrollup
10. AV_COST for Item 3 is NULL now

 

 

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