MARGIN_COST_VARIANCE Is Not Updated by SALWEEK
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Merchandising System - Version 220.127.116.11 to 13.1.9 [Release 13.1]
Oracle Retail Merchandising System - Version 14.0 and later
Information in this document applies to any platform.
In Oracle Retail Merchandising System (RMS) 13.1.x, and 14.0.x MARGIN_COST_VARIANCE is not updated by the SALWEEK batch process.
Steps to Reproduce:
- Create transactions and run the stock ledger batches to produce values for MARGIN_COST_VARIANCE, VAT_IN, VAT_OUT, DEAL_INCOME_SALES, DEAL_INCOME_PURCH for a known EOW_DATE in the DAILY_DATA table.
- Run the SALWEEK PRE and SALWEEK.PC for that EOW_DATE.
- Note that MARGIN_COST_VARIANCE, VAT_IN, VAT_OUT, DEAL_INCOME_SALES, DEAL_INCOME_PURCH fields are not updated.
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