My Oracle Support Banner

Sfscleanup Marks Records as Invalid For Custom Attachment Tables (Doc ID 1621854.1)

Last updated on MARCH 01, 2018

Applies to:

Siebel CRM - Version [21238] to [IP2013] [Release V8]
Information in this document applies to any platform.


There is a custom table (CX_DMS_DOCS) created for attachments in the repository. The table has the file property set.
Attachments linked to this table are created.
When calling sfscleanup utility, all attachments for this table are shown as INVALID like:


In the Database, the record is existing:

select FILE_REV_NUM, FILE_NAME from CX_DMS_DOCS where row_id='1-MSKPX';
SQL> select FILE_REV_NUM, FILE_NAME from CX_DMS_DOCS where row_id='1-MSKPX';
3. Mail Danish Crown ******************

On other test environments this also occurs for another CX table.
This makes it impossible to use sfscleanup for housekeeping.
It looks like sfscleanup does not know of this table.


To view full details, 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 a vibrant support community of peers and Oracle experts.