Skip to Main Content

API, CLI, SDK & Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

For the Material Consumption, what is the right API to GET the LOT generated for each item?

Ali RasmySep 17 2025 — edited Sep 17 2025

I am working on integrating with Oracle Fusion SCM using the REST APIs.

When I post material consumption (issue of raw material) using the materialTransactions REST API, Oracle requires me to provide the TransactionLot details.

However, I am not able to retrieve the generated or assigned lot numbers from the processWorkOrders REST API.

Questions:

  1. Which REST API should I use to get the lot numbers that are available for a given inventory item?
  2. Can I retrieve them directly from Inventory (for example, through lots, materialLots, or inventoryBalance APIs)?
  3. Is there a way to query the available lot numbers tied to a specific work order and operation?

I am testing with Postman at the moment and would appreciate any pointers or example payloads.

Comments
Post Details
Added on Sep 17 2025
0 comments
39 views