How to Purge Records Record From The Counter Readings Open Interface Tables (Doc ID 1962725.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

How to use the Install Base - Counter Readings Open Interface program to purge successfully process records from the CSI_CTR_READINGS_INTERFACE and CSI_CTR_READ_PROP_INTERFACE tables

Oracle® Install Base User's Guide Release 12.1
Using the Counter Readings Open Interface
Page 13-3 says: If you want the processed records to be cleared from the interface tables after processing, select Yes for Purge Processed Records.

From this it could be expected that once the records in the CSI_CTR_READINGS_INTERFACE table have been processed successfully they will be removed from the interface table. In fact this is not how the program works.

Solution

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