Question

Performance Issue in Receive Shop Order Window

  • 5 September 2022
  • 3 replies
  • 61 views
D
Rank
Userlevel 3
Badge +9

Environment: 

App8 IEE

 

Steps followed:

1. Navigate to 'Receive Shop Order' Window.
2. Search for an Order.
3. In the 'HU Handling' section set 'Qty To Report' as ‘1’.
4. Save the Order.
5. After saving the order, it takes around 120 seconds to save the record.
6. Normally it takes around 4 - 5 seconds for this execution.

 

Outcome:

 

In the 'HU Handling' section set 'Qty To Report' as ‘1’ and Save the Order.

 
It takes around 120 seconds for the execution in Customer’s Production Environment.
 
It takes around 5 seconds for the execution in Customer’s other environments.

 

Please help to resolve this issue.

3 replies

Björn Hultgren
Rank
Userlevel 7
Badge +23

I do not recognize the tab PegPackStruct, so it must be part of a modification or extension. Handling units was not introduced in IFS Core manufacturing until Apps 10. 

D
Rank
Userlevel 3
Badge +9

Hi @Björn Hultgren ,

 

Thanks for the information provided.

I will look into modifications done in the Extension Layer of the Customer code.

 

Best Regards,
Dumintha.

D
Rank
Userlevel 3
Badge +9

Hi,

 

Currently, the process is executed around 4-5 seconds without any issue.

 

Gathered data from the oracle statistics table and were able to identify that the statistics for the 'YVVDA_SHIP_PACK_STRUCT_TAB' has been analyzed up to the current date.

 

Suspects that there might be an issue at the time with statistics not being analyzed correctly at the time of the issue occurrence.

 

Also during the DB restart indexes related to 'YVVDA_SHIP_PACK_STRUCT_TAB' has been rebuilt.

 

Best Regards,
Dumintha.

Reply


Terms & ConditionsCookie settings