This discussion is archived
2 Replies Latest reply: Jan 16, 2013 11:57 PM by Pk RSS

ORA-20002: 3122: Duplicate item 'REQAPPRV/150342-427838' could not be creat

829361 Newbie
Currently Being Moderated
Hello all

I'm creating a form which has ' Approve & Reject ' for approving/rejecting po requisition. when i press reject button then it call the workflow process REQ_RETURN_REQ. i coded like this, is this correct way to call the process?

code

declare
     v_itemtype varchar2(100):='REQAPPRV';
     v_itemkey varchar2(100):='150342-4278';
     v_process varchar2(100):='REQ_RETURN_REQ';
begin
wf_engine.launchprocess(v_itemtype,v_itemkey,v_process,null,null);
end;

ORA-20002: 3122: Duplicate item 'REQAPPRV/150342-427838' could not be created.
ORA-06512: at "APPS.WF_ENGINE", line 4227
ORA-06512: at line 8

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

i tried using

Wf_Engine_Util.Function_Call(PO_APPROVAL_LIST_WF1S.Update_Action_History_Reject,REQAPPRV,150342-427838,94436,RUN);

i got compilation error 'wrong number or types of argument


------------------------------------------------------------------------------------------------------------------------------------------------------------

can any one help me to do the correct method of calling a workflow process REQ_RETURN_REQ inside a main process..

stracture of my workflow in

main function --->doc_approved-->REQ_RETURN_REQ

my current process is completed till doc_approved. i want to call this process REQ_RETURN_REQ.. i tried above to methods..


thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points