| po stuck inprocess status [message #486678] |
Sat, 18 December 2010 07:16  |
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
|
Senior Member |
|
|
Hi,
I have an issue with one of our po's. When a user was trying to approve a po the application threw an error "unable to extend applsys.wf_item_statuses by 512 in tablespace applsysd". The table space issue has been resolved now but the po remains in inprocess status so i thought retrying the errored item will fix the issue. when i queried the wf_item table to see particular workflow item i could not see the item there in the table but po_headers_v table has wf_item_key value in the column. Can you any body guide me to solve the isuue.
Looking forward to your supporting..
Warm Regards
Yoonus
|
|
|
|
|
|
| Re: po stuck inprocess status [message #486696 is a reply to message #486691] |
Sat, 18 December 2010 23:34  |
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
|
Senior Member |
|
|
select * from wf_item where item_key ='8977-37430';
no records
select * from wf_item_activity_statuses where item_key = '8977-37430';
no records
and now i have queried the table you mentioned also
select * from WF_ITEM_ATTRIBUTE_VALUES where name item_key = '8977-37430' ;
no record
but if i query as you said ( i hope ho_header_id is the document_id)
SELECT * FROM WF_ITEM_ATTRIBUTE_VALUES where name = 'DOCUMENT_ID' and number_value = 8977 ;
the result shows this item key - 8977-34267 but po_header_v.wf_item_key shows 8977-37430
so the item key at po level is different.
|
|
|
|
| Re: po stuck inprocess status [message #486736 is a reply to message #486696] |
Sun, 19 December 2010 13:55 |
 |
Alien
Messages: 292
Registered: June 1999
|
Senior Member |
|
|
Hi,
the performance of your queries will be better when you include the item_type (POAPPRV).
But if you do have a workflow item, with your document_id, then that is likely the workflow active for your item.
Check to see, if this item is still in process:
select * from wf_item_activity_statuses wias, wf_process_activities wpa where wias.process_activity=wpa.instance_id
and wias.item_type='POAPPRV' and wias.item_key='8977-34267'
order by begin_date,execution_time;
Since this is a lower ID, probably it is an item that has completed already. If it has not, then you might want to restart this item.
The item_key from po_header can be off, when a PO was submitted twice, through a customization, or when the approval is from a change request on PO or Requisition.
Regards,
Arian
|
|
|
|
| Re: po stuck inprocess status [message #486743 is a reply to message #486736] |
Sun, 19 December 2010 23:25 |
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
|
Senior Member |
|
|
I am really sorry Arian, i made a mistake while doing that query yesterday, actually i forgot to include item_type and i did not pay attention to that column at all.
So the item_key i posted in last reply was for another purchase requisition.
SELECT * FROM WF_ITEM_ATTRIBUTE_VALUES where name = 'DOCUMENT_ID' and number_value = 8977 and item_type = 'POAPPRV' ;
the result for the above query returns no nows. if this is the case, does that mean a workflow did not start for this po?
Regards,
Yoonus
[Updated on: Sun, 19 December 2010 23:27] Report message to a moderator |
|
|
|
|
|
| Re: po stuck inprocess status [message #486999 is a reply to message #486847] |
Wed, 22 December 2010 00:01 |
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
|
Senior Member |
|
|
Hi Arian,
How can i check if the po is encumbered?. The action history shows
0) submit
1) action is blank and performed is showing same user as 0
"If the PO is already reserved" what does this mean. What do you want me to test this on test? i am just cloning the system for testing this case.
I am sorry if i am asking very basic level question, i don't have very good knowledge of purchasing yet.
Regards,
Yoonus
|
|
|
|
|
|
| Re: po stuck inprocess status [message #572308 is a reply to message #487551] |
Mon, 10 December 2012 06:18 |
bimal_kaur
Messages: 4
Registered: March 2007
Location: delhi
|
Junior Member |
|
|
Hi Arian,
What if the change history shows that some change was requested and there has been no further response on the change requested.
Also, the owner of the action is no longer active in the system?
Thanks
|
|
|
|
|
|
| Re: po stuck inprocess status [message #572642 is a reply to message #572325] |
Fri, 14 December 2012 06:49 |
bimal_kaur
Messages: 4
Registered: March 2007
Location: delhi
|
Junior Member |
|
|
Thanks Arian!
Actually the POAPPRV workflow have been purged..And
1)there are 2 POs as there approved_flag is R. However the status is showing as Inprocess. -> think this can be changed to Requires reapproval with Oracle's script Change type here is Modification
2) Some POs have been modified after approval and they are not approved after change.the change is of type cancellation.The approvers are still in company and can approve the POS.
3) cancellation type change request. User no more with company.
so..since POs are in "In Process", with workflows purged, and Change requests with action_type in either Cancellation or Modification state, would it fine to run the script to turn them in to Requires Reapproval state?
Regards
Bimal
[Updated on: Fri, 14 December 2012 06:50] Report message to a moderator |
|
|
|
| Re: po stuck inprocess status [message #572646 is a reply to message #572642] |
Fri, 14 December 2012 08:36 |
bimal_kaur
Messages: 4
Registered: March 2007
Location: delhi
|
Junior Member |
|
|
I ran the following statement
select ref_po_num PO_Num, ref_po_rel_num Rel_Num, document_num Req_Num,
change_request_id CR_Id, change_request_group_id CR_Grp_ID,
last_update_date, document_line_number Doc_Line_Num, action_type,
request_reason, request_status status from apps.po_change_requests where ref_po_header_id in
(select po_header_id from apps.po_headers_all where segment1 in
(PO_NUMBER)
and org_id in (ORG_ID))
and document_type = 'REQ' order by last_update_date
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
