一些常用的EBS移植脚本

最新推荐文章于 2022-12-28 16:36:30 发布

@大海@

最新推荐文章于 2022-12-28 16:36:30 发布

阅读量420

点赞数

分类专栏： REPORT 开发 FORM 开发

FORM 开发同时被 2 个专栏收录

62 篇文章 3 订阅

订阅专栏

REPORT 开发

23 篇文章 0 订阅

订阅专栏

<pre name="code" class="sql"><pre name="code" class="sql">/*特别注意*/ 
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 ' ||
        ' PROFILE  APPLICATION_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_application  fa 
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_application  fa 
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_RULES  function_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