My Oracle Support Banner

SFSCLEANUP Deletes Attachment Files Generated by BIP (Doc ID 1436009.1)

Last updated on MAY 28, 2014

Applies to:

Siebel Life Sciences CRM - Version 8.1.1 SIA [21111] to [23016] [Release V8]
Information in this document applies to any platform.


In Siebel Reports, BI Publisher generate reports. These reports are stored as attachments in the Siebel File System (base table is S_XMLP_REPOUTPT).
When the sfscleanup utility is run with delete option, the S_XMLP_REPOUTPT_*.SAF files are marked Orphans (even the valid ones) and deleted.

Steps to Reproduce
This issue can be reproduced at will with the following steps:

1. Execute the sfscleanup utility in report mode (so the files will not be deleted), e.g.:
sfscleanup /u sadmin /p sadmin /c esia81_DSN /f "\\myserver\fs" /d siebel /n Y /r Y /x "C:\clean\sfscleanup1.log"

2. All S_XMLP_REPOUTPT_*.SAF files are marked ORPHAN, e.g.:


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.