Oracle EBS: Supplier Item Catalog畫面Due Date之作用
在說明文件上查到:
11. Enter the Due Date to get documents that are current as of this date or future effective. If you access this window from the Requisitions or Purchase Orders window, the default is the due date on the originating document line.
Ref:
1.Finding Supplier Items
https://docs.oracle.com/cd/A60725_05/html/comnls/us/po/sicov01.htm
問題: 因要保留舊PO號碼, 故對調新舊PO號碼. 舊PO已approve過, 把新舊PO號碼對調後, 新PO無法正常approve
Error Message(在workflow及user收到的通知信上):
po.plsql.PO_DOCUMENT_ACTION_AUTH.approve:90:archive_po not successful - po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call
原因: archive中已有相同PO號碼及版次, 造成unique key衝突
解法: 修改archive資料
Ref:
1.PO Approval Errors: Po.plsql.PO_DOCUMENT_ACTION_AUTH.Approve:90:Archive_po Not Successful: ORA-00001: (PO.PO_HEADERS_ARCHIVE_U2) (Doc ID 1296639.1)
Oracle SQL: 去除換行、空格、水平符號
基本款:
select replace(replace(replace(replace(?string, chr(13), ''), chr(10), ''), chr(9), ''), ' ', '') from dual
進階款:
select translate(?string, 'a ' || chr(9) || chr(10) || chr(13), 'a') from dual
Q: 使用excel格式(97-2003)的BI publisher report是否筆數能超過65536筆?
A: 不行, 只能使用RTF格式, 或是把資料分割到多到工作表中. 在BI Publisher 11.1.1.9及後版本可以產生xslx檔.
Ref:
1.Can we get more than 66K records by using BI publisher reports in excel output format ?
https://community.oracle.com/mosc/discussion/4115589/can-we-get-more-than-66k-records-by-using-bi-publisher-reports-in-excel-output-format
2.Splitting the Report into Multiple Sheets (Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher)
https://docs.oracle.com/middleware/11119/bip/BIPRD/create_excel_tmpl.htm#ext_multsheets
3.BI Publisher Excel Template Layout Output is Truncating Data to 65536 Rows (Doc ID 1469264.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=533024111404255&id=1469264.1&_afrWindowMode=0&_adf.ctrl-state=orvd8jckk_4
工單狀況與lookup_code對應
SELECT flv.language,
flv.lookup_code,
flv.meaning,
flv.description,
flv.source_lang,
flv.security_group_id,
flv.tag,
flttl.lookup_type,
flttl.view_application_id,
flttl.language,
flttl.meaning,
flttl.description
FROM applsys.fnd_lookup_values flv, applsys.fnd_lookup_types_tl flttl
WHERE (flttl.lookup_type = flv.lookup_type
AND flv.lookup_type LIKE 'WIP_JOB_STATUS');
號稱可在Edge/Chrome直接執行Oracle EBS的程式. 可試用, 有天數限制, 期滿後需購買授權.
ThinForms Chrome Extension
Run your Oracle EBS and Oracle Forms Applications with the latest Chrome Browser or Microsoft Edge (Chromium)
Cookie and SSO support, native EBS login
Fixes various Forms Bugs, e.g. TAB key in Database Login Screen
(simply enable in Extension Options)
And its simple - just click here go to the Chrome Web Store and install the Extension
Chrome uses the ThinForms Java Host App to run your Forms Applications - all required files will be downloaded for you by the Chrome Extension. Alternatively, you can directly install the ThinForms Java Host application from here
Ref:
1.TalkingByte
https://www.hello.talkingbyte.com/
問題: PO建立時未帶預設稅別, 需手動補入(SO也有相同狀況)
原因: Tax設定不完整
解法: 在Tax權限中補設定
Defaults and Controls
-> Application Tax Options
設定Defaulting Order 1及Defaulting Order 2
問題: 在Oracle support搜尋文章時, knowledge base區無資料
狀況:
1.搜尋文章時, knowledge base區無資料, 但後面的四區有
2.曾出現訊息: "Note: you have not selected the Knowledge Base as a source"訊息
原因: 不明, 其他人無相同狀況
解法: 把Knowledge Base的綠勾按掉再重選... Orz...
Ref:
1.Oracle E-Business Suite Performance Guide (Doc ID 1672174.1)
問題: cancel request時出現could not lock request訊息, 無法成功cancel
狀況:
1.以XML publisher寫的程式執行過久, 要cancel時出現訊息could not lock request
2.程式超過3小時後complete warning
3.log有訊息:
The Output Post-processor is running but has not picked up this request. No further attempts will be made to post-process this request, and the request will be marked with Warning status. Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.
解決方式:
1.Restart Output Post Processor
2.在DB中找出並cancel異常程式對應的session
3.手動更新異常concurrent request的狀態
Ref:
1.Concurrent request receiving Could Not Lock Request when canceling
https://doyensys.com/blogs/concurrent-request-receiving-could-not-lock-request-when-canceling/
2.could not lock request concurrent manager
https://mohamedazar.com/2019/05/16/could-not-lock-request-concurrent-manager/
Ref:
1.validation on email / postcode fields in sql/oracle
validation on email / postcode fields in sql/oracle - Stack Overflow
2.email validation check with Oracle regular expressions
email validation check with Oracle regular expressions (dba-oracle.com)
Oracle EBS快捷鍵, 很少在用, 只作參考.
Ref:
1.oracle-ebs-shortcut-keys
http://oracleebsfundamentals.blogspot.com/2012/11/oracle-ebs-shortcut-keys.html
