Getting Wrong Value for WAC Adjustment

(Doc ID 2395154.1)

Last updated on MAY 10, 2018

Applies to:

Oracle Retail Fiscal Management - Version 14.1.3.2 and later
Information in this document applies to any platform.

Symptoms

When a PO Receipt occurs with negative on hand and on hand becomes positive, the system should generate a tran code 70 (cost variance).
The calculation for the WAC adjustment should be: (WAC prior to receipt - new PO Cost) * (SOH prior to receipt).

However, a localization function is setting 0 (zero) to "WAC prior to receipt" when SOH is negative, generating a WAC adjustment with wrong value.

Steps to Reproduce:
1. Choose an item with negative SOH.
2. Receive a PO NF with quantity greater than current SOH.
See tran code 70 generated.

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