My Oracle Support Banner

IPM Migration Service is Exporting Date in the Wrong Timezone (Doc ID 2542668.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Oracle Imaging and Process Management - Version to [Release 10gR3]
Information in this document applies to any platform.


When using the IPM Migration Client to export input files for an Invoices application, the date format is being incorrectly exported as a day behind.

The Database format = YYYY-MM-DD 00:00:00.000
The IPM client (search results) = MM/DD/YYYY

The 12c input file  = YYYY-MM-DDT00:00:00

This configuration is producing a UTC conversion that the Input definition cannot convert back to the correct timezone.  All dates are being exported a day behind. The value is even correct in the original database, therefore the Migration Services is converting the date incorrectly in the export file.

For example, a time of 01-04-2019 12:00 is converting to 31-03-2019 1200.

Is there a way to turn off the utc format conversion? Or is there a way to convert on ingestion to convert it back to the local timezone to import the correct date?




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

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