We are getting records stuck in the HZ_DQM_SYNC_INTERFACE table which are being created regularly.
The column STAGED_FLAG = 'E' which I presume means Error.
I have searched on Oracle support but cannot find any previous entries where someone is getting rows stuck in HZ_DQM_SYNC_INTERFACE with STAGED_FLAG = 'E'.
Can anyone shed any light on why these records would be getting stuck.
We have over 12000 records in here now and I believe it is causing issues with the DQM Serial Sync Index Program getting stuck at Pending.
Any help would be appreciated.
This is the wrong forum for this question - you need an EBiz forum or similar because DQM does not use EDQ.