1 Reply Latest reply on Mar 13, 2007 6:36 PM by 190407

    Requistion Approval Issue - iprocurement

    556371
      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 ,welcome and try 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,
      Genneration Next