can Anyone hav any idea about " How 2 Open a Closed Purchase Order".
or
If anyone knows about " How to set The Status to Open/Incomplete through an SQL Query?" plz giv Reply.
How 2 Open a Closed Purchase Order
-
- Posts: 9
- Joined: Fri Apr 13, 2007 2:31 pm
- Location: India
-
- Posts: 32
- Joined: Thu Dec 21, 2006 2:20 am
- Location: India
Hi ,
You can set the PO status to Incomplete...
How To Reset a Document To Incomplete/Requires Reapproval For Isolated Cases
Doc ID: Note:390023.1 Type: HOWTO
Last Revision Date: 01-MAR-2007 Status: PUBLISHED
Solution
For cases where there is NOT a pending notification and the workflow cannot be progressed using wfretry, use the reset scripts provided in Patch 5549427. 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 Patch 5549427. The scripts will be available in the $PO_TOP/sql directory. This patch is applicable only on 11.5.9 and above.
Instructions:
The script prompts the user for :
Document number
Organization id
An option to delete or update the action history since the last submission of the document for approval. On selecting update, if there is an action pending on a particular user, the scripts will update the action code as ?No Action Taken?. If the action history does not contain a record with pending user action, the update action will have no effect on the action history. On selecting the delete option, the action history for the unsuccessful approval cycle would be deleted.
For example.: for Standard PO Number 5211
Revision Sequence Action Employee
0 1 Submit A
0 2 forward A
0 3 Approve B
0 4 Reserve B
1 5 Submit A
1 6 forward A
1 7
Here the document is stuck after 1 successful approval for Revision 0. Hence if you choose the Delete action for action history, the sequence number 5,6,7 will be deleted and the document would be set to Requires reapproval. If you choose the Update option for this case then the action at sequence 7 would be updated to ?No Action Taken? and the note field would indicate ?Updated by reset script on <date>?.
Scope:
These script picks up documents, which are:
Not canceled
Not finally closed
In statuses - 'IN PROCESS' or 'PRE-APPROVED'
Perform the following checks before proceeding to reset the PO:
If open notification is present, warn the user.
If a change request is associated with the document abort the script.
Reset requisition script is aborted if the requisition is found to be associated with a purchase order or internal Sales Order.
If USSGL Transaction codes are being used and/or Federal Purchasing, the script is aborted.
If you are on 11.5.10 and the document that you wish to reset is sourced to an encumbered blanket agreement or an encumbered global agreement, do not use this script.
Please run the program 'Import Journals' from the GL responsibility before running this script. This is required for the encumbrance diagnostics performed by this script. Failing to run the program may result in incorrect information coveyed by the script.
Do not apply the script to releases prior to 11.5.9.
If the above check pass the scripts:
Abort all the workflow processes associated with the document Approval.
Updates action history.
Updates the PO tables to set the status correctly.
Corrects encumbrance entries if encumbrance is used.
Suggest any Manual postings that may be required to correct encumbrance entries in GL. These manual postings appear in the table po_manual_postings_temp.
You can set the PO status to Incomplete...
How To Reset a Document To Incomplete/Requires Reapproval For Isolated Cases
Doc ID: Note:390023.1 Type: HOWTO
Last Revision Date: 01-MAR-2007 Status: PUBLISHED
Solution
For cases where there is NOT a pending notification and the workflow cannot be progressed using wfretry, use the reset scripts provided in Patch 5549427. 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 Patch 5549427. The scripts will be available in the $PO_TOP/sql directory. This patch is applicable only on 11.5.9 and above.
Instructions:
The script prompts the user for :
Document number
Organization id
An option to delete or update the action history since the last submission of the document for approval. On selecting update, if there is an action pending on a particular user, the scripts will update the action code as ?No Action Taken?. If the action history does not contain a record with pending user action, the update action will have no effect on the action history. On selecting the delete option, the action history for the unsuccessful approval cycle would be deleted.
For example.: for Standard PO Number 5211
Revision Sequence Action Employee
0 1 Submit A
0 2 forward A
0 3 Approve B
0 4 Reserve B
1 5 Submit A
1 6 forward A
1 7
Here the document is stuck after 1 successful approval for Revision 0. Hence if you choose the Delete action for action history, the sequence number 5,6,7 will be deleted and the document would be set to Requires reapproval. If you choose the Update option for this case then the action at sequence 7 would be updated to ?No Action Taken? and the note field would indicate ?Updated by reset script on <date>?.
Scope:
These script picks up documents, which are:
Not canceled
Not finally closed
In statuses - 'IN PROCESS' or 'PRE-APPROVED'
Perform the following checks before proceeding to reset the PO:
If open notification is present, warn the user.
If a change request is associated with the document abort the script.
Reset requisition script is aborted if the requisition is found to be associated with a purchase order or internal Sales Order.
If USSGL Transaction codes are being used and/or Federal Purchasing, the script is aborted.
If you are on 11.5.10 and the document that you wish to reset is sourced to an encumbered blanket agreement or an encumbered global agreement, do not use this script.
Please run the program 'Import Journals' from the GL responsibility before running this script. This is required for the encumbrance diagnostics performed by this script. Failing to run the program may result in incorrect information coveyed by the script.
Do not apply the script to releases prior to 11.5.9.
If the above check pass the scripts:
Abort all the workflow processes associated with the document Approval.
Updates action history.
Updates the PO tables to set the status correctly.
Corrects encumbrance entries if encumbrance is used.
Suggest any Manual postings that may be required to correct encumbrance entries in GL. These manual postings appear in the table po_manual_postings_temp.
Hi,
Why do u want to open a Closed PO ?
Hi Arshad,
Good Explanation
[quote]can Anyone hav any idea about " How 2 Open a Closed Purchase Order".
or
If anyone knows about " How to set The Status to Open/Incomplete through an SQL Query?" plz giv Reply.
<i><div align="right">Originally posted by shravandeekonda
Why do u want to open a Closed PO ?
Hi Arshad,
Good Explanation
[quote]can Anyone hav any idea about " How 2 Open a Closed Purchase Order".
or
If anyone knows about " How to set The Status to Open/Incomplete through an SQL Query?" plz giv Reply.
<i><div align="right">Originally posted by shravandeekonda
Who is online
Users browsing this forum: No registered users and 0 guests