Friday, February 6, 2015

Build a Data Definition & XML Template using XML Publisher.


1.Install this XML Publisher Desktop software on your pc, ensuring that you have MS-Word installed(for this demo)
The XML Builder Desktop Patch for Word is Patch Number: 4561835
This software can be downloaded from 
http://updates.oracle.com/download/4561835.html

This is a tool given by Oracle[Desktop XML Publisher] that will read any XML file, will create the fields automatically. 

2. Open MS Word after installing as per step 9, and you will now see something similar to below in Microsoft Word

Now in MS Word, click on “Load XML Data” and select file XX_MANAGERS_241106.xml that was created in our previous Step 8.(In Part A
  : Create a report and register it as Concurrent Program of type XML).

Image


Image

11. Now, click on Insert/Table Form
And then drag and drop “List G Manager No” within the template section and click on OK. 

Image


Effectively by doing these steps, you have just created a Layout for the report in XML Publisher. The layout will look like this [as below].
Image

Save this MSWord file as MANAGER_XML_TEMPLATE.rtf

By clicking on Preview, you will see the output.

12. Now, lets do the real bit in attaching the Concurrent Program definition to XML .
Publisher. Logon to responsibility “XML Publisher Administrator”.
Image

Click on “Data Definition” menu as above…so that we can create the XMLs source data Definition. Effectively we are saying that output of the Concurrent program becomes the data definition for XMLP.

Lets define the value in below fields 
Name : XX_MANAGERS
Application : Receivables
Code : XX_MANAGERS  [Note: This is the short name of the Concurrent program]
Start Date : Leave it to default Sysdate
Click on “Apply”
Image


No comments: