30 Oct 09 Purchase Orders stuck “In Process” status

Unable To Open PO from Purchase Order Summary

PROPOSED SOLUTION(S)
====================
Use poxrespo.sql to resubmit the document for approval by resetting the authorization status.

PROPOSED SOLUTION JUSTIFICATION(S)
==================================
This issue is described in Metalink Note 390023.1: How To Reset a Document To Incomplete/Requires Reapproval For Isolated Cases

For cases where there is NOT a pending notification and the workflow cannot be progressed using wfretry, use the reset scripts provided in Patch 5398037. These scripts allow the user to resubmit the document for approval by resetting the authorization status when documents are stuck in ‘In-Process’ or ‘Pre-Approved’ statuses. The scripts are:

– poxrespo.sql – to reset Standard, Blanket, Planned and Contract purchase orders
– poresrel.sql – to reset Blanket and scheduled releases
– poresreq.sql – to reset Internal and purchase requisitions
In order to obtain the scripts, apply these patches:
Patch 5549427 for release 11.5.9 and 11.5.10
Patch 8731607:R12.PO.A for release 12.

The scripts will be available in the $PO_TOP/sql directory. This patch is applicable only on 11.5.9 and above.

ACTION PLAN
===========
1. Run the script poxrespo.sql in the PO_TOP/sql directory to reset the PO to status Incomplete. Enter the following parameters:

– ‘Please enter the PO number to reset’: your po number

– ‘Please enter the organization id to which the PO belongs’: po’s org id

– ‘Do you want to delete the action history since the last approval ?’: Y

2. Commit the changes
commit;

3. Resubmit the PO for approval

CAUSE DETERMINATION
===================
It is not known what causes purchase orders occasionally not to process. This is a known issue for which root cause has not been identified. This issue cannot be reproduced at will.

CAUSE JUSTIFICATION
===================
Support and Development have been actively working together to determine the root cause however it’s an ongoing difficult task since the issue cannot be reproduced at will. This issue occurs occasionally in 10.7, 11.0 and 11i. Although purchase orders should not be stuck in process, though they do on occasion.

Etiketler: In Process, oracle, oracle purchasing, purchase order, purchase order summary, stuck, unable to open