Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

The REST API is failing to retrieve the lot details for a work order

Summary:

Hi Team,

We use this API to obtain the lot number: https://{pod}:443/fscmRestApi/resources/11.13.18.05/workOrders/{WO ID}/child/WorkOrderLotNumber. However, this is unfortunately not supported for lot numbers assigned during work order completion and works only for preassigned lot numbers. As an alternative, we are using another API to get the details: https://{pod}:443/fscmRestApi/resources/11.13.18.05/inventoryCompletedTransactions/{TransactionId}/child/lots. The transaction ID can be obtained using the following query: select * from INV_MATERIAL_TXNS where TRANSACTION_SOURCE_NAME = {'WO number'}. However, this query returns many transaction IDs. Could you please assist us with this?

Content (please ensure you mask any confidential information):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!