BI Publisher (MOSC)

MOSC Banner

BI Publisher and Word 2007 issue

edited Mar 26, 2010 1:48AM in BI Publisher (MOSC) 1 commentAnswered
Hello,

I am running into some problems with the bi publisher, DataTemplates and rtf files.

First thing i did was to create a DataTemplate xml file with the following structure:

<dataTemplate name="ABPROPERS" description="GetABPersonsFromId" version="1.0">
 <parameters>
  <parameter name="P_PERSON_ID" dataType="number" defaultValue="242" />
 </parameters>
 <dataQuery>
   <sqlStatement name="Q1">
    <![CDATA[    Select   pers.first_name first_name, pers.last_name last_name, user_status, start_date , end_date, business_group_id, assignment_id
From....
       Where  person_id = :P_PERSON_ID Order By  start_date Desc]]>
    </sqlStatement>
 </dataQuery>
 <dataStructure>
  <group name="PERSON_INFORMATION" source="Q1">   
   <element name="first_name" value="last_name"/>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center