XML Publisher Interview Questions and Answers

.     What are the XML publisher tables.

Ans>PER_GB_XDO_TEMPLATES
XDO_DS_DEFINITIONS_B
XDO_DS_DEFINITIONS_TL
XDO_DS_DEFINITIONS_VL
XDO_LOBS
XDO_TEMPLATES_B
XDO_TEMPLATES_TL
XDO_TEMPLATES_VL
XDO_TEMPLATE_FIELDS
XDO_TRANS_UNITS
XDO_TRANS_UNIT_PROPS
XDO_TRANS_UNIT_VALUES

2.     how to create report with out .rdf?

Ans> Using Data template…..see below link

http://appstechnical01.blogspot.in/2012/08/using-multiple-quires-data-template-code.html

3.     how to write a loop in rtf template design ?

Ans> <?for-each:G_invoice_no?>

     ……………………..<?end for each?>

4.     how to design  sub templates in rtf layout ?

Ans> using following tags..

                <?template:template_name?>

                      This is Last Page

                               <?end template?>

5.     how to call a header or footer ?

          Ans> using this tag <?call:header?> and <?call:footer?>

                We have to use header section and footer section of the page.

6.     How to break the page in specific condition ?

Ans>  <?split-by-page-break:?>

7.     How to use section break ?

Ans>  <?for-each@section:G_CUSTOMER(This is group name)?>

8.     How to create multi layouts in XMLP ?

        Ans>  using below conditions

              < ?choose:?>

               <?when:CF_CHOICE=’VENDOR’?>

            Your template….

               <?end when?>

                   <?when:CF_CHOICE=’INVOICE’?>

                Your template….

              <?end when?>

                           <?when:CF_CHOICE=’RECEIPT’?>

                              Your template….

                    <?end when?>

                                              <?end choose?>

9.     How to calculate the running total in XMLP?

Ans>           <?xdoxslt:set_variable($_XDOCTX, 'RTotVar', xdoxslt:get_variable($_XDOCTX, 'RTotVar') + ACCTD_AMT(This is                                                column name) )?><?xdoxslt:get_variable($_XDOCTX, 'RTotVar')?>

10.   How to submit a layout in the backend ?

       Ans>  we have to write a procedure for this using the below code

                              fnd_request.add_layout

                             (template_appl_name      => 'application name',

                              template_code           => 'your template code',

                              template_language       => 'En',

                              template_territory      => 'US',

                              output_format           => 'PDF'

                             );

11.   How to display the images in XMLP?

        Ans> url:{'http://image location'}

                 For example, enter:

                   url:{'http://www.oracle.com/images/ora_log.gif'}

                      url:{'${OA_MEDIA}/image name'}

12.   How to pass the page numbers in rtf layout?

Ans>  <REPORT>

<PAGESTART>200<\PAGESTART>

....

</REPORT>

Enter the following in your template:

<?initial-page-number:PAGESTART?>

13.How to display  last page is differently in XML Publisher Reports.

Ans> what you want to dispay the test anything write in last of page

last page header 

<?start@last-page-first:body?>    <?end body?>