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

Last updated on MARCH 05, 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 Recreate :

 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. Cancel 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.

Changes

Cause

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