XMLPublisher Oracle e-business suite notes

Submitted by code_admin on Fri, 07/20/2018 - 13:13

From a concurrent request

Create a Data Definition - with NO FILES
Create a Data Template
Make sure PLSQL CR outputs to XML
In CR add a call to BI Publisher

  1.    
  2.     l_req_id   := fnd_request.submit_request('XDO',
  3.                                              'XDOREPPB',
  4.                                              NULL,
  5.                                              NULL,
  6.                                              FALSE,
  7.                                              'Y',
  8.                                              fnd_global.conc_request_id,
  9.                                              20006, -- ICGL
  10.                                              'ICGL_ORPHANCODES', -- TEMPLATE
  11.                                              'en-US', -- English
  12.                                              NULL,
  13.                                              'RTF',
  14.                                              'EXCEL');
  15.  
  16.     Write('LOG','XMLPublisher submitted Request ' || to_char(l_req_id));

Patching

Collect LDT for CR
Collect LDT for Data Definition

Upload LDT's in patch e.g.

  1. #!/bin/bash
  2. echo "Script File to install ICIGS_PASSVISAUPDET.ldt, ICIGS_PASSVISAUPDET_XDO.ldt"
  3.  
  4. FNDLOAD apps/${APPS_PWD:-nothing} 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $ICFND_TOP/bin/ICIGS_PASSVISAUPDET.ldt
  5.  
  6. FNDLOAD apps/${APPS_PWD:-nothing} 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct  $ICFND_TOP/bin/ICIGS_PASSVISAUPDET_XDO.ldt
  7.  
  8. echo "complete"

Upload rtf in patch

  1. #!/bin/bash
  2.  
  3. vAPPS_VERSION=$(grep s_apps_version "${CONTEXT_FILE}" | sed 's/<[^>]\+>//g;s/^[ \t]*//')
  4. case "${vAPPS_VERSION}" in
  5.     11.5.10.2)
  6.         echo "Detected R11"
  7.         vJDBC_CONN=$(grep s_apps_jdbc_connect_descriptor $CONTEXT_FILE | sed 's/<[^>]\+>//g;s/^[ \t]*//g;s/jdbc:oracle:thin:@//g')
  8.         vFORMS_COMPILER="f60gen"
  9.         ;;
  10.     12.1.*)
  11.         echo "Detected R12"
  12.         vJDBC_CONN=$(echo ${APPS_JDBC_URL} | sed 's/jdbc:oracle:thin:@//')
  13.         vFORMS_COMPILER="frmcmp_batch"
  14.         ;;
  15.     *)
  16.         echo "Error - Unrecognised vAPPS_VERSION ${vAPPS_VERSION}"
  17.         exit 1
  18.         ;;
  19. esac
  20.  
  21. echo "running xdoloader for rtf template"
  22. adjava oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
  23. -DB_USERNAME APPS \
  24. -DB_PASSWORD ${APPS_PWD:-nothing} \
  25. -JDBC_CONNECTION "${vJDBC_CONN}" \
  26. -LOB_TYPE TEMPLATE \
  27. -APPS_SHORT_NAME ICGL \
  28. -LOB_CODE ICGL_CODECOMB \
  29. -LANGUAGE en \
  30. -NLS_LANG American_America.WE8ISO8859P1 \
  31. -XDO_FILE_TYPE RTF \
  32. -FILE_CONTENT_TYPE 'text/html' \
  33. -FILE_NAME "$ICIGS_TOP/install/Passport_Template_v2.rtf"
  34.  
  35. echo "complete"

fndload usage

RJM Article Type
Quick Reference