Dynamic Filename in Bursting

Hi,

I have a XML Publisher report in EBS. The output is an excel spreadsheet. I have to put this excel spreadsheet in a directory with a dynamic filename.

  I am trying to pass the filename from SQL query in data template and assign it in Bursting file. The bursting part fails. Can anyone tell me the procedure to do this please. I am using the following in my bursting file:

<?xml version="1.0" encoding="UTF-8"?>

<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi">

  <xapi:request select="/">

    <xapi:delivery>

      <xapi:ftp id="ftp1" server-alias="ftp1" remote-directory="/Marketing/FTP/Customer" remote-file="${FILENAME}" />