R12.1.3 : AP:Mass Additions Create (APMACR) Performance Issue
Hi ,
We are having issues in concurrent program Mass additions create. We have cancelled the request twice after seeing no activity in v$session. Here is the output of request
ayables: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
APMACR module: Mass Additions Create
+---------------------------------------------------------------------------+
Current system time is 05-FEB-2016 08:57:11
+---------------------------------------------------------------------------+
**Starts**05-FEB-2016 08:57:11
From v$session
| REQUEST_ID | SID | SERIAL# OSUSER |
---------- ---------- ---------- ------------------------------
| PROCESS | SPID | SQL_ID |
------------------------ ------------------------ -------------
MODULE
------------------------------------------------
| 6395386 | 543 | 12610 applprod |
| 19125 | 19197 |
APMACR
Please note that there is no SQL_ID associated with this request. Can you please let us know how to troubleshoot this issue.
Thanks