How to schedule a report with timestamp in filename

Saturday, December 31, 2022

Requirement
Schedule a report to deliver output file with timestamp in filename so it can be differentiated

Solution
Dynamic filename can be achieved using 2 ways -

1) User delivery option manually in schedule

In this method in delivery tab, select the delivery method and use below syntex in filename - BIPReport_%y%m%d%H24%M%S.txt

2) Define bursting and use SQL method of appending timestamp in filename parameter -

'BIPReport_'||to_char(SYSDATE, 'YYYYMMDDH24MISS'||'.txt' PARAMETER5

OA - Learning