<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ctrms66804的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ctrms66804</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ctrms66804]]></copyright><item><title><![CDATA[Top 10 Sql (DBA 调优参考)]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324681</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324681</guid><author>ctrms66804</author><pubDate>Wed, 23 Jul 2014 09:07:15 +0800</pubDate><description><![CDATA[--sqlarea
select * from v$sqlarea vs
where 1=1
and vs.HASH_VALUE = '2692618562';


--Top 10 by Buffer Gets:...]]></description><category></category></item><item><title><![CDATA[OIE 费用报表审批工作流AME审批组SQL一例(记录)]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324686</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324686</guid><author>ctrms66804</author><pubDate>Fri, 20 Dec 2013 22:23:09 +0800</pubDate><description><![CDATA[SELECT 'PER:'||a.supervisor_id
   FROM (SELECT t.person_id
       ,t.supervisor_id
     FROM pe...]]></description><category></category></item><item><title><![CDATA[EBS 用户密码处理]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324684</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324684</guid><author>ctrms66804</author><pubDate>Mon, 16 Dec 2013 11:51:02 +0800</pubDate><description><![CDATA[1. 后台批量更新用户密码
 DECLARE
   l_success BOOLEAN;
 BEGIN
   dbms_output.enable(300000);
   FOR i...]]></description><category></category></item><item><title><![CDATA[查找PA预算审批工作流的下一审批人(记录)]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324687</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324687</guid><author>ctrms66804</author><pubDate>Sat, 07 Dec 2013 12:07:16 +0800</pubDate><description><![CDATA[--客制化PA预算审批工作流为多级审批，要求取下一审批人或当前状况至预算查看界面. SQL记录一下.
SELECT a.to_user
   ,decode(a.message_name,
      ...]]></description><category></category></item><item><title><![CDATA[AR自动开票程序运行太慢的解决]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324677</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324677</guid><author>ctrms66804</author><pubDate>Fri, 15 Nov 2013 09:42:05 +0800</pubDate><description><![CDATA[1. 运行AR模块的统计数据收集模式
2. 调整自动开票的设置
 a: 调整内存至 1024 * 接口记录数
 b: 调整日志级别为0
3. 提交开票程序的例程数提高到2.
                     ...]]></description><category></category></item><item><title><![CDATA[取帐户段组合及帐户说明组合]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324682</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324682</guid><author>ctrms66804</author><pubDate>Wed, 13 Nov 2013 13:06:16 +0800</pubDate><description><![CDATA[段组合:
fnd_flex_ext.get_segs('SQLGL',
               'GL#',
                gcc...]]></description><category></category></item><item><title><![CDATA[请求输出为XML 格式的无法用EXCEL打开的解决]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324683</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324683</guid><author>ctrms66804</author><pubDate>Thu, 08 Aug 2013 16:52:17 +0800</pubDate><description><![CDATA[XML 报表导入EXCEL时的相关设置
			
			1. 如果报表是直接用浏览器打开，而不是下载，做如下设置 a. 系统管理员/安装/浏览器选项   为XML增加用EXCEL打开的行，如下:  ...]]></description><category></category></item><item><title><![CDATA[记录]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324673</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324673</guid><author>ctrms66804</author><pubDate>Thu, 08 Aug 2013 14:14:12 +0800</pubDate><description><![CDATA[app_special.enable('ABOUT', PROPERTY_OFF);app_special.enable('SAVE', PROPERTY_OFF);app_special.enable('FILE.N...]]></description><category></category></item><item><title><![CDATA[AR收款相关操作产生的表变化，随手记录...]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324670</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324670</guid><author>ctrms66804</author><pubDate>Sat, 22 Jun 2013 13:35:10 +0800</pubDate><description><![CDATA[新增收款ar_cash_receipts_all 状态为UNAPP --表示未核销ar_cash_receipt_history_all 状态为CLEARED, current_record_flag 为...]]></description><category></category></item><item><title><![CDATA[FORM中按F11进行查询状态后记录显示为白色的处理]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324680</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324680</guid><author>ctrms66804</author><pubDate>Thu, 09 May 2013 11:30:45 +0800</pubDate><description><![CDATA[此问题是在查询块中增加了WHEN-NEW-RECORD-INSTANCE触发器后产生的，只需把触发器的执行层次改为"BEFORE"即可避免。
			
			
			
			
                       ...]]></description><category></category></item><item><title><![CDATA[查询EBS在线用户(转)]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324668</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324668</guid><author>ctrms66804</author><pubDate>Wed, 17 Apr 2013 18:49:28 +0800</pubDate><description><![CDATA[SELECT u.user_name   ,app.application_short_name   ,fat.application_name   ,fr.responsibility_key   ,f...]]></description><category></category></item><item><title><![CDATA[几张R12 中关于帐套与业务实体关系的有用的视图]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324676</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324676</guid><author>ctrms66804</author><pubDate>Sat, 30 Mar 2013 14:59:14 +0800</pubDate><description><![CDATA[org_organization_definitions反映业务实体/帐套/法人主体关系的视图xle_firstparty_information_v反映法人主体/PARTY关系的视图gl_ledger_le_v反映帐套属性/法...]]></description><category></category></item><item><title><![CDATA[AR 创建会计科目请求效率低的解决步骤]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324665</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324665</guid><author>ctrms66804</author><pubDate>Sat, 30 Mar 2013 14:52:28 +0800</pubDate><description><![CDATA[来自于Metalink 的解答:
			
			Pleaseensurethefollowinghasbeendone.PleasefollowDocID791049.1:R12SLA/F...]]></description><category></category></item><item><title><![CDATA[R12 开发相关文件的编译（备查）]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324679</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324679</guid><author>ctrms66804</author><pubDate>Thu, 14 Mar 2013 12:07:17 +0800</pubDate><description><![CDATA[编译fmb文件：frmcmp userid=user/pwd@db module=xxx.fmb batch=no module_type=form. compile_all=yesoutput_file=frmcmp_bat...]]></description><category></category></item><item><title><![CDATA[AP期间例外检查脚本之一(其它例外)]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324675</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324675</guid><author>ctrms66804</author><pubDate>Thu, 21 Feb 2013 10:41:35 +0800</pubDate><description><![CDATA[SELECT xte.ledger_id      ledger_id   ,xte.source_id_int_1   source_id_int_1   ,xte.security_id_int_1...]]></description><category></category></item><item><title><![CDATA[批量结束运行中的WORKFLOW(慎用)]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324672</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324672</guid><author>ctrms66804</author><pubDate>Tue, 29 Jan 2013 20:37:28 +0800</pubDate><description><![CDATA[最近做workflow的开发，由于在测试过程中，可能要经常改客制化的工作流后台包，而在编译过程中，如果有未完成的工作流仍在pending中的话，会导致编译后的包与工作流缓存的包的版本不一致，导致后面新提交的工作流失败。因此要么把...]]></description><category></category></item><item><title><![CDATA[EBS Form 注册至系统后，导出功能无法使用的解决]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324661</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324661</guid><author>ctrms66804</author><pubDate>Tue, 29 Jan 2013 16:51:08 +0800</pubDate><description><![CDATA[可在导出块的when new block instance 中加入app_special.enable('FILE.EXPORT', PROPERTY_ON);
			
			
			
			
             ...]]></description><category></category></item><item><title><![CDATA[一个查询，取供应商期初余额导入的明细(备查)]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324671</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324671</guid><author>ctrms66804</author><pubDate>Tue, 22 Jan 2013 17:03:16 +0800</pubDate><description><![CDATA[SELECT DISTINCT xah.ae_header_id       ,xah.description 凭证说明       ,xah.accounting_date 核算日期   ...]]></description><category></category></item><item><title><![CDATA[EBS中 EXCEL 格式报表输出的公用API]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324674</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324674</guid><author>ctrms66804</author><pubDate>Sun, 13 Jan 2013 19:43:56 +0800</pubDate><description><![CDATA[最近的项目上写了一个公用的API,很久以前就用EXCEL发布过报表，但从没想过写API来简化。。。其实方法很简单，就是...]]></description><category></category></item><item><title><![CDATA[Workflow mailer的简要配置]]></title><link>https://blog.youkuaiyun.com/ctrms66804/article/details/100324667</link><guid>https://blog.youkuaiyun.com/ctrms66804/article/details/100324667</guid><author>ctrms66804</author><pubDate>Sat, 12 Jan 2013 12:19:10 +0800</pubDate><description><![CDATA[最近项目需要为工作流启动邮件功能，可配置workflow mailer一直不成功，因此花了半天劲用utl_smtp去发邮件了，设计了和notification差不多的html风格的邮件主体，用户反映还不错。可刚搞完，在DBA的帮...]]></description><category></category></item></channel></rss>