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.
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:
- Create a Bill Back Rebate (BBR) deal.
- Deal reporting level is week.
- Deal is Sales based.
- Run BATCH_DITINSRT.KSH
- Change vdate into date of transaction.
- Create POSU file.
- Run POSUPLD
- Run SALSTAGE
- Run PREPOST DEALACT_SALES PRE
- Run DEALACT
- Run DEALINC
- Run PREPOST DEALDAY PRE
- Run DEALDAY
- Run PREPOST DEALDAY POST
- Run PREPOST VENDINVC PRE
- Run VENDINVC
- Run PREPOST VENDINVC POST
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