I'm trying to fetch customer data from R12 EBS using DB Adapter. I could fetch the data and I could see in XML Format in EM. Now my requirement is is to get that data in CSV format.
I used File adapter with Write Operation and Assigned the DB Adapter Output variable to File adapter input variable. In the File adapter wizard I have mentioned the File naming convention as Customer.csv.
When I deploy the process Customer.csv file is created but the content in it is in XML format not in CSV format.
In a brief not my requirement is Fetching data from EBS using DB Adapter and Write it into CSV file using File Adapter.
Please help me.
You have to use Native XSD format for converting the XML structure into the respective CSV file format.
If you could paste the XML structure, then we could convert it into a native xsd format, which you could use in your File Adapter then.
You have to use native XSD (NXSD) in your outbound file/ftp adapter to achieve this. For CSV files, we have to use nxsd:terminatedBy="," nxsd:quotedBy='"' in the nxsd structure. The adapter wizard will help you generate this nxsd.
Hope this helps.
Edited by: 840696 on Dec 31, 2012 12:42 AM
Edited by: 840696 on Dec 31, 2012 12:45 AM