What is the dCpdIsDirtyLink field in the CPDLINKS table? What does it signify when an item has it set to 1?

(Doc ID 2327627.1)

Last updated on NOVEMBER 13, 2017

Applies to:

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

Goal

On a Content Server with the ContentFolios component enabled, notice that the indexing process query the CPDLINKS table and then the WebCenter Content (WCC) fetches the result. The result of this query returns a huge number of rows. The resultset matches all the rows of CPDLINKS table with dCpdIsDirtyLink equal to 1.

What is the dCpdIsDirtyLink in the CPDLINKS table? What does it signify when an item has it set to 1? At what event does the trigger change into the CPDLINKS table? What action(s) will clean up this table and the associated IsDirty flag?
 

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