Wednesday, 15 April 2015

BI Publisher Report with Excel Template

Step1:Concurrent Program
Create a Concurrent Program with Exceutable File Name as XDODTEXE

Step:2 Data Xml Template
Create a Data Xml Template for the Query

Step:3 Data Definitions
Create a Data Definition under XML Publisher Administrator responsibility with the above XML Template.

Step:4 Excel Template

Define the Tag for Fields in the Excel Template in the following Format:

Data elements: XDO_?element_name?
where XDO_ is the required prefix and
?element_name? is either:
the XML tag name from your data delimited by "?"
a unique name that you will use to map a derived value to the cell

?group_name? is the XML tag name for the parent element in your XML data delimited by "?".
a unique name that you will use to define a derived grouping logic.

Eg:
Tag for AR Invocie Posting Date : XDO_?AR_POSTING_DATE?
Tag for Group : XDO_GROUP_?G_HEADER?

The element name in XML data should match with the field name in the tag.
For group, select the entire record and provide the tag.

Step:5 Templates

Create a Templates under XML Publisher Administrator Responsibility with the type as ‘Microsoft Excel’
Step: 6 Excel Output:

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete