My Oracle Support Banner

RMS Purge Batches Partition Drop Gives Errors In Golden Gate (Doc ID 2590078.1)

Last updated on SEPTEMBER 19, 2019

Applies to:

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


When RMS purge batches do a partition drop for RMS tables, the drop fails to replicate through Oracle Golden Gate with

ITEM_EXPORT_STG is purged in Pro*c batch export_stg_purge.ksh /calls the function "DATA_EXPORT_SQL.PURGE_STG.
DAILY_DATA - purged in Pro*c batch salmaint ITEM_LOC_HIST - partition by data range interval - purged in Pro*c batch hstprg.
TRAN_DATA_HISTORY is partition by data range interval - purged in Pro*c batch salprg.

The issue can be reproduced at will with the following steps:

  1. Run purge batches.
  2. 2. Observe error in partition drop replication on Golden Gate application side.




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.