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.

the way you describe it, the workflow item has been purged. But tell us the queries you used to find the workflow item.
Did you search only in WF_ITEMS, or also on the DOCUMENT_ID from WF_ITEM_ATTRIBUTE_VALUES?

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.

ok. That makes sense then. But the query on WF_ITEM_ATTRIBUTE_VALUES guarantees that there exists NO workflow item for this PO.
Either it didn't start, or it was purged.

That leaves you with a PO that is in Process. Your next action depends on whether you use encumbrance accounting, and whether the PO is encumbered.
What does the Action History of the PO say?
If the PO is not encumbered, you could reset the Authorization status, and restart the approval process.
If the PO is already reserved, that might be tricky.

With the owner of the action you mean the person requesting the change?
It sounds as if the change was submitted, but the change process never completed. Either because of a workflow error, or because somebody didn't approve/reject the change.

You should check the status of the change request first. It will probably be stuck somewhere. When you solve that, the PO will still be updated to reflect the change, regardless of the person who initiated the change.

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?