Hi
I understand the leave request detals are stored in the following tables
PTREQ_HEADER (Request Header)
PTREQ_ITEMS (Request Items)
PTREQ_ACTOR (Request Participant)
PTREQ_NOTICE (Note for Request)
PTREQ_ATTABSDATA (Request Data for Attendances/Absences)
Over a period of time, the size must build up. IN an organization of 200,000 employees, there must be a need for maintaining the size of this database to manageable limits. I could not find any documentation for archiving or deleting the entries in this databse. there is a report rptarqdbdel, but according to documentation this is a trouble shooting tool and must be used for individual cases only and with extreme caution.
Can any one please advise as to whether there are any tools/best practices for maintaining the size of this databse periodically? As there are several tables involved one would like to avoid having to write a custom program for this.