Resource and Overhead Cost Workers Complete in Error or Resource Transactions Remain In Pending Status (Doc ID 1083808.1)

Last updated on JANUARY 11, 2017

Applies to:

Oracle Cost Management - Version 12.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Jan-2103***

Executable:CMCCTW - Resource Cost Worker
ConcurrentProgram:CMCOCW - Overhead Cost Worker


Symptoms

Resource transactions are getting stuck in the WIP_COST_TXN_INTERFACE table, without error. Customer runs the generic script to null out the id's and they resubmit with no success.

Following error could be generated in the Resource and Overhead Cost Worker Log Files

Concurrent Manager encountered an error while attempting to start your immediate concurrent
program &PROGRAM. Routine &ROUTINE received a return code of failure.



The issue can be reproduced at will with the following steps:
1. Go to MES Operator Responsibility > MES Workstation.
2. Select Job radial button
3. Enter badge number
4. Click Clock In button
5. When physically done, select job radial button
6. Enter badge number
7. Click Clock Out button
8. Click 'Move and Complete' button.
9. Click finished.
At this point the system sends the Resource Transaction to Pending Resource Transactions and does not transact the record.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms