Oracle ERP ZOOM按鈕開發
— 在ERP標準custom.pll文件中,填寫下面類似代碼: FUNCTION zoom_ava …
— 在ERP標準custom.pll文件中,填寫下面類似代碼: FUNCTION zoom_ava …
資料來源: 這裡 ap_po_vendors_apis_pkg.insert_new_vendor(p …
參考資料: 這裡
Display user information (FreeBSD):
$pw usershow user_name user_name:*:1002:1002::0:0:Some User Name:/home/user_name:/bin/sh
You’ll notice that last field (/usr/local/bin/bash) is the shell of the user.
Display user information(AIX):
$ lsuser -a shell root root shell=/usr/bin/ksh
Change user’s shell on FreeBSD system to bash
$ pw usermod user_name -s /usr/local/bin/bash $ pw usershow user_name user_name:*:1002:1002::0:0:Some User Name:/home/user_name:/usr/local/bin/bash
Change user’s shell on Linux
$ chsh -s /bin/bash user_name
Change user shell on AIX
$ chuser shell=/path/to/new/shell root
In this article I’ve used root and user_name users.
You’ll have to use whatever suits your case.
Be careful to what shell you’re changing to because that user (or root in some cases) will not be able to log in if the shell does not exist or is an altered binary file.
資料來源:這裡
SELECT disabled_flag, TO_CHAR(first_connect, 'MM/DD/YYYY HH:MI:SS') start_time, TO_CHAR(SYSDATE, 'HH:MI:SS') current_time, user_name, session_id, ROUND((SYSDATE - last_connect) * 24 * 60) mins_idle, fnd_profile.value_specific('ICX_SESSION_TIMEOUT', a.user_id, a.responsibility_id, a.responsibility_application_id, a.org_id, NULL) timeout FROM icx_sessions a, fnd_user b WHERE a.user_id = b.user_id AND last_connect > SYSDATE - 1 / 24; |
SELECT disabled_flag, to_char(first_connect, 'MM/DD/YYYY HH:MI:SS') start_time, to_char(SYSDATE, 'HH:MI:SS') current_time, user_name, session_id, round((SYSDATE - last_connect) * 24 * 60) mins_idle, fnd_profile.value_specific('ICX_SESSION_TIMEOUT', a.user_id, a.responsibility_id, a.responsibility_application_id, a.org_id, NULL) timeout FROM icx_sessions a, fnd_user b WHERE a.user_id = b.user_id AND last_connect > SYSDATE - 1 / 24;
自己組 SQL 來 monitor
SELECT df.tablespace_name TABLESPACE, df.max_space_gb max_space_gb, df.total_space_gb total_space_gb, (df.total_space_gb - fs.free_space_gb) used_space_gb, fs.free_space_gb free_space_gb, ROUND(100 * (fs.free_space_gb / df.total_space_gb), 2) pct_free, ROUND(100 - 100 * (df.total_space_gb - fs.free_space_gb) / df.max_space_gb, 2) pct_max_free FROM (SELECT tablespace_name, ROUND(SUM(DECODE(autoextensible, 'YES', maxbytes, bytes)) / 1073741824, 2) max_space_gb, ROUND(SUM(bytes) / 1073741824, 2) total_space_gb FROM dba_data_files GROUP BY tablespace_name) df, (SELECT tablespace_name, ROUND(SUM(bytes) / 1073741824, 3) free_space_gb FROM dba_free_space GROUP BY tablespace_name) fs WHERE df.tablespace_name = fs.tablespace_name(+) ORDER BY fs.tablespace_name; |
SELECT df.tablespace_name tablespace, df.max_space_gb max_space_gb, df.total_space_gb total_space_gb, (df.total_space_gb - fs.free_space_gb) used_space_gb, fs.free_space_gb free_space_gb, round(100 * (fs.free_space_gb / df.total_space_gb), 2) pct_free, round(100 - 100 * (df.total_space_gb - fs.free_space_gb) / df.max_space_gb, 2) pct_max_free FROM (SELECT tablespace_name, round(SUM(decode(autoextensible, 'YES', maxbytes, bytes)) / 1073741824, 2) max_space_gb, round(SUM(bytes) / 1073741824, 2) total_space_gb FROM dba_data_files GROUP BY tablespace_name) df, (SELECT tablespace_name, round(SUM(bytes) / 1073741824, 3) free_space_gb FROM dba_free_space GROUP BY tablespace_name) fs WHERE df.tablespace_name = fs.tablespace_name(+) ORDER BY fs.tablespace_name;
開立帳號或變更權限時需特別注意
APP-AR-96983 User Write-off limit does not exist, 註銷金額不存在
可由以下路徑設定權限,
Nav => Setup => Transactions => Approval Limits
文章轉貼自 這裡 Q: PO 中 match approval level 的 3-way / 4-way …
轉貼資訊來源:
1 2 3 4 5 6 7 8 9 10 | Sub ChangeFormualToValue() Dim rng As Range ActiveSheet.EnableCalculation = False For Each rng In ActiveSheet.UsedRange If rng.HasFormula Then rng = rng.Value End If Next ActiveSheet.EnableCalculation = True End Sub |
Sub ChangeFormualToValue() Dim rng As Range ActiveSheet.EnableCalculation = False For Each rng In ActiveSheet.UsedRange If rng.HasFormula Then rng = rng.Value End If Next ActiveSheet.EnableCalculation = True End Sub