Supply and Demand Performance

[Natalie W]

Hi there,
We are in 8.10 non-web and have recently started to have serious performance issues in supply and demand, where the time to look up one part takes an 4-5 minutes.
We have purged data recently, defragged indices in the database, but that has helped very little.
The SARS that are posted for Supply & Demand (which may or may not help) require installing huge ESUs which touch 300+ objects.
Can anyone offer any other tips on performance improvement for S&D?
We are on version EnterpriseOne 8.10 tools 8.96.2.2.

Thanks.

 

[Larry_Jones]

Hello Natalie, welcome to JDEList.
FYI its always good practice to include platform and database also - in this case the solution may be database oriented so please let us know.

Some questions:

1. Does this happen on all parts or only the most frequently transacted parts?
2. For a part that this happens on, how many location records exist for that part?
3. Have you recently installed any ESUs?
4. Has anyone recently changed OCM mappings?
5. Do you have any customizations to B3400310?

 

[Natalie W]

Hi Larry,
Thanks for your reply.
We are running on windows 2003, sql 2000

To answer your questions,
1. The long response time is on the most frequently transacted parts
2. The # of locations is usually 2.
3. No, we have not installed any esus recently.
4. About OCM mappings, no we have not changed any mappings.
5. No, no customizations have been made to B3400310.

Thanks,
Natalie

 

[rahul123]

Deploy only P4021, B3400310, B3400300 from the ESU. There are some good performance enhancements. Specially if you are in a Manufacturing environment, you will see significant improvement.
One of the things that helps is that this program reads demand from F3111 (Parts List). Since Parts List Table does not have the work order status, P4021 reads all Parts list records in the system, then goes to F4801 for the work order to check the status(to reject completed and cancelled WO).
With the SAR, a join view of F4801, F4801T and F3111 is used and the closed and cancelled Orders are never read.
Same is true for Sales Orders.
The currency triggers are disabled for the program.
If you are using Forecast Consumption in MRP, that is implemented within the Supply Demand Application as well.

 

[Natalie W]

Thanks for your reply. That sounds encouraging! We will try that.
We're not sure how to get only select objects from the ESU, but hopefully we can find someone who can (advanced cnc resource? or is it fairly straightforward?)

Thanks again,
Natalie