Archive Schedule in APCC
Hello,
What would be the best way to archive APCC plans with Oracle concurrent scheduler (Schedule option we get while launching concurrents in apps) when having below requirements:
1. ASCP plan runs everyday, APCC should also archive summary for this plan everyday. While archiving plan, previous days summary should be overwritten.
2. Summary archived on 1st day of a month should not be overwritten (to retain monthly archives)
3. 'Purge Plan Summary' program should be triggered every month to purge 6 months prior plan summary. e.g. In Feb-17, Purge Plan Summary should purge plan archived in Aug-16.
We do not have any external scheduling tool currently and are exploring ways to achieve this using Oracle basic scheduler. Any pointers to achieve this are welcome!