Work Order Material Availability Check Using Deep Links in Oracle Manufacturing Cloud


Often a times, shop floor team struggles with understanding how much on hand existing in supply sub inventory of a work order to transact. So, it is important for shop floor transacting a work order to know how much on hand is available in supply sub inventory of an item so that transaction processing is done efficiently. This solution outlines the bringing visibility of on hand in supply sub inventory of an item and how this can be included in a work order using deep links.


Conventional Solution


Figure 1 – Conventional Solution


As a conventional solution of Oracle Manufacturing Cloud, work order shows organization on-hand balance instead of on hand available in supply sub inventory. This leaves users at a disadvantageous situation not having visibility of what on hand is available in supply sub inventory whenever any transaction error occurs, and transaction error does not even specify which item is having on hand shortage. In order users to know the on hand, they need to navigate back to inventory management with appropriate roles & data access, query an item in supply sub inventory under ‘Manage Item Quantities’ screen. These are additional steps and sometimes, these screens are not even provided to shop floor users.

Solution Details

Visibility of bringing on hand in supply sub inventory for items in work order gives users a view what on hand exists in supply sub inventory and in organization and can decide whether materials are to be issued to supply sub inventory or PO receipts are to be carried out to bring in on hand. The solution to provide this visibility greatly helps shop floor users to get this view and take informed decisions.

Below are high level solution details.

  1. Create a BIP Report
  2. Embed the report / dashboard into work order screen.

Embed OTBI & Dashboards with in MFG cloud.

Below are steps to follow to enable this OTBI report to be made available in work order screen.

1.    Create & Enter Sandbox with “Page Composer” tool.


2.  Navigate to Edit Work Order page


3.Enter Page Composer mode & select “Structure.”


4.Within the WO Go to Panel Region select “panelTabbed:Above” select properties



5. Click on “+ Add Tab” to add new tab and can be renamed as required and Apply changes.



6.Next Select “Add Content” > Click on + Add Content in Newly created tab > Click on Components > + Add Webpage



7. Go to Properties of the Webpage > go to the source and edit the expression > select Binding parameter = Work order and replace the expression with OTBI/Dashboards path


In above url, we need to restrict the BIP report parameters to run for the work order for which this report is applicable.

https://<Application url>/analytics/saw.dll?Go&Dashboard&PortalPath=%2Fshared%2FCustom%2F_portal%2FFIB%20WO%20OHB&page=page%201&Action=Navigate&P0=1&P1=eq&P2=”Work%20Order”.”Work%20Order”&P3=#{bindings.WorkOrderNumber.inputValue}




·         This solution is built using standard features of Oracle Cloud and with minimal coding

·         Implemented in ‘Home & Security’ manufacturing organization.

·         Saved 150 person hrs. effort per month.

·         Improved process efficiency.

·         Easy to maintain and enhance.

·         Highly leverageable and can be implemented in similar engagements.




ERP: Enterprise Resource Planning

OIC: Oracle Integration Cloud Service

FG: Finished Good

Mfg: Manufacturing

BIP: Business Intelligence Publisher





Sudarshan Musku, Senior Consultant.

Viswanadham Sighakolli, Principal Consultant.




Author Details

Viswanadham Sighakolli

Viswanadham Sighakolli is an Oracle Fusion Cloud Principal consultant having having 17.5 years of rich consulting expertise in Oracle Supply Chain & Mfg (OPM & Discrete) modules backed by 5 yrs 8 Months of rich domain experience. Having good knowledge on integration touch points with Finance modules. He is an Enterprise Solution Architect delivering client value and also experienced in ERP transformational programs. He worked clientele from all geographies (Americas, APAC, Europe). He is a PMP certified, Fusion Cloud certified in Procurement, Manufacturing, Costing, Inventory Implementation Essentials & Data Scientist enthusiastic. He worked multiple industries like Home & Security, High-Tech Distributor, Automotive Manufacturing, Inverter, Textiles, Engineering, Chemical, Aerospace and ATM Manufacturers.

Leave a Comment

Your email address will not be published.