Hi,
I need to burst and FTP multiple PDF files. Issue is the file names of the FTP'ed files are not changing dynamically, resulting in only one file holding the information of the last Customer (Bursting Criteria).
From the log file of the XML Publisher Report Bursting Program, I can see separate pdf files (with customer number as file name) are getting created in source location (where I have put my template RTF file), but while sending the files to the destination server, all the files goes with same name 21320159.pdf (21320159 is the 1st customer’s ACCOUNT_NUMBER). The contents within each bursted file are changing dynamically. When the Bursting Program is completed, the file 21320159.pdf has the details of the last customer (Z9000581) and this is the only file left out, as each time the same file is being over-written.
Ideally separate files have to be FTP’ed for each customer as 21320159.pdf, 440068576.pdf and Z9000581.pdf.The original XML output has 3 customers.
As I am not able to upload as attachment, please find below the contents of the Bursting Control File XHL_TEST_BURST_CTRL_FTP.xml. Please advice what is wrong with it.
Thanks Much,
Rama
PS: I am successful in using the API - "xapi:filesystem" to burst 3 PDF files as above in the local Linux Server(CM Tier) from where the Conc. program is run. I Please see below the contents of the filesystem control file (XHL_TEST_BURST_CTRL.xml).
Contents of XHL_TEST_BURST_CTRL_FTP.xml
- <xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
- <xapi:request select="/XHL_TEST_BURST/LIST_G_ACCOUNT_NUMBER/G_ACCOUNT_NUMBER">
- <xapi:delivery>
<xapi:ftp id="ftp1" server="ABC.us.oracle.com" user="${user}" password="${password}" remote-directory="/nfs/UTL/hlg4f/interfaces/out/FRSS" remote-file="${ACCOUNT_NUMBER}.pdf" />
</xapi:delivery>
- <xapi:document key="${ACCOUNT_NUMBER}" output="${ACCOUNT_NUMBER}" output-type="pdf" delivery="ftp1">
<xapi:template type="rtf" locale="" location="/tmp/FR/FRSS/XHL_TEST_BURST.rtf" translation="" filter="" />
</xapi:document>
</xapi:request>
</xapi:requestset>
Contents of XHL_TEST_BURST_CTRL
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
<xapi:request select="/XHL_TEST_BURST/LIST_G_ACCOUNT_NUMBER/G_ACCOUNT_NUMBER">
<xapi:delivery>
<xapi:filesystem output="/nfs/UTL/hlg4f/interfaces/out/FRSS/${ACCOUNT_NUMBER}.pdf"/>
</xapi:delivery>
<xapi:document output-type="pdf">
<xapi:template type="rtf" location="/tmp/FR/FRSS/XHL_TEST_BURST.rtf">
</xapi:template>
</xapi:document>
</xapi:request>
</xapi:requestset>
