查询所有ICX Profile的脚本查询所有ICX相关Profile的SQLset pages 100set line 120column Option format
查询所有ICX Profile的脚本
查询所有ICX相关Profile的SQL
set pages 100set line 120column "Option" format 99999999column "Profile Name" format A35column "Profile Value" format A55spool support_profile_value.txtselect a.PROFILE_OPTION_ID "Option" ,a.PROFILE_OPTION_NAME "Profile Name" ,b.PROFILE_OPTION_VALUE "Profile Value"from fnd_profile_options a ,fnd_profile_option_values bwhere a.PROFILE_OPTION_ID = b.PROFILE_OPTION_ID(+) and a.PROFILE_OPTION_NAME like 'ICX%'/spool off
Reference:
Scripts To Obtain ICX Profiles For Discoverer 4i And E-Business Suite Integration (Doc ID 222135.1)