6 Replies Latest reply on Nov 10, 2015 10:14 AM by 2700980

    AME_API2.GETNEXTAPPROVER1 ERROR

    2700980

      I am new to ORACLE AME API. i have defined a rule in PURCHASE_REQ Transaction type which is working fine when i run it. Now i want to get the next approver based using AME_API2.GETNEXTAPPROVER1 Method. When i run the script in Toad i am getting this error

      ORA-01403: no data found

      ORA-06512: at line 20

       

      Here is the code

      DECLARE

      x_nextapproversout ame_util.approverstable2;

      x_itemindexesout ame_util.idlist;

      x_itemclassesout ame_util.stringlist;

      x_itemidsout ame_util.stringlist;

      x_itemsourcesout ame_util.longstringlist;

      x_approvalprocesscompleteynout varchar2(100);

      BEGIN

      Ame_Api2.getnextapprovers1( applicationidin => 201

      ,transactiontypein => 'PURCHASE_REQ'

      ,transactionidin => 4033438 --requisition_header_id

      ,flagapproversasnotifiedin => ame_util.booleantrue

      ,approvalprocesscompleteynout => x_approvalprocesscompleteynout

      ,nextapproversout => x_nextapproversout

      ,itemindexesout => x_itemindexesout

      ,itemclassesout => x_itemclassesout

      ,itemidsout => x_itemidsout

      ,itemsourcesout => x_itemsourcesout

      );

      dbms_output.put_line('x_nextapproversout(1).name: '||x_nextapproversout(1).NAME);

      END;

       

       

      What am i doing wrong here? it's urgent  kindly help.

       

      --

      Usman