We have OSM 126.96.36.1990 installed on a cluster with two managed servers.
The behavior we are experiencing is that if we query for a specific Order ID, the query returns that order. If we run the default query, the same order is not included in the result set.
The same behavior is exhibited by both the Order Management Web Client and the Task Web Client. Interestingly enough, though, it is not the same order(s) that are missing from the results.
For example, running the default query in the Order Management Web Client "hides" orders 1, 2 and 3, but running the default query in the Task Web Client "hides" orders 7, 8 and 9.
No exceptions are logged whatsoever.
Does anyone have any ideas as to what might be causing this behavior?
I can't explain the behaviour you are observing based on your description of the problem. I would recommend you log an issue with support and if possible take a screen cam video of what you are seeing in both web clients.
It must be something simple/trivial that we are both overlooking - what you are trying to do is perfectly reasonable and should work as expected out of the box.
Hi Pantelis, there is a way to log the SQL going to the database.
On the log4j page, just select DEBUG for the proxyQuery (or queryProxy).
If this is a product issue, this won't help you, but if it is due to some settings, this might help you figure it out.
Or it might help Oracle support figure it out :-)