Question Locked

XML Publisher in Oracle APPS

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

There is a requirement to create a XML Publisher report.I have developed a report in Reports 61i.Then I have created a template in RTF,mapped the XML Tags.But I heard that this a old way of doing it.Is there any way to create a template without using reports 6i.Please help.Thanks in advance

Thanks

3 replies

by priyaranjan53

Hi,
Instead of using reports6i,you can do it in Apps.steps are as follows
goto application developer
In concurrent ->program->define change the output type as XML.
now run the concurrent program->open the output window->now save as XXX.xml->open the word file(XML desktop has to be installed)->load data->select the list of tables or fields that is required->do whatever modification u need(like if u need to calculate total groupwise then use the tags )->then view the output in wordfile->and save as xxx.rtf format->goto XML publisher administrator responsibility->goto data definition->(give data definition name and concurrent program short name)->goto templates-select the data definition already created->select xxx.rtf templete->select output type as pdf and save it.

run the concurrent program->now u will get the desired output.

by schinchod

Template builder has a feature to connect to database where you can specify a SQL statement and template builder will load XML into the memory and you can design the RTF template.

This discussion is closed to new replies.