{"id":3163,"date":"2023-09-29T08:32:04","date_gmt":"2023-09-29T03:02:04","guid":{"rendered":"https:\/\/blogs.infosys.com\/infosys-cobalt\/?p=3163"},"modified":"2023-09-29T08:32:04","modified_gmt":"2023-09-29T03:02:04","slug":"work-order-material-availability-check-using-deep-links-in-oracle-manufacturing-cloud","status":"publish","type":"post","link":"https:\/\/blogs.infosys.com\/infosys-cobalt\/cloud-applications\/oracle\/work-order-material-availability-check-using-deep-links-in-oracle-manufacturing-cloud.html","title":{"rendered":"Work Order Material Availability Check Using Deep Links in Oracle Manufacturing Cloud"},"content":{"rendered":"<p><strong>Overview<\/strong><\/p>\n<p>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.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Conventional Solution<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3323\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/core\/uploads\/2023\/09\/Picture1.jpg\" alt=\"\" width=\"1075\" height=\"467\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Figure 1 &#8211; Conventional Solution<\/p>\n<p>&nbsp;<\/p>\n<p>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 &amp; data access, query an item in supply sub inventory under \u2018Manage Item Quantities\u2019 screen. These are additional steps and sometimes, these screens are not even provided to shop floor users.<\/p>\n<p><strong>Solution Details<\/strong><\/p>\n<p>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.<\/p>\n<p>Below are high level solution details.<\/p>\n<ol>\n<li>Create a BIP Report<\/li>\n<li>Embed the report \/ dashboard into work order screen.<\/li>\n<\/ol>\n<p><strong>Embed OTBI &amp; Dashboards with in MFG cloud.<\/strong><\/p>\n<p>Below are steps to follow to enable this OTBI report to be made available in work order screen.<\/p>\n<p>1.\u00a0\u00a0\u00a0 Create &amp; Enter Sandbox with \u201cPage Composer\u201d tool.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3324\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/core\/uploads\/2023\/09\/Picture2-1.jpg\" alt=\"\" width=\"1047\" height=\"505\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>2.\u00a0 Navigate to Edit Work Order page<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3325\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/core\/uploads\/2023\/09\/Picture3.jpg\" alt=\"\" width=\"1445\" height=\"586\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>3.Enter Page Composer mode &amp; select &#8220;Structure.&#8221;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3327\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/core\/uploads\/2023\/09\/Picture4.jpg\" alt=\"\" width=\"1438\" height=\"575\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>4.Within the WO Go to Panel Region select &#8220;panelTabbed:Above&#8221; select properties<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3328\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/core\/uploads\/2023\/09\/Picture5.jpg\" alt=\"\" width=\"1439\" height=\"612\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>5. Click on &#8220;+ Add Tab&#8221; to add new tab and can be renamed as required and Apply changes.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3330\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/core\/uploads\/2023\/09\/Picture6.jpg\" alt=\"\" width=\"1439\" height=\"548\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>6.Next Select &#8220;Add Content&#8221; &gt; Click on + Add Content in Newly created tab &gt; Click on Components &gt; + Add Webpage<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3332\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/core\/uploads\/2023\/09\/Picture8.jpg\" alt=\"\" width=\"1437\" height=\"721\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>7. Go to Properties of the Webpage &gt; go to the source and edit the expression &gt; select Binding parameter = Work order and replace the expression with OTBI\/Dashboards path<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3333\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/core\/uploads\/2023\/09\/Picture9.jpg\" alt=\"\" width=\"1434\" height=\"600\" \/><\/p>\n<p>In above url, we need to restrict the BIP report parameters to run for the work order for which this report is applicable.<\/p>\n<p>https:\/\/&lt;Application url&gt;\/analytics\/saw.dll?Go&amp;Dashboard&amp;PortalPath=%2Fshared%2FCustom%2F_portal%2FFIB%20WO%20OHB&amp;page=page%201&amp;Action=Navigate&amp;P0=1&amp;P1=eq&amp;P2=&#8221;Work%20Order&#8221;.&#8221;Work%20Order&#8221;&amp;P3=#{bindings.WorkOrderNumber.inputValue}<\/p>\n<p>&nbsp;<\/p>\n<p>Takeaways:<\/p>\n<p>&nbsp;<\/p>\n<p>\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 This solution is built using standard features of Oracle Cloud and with minimal coding<\/p>\n<p>\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Implemented in \u2018Home &amp; Security\u2019 manufacturing organization.<\/p>\n<p>\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Saved 150 person hrs. effort per month.<\/p>\n<p>\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Improved process efficiency.<\/p>\n<p>\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Easy to maintain and enhance.<\/p>\n<p>\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Highly leverageable and can be implemented in similar engagements.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Glossary<\/p>\n<p>ERP: Enterprise Resource Planning<\/p>\n<p>OIC: Oracle Integration Cloud Service<\/p>\n<p>FG: Finished Good<\/p>\n<p>Mfg: Manufacturing<\/p>\n<p>BIP: Business Intelligence Publisher<\/p>\n<p>&nbsp;<\/p>\n<p>References:<\/p>\n<p>https:\/\/community.oracle.com\/customerconnect\/events\/603746-scm-using-deep-links-and-otbi-reports-in-manufacturing-cloud<\/p>\n<p>&nbsp;<\/p>\n<p>Authors:<\/p>\n<p>Sudarshan Musku, Senior Consultant.<\/p>\n<p>Viswanadham Sighakolli, Principal Consultant.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview Often a times, shop floor team struggles with understanding how much on hand [&hellip;]<\/p>\n","protected":false},"author":507,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[69],"tags":[143,333],"coauthors":[327],"class_list":["post-3163","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-manufacturing-cloud","tag-work-order"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/posts\/3163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/users\/507"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/comments?post=3163"}],"version-history":[{"count":10,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/posts\/3163\/revisions"}],"predecessor-version":[{"id":3315,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/posts\/3163\/revisions\/3315"}],"wp:attachment":[{"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/media?parent=3163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/categories?post=3163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/tags?post=3163"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/coauthors?post=3163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}