2023年8月14日 星期一

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)

2023年8月11日 星期五

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



2023年8月4日 星期五

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