Oracle EBS: 用於處理OM order之API
OE_ORDER_PUB.Process_order(
Standard Parameters
Specific Parameters)
功能包括:
CREATE
UPDATE
Reserve
Unreserve
Split line
Delete
Book order
Apply hold
Release hold
Ref:
1.Process Order API In Order Management (Doc ID 746787.1)
Q: OM的transaction type是否有API可用?
A: 沒有, 若要update, 可以直接改table, 但對於新增, 尚未能確定要寫入哪些table, 或許可以只處理以下兩個table:
OE_TRANSACTION_TYPES_ALL.
OE_TRANSACTION_TYPES_TL.
Ref:
1.API for creating transaction type in order management in r12
https://community.oracle.com/mosc/discussion/4297735/api-for-creating-transaction-type-in-order-management-in-r12
Receipt Routing常看到, 但沒特別注意有什麼差別. 既然有人問了, 就來查查.
依原始說明資料:
Direct Delivery: 收貨後直接入庫, 在同一筆交易中
Standard Receipt: 收貨與入庫是各自獨立的交易, 入庫前可作檢驗或轉倉
Inspection Required: 收貨後進行檢驗, 另一筆獨立交易作入庫
--
Shipments are received into a receiving location and put away in the same transaction. Put away happens automatically upon receipt creation.
Shipments are received into a receiving location and then put away in a separate transaction. Standard receipts can be inspected or transferred before put away.
Shipments are received into a receiving location and then inspected and put away in separate transactions. You can accept or reject material during the inspection, and put away to separate locations, based on the inspection result.
Ref:
1.Receipt Routing
https://docs.oracle.com/en/cloud/saas/supply-chain-management/23a/famli/receipt-routing.html#s20029748
解決 UTF-8 編碼 CSV 檔案出現亂碼問題
STEP 1: 在 Excel 中選擇「資料」頁籤中的「從文字/CSV匯入」。
STEP 2: 選擇自己的 CSV 檔案。
STEP 3: 實際匯入資料之前可以先預覽資料的狀況，預設的編碼方式是 Big5，要選擇正確的編碼才能得到正確的資料。
STEP 4: 如果是 UTF-8 編碼的 CSV 檔案，就選擇「65001: Unicode (UTF-8)」這個編碼方式。
STEP 5: 如果選擇的編碼正確，就可以看到實際的資料了，如果分隔符號不是逗號，也可以在這裡調整。確認資料沒問題之後，按下「載入」即可匯入資料。
STEP 6: 這是搭配正確的編碼，將 UTF-8 資料匯入的結果。
Ref:
1.Excel 解決 UTF-8 編碼 CSV 檔案出現亂碼問題教學
https://officeguide.cc/excel-import-csv-file-with-utf8-big5-encoding-tutorial-examples/
問題: 客製的 Oracle Form 多數查不出使用記錄, 只有少數Form有記錄
原因: 客製的Form需要在 Pre-Form 中註明 Form name 跟 Application , 才會被加入使用記錄中
