Oracle XML Publisher: Generate Skeleton XML data file from SQL

The below steps generates an XML data definition data template from an SQL statement. 

1.Define new concurrent program in EBS with required parameters.

2.Develop the SQL to fetch the data for the report.

3.Download and compile the helper PLSQL package xxxdo_generate_xml.sql

4.Execute the below script with SQL and concurrent program short name as parameters.

BEGIN xxxdo_generate_xml.generate( p_sql => '&SQL', p_conc_program_short_name => '&Concurrent_program_short_name'); END;
5.Save the DBMS output as XML data template file.

6. Upload the data template to Oracle using XML Publisher reponsibility

7. Submit the concurrent request to make sure that XML output is being generated.

The next step is to develop the layout. This is quiet userful to rapidly develop XML publisher reports from relatively simpler SQL.