My Oracle Support Banner

Install Base - Counter Readings Open Interface is not Picking up Records for Processing (Doc ID 2708755.1)

Last updated on SEPTEMBER 08, 2020

Applies to:

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

Symptoms

On 12.2.8,

Install Base - Counter Readings Open Interface is not picking up records for processing when the From Date and To Date passed is same as the source_transaction_date of the record in interface table.

e.g: In interface table CSI_CTR_READINGS_INTERFACE, record is present with source date as 17-JUL-2020.
When the program is run with date range as 17-JUL-2020 to 17-JUL-2020, the record is not picked up for processing.
It is only picked up when date range is 16-JUL-2020 to 18-JUL-2020. Ideally, the record should be picked up in first case also as the source date is 17th Jul.

Steps:
================
1. Run Install Base - Counter Readings Open Interface program with same From Date and To Date parameters

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.