一些常用的EBS移植脚本
/*特别注意*/export NLS_LANG="SIMPLIFIED CHINESE_CHINA.UTF8"
/*profile*/
select 'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct' || fpo.profile_option_name || '.ldt ' ||
' PROFILEAPPLICATION_SHORT_NAME=' || fa.application_short_name || 'PROFILE_NAME=' || fpo.profile_option_name
from FND_PROFILE_OPTIONS fpo,
fnd_application fa
where fpo.application_id = fa.application_id
AND fa.application_short_name = 'CUX';
select fpo.USER_PROFILE_OPTION_NAME,
'FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct ' || fpo.profile_option_name || '.ldt'
from FND_PROFILE_OPTIONS_vl fpo, fnd_application fa
where fpo.application_id = fa.application_id
AND fa.application_short_name = 'CUX'
--AND fpo.profile_option_name NOT IN ()
;
/*lookup_type*/
select 'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct' || flt.LOOKUP_TYPE || '.ldt ' ||
' FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=' || fa.application_short_name || ' LOOKUP_TYPE=' || flt.LOOKUP_TYPE
from FND_LOOKUP_TYPES flt, fnd_application fa
where flt.application_id = fa.application_id
and fa.application_short_name = 'CUX';
select flt.LOOKUP_TYPE,
flt.MEANING,
'FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct' || flt.LOOKUP_TYPE || '.ldt'|| ' -'
from FND_LOOKUP_TYPES_vl flt, fnd_application fa
where flt.application_id = fa.application_id
and fa.application_short_name = 'CUX'
AND flt.LOOKUP_TYPE NOT IN ('SRG_STATUS','SRG_EXPENSE_TYPE','SRG_RATE_TYPE','SRG_SETTLE_STATUS')
;
--export NLS_LANG="SIMPLIFIED CHINESE_CHINA.UTF8"
/*message*/
SELECT 'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct' || fnm.message_name || '.ldt ' ||
' FND_NEW_MESSAGES APPLICATION_SHORT_NAME=' || fa.application_short_name || 'MESSAGE_NAME=' || fnm.message_name
FROM FND_NEW_MESSAGES fnm,
fnd_applicationfa
WHERE fnm.application_id = fa.application_id
AND fa.application_short_name = 'CUX'
AND fnm.language_code = 'ZHS' ;
SELECT fnm.message_name,
'FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct' || fnm.message_name || '.ldt '|| ' -'
FROM FND_NEW_MESSAGES fnm,
fnd_applicationfa
WHERE fnm.application_id = fa.application_id
AND fa.application_short_name = 'CUX'
AND fnm.message_name NOT IN ('CUX_ZSW_TEST') ;
/*concurrent program*/
select'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct' || fcp.CONCURRENT_PROGRAM_NAME || '.ldt ' ||
' PROGRAM APPLICATION_SHORT_NAME=' || fa.application_short_name || ' CONCURRENT_PROGRAM_NAME=' || fcp.CONCURRENT_PROGRAM_NAME
from fnd_concurrent_programs fcp, fnd_application fa
where fcp.application_id = fa.application_id and
fa.application_short_name = 'CUX';
select fcp.USER_CONCURRENT_PROGRAM_NAME,
'FNDLOAD apps/apps 0 Y UPLOAD$FND_TOP/patch/115/import/afcpprog.lct' || fcp.CONCURRENT_PROGRAM_NAME || '.ldt'
from fnd_concurrent_programs_vl fcp, fnd_application fa
where fcp.application_id = fa.application_id and
fa.application_short_name = 'CUX'
AND fcp.CONCURRENT_PROGRAM_NAME NOT IN ('CUX_TEST_FNDUSER','CUX_TEST_FNDUSER_PDF','CUX_TEST_PO','CUXTEST','CUXTEMPTEST',
'CUXINTRP','CUXLYINS','CUXLYINT','CUXASSLYPROD','CUXASSLY','CUXASSYL',
'CUXSCARCASH','CUXSCCASH','CUX_TEST_FNDUSRE_PDF')
;
/*function*/
SELECT 'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct' || fcp.function_name || '.ldt ' ||
' FUNCTION FUNC_APP_SHORT_NAME=' || fa.application_short_name || ' FUNCTION_NAME=' || fcp.function_name
FROM fnd_form_functions fcp, fnd_application fa
WHERE fcp.application_id = fa.application_id
AND fa.application_short_name = 'CUX' ;
SELECT fcp.USER_FUNCTION_NAME,
'FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct' || fcp.function_name || '.ldt'
FROM fnd_form_functions_vl fcp, fnd_application fa
WHERE fcp.application_id = fa.application_id
AND fa.application_short_name = 'CUX'
AND fcp.function_name NOT IN ('CUXVATREQN');
/*个性化*/
SELECT DISTINCT 'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct' || fcr.function_name || '.ldt ' ||
' FND_FORM_CUSTOM_RULESfunction_name=' || fcr.function_name
FROM FND_FORM_CUSTOM_RULES fcr;
SELECT DISTINCT 'FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct' || fcr.function_name || '.ldt '
FROM FND_FORM_CUSTOM_RULES fcr;
/*menu*/
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct CUX_menu.ldt MENU MENU_NAME='CUX_SUPER'
FNDLOAD apps/apps 0 Y UPLOAD$FND_TOP/patch/115/import/afsload.lct CUX_menu.ldt
/*request group*/
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct CUX_reqgrp.ldt REQUEST_GROUP APPLICATION_SHORT_NAME=CUX REQUEST_GROUP_NAME='CUX: All Reports'
FNDLOAD apps/apps 0 Y UPLOAD$FND_TOP/patch/115/import/afcpreqg.lct CUX_reqgrp.ldt
页:
[1]