My Oracle Support Banner

Closing Stock Not Carried Forward Correctly To Opening Stock On Week_Data/Month_data Table (Doc ID 1597366.1)

Last updated on AUGUST 17, 2020

Applies to:

Oracle Retail Merchandising System - Version 13.2.5 to 13.2.7 [Release 13.2]
Information in this document applies to any platform.


Batch salweek is not updating Cumulative Mark On (CMO) Percentage when there are no transactions in that week.

Steps to Reproduce:

  1.  Create a new subclass and run salins batch to insert records into WEEK_DATA and MONTH_DATA
  2. For the current week (week 1) generate some transactions such that HTD_GAFS_COST < HTD_GAFS_RETAIL
  3. Move the vdate to EOW date and run salweek. Notice that the CUM_MARKON_PCT is calculated correctly
  4. In the next week (week 2), generate transactions such that it results in HTD_GAFS_COST > HTD_GAFS_RETAIL (Promotions, Markdowns, clearances etc).
  5. Close week 2 by running salweek. Notice that CUM_MARKON_PCT is copied from last week since the calculated CUM_MARKON_PCT is negative.
  6. In the following week 3, make sure there are no transactions and close the week
  7. Notice that closing stock values are correct (same as last week) but the CUM_MARKON_PCT is NULL.
  8. Close the week 4 without any transactions. Notice that CUM_MARKON_PCT is still NULL but the CLS_STK_COST is half of CLS_STK_RETAIL. The closing stock cost value has been updated even if there are no transactions in week 4.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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