Manufacturing

Get Involved. Join the Conversation.

Topic

    Sam Napoli
    Quick Way to Identify Complete Work Orders with Missing...Answered
    Topic posted October 16, 2019 by Sam NapoliBronze Medal: 1,250+ Points, tagged Work Execution 
    54 Views, 5 Comments
    Title:
    Quick Way to Identify Complete Work Orders with Missing Transactions
    Summary:
    Quick Way to Identify Complete Work Orders with Missing Transactions
    Content:

     The user is seeking functionality where they can be presented with a list of work orders with status Complete, but material or resources are not recorded. This being the list of exceptions they need to fix before they Mass Close all the work orders. The Dispatch List UI provides a visual indication of which work orders need recording of material and resources, as well as which have been done (tick) and which are outstanding (paper and pencil). However, there's no way to filter the list by this. Is there a UI or report which can be used? If not, how could I write a report to show this? How does the Dispatch List UI do it?

     

     

    Version:
    19C
    Image:

    Best Comment

    Siddesh Colvenkar

    Sam,

    There isnt any data model attribute either at work order level or at work order material level which tracks material(s) is/are fully issued. 

    Also there isnt any attribute to store the open quantity(i.e the yet to be issued quantity) for a given material and is determined as part of the UI logic. 

    the tick icon in Dispatch list are determined as part of the UI logic by first determining the open quantities for push material requirements and then aggregating it for all the material requirements for a given operation. 

    Let me know if you need any more details. 

     

     

    Comment

     

    • Thierry Lamote

      Sam

      Did you already leverage in your setup the 19B enhancement named "Validate Material Issue and Operation Completion During Production", which would allow to eliminate/solve a part of your problem by setting up the operation attribute “Completions with Under Issues” to  “Do not allow” or “Allow with warning”.

      At least the Push material part of your above requirement can be handled by preventing completion with insufficient component issues.

      You can find more details about it here:

      Readiness Training Video: https://download.oracle.com/ocomdocs/global/apps_19B/scm/Validate_Material_Issue_Operation_Completion/index.html

      This feature has an opt in.

      Besides, BI Publisher and OTBI features to retrieve what you look for should be investigated.

      Hope this helps

       

      • Sam Napoli

        Thanks Thierry. i was aware of this feature, but it doesn't fit their business process. The way the company manufactures, they need to record the completion first and then record material issue afterwards. Partial completions happen through barcode scanning for each pack produced. They can only record material usage at the end, once they've measured the amount of material used. So we need a mechanism to review the work orders completed today but without material recorded. Of course, I could write a custom report which compared material issued vs required quantity, but I'm wondering if there's a simplier way? How does the Dispatch List know to show the tick icon? Is there a field set somewhere when material is fully issued or is the UI exactly doing a comparison for each individual work order?


        Sam

        • Siddesh Colvenkar

          Sam,

          I am checking internally whether there is any data model attribute which tracks whether material is fully issued. 

           

           

          • Siddesh Colvenkar

            Sam,

            There isnt any data model attribute either at work order level or at work order material level which tracks material(s) is/are fully issued. 

            Also there isnt any attribute to store the open quantity(i.e the yet to be issued quantity) for a given material and is determined as part of the UI logic. 

            the tick icon in Dispatch list are determined as part of the UI logic by first determining the open quantities for push material requirements and then aggregating it for all the material requirements for a given operation. 

            Let me know if you need any more details. 

             

             

            • Sam Napoli

              Thanks for looking into this Siddesh. We could still write a custom report. It would just have to be a little more complex and have to check the Required and Issued Quantity for each material. You've set me on the right path. Thanks