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 10.1.3.6 to 10.1.3.6 [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