Hi!
We have noticed that our Application Messages is being processed very slowly from WMS - IFS.
It can take awhile for a small XML-file to process and it’s customer order and purchase order messages in the same queue.
We also
To fix this issue we use DBMS_SHARED_POOL.PURGE in Oracle and then it runs smoothly again.
This happens every day and we need to found a solution to fix this permanently.
The SQL_text that runs in Database session when this happens is: SELECT SUM(QTY_SHORT) FROM SHORTAGE_DEMAND WHERE CONTRACT = :B3 AND PART_NO = :B2 AND (ACTIVITY_SEQ = :B1 OR :B1 IS NULL)
Have anyone experienced this before?
We use Apps9 and Oracle 12.1