DEALPRG Batch is Not Retrieving Closed Deals Which Has Record in DEAL_ACTUALS_ITEM_LOC Table

(Doc ID 2316831.1)

Last updated on OCTOBER 22, 2017

Applies to:

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

Symptoms

DEALPRG Batch is Not Retrieving Closed Deals Which Has Record in DEAL_ACTUALS_ITEM_LOC Table

Steps To Recreate:

1.Run Dealprg Batch.

Check the DEAL_* tables to find that the few deals which are closed are not deleted.

Batch deletes the deals which are closed and do not have records  in the DEAL_ACTUALS_ITEM_LOC  table. 

Changes

 

Cause

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