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