XMLP PURGE RECORDS WORKFLOW DOESN'T DELETE ALL THE REPORTS
Last updated on JUNE 05, 2017
Applies to:Siebel CRM - Version 18.104.22.168  and later
Information in this document applies to any platform.
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 22.214.171.124 only.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms