FND FNDLOAD Object Transfer

Description
Categories: Application, Enginatics, Setup
Generates FNDLOAD download and upload linux commands for automated setup transfer between environments
select
'Concurrent Program' object_type,
fcpv.concurrent_program_name object_name,
'FNDLOAD apps/&apps_password_download 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct '||:output_file_location||'conc_'||fcpv.concurrent_program_name||'.ldt PROGRAM CONCURRENT_PROGRAM_NAME='||fcpv.concurrent_program_name download,
'FNDLOAD apps/&apps_password_upload 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct conc_'||fcpv.concurrent_program_name||'.ldt' upload
from
fnd_concurrent_programs_vl fcpv
where
1=1 and
:object_type='Concurrent Program'
union all
select
'Lookup' object_type,
flt.lookup_type,
'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct '||:output_file_location||'look_'||flt.lookup_type||'.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME='||fa.application_short_name||' LOOKUP_TYPE='||flt.lookup_type download,
'FNDLOAD apps/&apps_password_upload 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct look_'||flt.lookup_type||'.ldt' upload
from
fnd_lookup_types flt,
fnd_application fa
where
3=3 and
:object_type='Lookup' and
flt.application_id=fa.application_id
union all
select
'Profile Option' object_type,
fpo.profile_option_name object_name,
'FNDLOAD apps/&apps_password_download O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct '||:output_file_location||'prof_'||fpo.profile_option_name||'.ldt PROFILE PROFILE_NAME='||fpo.profile_option_name||' PROFILE_VALUES=N' download,
'FNDLOAD apps/&apps_password_upload 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct prof_'||fpo.profile_option_name||'.ldt' upload
from
fnd_profile_options fpo
where
5=5 and
:object_type='Profile Option'
Parameter Name SQL text Validation
Object Name
fpo.profile_option_name=:object_name
Object Name
flt.lookup_type=:lookup_type
Object Type
<parameter_value>
Apps Password Upload
<parameter_value>
Apps Password Download
<parameter_value>
Output File Location
 
Application Short Name
fav.application_short_name=:short_name
LOV
Object Name
fcpv.concurrent_program_name=:concurrent_program_name
LOV
Object Type
 
LOV