My Oracle Support Banner

OCM Rest API Does Not Return Results In The Same Sorted Order From Instances In Different Datacenters (Doc ID 2903852.1)

Last updated on OCTOBER 20, 2022

Applies to:

Oracle Content Management - Version N/A and later
Content and Experience Cloud Service - Version N/A and later
Content and Experience Cloud Classic - Version 19.3.2 and later
Information in this document applies to any platform.


Customer uses 2 OCM services, S is the main OCM and A is replicated one from S OCM.
Content is synchronized by replicating new material from S OCM to A OCM every 30 mins.
Then, customer receive emails of "new materials update notification", that are "updated files in S OCM" and "updated files in A OCM".
These two notifications should be identical, but they are not. (However, since the contents of two regions are the same, there is no error occurred during replication.)
There may be errors in the sorting process.
When looking up the list of two regions, it is found that "A" region (replication of S OCM) has wrong order. They are not sorted correctly.

The algorithm for searching for newly updated files is as follows.

(1) Search all folders hierarchically
(2) For each folder, set the order by "last modified date" and then look up the documents in the list
(3) If the first document in the list was updated yesterday or earlier than yesterday, this folder is recognized that there is no . Then, navigate to the next folder and search for the newly updated file.
(4) If the document is and then this document is added in the e-mail content.
(5) Scan all folders to check for newly updated documents ( today) and mail the list of documents to the customer




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.