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:
- Run purge batches.
- 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