Xml Publisher Report

1. How to Upload RTF Template from Back end ?

By using oracle.apps.xdo.oa.util.XDOLoader

Upload:

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME $apps_user -DB_PASSWORD $apps_pwd -JDBC_CONNECTION Host Ip:Port:SID -LOB_TYPE TEMPLATE_SOURCE -APPS_SHORT_NAME XX -LOB_CODE XX_TEMP -LANGUAGE en -TERRITORY US -XDO_FILE_TYPE RTF -FILE_CONTENT_TYPE 'application/rtf' -FILE_NAME 'XX_TEMP.rtf' -CUSTOM_MODE FORCE

2. How to Map RTF Template Via Backend

   Using api FND_PROGRAM.ADD_TEMPLATE

3. What are the executeable and Concurrent Program used to develop a report without RDF?

     Executable: XDODTEXE

     Concurrent Program : Java Concurrent Program

  For developing a XML Publisher report without RDF

4. How to repeat header of the template on each and every page of the output ?

   Use <?@section: ?> in order to repeat that specific section in each page of the output. Also to reset the page number.

5. How many ways we can display images in a BI Publisher report?

    It can done in 5 ways

--> Direct insertion in RTF Template

--> URL Reference

--> OA_MEDIA directoty reference

--> Image from BLOB datatype from database

--> Using BI Beans

6. Conditional formatting:

      --> If statements :     <?if:condition?> your data <?end if?>

      -->If then else statements :            <?xdofx:if element_condition

                                                                                 Then output1

                                                                                 else output2     end if?>

      -->Choose statements:     for multiple conditions

                                                  <?choose?><?when:expression?><?otherwise?>

    There are more ways for Conditional Formatting in addition to the above like column formatting, row formatting etc.

7. Tables in Xml Publisher:

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