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

Last updated on FEBRUARY 03, 2019

Applies to:

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

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