- Jan 11 Wed 2017 22:01
-
有關鎖定某些技術文章閱讀需為好友權限問題.
- May 20 Sun 2018 21:59
-
Oracle Form 直接列印 PDF Report (Report Direct Print) form & Report 10/11/12
Version 1.0.0.5
有興趣的客戶,請與我聯繫.
if you interested in this product , please contact us.
Web Form automatically populate Client Printer in Form , user can choice Printer and Direct Print PDF report Object to Client Printer .
deployment product required :
- Apr 25 Wed 2018 20:30
-
EBS close current period Single order
make sure order line closed
check order header workflow
Close header is waiting at 2018/04/30 to start
Metalink official ,just advice update workflow builder Close Order flow and change waiting period ,but if we use , all order will be apply close at same time period check, it not make sense , so let us cheat it ...
write down item_key=479632
- Mar 29 Wed 2017 15:41
-
Oracle database 12.2 new future memo
K文件看倒不錯的enhance , memo 一下~
1.
db 12.2 Quoted User-Defined Identifiers
A quoted user-defined identifier is enclosed in double quotation marks. Between the double quotation marks, any characters from the database character set are allowed except double quotation marks, new line characters, and null characters. For example, these identifiers are acceptable:
Example a
- Feb 28 Tue 2017 13:48
-
E-Business R12 LDAP SSO Integration customization
E-Business R12 LDAP SSO
Integration customization :Multi-Domain
(OAF Version 0.97)
有購買需求請連繫我!
(If you want to buy this product , please contact me.)
- Feb 14 Tue 2017 08:54
-
Oracle 資料庫 QRCODE Package 功能說明
Oracle 資料庫 QRCODE Package 功能說明
(Java Version 0.9)
有購買需求請連繫我!
環境需求
資料庫版本 : 10.2.x , 11.x, 11.2.0.2(+), 12.x
- Oct 18 Tue 2016 02:13
-
Oracle Logminer 查找物件的修改紀錄
基本上redo log = archive log 的前身,就是說當備份機制啟動時,redolog 切換到下一個時就會同時產生一個archivelog
Online redolog
Select * from V_$LOGFILE
- Nov 17 Tue 2015 23:34
-
EBS OM 關閉系統預設稅則 ,建立客制預設稅則
1.建立客制預設稅則function ex:XXOM_TAXASSIGN_PKG.OE_ORDER_LINE_DEF_TAX
/*預設客製參數
FUNCTION OE_ORDER_LINE_DEF_TAX (
p_database_object_name IN VARCHAR2,
p_attribute_code IN VARCHAR2
- Jun 09 Tue 2015 12:22
-
EBS SQL function 取客戶承受風險金額
--參考別人用的標準API,自己 改成SQL可呼叫的function .
CREATE OR REPLACE FUNCTION APPS.XXGET_CUSTOMER_EXPOSURE(I_ORG_ID IN NUMBER , I_CUSTOMER_ID IN NUMBER , I_SITE_ID IN NUMBER default null , I_LIMIT_CURR_CODE IN VARCHAR2 , I_CREDIT_CHECK_RULE_ID IN NUMBER DEFAULT 1041 )
RETURN number
AS
/********************************************************************/
- Mar 03 Tue 2015 11:14
-
Oracle EBS R12 UTF8 鍵盤說明亂碼解法
- Oct 06 Mon 2014 22:25
-
zx_party_tax_profile_pkg.sync_tax_reg_num
如果各位升級EBS 後,修改客戶或供應商資料遇到
1." This record in table HZ_PARTIES cannot be locked as it has been updated by another user"
或
2.'Tax Registration Number is already in use for party type: Third Party, Party Name: XXX'
這些情形,且確定資料根本沒重複且也沒人在更新中...Tax Registration Number 手動進去一筆一筆改
- Oct 03 Fri 2014 23:25
-
oracle 檢查時間區間重複簡單的處理方式
--結尾加上1秒,是因為此function endtime=start_time 視為未重複,
因此稍作手腳給他變一下可檢查到endtime=start_time
--重複 --X
SELECT * FROM DUAL
WHERE
