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

Last updated on MARCH 08, 2017

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

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