RECORDS IN S_SRM_REQUEST TABLE NEED TO BE DELETED SOONER THAN 7 DAYS
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 220.127.116.11.16 [IP2014] and later
Information in this document applies to any platform.
Customer uses Server Requests Business Service to submit jobs.
The request information is stored in S_SRM_REQUEST Table. This is deleted by SvrTblCleanup Component periodically. However, this component deletes the job that are older than 7 days. This is resulting in huge number of "completed" requests (records) piling up in S_SRM_REQUEST Table.
Customer wants to know if this can be controlled - If the data in S_SRM_REQUEST Table can be deleted in fewer than 7 days?
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