Simon82
Member
Hello List,
we are a manufacturing factory and for the next year we are planning to introduce a MES and a WMS system in order to achieve a more flexible control of the production and help our people in the warehouse to schedule the picking of the materials.
Since this will bring in a lot of interfaces with JDE (9.1) we are trying to understand which can be the better solution for us to build the data-interchange.
Here below are some insights we just came to:
- webservices: we're not ready. Never implemented and apparently costly (hw+sw)
- flat files: we already had some expierience with that and we consider this solution too inefficient to guarantee data alignment
- staging-tables : already used for smaller interfaces - at the moment it seems the best trade off
Regarding JDE specifically:
1- I already had a look to "interoperability" and I think it will be useful to move data/changes of F4101,F4102,F0101 and then F4211-F4311 for item mevements and F4801/F3111/F3112 for workorders.
I'm a little in doubt how to pass receipts (standard interop has some bugs) and other small custom data.
2- I had a look to subsystem jobs (and I like the solution. This could help us to avoid WSJ being filled by 1-minute-scheduled reports). Btw on the forum I noticed that subsystem jobs are suggested when the update frequency is higher/continuous.
3- We also already (positively) implemented a solution where there's a single JDE UBE / DISPATCHER (scheduled each minute) which checks on a "reference table" if there are new transactions to process, triggering the needed report only in case it has to update a JDE table or a shared table.
What do you think?
Any idea / experience with be appreciated!
Thanks in advance.
we are a manufacturing factory and for the next year we are planning to introduce a MES and a WMS system in order to achieve a more flexible control of the production and help our people in the warehouse to schedule the picking of the materials.
Since this will bring in a lot of interfaces with JDE (9.1) we are trying to understand which can be the better solution for us to build the data-interchange.
Here below are some insights we just came to:
- webservices: we're not ready. Never implemented and apparently costly (hw+sw)
- flat files: we already had some expierience with that and we consider this solution too inefficient to guarantee data alignment
- staging-tables : already used for smaller interfaces - at the moment it seems the best trade off
Regarding JDE specifically:
1- I already had a look to "interoperability" and I think it will be useful to move data/changes of F4101,F4102,F0101 and then F4211-F4311 for item mevements and F4801/F3111/F3112 for workorders.
I'm a little in doubt how to pass receipts (standard interop has some bugs) and other small custom data.
2- I had a look to subsystem jobs (and I like the solution. This could help us to avoid WSJ being filled by 1-minute-scheduled reports). Btw on the forum I noticed that subsystem jobs are suggested when the update frequency is higher/continuous.
3- We also already (positively) implemented a solution where there's a single JDE UBE / DISPATCHER (scheduled each minute) which checks on a "reference table" if there are new transactions to process, triggering the needed report only in case it has to update a JDE table or a shared table.
What do you think?
Any idea / experience with be appreciated!
Thanks in advance.
Last edited: