R12 中利用XML source file 建立XML Publisher reports

1. 建立XML source file (xxxx.xml)

2. 建立word template file (xxxx.rtf)

3. 在XML Publisher administrator 中定义数据源(Data definitions), 注意code 必须与后面将要建的Concurrent short name 一致

4. 在XML Publisher administrator 中定义模板(Template), 注意code 必须与后面将要建的Concurrent short name 一致

上述两文件须放到客制化应用的reports目录中。

5. 注册Concurrent , short name 须与上述code 一致， 执行文件为 XDODTEXE， 这是XML Publisher Data Template Executable，设定参数及其它选项。

Below is a XML source file example:

   xml version="1.0" encoding="WINDOWS-1252" ?>

- < dataTemplate name =" dataTemplateName " description =" Template description " version =" 1.0 ">

- < properties >

  < property name =" include_parameters " value =" true " />

  properties >

- < parameters >

  < parameter name =" pi_offer_name " dataType =" character " />

  < parameter name =" pi_line_status " dataType =" number " />

  < parameter name =" pi_invoice_num " dataType =" character " />

  < parameter name =" pi_order_number " dataType =" character " />

  < parameter name =" pi_period_name " dataType =" character " />

  < parameter name =" pi_ship_date_from " dataType =" character " />

  < parameter name =" pi_ship_date_to " dataType =" character " />

  < parameter name =" pi_access_set_id " dataType =" number " />

  < parameter name =" PI_MIN_FLEX1 " dataType =" character " />

  < parameter name =" PI_MAX_FLEX1 " dataType =" character " />

  < parameter name =" PI_MIN_FLEX2 " dataType =" character " />

  < parameter name =" PI_MAX_FLEX2 " dataType =" character " />

  < parameter name =" pi_structure_num " dataType =" number " defaultValue =" 101 " />

  parameters >

- < lexicals >

  < lexical type =" oracle.apps.fnd.flex.kff.where " name =" WHERE_FLEX1 " application_short_name =" SQLGL " id_flex_code =" GL# " id_flex_num =" :pi_structure_num " code_combination_table_alias =" gccka " segments =" ALL " operator =" BETWEEN " operand1 =" :PI_MIN_FLEX1 " operand2 =" :PI_MAX_FLEX1 " />

  < lexical type =" oracle.apps.fnd.flex.kff.where " name =" WHERE_FLEX2 " application_short_name =" SQLGL " id_flex_code =" GL# " id_flex_num =" :pi_structure_num " code_combination_table_alias =" gcckb " segments =" ALL " operator =" BETWEEN " operand1 =" :PI_MIN_FLEX2 " operand2 =" :PI_MAX_FLEX2 " />

  lexicals >

- < dataQuery >

- < sqlStatement name =" Q1 ">

-

  ]]> f(clean);

  sqlStatement >

  dataQuery >

- < dataStructure >

- < group name =" Q1 " source =" Q1 ">

  < element name =" pi_structure_num " dataType =" varchar2 " value =" GL_GLRJED_XMLP_PKG.STRUCT_NUM_p " />

  < element name =" WHERE_FLEX1 " dataType =" varchar2 " value =" GL_GLRJED_XMLP_PKG.WHERE_FLEX_p " />

  < element name =" WHERE_FLEX2 " dataType =" varchar2 " value =" GL_GLRJED_XMLP_PKG.WHERE_FLEX_p " />

  < element name =" ORDER_NUMBER " value =" ORDER_NUMBER " />

  < element name =" CUSTOMER_NAME " value =" CUSTOMER_NAME " />

  < element name =" ULTIMATE_DESTINATION " value =" ULTIMATE_DESTINATION " />

  < element name =" ITEM_NUMBER " value =" ITEM_NUMBER " />

  < element name =" ITEM_DESCRIPTION " value =" ITEM_DESCRIPTION " />

  < element name =" INVOICE_NUMBER " value =" INVOICE_NUMBER " />

  < element name =" INVOICE_LINE_REVENUE_ACCOUNT " value =" INVOICE_LINE_REVENUE_ACCOUNT " />

  < element name =" LINE_NUM " value =" LINE_NUM " />

  < element name =" QUANTITY " value =" QUANTITY " />

  < element name =" SELL_PRICE " value =" SELL_PRICE " />

  < element name =" TOTAL_SELL_PRICE " value =" TOTAL_SELL_PRICE " />

  < element name =" PRICING_DATE " value =" PRICING_DATE " />

  < element name =" SHIPPED_DATE " value =" SHIPPED_DATE " />

  < element name =" LINE_STATUS " value =" LINE_STATUS " />

  < element name =" DISCOUNT_NAME " value =" DISCOUNT_NAME " />

  < element name =" OFFER_NUMBER " value =" OFFER_NUMBER " />

  < element name =" DISCOUNT_AMOUNT " value =" DISCOUNT_AMOUNT " />

  < element name =" DISCOUNT_PERCENT " value =" DISCOUNT_PERCENT " />

  < element name =" ACCRUAL_ACCOUNT " value =" ACCRUAL_ACCOUNT " />

  < element name =" SALES_EXPENSE_ACCOUNT " value =" SALES_EXPENSE_ACCOUNT " />

  < element name =" CALCULATED_AMOUNT " value =" CALCULATED_AMOUNT " />

  < element name =" TRADE_MGMT_EARNED_AMOUNT " value =" TRADE_MGMT_EARNED_AMOUNT " />

  group >

  dataStructure >

  dataTemplate >

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10359218/viewspace-705268/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10359218/viewspace-705268/