MARGIN_COST_VARIANCE Is Not Updated by SALWEEK (Doc ID 1937795.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.1.2.4 to 13.1.9 [Release 13.1]
Oracle Retail Merchandising System - Version 14.0 and later
Information in this document applies to any platform.

Symptoms

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:

  1. 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.
  2. Run the SALWEEK PRE and SALWEEK.PC for that EOW_DATE.
  3. Note that MARGIN_COST_VARIANCE, VAT_IN, VAT_OUT, DEAL_INCOME_SALES, DEAL_INCOME_PURCH fields are not updated.

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