Home » Applications » Oracle Fusion Apps & E-Business Suite » Requistion Approval Issue - iprocurement
icon4.gif  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
Previous Topic: Apps Foems Debug Log
Next Topic: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508
Goto Forum:
  


Current Time: Thu Jul 04 18:27:01 CDT 2024