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
