My Oracle Support Banner

Dealprg Deletes VFP Complex Deal That Still Has Promotions (Doc ID 1540889.1)

Last updated on APRIL 16, 2020

Applies to:

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


Dealprg deletes Vendor Funded Promotion (VFP) deals too soon before it should be as it still has promotions.

Steps to Recreate

1.Create and approve a VFP complex deal. Use that deal in RPM while creating a promotion.
2.Allow the deal to close via dealcls because the date has passed.
3.Suppose the required # of months has passed and run dealprg.
4.Since the deal will actually have a billing type of VFP, not BBVFP, the code meant to call PM_API_SQL.DEAL_PROMO_EXISTS(deal_id) to prevent deals that are on active promotions from being purged, will not work and the deal will get purged too soon.




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

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