#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2011
    Posts
    2
    Rep Power
    0

    Oracle EBS and XML raport .. urgent


    Hi everyone

    I am creating raport under oracle EBS.

    I am creating XML data template for the first time
    I have problem with parameters:

    <parameters>
    <parameter name="P_STATUS_DATE" dataType = "character"></parameter>
    </parameters>

    I want to show it on OUTPUT (RTF) but before this I want to modifie data. So I have created my own parameter:

    <sqlStatement name="Parameters">
    <![CDATA[
    select
    s_stat_date STAT_DATE
    from dual
    ]]>

    and then RUN BEFOR_REPORT procedure (DB package):

    <dataTrigger name="BEFOREREPORT" source="XXWYRECDEC_PKG.before_report"/>

    where I set value for ps_stat_date (ps_stat_date is global parameter in DB Package).

    Then I set above value to my parameter in XML:

    <dataStructure>
    <element name="CP_STAT_DATE" value="STAT_DATE" />
    </dataStructure>

    But I dont see any data on report??

    What I do wrong??
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2011
    Posts
    2
    Rep Power
    0

    Any help??


    I can give some more details if needed.

    Please help.

IMN logo majestic logo threadwatch logo seochat tools logo