FND FNDLOAD Object Transfer

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Generates FNDLOAD download and upload linux commands for automated setup transfer between environments

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
'Function' object_type,
fff.function_name,
'FNDLOAD apps/&apps_password_download 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct '||:output_file_location||'func_'||fff.function_name||'.ldt FUNCTION FUNCTION_NAME='||fff.function_name download,
'FNDLOAD apps/&apps_password_upload 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct func_'||fff.function_name||'.ldt' upload
from
fnd_form_functions fff
where
2=2 and
:object_type='Function'
union all
select
'Lookup' object_type,
flt.lookup_type,
'FNDLOAD apps/&apps_password_download 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 Type 
 
 LOV
Object Name 
fcpv.concurrent_program_name=:object_name
 LOV
Application Short Name 
fcpv.application_id in (select fa.application_id from fnd_application fa where fa.application_short_name=:application_short_name)
 LOV
Output File Location 
 
 Char
Apps Password Download 
<parameter_value>
 Char
Apps Password Upload 
<parameter_value>
 Char
Download
 
Related Blitz Reports
FND Responsibility Access FND Responsibility Access 11i FND Forms Personalizations FND Concurrent Requests FND Attachment Functions Blitz Report Assignments and Responsibilities FND Flex Value Sets, Usages and Values FND Concurrent Requests 11i FND Concurrent Programs and Executables 11i
Blitz Report™

Blitz Report™ provides multiple benefits: