| Multiple Excel output files [message #538232] |
Wed, 04 January 2012 15:17  |
Apps11i
Messages: 14
Registered: August 2008
|
Junior Member |
|
|
Hi,
I need a help in generating the multiple Excel output's. can some one please guide me how to implement it?
I am generating the XML file using plsql program.
XML Syntax:
<?xml version="1.0"?>
<XXGRPDIV>
<customer Num>1000</customer Num>
<Divisions>
<Division>10001</Division>
<Add1>123street</Add1>
</Divisions>
<Divisions>
<Division>10002</Division>
<Add1>456street</Add1>
</Divisions>
<Divisions>
<Division>10003</Division>
<Add1>789street</Add1>
</Divisions>
<Divisions>
<Division>10004</Division>
<Add1>1111street</Add1>
</Divisions>
</XXGRPDIV>
in the above XML file i have one customer with four sites (Divisions).
i want to create a separate excel output sheet or file for each Division. How do i achieve the requirement?
I tired bursting concept but didn't work. (Might be am making mistake in control file. I can provide you if you would like to look). I need to generate the file but not required to send an email.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
