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 FEBRUARY 08, 2021

Applies to:

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

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