My Oracle Support Banner

Oracle Job Workbench Is Having Display Problems (Doc ID 2443814.1)

Last updated on FEBRUARY 10, 2021

Applies to:

Oracle Work in Process - Version 12.2 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.


When attempting to use repeated query for discrete jobs with similar criteria, the following problems occur.

1. Refreshing the workbench with identical criteria changes the results (not willfully replicable)
2. Jobs that should appear in response to a query do not appear.

The issue can be reproduced at will with the following steps:
1. Responsibility = Work In Process (WIP)
2. Navigation = Discrete-> Job Workbench
3. Enter a WIP Job <job id> for processing. <resource name> is a resource assigned to department <department name>. Launched Job Workbench to see the job in the schedule, but it doesn’t’ show up for resource
  <resource name>, but 9 total jobs show up in the schedule.

4. Change the filter to include department <department name> and 12 total WIP Jobs showed up in the schedule. WIP job <job id> was one of three jobs that showed, and there were two others as well.

5. Changed the filter BACK to just resource <resource name> and the 9 original WIPS showed up again (see screenshot below). When I refreshed the screen without any additional WIP jobs being added, or changes being made, 4 more WIPs dropped off the list and only 5 remained. This is what happened last week, and again today when I was working with the Planner responsible for <resource name>. When I tried to duplicate the loss of more WIPs with just a simple refresh, it would not repeat so I could not get the screenshot of the list of 5 WIPS for this documentation. But it did actually happen that way. Just not sure why I can’t repeat it time after time.

6. One thing to make sure is clear on this is that the filter with <department name> and <resource name> should be identical to the filter with just <resource name>. There should be no difference between the two list, because of the way our routings are set up.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.