How to Improve Turnaround time of Oracle ATO (assemble to order) Updates

Introduction

Are you using Oracle Fusion Order Management? Are you struggling with updating / cancelling of Oracle ATO lines? Jade Global can solve this for you.

This blog post will discuss on how we solved this for one of fortune 500 client.

We have created a custom UI solution using Oracle Apex which navigates from Order Entry page in Oracle Fusion Order Management, giving quick access to

• Modify Header and Line EFFs
• Copy an ATO line
• Cancel multiple lines or all lines

Scope and Benefits of the Oracle Apex UI Solution

This UI customization and extension solution is not limited to individual customer-specific requirements and can be tailored to business needs and use cases. As per the current development & features, this solves the central problem: generic across global customers having multiple order lines processing and can significantly reduce the turnaround time.

This UI extension is of great importance for Semi-Conductor, Automotive or Telecommunication Industries where multi lines Assembly-to-order (ATO) orders are being processed.

Assemble-to-Order, or ATO, is a manufacturing strategy in which products are assembled from previously completed sub-assemblies once an order comes in. The ATO workflow is used for goods that still have some customizability but the sub-assemblies are made to stock before orders come in.

The Solution For ATO

Using Oracle Apex and REST / SOAP Web Services provided by Oracle we have created a PL/SQL package which internally calls various procedures to fetch data from and update or modify EFFs and line information.

Screenshot 1: Order Entry Page of Oracle Fusion Order Management having navigation link for custom UI

Upon Click of the Update Order Tool, it calls BIP SOAP web service, which fetches data from Fusion and Inserts it in Oracle DBaaS. It displays the data in the UI for the respective order.

For Copy ATO Lines and cancelling multiple lines, logic is being written in PL/SQL, which internally calls REST Web service to push records in SaaS.

For Header and Line EFFs update, SOAP Web service call is also being used, which stores the data in DbaaS and updates the same in Fusion.

Screenshot 2: Copy ATO Line feature

Screenshot 3: Modify Header / Line EFFs

SOAP WSDL URL - /soa-infra/services/default/DooDecompReceiveOrderExternalComposite/ReceiveOrderRequestService? WSDL

Action -http://xmlns.oracle.com/apps/scm/doo/decomposition/receiveTransform/receiveSalesOrder/DooDecompReceiveOrderExternalComposite

Screenshot 4: Cancel multiple or All Lines

REST API URI -hostname:443/fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub/sourcetransactionsystem: sourcetransactionid

Conclusion

If your organization is planning to implement this extension and reduce the turnaround time significantly, reach out to us and talk to our experts who have hands-on experience in implementation and customization using Oracle Apex SOAP and Apex Rest Web Service VBCS. This extension enables the customer with faster order processing and easy to use interface with striking features that can be extended and scaled further as per business use cases.

Click HERE to know more about our Oracle Service offerings.