Requset in terminating state for a long period.. [message #207064] |
Mon, 04 December 2006 01:13 |
deepayan
Messages: 51 Registered: December 2005
|
Member |
|
|
Dear all,
I have cancelled a request in oracle applications but its in terminating state for a very long period(almost 2 days).
I have found the problematic area of the request.Its
SELECT COUNT(DISTINCT(AIA.INVOICE_ID)) --new line added
INTO V_INV_COUNT
FROM AP_INVOICES_ALL AIA,
AP_INVOICE_DISTRIBUTIONS_ALL AID,
GL_CODE_COMBINATIONS GL
WHERE AIA.INVOICE_ID = I.V_INV_ID
GROUP BY LIABILITY_ACCOUNT;
This query is wrong.
Now I cant change the procedure also since the request has acquired a lock.
Please suggest any idea so that I can terminate it...
----------------------------
Thanks in advance....
|
|
|
|
|
Re: Requset in terminating state for a long period.. [message #207645 is a reply to message #207064] |
Wed, 06 December 2006 07:08 |
prashant_pathak
Messages: 263 Registered: February 2006 Location: California,US
|
Senior Member |
|
|
Hi,
As you have terminated the the program after 2 hours there must be huge rollback segment for that request and thats the reason it is taking long time in Termination state.
You can ask your DBA to kill the Process from Unix for that request if the request is in Development and not much of importance.
Regards
Prashant Pathak
|
|
|