FNDLOAD Create Concurrent Program and XML Template
Steps
1- Run the query ( Given Below ).
Query will provide you download and upload commands. It also enables you to Download Template File. (i.e.RTF file)
2- Run environment file and Run download script on Source Node.
This will create .ldt file and as well as log file.
3- Move .ldt file on Target Node and Run environment file and then Upload Script.
This will upload you required file on Target Node.
-------------------- Query for Generating FND LOAD Command -------------------------------
SELECT
VV.USER_CONCURRENT_PROGRAM_NAME,
FA.APPLICATION_NAME,
VV.OUTPUT_FILE_TYPE REPORT_TYPE,
FE.EXECUTABLE_NAME,
VV.CREATION_DATE CREATION_DATE,
-- Executable and Program --
'FNDLOAD apps/' || NVL(:P_APPS_PWD,'apps') || ' 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct '|| VV.CONCURRENT_PROGRAM_NAME ||'.ldt PROGRAM APPLICATION_SHORT_NAME="' || FA.APPLICATION_SHORT_NAME || '" CONCURRENT_PROGRAM_NAME="' || VV.CONCURRENT_PROGRAM_NAME ||'"' DOWNLOAD_SCRIPT,
'FNDLOAD apps/' || NVL(:P_APPS_PWD,'apps') || ' 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct '|| VV.CONCURRENT_PROGRAM_NAME ||'.ldt' UPLOAD_SCRIPT,
-- Xml Template --
XTMP.TEMPLATE_NAME,
DECODE(VV.OUTPUT_FILE_TYPE,'XML',
'FNDLOAD apps/' || NVL(:P_APPS_PWD,'apps') || ' 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct "'|| FE.EXECUTABLE_NAME ||'_XT.ldt" XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="' || XDEF.APPLICATION_SHORT_NAME || '" DATA_SOURCE_CODE="'|| XDEF.DATA_SOURCE_CODE ||'" TMPL_APP_SHORT_NAME="' || XTMP.APPLICATION_SHORT_NAME ||'" TEMPLATE_CODE= "' || XTMP.TEMPLATE_CODE || '"'
) DOWNLOAD_TEMPLATE,
DECODE(VV.OUTPUT_FILE_TYPE,'XML',
'FNDLOAD apps/' || NVL(:P_APPS_PWD,'apps') || ' 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct "'|| FE.EXECUTABLE_NAME ||'_XT.ldt"'
) UPLOAD_TEMPLATE,
(
SELECT
XL.FILE_NAME
FROM
XDO_LOBS XL
WHERE
XL.XDO_FILE_TYPE = 'RTF'
AND XL.LOB_CODE = XTMP.DATA_SOURCE_CODE
AND XL.APPLICATION_SHORT_NAME = XTMP.APPLICATION_SHORT_NAME
) RTF_FILE_NAME,
(
SELECT
XL.FILE_DATA
FROM
XDO_LOBS XL
WHERE
XL.XDO_FILE_TYPE = 'RTF'
AND XL.LOB_CODE = XTMP.DATA_SOURCE_CODE
AND XL.APPLICATION_SHORT_NAME = XTMP.APPLICATION_SHORT_NAME
) CLICK_TO_DOWNLOAD
FROM
FND_CONCURRENT_PROGRAMS_VL VV,
FND_APPLICATION_VL FA,
FND_EXECUTABLES FE,
XDO_DS_DEFINITIONS_VL XDEF,
XDO_TEMPLATES_VL XTMP
WHERE
VV.CREATED_BY = 1110
AND VV.APPLICATION_ID = 660 --- Order Management
AND VV.ENABLED_FLAG = 'Y'
AND VV.EXECUTABLE_ID = FE.EXECUTABLE_ID
AND FA.APPLICATION_ID = VV.APPLICATION_ID
AND XDEF.DATA_SOURCE_CODE (+) = FE.EXECUTABLE_NAME
AND XTMP.DATA_SOURCE_CODE (+) = FE.EXECUTABLE_NAME
AND UPPER(VV.USER_CONCURRENT_PROGRAM_NAME) LIKE '%'||UPPER(:P_PROGRAM_NAME)||'%'
