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
-
-
l_req_id := fnd_request.submit_request('XDO',
-
'XDOREPPB',
-
NULL,
-
NULL,
-
FALSE,
-
'Y',
-
fnd_global.conc_request_id,
-
20006, -- ICGL
-
'ICGL_ORPHANCODES', -- TEMPLATE
-
'en-US', -- English
-
NULL,
-
'RTF',
-
'EXCEL');
-
-
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.
-
#!/bin/bash
-
echo "Script File to install ICIGS_PASSVISAUPDET.ldt, ICIGS_PASSVISAUPDET_XDO.ldt"
-
-
FNDLOAD apps/${APPS_PWD:-nothing} 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $ICFND_TOP/bin/ICIGS_PASSVISAUPDET.ldt
-
-
FNDLOAD apps/${APPS_PWD:-nothing} 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct $ICFND_TOP/bin/ICIGS_PASSVISAUPDET_XDO.ldt
-
-
echo "complete"
Upload rtf in patch
-
#!/bin/bash
-
-
vAPPS_VERSION=$(grep s_apps_version "${CONTEXT_FILE}" | sed 's/<[^>]\+>//g;s/^[ \t]*//')
-
case "${vAPPS_VERSION}" in
-
11.5.10.2)
-
echo "Detected R11"
-
vJDBC_CONN=$(grep s_apps_jdbc_connect_descriptor $CONTEXT_FILE | sed 's/<[^>]\+>//g;s/^[ \t]*//g;s/jdbc:oracle:thin:@//g')
-
vFORMS_COMPILER="f60gen"
-
;;
-
12.1.*)
-
echo "Detected R12"
-
vJDBC_CONN=$(echo ${APPS_JDBC_URL} | sed 's/jdbc:oracle:thin:@//')
-
vFORMS_COMPILER="frmcmp_batch"
-
;;
-
*)
-
echo "Error - Unrecognised vAPPS_VERSION ${vAPPS_VERSION}"
-
exit 1
-
;;
-
esac
-
-
echo "running xdoloader for rtf template"
-
adjava oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-
-DB_USERNAME APPS \
-
-DB_PASSWORD ${APPS_PWD:-nothing} \
-
-JDBC_CONNECTION "${vJDBC_CONN}" \
-
-LOB_TYPE TEMPLATE \
-
-APPS_SHORT_NAME ICGL \
-
-LOB_CODE ICGL_CODECOMB \
-
-LANGUAGE en \
-
-NLS_LANG American_America.WE8ISO8859P1 \
-
-XDO_FILE_TYPE RTF \
-
-FILE_CONTENT_TYPE 'text/html' \
-
-FILE_NAME "$ICIGS_TOP/install/Passport_Template_v2.rtf"
-
-
echo "complete"
RJM Article Type
Quick Reference