My Oracle Support Banner

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

Last updated on APRIL 02, 2024

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

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
Goal
Solution
References


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