My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2019

Applies to:

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

Symptoms

When no sales data was uploaded for a given week, DEAL_ACTUALS_ITEM_LOC table shows actual_income as 0.0001.

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

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
Symptoms
Cause
Solution
References


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