WIPTIRSC: Pending Resource Transactions: Work In Process (WIP) Resource Transactions Will Not Process. The Resource Cost Worker Will Not Launch.

(Doc ID 435324.1)

Last updated on OCTOBER 02, 2017

Applies to:

Oracle Work in Process - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms

There are Pending Resource Transactions in the Work In Process (WIP) pending resource transaction form with a status of pending.  Also, you cannot find any indication that the Resource Cost Worker concurrent request was ever executed (this occurs on new or upgraded instances). 

Material and move transactions process.

Expect all transactions to process including resource transactions

The issue can be reproduced at will with the following steps:
1. WIP Super User responsibility
2. Resource Transactions
3. Pending Resource Transactions.  Not one resource transaction processes
4. Enter the search criteria and/or press the FIND button in the Find Pending Resource
Transactions form.) There are no error messages displayed when pushing the Errors button.

Also, the following SQL returns an S:

 

Changes

This occurs when an instance is new or upgraded.

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