DEALINC.PC (Deal Income batch)Creates Wrong Records in DEAL_ACTUALS_ITEM_LOC Table for BBR Type Deals
Last updated on DECEMBER 29, 2017
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
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