1,151 total views
There could be scenarios where in the client needs the report output in XML format and that XML file will be sent to some third-party vendor and it will be imported to their legacy systems for other processing. And the vendor might expect the XML file with some pre-defined tags for the attributes for them to process the files and in turn we will be asked to generate an XML file with specified tags.
The Normal XML output of a data model will have the <DATA_DS> as the starting tag, and the other tags can be created by adding dataset with the specified name and selecting the attributes in the SQL with these alias names.
However, we will not have control over the main tag which is <DATA_DS> and we cannot control it using the SQL.In order to modify the XML tag from DATA_DS to INVOICE we need to follow the below steps:Data Model after the SQL has been added:
We can see that except the first main tag, all other tags are set using the Data Set Name and Attributes.Now click on Structure tab:
We can see there is an option to override the XML tag names for main data set and it’s children and attributes.Now we will change the tag name to INVOICE as per the requirement and save it.And then go to Data Tab and click on export, it should export data to an xml file and it should look like below:
In this way we are able to change the XML tag names with a simple configuration change in the Data Model properties.
If you have any questions, please feel free to reach out to me by posting in comments section.
If you are interested in learning Fusion Technical tools go through this post
If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.
Latest posts by Sricharan Monigari (see all)
- Renaming HCM Extracts is a possibility from 20D - November 24, 2020
- Sangam20 – Oracle Users Group Conference - November 23, 2020
- Passing Parameter values from Flow Instance to HDL Transformation Formula - November 23, 2020
- Solve manual FTP server update issue for HCM Extracts post every P2T refresh - November 16, 2020