Defects Manager - XML Publisher

Using troubleshoot page, I shall summarize the list of problems faced during xml report creation and it's resolution.

1) Leading zero issue - Invoice number can have leading zeros ("000INV1").Reporting any invoice number field in excel format can not preserve the leading zeros and display only "INV1".

Solutions -  use inbuilt function fo-bidi
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?INVOICE_NO_TAG?></fo:bidi-override>
or
Open the template and put some space before invoice number tag field.
==========================================================================

2) RTF formatting issue – Any changes to border and shading is reverting back if we close the rtf and re open it.

Solution – While changing border and shading apply it to TABLE level not COLUMN level. Changes at TABLE level will be preserved. refer below screenshots - 

                         







==========================================================================
3) OPP service failure - This issue occurs during concurrent program execution and most frequently while CP is generating any xml report and program will end in warning.
Solution -  Check with DBA and ask to up the OPP service if down or check your template. there will be few garbage character available in template, which is causing the issue.(For more details check - OPP Service post)




                                             

To be continued.......

XML Publisher - A Beginning ....

Basic steps to create BI Reports - 

1) Create the simple oracle report (rdf file) 

2) create concurrent program with executable as oracle report

3) set the output format as XML

4) run the program. output report will generate the xml tags

5) Now create Data Definition with code as concurrent program name in xml publisher admin(R)

6) create the rtf template (in word/excel/pdf)

7) use can xml tags generated in step 3 as data source to validate the output in rtf template

8) create the template with default output format and associate with created data definition and   attach the rtf file.  now run the concurrent program output will be in the specified format.