DEALINC.PC (Deal Income) Creates Wrong Records in DEAL_ACTUALS_ITEM_LOC Table for BBR Type Deals (Doc ID 2096664.1)

Last updated on JUNE 23, 2017

Applies to:

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

Symptoms

Actual Behavior
---------------
Although no sales data was uploaded for a given week, DEAL_ACTUALS_ITEM_LOC table shows actual_income as 0.0001.

Expected Behavior
---------------
The actual_income should be zero when no sale data is uploaded for a given week.

Steps to Reproduce
---------------

  1. Create a Bill Back Rebate (BBR) deal.
  2. Deal reporting level is week.
  3. Deal is Sales based.
  4. Run BATCH_DITINSRT.KSH
  5. Change vdate into date of transaction.
  6. Create POSU file.
  7. Run POSUPLD
  8. Run SALSTAGE
  9. Run PREPOST DEALACT_SALES PRE
  10. Run DEALACT
  11. Run DEALINC
  12. Run PREPOST DEALDAY PRE
  13. Run DEALDAY
  14. Run PREPOST DEALDAY POST
  15. Run PREPOST VENDINVC PRE
  16. Run VENDINVC
  17. Run PREPOST VENDINVC POST

 



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