Search This Blog

Friday, August 14, 2015

XDOLoader UPLOAD to Attach Bursting Control File

# *********************************************************************************************
# Attaching Bursting Control File
# *********************************************************************************************
echo " "
echo "Attaching Bursting Control File..."
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD $APPSID_PASS \
-JDBC_CONNECTION $v_jdbc_url \
-LOB_TYPE BURSTING_FILE \
-APPS_SHORT_NAME CUSTOM \
-LOB_CODE TEMPLATE_SHORT_CODE \
-LANGUAGE en \
-TERRITORY US \
-XDO_FILE_TYPE XML-BURSTING-FILE \
-NLS_LANG American_America.WE8ISO8859P1 \
-FILE_NAME XXDEDUCTION_CTL.xml \
-LOG_FILE XXDEDUCTION_CTL.log \
-CUSTOM_MODE FORCE

Bursting Control File to Place Output files in Remote Directory

<?xml version="1.0" encoding="UTF-8"?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
 <xapi:globalData location="stream">
 </xapi:globalData >
    <xapi:request select="/TEMP08/LIST_G_EMPLOYEE_NUMBER/G_EMPLOYEE_NUMBER">
 <xapi:delivery>
<xapi:filesystem id="FILE_DELIVERY" output="/var/tmp/${PAYROLL}_${PAY_DATE}.pdf" />
 </xapi:delivery>
 <xapi:document output-type="pdf" delivery="FILE_DELIVERY">
 <xapi:template type="rtf" location="xdo://CUSTOM.XX_DEDUCTION_PDF.en.US/?getSource=true" filter="">
</xapi:template>
  </xapi:document>
 </xapi:request>
     <xapi:request select="/TEMP08/LIST_G_EMPLOYEE_NUMBER/G_EMPLOYEE_NUMBER">
 <xapi:delivery>
<xapi:filesystem id="123" output="/var/tmp/${PAYROLL}_${PAY_DATE}.txt" />
 </xapi:delivery>
 <xapi:document output-type="txt" delivery="123">
  <xapi:template type="eText" location="xdo://CUSTOM.XX_DEDUCTION_INT.en.US/?getSource=true" filter="">
</xapi:template>
  </xapi:document>
 </xapi:request>
</xapi:requestset>