AOL

Download Concurrent Program LDT

FNDLOAD apps/appspwd O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct yourfilename.ldt PROGRAM APPLICATION_SHORT_NAME="appl_short_name" CONCURRENT_PROGRAM_NAME="conc_prog_short_name"

Download Lookup LDT

FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct yourfilename.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME ='appl_short_name' LOOKUP_TYPE="conc_prog_short_name"

Download concurrent program assignment to request group LDT

FNDLOAD apps/appspwd O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct yourfilename.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request_group_name" APPLICATION_SHORT_NAME="request_group_application" REQUEST_GROUP_UNIT UNIT_NAME="conc_prog_short_name"

Download value set LDT

$FND_TOP/bin/FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct yourfilename.ldt VALUE_SET FLEX_VALUE_SET_NAME="valuesetname"

Download Request Set and Request Set Links LDT files

FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct yourfilename.ldt REQ_SET REQUEST_SET_NAME='request_set_name'

FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct yourfilename.ldt REQ_SET_LINKS REQUEST_SET_NAME='request_set_name'

Download Web ADI LDT

$FND_TOP/bin/FNDLOAD apps/appspwd 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct yourfilename.ldt BNE_INTEGRATORS INTEGRATOR_ASN="appl_short_name" INTEGRATOR_CODE="integrator_code"

Download Form Function LDT

FNDLOAD apps/appspwd O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct yourfilename.ldt FUNCTION FUNC_APP_SHORT_NAME="appl_short_name" FUNCTION_NAME="function_name"

PL/SQL Script to attach request set to request group

BEGIN
fnd_set.add_set_to_group (request_set => 'request_set_name',
set_application => 'req_set_appl_short_name', --REQUEST SET APPLICATION SHORT NAME
request_group => 'request_group_name',---REQUEST GROUP NAME
group_application => 'req_grp_appl_short_name'--REQUEST GROUP APPLICATION SHORT NAME
);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE ('Error in attaching request_set to Request Group ' || SQLERRM);
END;

COMMIT;

Query to get Concurrent Program Details

SELECT CPTL.USER_CONCURRENT_PROGRAM_NAME,
       (SELECT APPLICATION_SHORT_NAME
          FROM APPS.FND_APPLICATION
         WHERE APPLICATION_ID = CP.APPLICATION_ID) APPL_SHORT_NAME,
       CPTL.CREATION_DATE,
       CP.CONCURRENT_PROGRAM_NAME,
       CP.LAST_UPDATED_BY,
       CP.LAST_UPDATE_DATE,
       CP.CONCURRENT_PROGRAM_ID,
       CP.ENABLED_FLAG,
       CP.EXECUTION_METHOD_CODE,
       EC.LOOKUP_TYPE,
       EC.MEANING,
       E.EXECUTABLE_NAME,
       E.EXECUTION_FILE_NAME,
       CP.OUTPUT_FILE_TYPE,
       E.EXECUTION_FILE_PATH,
       (SELECT APPLICATION_NAME
          FROM APPS.FND_APPLICATION_TL
         WHERE LANGUAGE = USERENV('LANG')
           AND APPLICATION_ID = E.APPLICATION_ID) EXE_APPL
  FROM APPS.FND_CONCURRENT_PROGRAMS_TL CPTL,
       APPS.FND_CONCURRENT_PROGRAMS    CP,
       APPS.FND_EXECUTABLES            E,
       APPS.FND_LOOKUP_VALUES          EC
 WHERE CP.CONCURRENT_PROGRAM_ID = CPTL.CONCURRENT_PROGRAM_ID
   AND E.EXECUTABLE_ID = CP.EXECUTABLE_ID
   AND EC.LOOKUP_CODE = E.EXECUTION_METHOD_CODE
   AND EC.LANGUAGE = CPTL.LANGUAGE
   AND ('&&conc_prog_name' IS NULL OR
       UPPER(CPTL.USER_CONCURRENT_PROGRAM_NAME) LIKE
       UPPER('%' || '&conc_prog_name') || '%')
   AND ('&&conc_prog_short_name' IS NULL OR
       UPPER(CP.CONCURRENT_PROGRAM_NAME) LIKE
       '%' || ('&conc_prog_short_name') || '%')
   AND CPTL.LANGUAGE = 'US'
   AND EC.LOOKUP_TYPE = 'CP_EXECUTION_METHOD_CODE'
   AND ('&&exec_file_name' IS NULL OR
       UPPER(E.EXECUTION_FILE_NAME) LIKE
       '%' || UPPER('&exec_file_name') || '%')
 ORDER BY CPTL.USER_CONCURRENT_PROGRAM_NAME;