4 Replies Latest reply: Aug 26, 2011 8:09 AM by user604737 Branched to a new discussion. RSS

    Reservations from ASCP

    user604737
      Hi,

      I have a question on ASCP (11.5.10)funtionality.

      We create SO for ATO Model, configure it to create * Item (configured item). We collect data and run unconstrained plan. Checking the workbench we can see that ASCP recommends to create a Discrete Wip Job (Make Item). We release the order from ASCP. This will run the WIP Mass Load and creates a WIP JO in the destinations (Transaction) instance. But, it does not get reserved to the Sales order, is this a bug in ASCP? If this is a functionality what is the logic behind this, why is oracle not reserving the WIP order for the sales order?

      What is the best possible workaround to populate the reservatiion automatically?

      Looking forward for a reply.

      Thanks
        • 1. Re: Reservations from ASCP
          Sandeep Gandhi, Consultant
          What you see is intended functionality.
          If you want the WO to get reserved to the SO automatically, you need to schedule the "Autocreate final assembly work orders" concurrent request. That request will create jobs and reserve them to the sales order.

          Hope this helps
          Sandeep Gandhi
          Independent Techno-functional Consultant
          • 2. Re: Reservations from ASCP
            user604737
            Hi Sandeep,
            Thanks for the quick response.

            We want to create jobs from ASCP workbench only. Is there a way we can reserve the WIP job to the SO when released from ASCP. What would be a good technical approach (customization) to fulfill this requirement? Any of your suggestions would help us a lot.

            Regards
            • 3. Re: Reservations from ASCP
              Sandeep Gandhi, Consultant
              When you release a job, ASCP creates a record in wip interface table.
              Write a d/b trigger on this table.
              In the trigger, use the transaction id to find the record in msc_supplies.
              Traverse the pegging tree using this to reach the demand_id.
              Using the demand id get the sales order number.
              Create a temp. table that stores the job# and the sales order number.

              Use that as a link.

              If you want, you can then use this table and create reservations between the sales order and the work order.

              Hope this helps
              Sandeep Gandhi
              Independent Techno-functional Consultant

              PS: This approach is not perfect. But I can't think of any other way.
              • 4. Re: Reservations from ASCP
                user604737
                Thanks Sandeep, we will look into the option suggested.