BI Publisher (MOSC)

MOSC Banner

Data Definition Template -- How to pass in Parameters

edited Jul 2, 2013 11:57PM in BI Publisher (MOSC) 3 commentsAnswered
Hi Gurus,I have created one xml template in place of rdf.

---------------------------------------------------------------------------------------------------------------------------------------
<?xml version = "1.0" encoding = "UTF-8" ?>
<dataTemplate name="EQXCUST111" defaultPackage="EQXCUST_XMLP_PKG" version="1.0">
<properties>
<property name="xml_tag_case" value="upper"/>
</properties>
<parameters>
<parameter name="P_CONC_REQUEST_ID" dataType = "number" defaultValue="0"/>
<parameter name="P_COLLECTOR" dataType="character"/>
<parameter name="P_STATEMENT_NUMBER" dataType="number"/>
<parameter name="P_FROM_CUSTOMER" dataType="character"/>
<parameter name="P_TO_CUSTOMER" dataType="character"/>
</parameters>
<lexicals/>
<dataQuery>
<sqlStatement name="Q_MAIN">
<![CDATA[
SELECT STATEMENT_NUMBER,
to_char(STATEMENT_DATE,'MM/DD/YYYY') STATEMENT_DATE ,
PAYMENT_TERMS,
CUSTOMER,
CUSTOMER_ACCOUNT,
 CUSTOMER_ADDRESS_1,
 CUSTOMER_ADDRESS_2,

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