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 -

Screenshot 4: Cancel multiple or All Lines


REST API URI -hostname:443/fscmRestApi/resources/ sourcetransactionid


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.

Subscribe to our email Newsletter

Popular Posts


About the Author

Mrigank Sharma

Mrigank Sharma

Manager - Client Services, Enterprise Cloud Apps - Oracle

Mrigank Sharma has 14+ years of experience in EBS (OAF/XML Publisher/Interfaces/Conversions) & Oracle Fusion Implementation, R12 Upgrade, Enhancement & Support (11i, R12.x.x). In the last 6 years, he has extensively worked on Oracle fusion PaaS offerings like (OIC/Cloud APEX/VBCS/DbaaS). Also, have expertise in Oracle fusion RestAPI for O2C and R2R modules. Has expertise in pre-sales activities to estimate and solve custom modules to be integrated with fusion apps.

About the Author

profile image

Vivek Agarwal

Senior Technical Analyst, Enterprise Clouds - Oracle

Vivek Agarwal is a Senior Technical Analyst and has worked on Oracle Technologies for over 6 years. His primary focus for the past few years has been on Oracle Fusion Technologies, including Data Migration, BI Reporting, Integration Cloud, Fusion SaaS, and PaaS customizations/extensions.

How Can We Help You?