Oracle EBS: 修正PO interface資料重轉
select * from po_headers_interface
where ...
select * from po_lines_interface
where interface_header_id = ?19248184
update po_headers_interface
set process_code = null,
processing_id = null
where interface_header_id = ?19248184
update po_lines_interface
set process_code = null,
processing_id = null
where interface_header_id = ?19248184
select * from po_interface_errors
where interface_header_id = ?19248184
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
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
