Requistion Approval Issue - iprocurement [message #215053] |
Fri, 19 January 2007 02:12 |
Gennext
Messages: 27 Registered: September 2006
|
Junior Member |
|
|
Hi Team
I was testing the Req approval program for Req 23 . Logged in as REVREC and submitted the req for approval.
Logged in as zander and tried to edit requisition .change the quantity to 5 and hit the approver checkout.
After a few button clicks you wil get the following message
"Now that you've updated the requisition, press the Continue button to return to the notification and complete your approval response. Note that the notification was generated based on the original requisition and won't reflect the edits you've just made. "
After that if you hit the 'APPROVE ' button at the home page and have the following error message in the workflow admin page .
Error Message
ORA-06502: PL/SQL: numeric or value error ORA-06512: at "APPS.PO_REQAPPROVAL_INIT1", line 6470 ORA-06512: at "APPS.PO_APPROVAL_LIST_WF1S", line 2703 ORA-01086: savepoint 'UPDATE_RESPONSE' never established ORA-06512: at "APPS.PO_APPROVALLIST_S1", line 2517 ORA-01422: exact fetch returns more than requested number of rows
Error Stack
PO_APPROVAL_LIST_WF1S.Update_App_List_Resp_Success(Update_App_List_Resp_Success: 010 APP471 RES471 FWD, ORA-01086: savepoint 'UPDATE_RESPONSE' never established ORA-06512: at "APPS.PO_APPROVALLIST_S1", line 2517 ORA-01422: exact fetch returns more than requested number of rows) Wf_Engine_Util.Function_Call(PO_APPROVAL_LIST_WF1S.UPDATE_APP_LIST_RESP_SUCCESS, REQAPPRV, 122-15482, 135158, RUN).
Note: Reverec He books the Purchase requistion and sends for the Approval
Zander is the next of Approval he Changes the Qty on the Purchase Requistion and sends for Approval
There is one more person Coder he needs to verify it Either he can accept or Requisition but can't modify.
Is there any possibilty of Coder Not been assigned in the Hierarchy but have options to view and Accept/Reject.
Can You Please Help me in Resolving this Issue.
Thanks & Regards,
Gennext
|
|
|