My Oracle Support Banner

Table WIP_RESOURCE_ACTUAL_TIMES shows incorrect status (Doc ID 2807736.1)

Last updated on OCTOBER 15, 2021

Applies to:

Oracle MES for Discrete Manufacturing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

When attempting to query WIP jobs from the time entry web page and trying to close many wip jobs with, the following error occurs. When trying to query these jobs from the time entry web page we get the message 'No results found'. Yet when querying the table WIP_RESOURCE_ACTUAL_TIMES, these job have the status STATUS_TYPE=1 which means it is PENDING. After tracing the session and found the sql used to query the jobs on the time entry form has a condition  process_status <> 4 . All the offending wip jobs that we can not query on the time entry web page have the process_status= 4. Therefore they can not be approved.

ERROR

There are pending time against the wip job.


STEPS

The issue can be reproduced at will with the following steps:
1. (R) MES Supervisor.
2. (N) MES supervisor workbench->Metrics->Review Time Entries
3. Search for job and assembly.
4. The aforementioned error is shown.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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