2 Replies Latest reply: Jan 17, 2013 1:57 AM by Pk RSS

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

    829361
      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