We will use the FNDLOAD utility to deploy the Web ADI to other instances.
> We just need to deploy the 'Integrator' because it also includes the realted content,layout and mappings and then the related Form Function (R12)
>> Integrator
select * --integrator_code, application_id,user_name
from bne_integrators_vl vl
where user_name like 'XXAK%%'
and integrator_code like 'XXAK%';
fndload apps/<apps password> 0 y download $bne_top/patch/115/import/bneintegrator.lct xxaktestadi_xintg.ldt bne_integrators integrator_asn="XXAKTEST_ADI_XINTG" integrator_code="XXAKTESTADI_XINTG"
fndload apps/<apps password> 0 y upload $bne_top/patch/115/import/bneintegrator.lct xxaktestadi_xintg.ldt
>> Form Function
select * --function_name
from fnd_form_functions_vl
where function_name like 'XXAK%';
fndload apps/<apps password> 0 y download $fnd_top/patch/115/import/afsload.lct xxaktestadi_func.ldt function function_name="XXAKTESTADI"
fndload apps/<apps password> 0 y upload $fnd_top/patch/115/import/afsload.lct xxaktestadi_func.ldt - warning=yes upload_mode=replace custom_mode=force
Please use below scripts if you have to deploy contents/layouts/mappings
>> Content
select * --content_code
from bne_content_cols_vl
where content_code like '%XXAK%';
fndload apps/<apps password> 0 y download $bne_top/patch/115/import/bnecont.lct xxaktestadi_cnt2.ldt bne_contents content_asn="XXAK" content_code="XXAKTESTADI_CNT2"
fndload apps/<apps password> 0 y upload $bne_top/patch/115/import/bnecont.lct xxaktestadi_cnt2.ldt
>> Layout
select *--LAYOUT_CODE
from bne_layouts_vl vl
where integrator_code like 'XXAK%';
fndload apps/<apps password> 0 y download $bne_top/patch/115/import/bnelay.lct xxaktestadi_lay.ldt bne_layouts layout_asn="XXAK" layout_code="XXAKTESTADI"
fndload apps/<apps password> 0 y upload $bne_top/patch/115/import/bnelay.lct xxaktestadi_lay.ldt
>> Mapping
select * --mapping_code, integrator_code
from bne_mappings_vl
where mapping_code like 'XXAK%';
fndload apps/<apps password> 0 y download $bne_top/patch/115/import/bnemap.lct xxaktestadi_map.ldt bne_mappings mapping_asn="XXAK" mapping_code="XXAKTESTADI"
fndload apps/<apps password> 0 y upload $bne_top/patch/115/import/bnemap.lct xxaktestadi_map.ldt
> We just need to deploy the 'Integrator' because it also includes the realted content,layout and mappings and then the related Form Function (R12)
>> Integrator
select * --integrator_code, application_id,user_name
from bne_integrators_vl vl
where user_name like 'XXAK%%'
and integrator_code like 'XXAK%';
fndload apps/<apps password> 0 y download $bne_top/patch/115/import/bneintegrator.lct xxaktestadi_xintg.ldt bne_integrators integrator_asn="XXAKTEST_ADI_XINTG" integrator_code="XXAKTESTADI_XINTG"
fndload apps/<apps password> 0 y upload $bne_top/patch/115/import/bneintegrator.lct xxaktestadi_xintg.ldt
>> Form Function
select * --function_name
from fnd_form_functions_vl
where function_name like 'XXAK%';
fndload apps/<apps password> 0 y download $fnd_top/patch/115/import/afsload.lct xxaktestadi_func.ldt function function_name="XXAKTESTADI"
fndload apps/<apps password> 0 y upload $fnd_top/patch/115/import/afsload.lct xxaktestadi_func.ldt - warning=yes upload_mode=replace custom_mode=force
Please use below scripts if you have to deploy contents/layouts/mappings
>> Content
select * --content_code
from bne_content_cols_vl
where content_code like '%XXAK%';
fndload apps/<apps password> 0 y download $bne_top/patch/115/import/bnecont.lct xxaktestadi_cnt2.ldt bne_contents content_asn="XXAK" content_code="XXAKTESTADI_CNT2"
fndload apps/<apps password> 0 y upload $bne_top/patch/115/import/bnecont.lct xxaktestadi_cnt2.ldt
>> Layout
select *--LAYOUT_CODE
from bne_layouts_vl vl
where integrator_code like 'XXAK%';
fndload apps/<apps password> 0 y download $bne_top/patch/115/import/bnelay.lct xxaktestadi_lay.ldt bne_layouts layout_asn="XXAK" layout_code="XXAKTESTADI"
fndload apps/<apps password> 0 y upload $bne_top/patch/115/import/bnelay.lct xxaktestadi_lay.ldt
>> Mapping
select * --mapping_code, integrator_code
from bne_mappings_vl
where mapping_code like 'XXAK%';
fndload apps/<apps password> 0 y download $bne_top/patch/115/import/bnemap.lct xxaktestadi_map.ldt bne_mappings mapping_asn="XXAK" mapping_code="XXAKTESTADI"
fndload apps/<apps password> 0 y upload $bne_top/patch/115/import/bnemap.lct xxaktestadi_map.ldt
No comments:
Post a Comment