Date Fields Losing Seconds Precision When Updating Metadata (Doc ID 2197433.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle WebCenter Content - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Goal

When the service UPDATE_DOCINFO is called to update some metadata of a document, the date fields dCreateDate and dInDate as well as all custom date fields lose their seconds precision.

The dates are simply truncated at minute level. This bug is addressed in bugs 21116421 and 18551978, but none of them are solved.

The bug causes problems, because the check-in order can no longer be determined on dInDate. Also we use date fields to compute throughput/performance and losing second precision severely blurs the results.
 

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