Bi Publisher Control file- Reference elements from another level
Hi,we are using EBS 11i and XML publisher 5.6.3.
I have an interesting challenge. We have to burst a file with the exact same name every day so that it gets overwritten.
So my thought was to create a parameter which will determine the backup file name including some date stamp and burst it to a 'backup' directory.
So far so good till I tried scheduling it (with increment date on) and then obviously my parameter generates the exact same date and time because I am using something like this
select 'my_employees_'||to_char(sysdate, 'DDMONYYYY_HH24MI_ss')||'.csv' log_file_name from dual as the default.
I have an interesting challenge. We have to burst a file with the exact same name every day so that it gets overwritten.
So my thought was to create a parameter which will determine the backup file name including some date stamp and burst it to a 'backup' directory.
So far so good till I tried scheduling it (with increment date on) and then obviously my parameter generates the exact same date and time because I am using something like this
select 'my_employees_'||to_char(sysdate, 'DDMONYYYY_HH24MI_ss')||'.csv' log_file_name from dual as the default.
0