Vendor Funded Promotion Deals Created From RPM Has Duplicate Reporting Date In DEAL_ACTUALS_FORECAST Table (Doc ID 1959945.1)

Last updated on SEPTEMBER 02, 2015

Applies to:

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


Vendor funded promotion deals created from RPM has duplicate reporting date in DEAL_ACTUALS_FORECAST table.

Steps To Recreate:

1.       On RPM, create a promotion event lasting for days only for current month. System calendar is Gregorian.

2.       Approve promotion and attach vendor funding so that a VFP deal can be created.

3.       Check the generated Deal in the RMS and the value in the DEAL_ACTUALS_FORECAST table.

4.       Note that there are duplicate records in DEAL_ACTUALS_FORECAST table.


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