Resource and Overhead Cost Workers Complete in Error or Resource Transactions Remain In Pending Status
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
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
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.
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