My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.