FNDLOAD Scripts

Personalization

-- Download Personalization

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XXCUS_HIRE_CORE_HR.ldt FND_FORM_CUSTOM_RULES function_name="PERWSHRG-ZORAN_SUPERUSER"

-- Upload Personalization

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXCUS_HIRE_CORE_HR.ldt

Concurrent Program

-- Download Concurrent Program

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/admin/import/afcpprog.lct XXCUSHR_FOOTPRINT_NEWHIRE.ldt PROGRAM APPLICATION_SHORT_NAME='XXCUS' CONCURRENT_PROGRAM_NAME='XXCUSHR_FOOTPRINT_NEWHIRE'

-- Upload Concurrent Program

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXCUSHR_FOOTPRINT_NEWHIRE.ldt

Request Set

-- Download Request Set

$FND_TOP/bin/FNDLOAD apps/apps@ZHRDEV 0 Y DOWNLOAD $FND_TOP/admin/import/afcprset.lct XXCUS_HR_HIRE_REQ_SET.ldt REQ_SET REQUEST_SET_NAME="FNDRSSUB923"

-- Upload Request Set stages

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XXCUS_HR_HIRE_REQ_SET.ldt

Request Set Links

-- Download Request Set links

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XXCUS_HR_HIRE_REQ_LINKS.ldt REQ_SET_LINKS

REQUEST_SET_NAME="FNDRSSUB923"

-- Upload Request Set stages

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XXCUS_HR_HIRE_REQ_LINKS.ldt

Alert

--Download Alert

FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XXCUS_HR_NEW_HIRE_CEO_ADMIN.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXCUS ALERT_NAME='XXCUS_HR_NEW_HIRE_CEO_ADMIN'

--Upload Alert

FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XXCUS_HR_NEW_HIRE_CEO_ADMIN.ldt

Value Set

-- Download Value set

$FND_TOP/bin/FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/admin/import/afffload.lct XXCUS_HR_FP_TERM_LOV.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME='XXCUS_HR_FP_TERM_LOV'

-- Upload value set

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XXCUS_HR_FP_TERM_LOV.ldt

Lookup

--downlaod lookup

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XXCUS_HR_WEBTIME_ASG_STATUSES.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME ='PER' LOOKUP_TYPE='XXCUS_HR_WEBTIME_ASG_STATUSES'

--upload lookup

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XXCUS_HR_WEBTIME_ASG_STATUSES.ldt

Profile Option

--download profile option

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XXCUS_HR_ZRANSITE_TARGET_DIR_PO.ldt PROFILE PROFILE_NAME='XXCUS_HR_ZRANSITE_TARGET_DIR' APPLICATION_SHORT_NAME='XXCUS'

  

DFF FNDLOAD

SELECT application_id, DESCRIPTIVE_FLEXFIELD_NAME, application_table_name

FROM fnd_descriptive_flexs_vl

WHERE APPLICATION_TABLE_NAME like '%' || upper('&tab_name') || '%'

ORDER BY APPLICATION_TABLE_NAME

SELECT * fromfnd_application whereapplication_id = 800

-- Download

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXCUS_ASSIGNMENT_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME=PER DESCRIPTIVE_FLEXFIELD_NAME='PER_ASSIGNMENTS'

--Upload

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XXCUS_ASSIGNMENT_DFF.ldt

Responsibility Download

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct XXCUS_HR_WW_EMP_NO_ZMA.ldt FND_RESPONSIBILITY RESP_KEY=’XXCUS_HR_WW_EMP’

## note that XX_PERSON_RESPY is the responsibility key

## Now to upload
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XXCUS_HR_WW_EMP_NO_ZMA.ldt

Menu Download

$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD

$FND_TOP/patch/115/import/afsload.lct ICX_POR_SSP_HOME.ldt MENU MENU_NAME= “ICX_POR_SSP_HOME”

## Now to upload

$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct ICX_POR_SSP_HOME.ldt