Oracle EBS: 修改RCV interface資料以重收貨

Oracle EBS: 修改RCV interface資料以重收貨

update rcv_headers_interface rhi

 set processing_request_id=null ,

receipt_header_id=null ,

validation_flag = 'Y' ,

processing_status_code = 'PENDING'

where 1=1 --group_id = 2634307

  and processing_status_code = 'ERROR'

  and exists  (select header_interface_id 

                 from rcv_transactions_interface rti

                where rhi.HEADER_INTERFACE_ID=rti.HEADER_INTERFACE_ID )

  

update rcv_transactions_interface

  set request_id=null ,

processing_request_id=null ,

order_transaction_id=null ,

primary_quantity=null ,

primary_unit_of_measure=null ,

interface_transaction_qty=null ,

validation_flag = 'Y' ,

processing_status_code = 'PENDING' ,

transaction_status_code = 'PENDING' 

 where 1=1 --group_id = 2634307

   and (processing_status_code = 'ERROR' or transaction_status_code = 'ERROR')

      

--------------------------------------------------------------------------------------

update rcv_headers_interface rhi

 set processing_request_id=null ,

receipt_header_id=null ,

validation_flag = 'Y' ,

processing_status_code = 'PENDING'

where group_id = ?2638496

  and processing_status_code = 'ERROR'

  and exists  (select header_interface_id 

                 from rcv_transactions_interface rti

                where rhi.HEADER_INTERFACE_ID=rti.HEADER_INTERFACE_ID )

  

update rcv_transactions_interface

  set request_id=null ,

processing_request_id=null ,

order_transaction_id=null ,

primary_quantity=null ,

primary_unit_of_measure=null ,

interface_transaction_qty=null ,

validation_flag = 'Y' ,

processing_status_code = 'PENDING' ,

transaction_status_code = 'PENDING' 

 where group_id = ?2638496

 

Oracle EBS: 用於處理OM order之API

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)

Oracle EBS: OM的transaction type是否有API可用?

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

Oracle EBS: Receipt Routing概述

 Receipt Routing常看到, 但沒特別注意有什麼差別. 既然有人問了, 就來查查.

依原始說明資料:

Direct Delivery: 收貨後直接入庫, 在同一筆交易中

Standard Receipt: 收貨與入庫是各自獨立的交易, 入庫前可作檢驗或轉倉

Inspection Required: 收貨後進行檢驗, 另一筆獨立交易作入庫

--

Direct Delivery

Shipments are received into a receiving location and put away in the same transaction. Put away happens automatically upon receipt creation.

Standard Receipt

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.

Inspection Required

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

EXCEL: 解決 UTF-8 編碼 CSV 檔案出現亂碼問題

解決 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/