Applications

Expand all | Collapse all

Manufacturing Scheduling Software?

  • 1.  Manufacturing Scheduling Software?

    Posted 04-29-2021 14:27
    What manufacturing scheduling software are you using? Is anyone using a really simple tool they bought that integrates with EBS? Not looking for a complicated year long implementation, basically just need something quick and easy for a small warehouse that was just bought.

    ------------------------------
    Ryan Hennekens
    Solution Architect
    Charter Manufacturing Company, Inc.
    Mequon WI
    (414) 390-3127
    ------------------------------


  • 2.  RE: Manufacturing Scheduling Software?

    Posted 04-30-2021 09:26
    Without knowing your specific requirements (I've found that 'scheduling' means many things to many people), it's doubtful this will be of much help, but I will share our companies approach for several methods of 'scheduling'.

    We created an extension in php to schedule our demand (in the form of sales orders or wip discrete jobs) that we group our items by what we call a master schedule category ( the category in this instance is a particular  Oracle Inventory Category Set.  This  system stores the current 'load' and compares that to the 'capacity' we created for each of the master schedule categories by organization and date.  The schedulers compare the load vs. capacity and make adjustments if necessary to rebalance.  For new demand (sales orders), the user can place the demand in an available bucket (behind the scenes we are updating the schedule_date fields on oe_order_lines_all via the api.  This schedule is what we consider 'Master Scheduling'...but really it's more of a rough cut plan.

    Once we have Oracle wip discrete jobs, we use API-Wizard to group together like items (by organization_id and master schedule category) and make any final adjustments to dates and then use API-Wizard to release the jobs to the plant floor.  Another version of this scheduling tool in API-Wizard is used to release jobs at our vertically integrated supply plants.

    Finally, we have one organization that acts as a central warehouse.  This organization receives demand from source organizations via internal orders.  We create a special 'Pick and Load' system for this warehouse to do a poor mans WMS.  This system creates pick tickets(from internal sales order demand) with information allowing the pickers to pull inventory based off of the location in the warehouse and then add these items to an 'LPN' (actually an Oracle subinventory).  LPNs can then be tranferred to our subinventory's that are used in pick/ship rules to ship to the source organziations (internal order shipping).  All the transactions at this warehouse are done with handheld scanners and the screens were designed so minimal data entry is required.  The use of the 'LPN' concept alone saves thousands or transactions per day.

    We have one other system we designed for our finish goods warehouse (we also ship our own product as well as customers of our transportation company).  This system stores inventory in Oracle but we have multiple screens designed for picking, transferring, and loading trucks.

    So in summary, we did not use the Oracle scheduling tools, nor buy third party tools.  I think in either case there is almost always a substancial implementation and purchase cost.  What we have works pretty well for our company.

    ------------------------------
    Dean Miller
    Manager of ERP Technology
    OFS Brands, Inc
    Huntingburg IN
    (812) 827-1030
    ------------------------------



  • 3.  RE: Manufacturing Scheduling Software?

    Posted 04-30-2021 09:43
    Thank you for the detailed response. We use and are pretty comfortable with ASCP for planning our multiple warehouses, we have some custom tools we created to finite schedule at other divisions but wanted to see if there was anything real simple out there. I have looked into API wizard, what has been your experience with it? Was it easy to build a "front end" scheduling form using that tool? Were the API hooks easy to use?

    Thanks,
    RYan

    ------------------------------
    Ryan Hennekens
    Solution Architect
    Charter Manufacturing Company, Inc.
    Mequon WI
    (414) 390-3127
    ------------------------------



  • 4.  RE: Manufacturing Scheduling Software?

    Posted 04-30-2021 11:10
    more background: we do not use ASCP, we use the Supply Chain MRP and it meets our needs.  API Wizard is an excel based add-on that has a very easy process to create spreadsheets using Oracle API's, as well as API's that you can create yourself.    We really are happy with this tool, it's easy to use, they have excellent support and knowledge of the Oracle api's, and it quite affordable.  However, based off your question I'm not sure it's what you need if you are thinking form-based?...I guess it depends on what activities your are doing when you are scheduling.  I actually did a presentation on how we used API-Wizard at two OAUG's(most recently at the last conference in Las Vegas)...I'm pretty sure you can pull it up on the OAUG site, or the API-Wizard people would have it available as well.

    ------------------------------
    Dean Miller
    Manager of ERP Technology
    OFS Brands, Inc
    Huntingburg IN
    (812) 683-4848
    ------------------------------



  • 5.  RE: Manufacturing Scheduling Software?

    Posted 04-30-2021 14:52
    I actually attended that session and we're looking into API-Wizard. Didn't know if it had any ability to build simple forms or if it was truly excel based. Even if it is only excel based it may be what we are looking for. 

    On a separate topic.. I have only ever used ASCP. It is a robust tool, but can be complicated and cumbersome is overkill for some of our smaller sites. Is there any documentation on how to set up supply chain MRP? I'm assuming this is done directly in ERP and not a separate instance like ASCP is?

    ------------------------------
    Ryan Hennekens
    Solution Architect
    Charter Manufacturing Company, Inc.
    Mequon WI
    (414) 390-3127
    ------------------------------



  • 6.  RE: Manufacturing Scheduling Software?

    Posted 05-03-2021 08:41
    No...API-Wizard is truly Excel- based.  That being said, if you are creative with Visual Basic Macros (I am not)...there is some ability to pre-process your data before you actually use the 'engine' of API-Wizard, which is to load your excel formatted data into Oracle via API's.

    Concerning ASCP, we did start an implementation in 2008, which we had to cancel, where we planned on doing ASCP.  My opinion, for most companies it's hard to come up with the brain power, or  need for all the bells and whistles that ASCP offers.  

    Supply Chain MRP still uses some of the documentation from many years ago.  We use it to plan  14 organizations together, and think it does a pretty good job.  There isn't a separate 'instance' like ASCP, but like it's predecessor, Oracle MRP, what it does when you launch the process is to snapshot EBS data and sqlload it into the MRP schema.  Once loaded, the Memory Based Planner kicks off and generates the plan.

    My only concern with Supply Chain MRP is what future support can we really expect from Oracle long term....I'm afraid we may be forced to go to ASCP (or some other solution) eventually.

    ------------------------------
    Dean Miller
    Manager of ERP Technology
    OFS Brands, Inc
    Huntingburg IN
    (812) 683-4848
    ------------------------------



  • 7.  RE: Manufacturing Scheduling Software?

    Posted 04-30-2021 10:01
    Good morning Ryan,

    Is there a reason you're looking for a 3rd party and not doing this within EBS?  EBS has production scheduling and Shop floor. 

    We've seen customers use Kinaxis but then there is the integration. 



    ------------------------------
    Peter Quintiliani
    Apps Associates
    (781) 413-1413
    Pete.Quintiliani@AppsAssociates.com
    www.AppsAssociates.com
    ------------------------------