Pending Resource Transactions With PROCESS_STATUS = 1

(Doc ID 1290210.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Cost Management - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance 27-JAN-2014***

Symptoms

There are pending resource transactions with process_status= 1 in the wip_cost_txn_interface (Pending Resource Transactions screen).
These transactions are for OSP items for Discrete Jobs. Standard costing is being used.   No cost cutoff date is set in this organization.
There are no errors for the resource transactions in the table, but the resource cost worker logfile shows errors.

ERROR
-----------
CMCCTW module: Resource Cost Worker

gib->tvegixit = WIP_COST_TXN_INTERFACE
sqlcaid = sqlcode = %-ld sqlerrml = %-d sqlabc = 1074421168
sqlerrmc:
sqlerrp =  sqlerrd[] = {0 0 0 0 0 0}
sqlwarn = sqlext =
oracaid =  oracabc = 0
oracchf = 0 oradbgf = 0 orahchf = 0 orastxtf = 1 orastxtl = 70
orastxtc:
select request_id into :b0 from fnd_concurrent_requests where ((((pro
orasfnmc = 94510279/bom/lib/cmlctw.lpc oraslnr = 332 orasfnml = 27
orahoc = 100 ormoc = 5 oracoc = 5 oranor = 0 oranpr = 5 oranex = 5

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