-
编辑 删除
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...
