Discrepancies On SHRINKAGE_RETAIL Calculation Field in Stock Ledger MONTH_DATA Table (Doc ID 2066644.1)

Last updated on MAY 01, 2017

Applies to:

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

Symptoms

Discrepancies on SHRINKAGE_RETAIL calculation field in Stock ledger while following below steps:

1. Create price change in RPM.
2. Check tran_data for tran_code 11 entry, verify that VAT is not included in the values of TOTAL_RETAIL, OLD_UNIT_RETAIL , NEW_UNIT_RETAIL.
3. Run pos upload (posupld) for a sale before the cost change.
4. Posupld process will create new type of movements (13, 14) in TRAN_DATA table in order to reverse the respective RPM movements where it happens subsequently, including VAT for item location.

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