We have received a requirement from business wherein a set of records should be held in current day's batch and should be processed after 7 days of hold.
We tried sorting the records to a GDG and then use -5th version for referring the file, but in this method we are suspecting what would happen if the batch is cancelled on any day and the GDG isnt created.
As the records have current date in them, we also tried sysdate minus 7 and check the same, but we require the 7 days difference only for business days excluding weekend.
So, i would like to get some other ideas from you on this.