-
编辑 删除
how to use fnd message in PL/SQL
1. Create a message with variable Patch: Application Developer/ Message/Current Message Text:The Customer Bill To on this Service Request has failed credit check. Please review and respond as appropriate.<br/><br/>Service Request Identifier: SR#&V_SR_NUM<br/>Customer: &V_CUSTOMER_NAME<b...
-
编辑 删除
How to check how many processes of Manager are running
<span id="kmPgTpl:r1:ot71" class="kmContent" style="font-size:small;color:Black;">1. log in ap server<br /><br />2. <br />you can use System Administrator->Concurrent->Manager->Define to check the short name<br /><span id="kmPgTpl:r1:ot71" class="kmContent" style="font-size:small;color:...
-
编辑 删除
Initialization SQL Statement - Custom
1.Set the profile 'Initialization SQL Statement - Custom' value at user levelThe valueBEGIN FND_CTL.FND_SESS_CTL ('','','TRUE','TRUE','LOG','ALTER SESSION SET TRACEFILE_IDENTIFIER=''ALLEN_ZHONG_TEST'' EVENTS=''10046 TRACE NAME CONTEXT FOREVER, LEVEL 12''');END;2. L...
-
编辑 删除
怎么去启用FND DEBUG(How to enable fnd debug)
1. set below profiles value at user level<br /><br /><span id="kmPgTpl:r1:ot71" class="kmContent" style="font-size:small;color:Black;">FND: Debug Log Enabled -> Yes<br />FND: Debug Log Level -> Statement<br />FND: Debug Log Module -> csd% <br />( this is for CSD module, for INV mo...
-
编辑 删除
you don’t have right to execute this responsibility
<p style="margin-left:18.0pt;text-indent:-18.0pt;"><span><span>1.<span> </span></span></span><span>Some time, after we added oneOAF page, but when we checked and use it, it will show you don’t have right toexecute this responsibility.</span></p><p style="ma...
-
编辑 删除
重新提交workflow节点
1. 选择具有administrator 的workflow职责，一般是Workflow Administrator Web Applications 或者是Workflow Administrator.<br />2.选择Status Monitor<br />3. 输入值， 然后点retry 重新执行某节点， 可依据workflow status 界面来出入查询值。<br />
-
编辑 删除
ref cursor ,动态SQL
DECLARE<br /> TYPE ref_cursor IS REF CURSOR;<br /><br /> v_ref_cursor ref_cursor;<br /><br /> CURSOR cur_get_order IS<br /> SELECT organization_id,<br /> organization_code<br /> ...
-
编辑 删除
Debugging Oracle Apps code
FND Debug Log - Debugging Oracle Apps code
-
编辑 删除
OM process
http://blog.csdn.net/pan_tian/article/details/7693447
-
编辑 删除
OM apply hold/release hold
Code sample: declarerecord_hold_source oe_holds_pvt.hold_source_rec_type; v_msg_data VARCHAR2 (2000)...
-
编辑 删除
Oracle AOL API(Lookup,Profile,Value set value) , testing in R11 11.5.10
FND_PROFILE.SAVE(, , , &nbs...
-
编辑 删除
弹性域报表实例(二）
报表 3：表格式报表[@more@]This is a sample report that selects Accounting Flexfield information for a single structure for a single company. This report uses a more complex WHERE clause with an ORDER BY clause. It also contains extra columns for the report header information.Sample OutputThis report contains a list of Accounting Flexfield combinations and a description for each based on their segment values. It has a more complex header that includes the set of books, date, currency, period, and
-
编辑 删除
弹性域报表实例(一）
本节示范如何将弹性域数据纳入报表，以及如何使用 Oracle Application Object Library (AOL) 用户出口来建立不同类型的弹性域报表。以下样本报表示范了五种构造报表的方法。[@more@]本节示范如何将弹性域数据纳入报表，以及如何使用 Oracle Application Object Library (AOL) 用户出口来建立不同类型的弹性域报表。以下样本报表示范了五种构造报表的方法。报表 1：简单表格式报表报表 2：具有多弹性域结构的简单表格式报表报表 3：表格式报表报表 4：主 - 明细报表报表 5：多结构的主 - 明细报表前两个实例显示了建立具有弹性域支持的报表
-
编辑 删除
Which responsibility ran the sales order Workflow ？
OEOL Workflow , 客制化一个function node ，在function node 里面 call apply hold API， 问题来了apply hold API 会check对于hold name 的职责权限， 那些职责有权限做apply hold和release hold， 很想知道workflow取的环境的值是什么，取的是那个职责。 fnd_global.apps_initialize我们知道Workflow是后台运行的，通过...
-
编辑 删除
How to find the common problems from the trace file
1. didn't use the bind variableA number of very similar statements that execute only once (Executions = 1)2. Ratio between logical IOs and processed rows is big (greater than 1000)Normally this is evidence of an inferior execution plan and could also indicate a big number of throwaways due to po...
