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

Query behind Orderless Work Orders - Review Production Transaction History

edited Jul 23, 2024 1:48PM in Manufacturing 2 comments

Summary:

Hi,

I tried looking for a REST/SOAP service to get the details similar to the UI - "Review Production transaction History (selected with Orderless)"

Log on to Fusion applications and Under Supply Chain Execution->Work Execution from the Task pane - select 'Review Production Transaction History' under Execute Production.

Since there is no public web service, I started looking to get the query behind the form. There is no subject analysis to check the tables or query and when looking into the end tables, I noticed the operation and resources come from work definition where as work order names are from the work order table. Is it possible to get the query used behind the Review Production Transaction History so that I can use it to create a custom web service?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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