My Oracle Support Banner

Install Base - Counter Readings Open Interface Report Shows Wrongly Formated Dates (Doc ID 2137453.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Goal

Install Base - Counter Readings Open Interface is displaying date wrongly when launched using fnd_request.submit_request.

The output report shows from date and to date in a wrong format.

For Example:

From Date :16-03-0028 12:00:00
To Date :16-03-0030 12:00:00

Launched the program as follows.

fnd_request.submit_request (application => 'CSI'
  ,program => 'CSICTRML'
  ,description => NULL
  ,start_time => NULL
  ,sub_request => FALSE
  ,argument1 => c_meter_import.batch_name
  ,argument2 => SYSDATE - 1
  ,argument3 => SYSDATE + 1
  ,argument4 => 'Y'
  ,argument5 => NULL);

Concurrent program is getting launched properly however no records are getting processed.

It was noticed, from date and to date are completely messed up even though sysdate was passed as parameter.

CSICTRML: Install Base - Counter Readings Open Interface
+---------------------------------------------------------------------------+

Current system time is 29-MAR-2016 14:21:49

+---------------------------------------------------------------------------+

**Starts**29-MAR-2016 14:21:50
**Ends**29-MAR-2016 14:21:51
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
From Date :16-03-0028 12:00:00
To Date :16-03-0030 12:00:00
Record count is : 0
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
 

Solution

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
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.