Thursday, 25 April 2013
Please execute poxrespo.sql in ebsdev instance which is located at $PO_TOP/sql?
For instruction or for more assistance you can below metalink id.
==================================================
How To Reset a Purchase Order or Requisition From In Process or Pre-Approved
To Incomplete/Requires Reapproval For Isolated Cases [ID 390023.1]
1)For instruction check metalink id [ID 390023.1]
2)Go to cd $PO_TOP/sql and run poxrespo.sql in apps schema.
cd $PO_TOP/sql
SQL> select name,user from v$database;
NAME USER
--------- ------------------------------
ebsdev APPS
SQL>
SQL> @poxrespo.sql
DOC> | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA|
DOC> | All rights reserved. |
DOC> +=======================================================================*/
DOC>
DOC> This script will:
DOC>* reset the document to incomplete/requires reapproval status.
DOC>* delete/update action history as desired (refere note 390023.1 for more details).
DOC>* abort all the related workflows
DOC>
DOC>If using encumbrance it will also:
DOC>* correct po encumbrance values if corrupted
DOC>* Suggest gl manual postings to have the gl data in synch.
DOC>*/
Please enter the PO number to reset : 435750237
Please enter the organization id to which the PO belongs (Default NULL) : 1155
Do you want to delete the action history since the last approval ? (Y/N) N
table already exists, hence not creating again
PL/SQL procedure successfully completed.
SQL>
To check old post click on older post in the bottom of the page.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment