XML Publisher

XML Publisher
---------------------
xml publisher is a report generated utility tool. now a days we
are calling it as bi publisher. The main difference between bi and xml publisher is : xml publisher
is integrated with oracle apps.but bi publisher is stand alone edition.
we can utilize it in other applications like sap,people soft,obrm

(oracle billing revenue management). etc.
we can run the report into multiple output formats like

pdf,excel,html,rtf,.if we require report output into 3 output formats
we don’t need to run 3 times.we can run the report once.and we can
republish into various output formats.
bi publisher version are 10g,11g
xml publisher versions are 5x,10x
->BI/XML Publisher allows customer ready documents such as financial

statements,marketing materials,invoices,purchase orders directly from
the ebusiness suites.we can develop the xml publisher report from
various data sources like’s rdf,data template,oaf etc.
-->we can use bursting feature to split the output into various logical
parts and sending email to related users.
->to develop xml publisher report,we need to install
window 3 installer(someper(some times only requied). xml/bi publisher
desktop edition. times only required),JRE(java run time environment)
.net 2.5 frame works develop.
We need to restart the system ,then only it will reflect.

we can see extra plug into mircrosoft word document.
xml publisher points
---------------------------
2).xml Publisher using RDF builder and registration into oracle apps
-------------------------------------------------
1)create rdf without layout model(if layout model exists
also not a problem but if we remove any columns from the
query which we are already assigned to any one of the text file.it will give run
time issues)
2) deploy the rdf report into oracle applications custom top
by using any FTP
3) go to system administrator
create executable by taking method as oracle reports.
4) create concurrent program-- format-- xml
5) attach it to request group
6) submit it from our responsibility.
we can see the output into xml tags.
save as .xml
(go to file -->save as -->choose save as type as .xml files.
file name.xml
if done symbol then only we need to save.if we see the done
symbol with warning state at the bottom in the internet explorer,we need to rectify
the issue .)
7) create RTF by using this .xml file
8) go to xml publisher administrator responsibility

data definition
Name -- any name related to your report

-- it is not visible to user
code-- concurrent program short name .
it is case sensitive
application -- custom application
start date -- enter <=sysdate
end date -- to inactive the data definition we can use
- for time being not required.
copy the data defination name
9) go to templates
click on create template.
template name : it is visible to user.enter some

meaningful name which is visible to user.
code : no need to enter concurrent program short name,
do not keep any space.otherwise it will give errors
while migrating from one instance to other instance.
application : custom application

type-- RTF
click on browse ,upload RTF
mention the language as english
territory as united states.
its mandotory in 11i in r12 it is optional.
click on apply.
10)switch responsibiity to your responsibility
submit the program
first time do not use copy button.it will fail to pick up
the template.next time onwards we can use copy button.
3.Repeating headers for each and every page
--------------------------------------------
It acts as display all pages property in d2k reports
it is applicable only for pdf and RTF & not for html and excel
when we take user defined tables ,we need to set this option otherwise we can not
see
the titles for every page other than first page.
first select the header row of the table.right click table properties->row tab->
check the check box of "Repeat as header row at the top of each page"....
3.buliding layout based on wizard

----------------------------------
first load xml data.->go to data->load xml data

to insert the table ,go to template builder->insert->table/form-->wizard
to insert the column,go to template builder->insert->field
table properties
------------------
to insert new row,place the cursor at the end of the table,press enter
or keep the cursor in to the last column ,press tab
to introduce new column,select the column,right click,split cells
to combine the multiple columns-->select the columns-->right click merge cells
to maintain only borders for table..or for columns we need to change the borders
propety
select the table-->right click--->broders and shading..
we can use this feature for all like table,text,column,paragraph..

4)xml page can not be displayed
It is error ..mainly caused by the spaces

in xml tags in formula columns and place holder columns.
eg: with holding tax by invoice report.
available in payables responsibility.
steps
-----
submit report ,copy the error tag below the xml
page can not be displayed.
go to rdf,object navigator,enter the tag
find-->it will show the column,go to property pallette
-->remove the spaces or fill with underscores in xml
tag.
it is error...after submitting the report we can see the below error some where in
the output
The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click
the Refresh button, or try again later.
--------------------------------------------------------------------------------
Missing equals sign between attribute and attribute value. Error processing resource
'http://apps.ora.com:8000/OA_CGI/FNDWR...
<AP WITHHOLDING TEMPLATE REPORT></AP WITHHOLDING TEMPLATE REPORT>

------------------^
to fix this copy the tag,downolad RDF,select the column,f4,remove the space
in the xml tag name or fill with underscores.
usually this issue raised because of the space in xml tags, an will happen with
formula columns and place holders columns..some times because of the data also..
if any data consists of junk characters it will give this error...
5) section break/Page Break or each master record needs to start at freshly on starting of the
page
--------------------------------------------------------------business requirement
some times business wants suppliers needs to start from the starting of the page
to send the hard copies to different suppliers .we can use page break before
ending of the main group.
go to insert->break->page break
or else control +enter
while using the above feature,we need to use the page reset property.
to reset use the section keyword for the main group like below.
<?for-each@section:g_supplier_details?>
6)Number format
----------------
to apply the number format.
select the field in the rtf->double click,change type to number from regular text,
select the number format as #,##0.00.provide the default number as 9,990.00.
or else double click on the text field.go to add help text.go to status bar/help
key.
select type your own-->write the following syntax.
<?format-NUMBER:AMOUNT_PAID;'999G990D99'?>
7.sub total,grand total

--------------------------
take one summary column inside of the main group end for each.
place the cursor at the end of the table,enter,it will create one new row.
copy paste the amount field xml tag.double click on it.go to add help text.
use the sum function like below.
<?sum(inv_amt)?>
or else
create one new row.place the cursor in that new column,
go to template builder->insert-->field-->select your column->select sum in
calculation-->click
on insert..
to display grand total->use the summary column outside of the main group.
08)NaN-- Not a number

---------------
it is one error,will occur in doing the calculations on null values.
sol1: use NVL in the query part.eg: NVL(invoice_amt,0)
or go to RDF builder Data model
-->select the column-->F4-->enter '0' in place of "value if null"

XML Publisher

Uploaded by

Copyright:

Available Formats

XML Publisher

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

XML Publisher

Uploaded by

Copyright:

Available Formats

XML Publisher

we can utilize it in other applications like sap,people soft,obrm

we can run the report into multiple output formats like

->BI/XML Publisher allows customer ready documents such as financial

We need to restart the system ,then only it will reflect.

8) go to xml publisher administrator responsibility

Name -- any name related to your report

copy the data defination name

template name : it is visible to user.enter some

application : custom application

3.buliding layout based on wizard

first load xml data.->go to data->load xml data

select the table-->right click--->broders and shading..

we can use this feature for all like table,text,column,paragraph..

It is error ..mainly caused by the spaces

available in payables responsibility.

The XML page cannot be displayed

<AP WITHHOLDING TEMPLATE REPORT></AP WITHHOLDING TEMPLATE REPORT>

7.sub total,grand total

08)NaN-- Not a number

You might also like