Sfscleanup Marks Records as Invalid For Custom Attachment Tables

(Doc ID 1621854.1)

Last updated on APRIL 02, 2015

Applies to:

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

Symptoms

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:

CX_DMS_DOCS_1-MSKPX_1-2HWKZ.SAF INVALID

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';
FILE_REV_NUM
------------------------------------------------------------
FILE_NAME
--------------------------------------------------------------------------------
1-2HWKZ
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.

Cause

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