My Oracle Support Banner

Identify Orphaned Resource Transactions. (Doc ID 363091.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Cost Management - Version 11.5.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Purpose

There are transactions stuck in WIP_COST_TXN_INTERFACE

1.The transactions are not getting resubmitted. Tried script:

update wip_cost_txn_interface
set group_id = NULL,
transaction_id = NULL,
process_status = 1 ;

commit;


2. There is no error message.
3. There is no cost cut off date set in the Organization Parameters (Inventory>Setup>Organizations>Parameters>costing TAB)

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
References

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