XMLP PURGE RECORDS WORKFLOW DOESN'T DELETE ALL THE REPORTS (Doc ID 2273630.1)

Last updated on JUNE 05, 2017

Applies to:

Siebel CRM - Version 8.1.1.5 [21229] and later
Information in this document applies to any platform.

Symptoms

The customer is running XMLP purge process but it does not delete all the records. Further analyzing we could find that there is a difference in number of records between S_XMLP_REPOUTPT and S_REPOUTPT_PSTN. As per the SQLs found in the logs, XMLP purge process will only remove reports if records are present in both the tables.

The difference in records between the tables could be because the customer started using 7.x and gradual upgrades happened on the course and the current version is IP15. The table S_REPOUTPT_PSTN was introduced in 8.1.1.5 only.

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