問題: 因要保留舊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/
