add

About Me

My photo
Oracle Apps - Techno Functional consultant

Friday, March 9

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

No comments: