Timestamp getting Corrupted when Consuming Message from AQ Adapter, 'Invalid date value'
(Doc ID 1607806.1)
Last updated on JUNE 23, 2021
Applies to:Oracle Service Bus - Version 18.104.22.168.0 to 22.214.171.124.0
Oracle SOA Suite - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 11gR1 to 12c]
Information in this document applies to any platform.
Timestamp getting corrupted after 11g PS6 upgrade.
When OSB proxy service is consuming the message through the AQ Adapter, the timestamp 2013-10-17T15:35:46.000-0500 has the wrong format where the COLON is missing in 0500.
Due to this, all of the messages are erroring out with "dateTime: error: date: Invalid date value".
Error seen in osb .out log:
Expected format: 2013-10-17T15:35:46.000-05:00
Upgrade from PS4 to PS6.
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