My Oracle Support Banner

Pending Resource Transactions With PROCESS_STATUS = 1 (Doc ID 1290210.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

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

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
Symptoms
Cause
Solution
References


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