-
编辑 删除
how to use VLOOKUP
=VLOOKUP(D2,'Sheet 1 (2)'!$D$2:$D$43,1,0)1. first choose a value as the parameter 12. choose the search area, but don't forget to add a $ maually (if not, the seach area will change when we copy the vlookup)3. click the column when it displays a + scroll down , then we...
-
编辑 删除
temp table
CREATE GLOBAL TEMPORARY TABLE ([COLUMN DEFINTION]) ON COMMIT [DELETE | PRESERVE] ROWS;on commit delete rows,it means when you commit the row which you insert, then there is no data in the temp table(in the same session)on commit perserve rows,it measns when you do commit, the data sti...
-
编辑 删除
查询GL账号描述信息, fetching GL Description
Select description fromfnd_flex_values_vlwhere flex_Value = <segment value>and flex_value_set_id = < enter the value set id > Select GCC.CONCATENATED_SEGMENTS ACCOUNT,GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION(GCC.CHART _OF_ACCOUNTS_ID,GCC.CODE_COMBINATION_ID) DESCRIPTIONfrom GL_CODE_COMBINATIO...
-
编辑 删除
ORCLE 数据库中一些常用的表
1. DBA_TAB_PRIVS -- 用来查询那些数据库账号对某个表有什么权限。select * from dba_tab_privs where privilege = 'DELETE' and table_name IN ( 'XXAP_JFI_SUPPLIERS','XXAP_JFI_SUPPLIER_SITES',)AND GRANTEE ='JASON_SU'2. ALL_DEPENDENCIES --这个表厉害了，可以查一...
-
编辑 删除
Some common query which i used in my work
BEGIN DBMS_APPLICATION_INFO.set_client_info (<OU ID>); END; BEGIN fnd_global.apps_initialize(<v_num_user_id>, &nb...
-
编辑 删除
FS-CANT OPEN TEMPFILE
not able to open output and log file for all of request, it shows error 'FS-CANT OPEN TEMPFILE'We can run concurrent program 'Purge Concurrent Request and/or Manager Data' to solve issue 'FS-CANT OPEN TEMPFILE'
-
编辑 删除
FA period closing process.
Please see the FA closing process: Here are steps & procedures for performing period-end processing in Oracle Assets Release 12.In FA, at period end, we require to run depreciation for depreciation books set up for the organization, and to Create accounting for Oracle General Ledg...
-
编辑 删除
（原创）FA 期间重新打开
FA 期间被认为是 关闭后不再能打开。虽然不知道强行打开具体会有什么问题出现， 但是还是避免不了客户误操作导致期间关闭，所以重新打开的需求将是很迫切的。我在一次事件中做过这样的操作， 测试了运行折旧， 和创...
-
编辑 删除
RTF can't do Preview
1. when you want to do preview after you loading XML data.it shows below error message:Error No:53Description:File not foundPlease confirm that:1)A java runtime version 1.3 or later is installed correctly;2)The Java executable is accessible through the windows path or the jave home directory ...
-
编辑 删除
how the control the concurrent program return status in the form
we know we can use retcode =0 or 1 to control the concurrent program return status for PL/SQL TypeHow can we do it the form builder?IF -- Set Concurrent Request Warning v_boo_status := fnd_concurrent.set_completion_status('WARNING',v_ch...
-
编辑 删除
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)...
