1 Reply Latest reply: Jun 19, 2013 9:04 PM by Leno Sun RSS

    Unable to Update Custom WebADI Integrator

    Kaja Rajesh

      Hi,

       

      I have created a Custom Integrator using Create Document Function from 'Desktop Integrator' Responsibility using 'HR Integrator Setup' Integrator.

       

      I have Provided Pl/SQL Procedure as API Type. Integrator got created Successfully but in the Document i am seeing headers like p_emp_num_i etc which are my Procedure's Input Parameter names.

       

      I want to change these Column names to more user friendly.

       

      But Now when I go to the Desktop Integration Manager->Manage Integrator  the update icon is disabled for this custom integrator and also the source is set to Oracle.


      Is there any way i can change the Prompt of the Column names?


      Thanks

      Kaja



        • 1. Re: Unable to Update Custom WebADI Integrator
          Leno Sun

          Hi,kaja

           

          There are two ways for ur situation.

           

          1.Update the source into custom by following sql:

          UPDATE BNE_INTEGRATORS_B

          SET SOURCE = 'C'

          WHERE APPLICATION_ID = 'XXX'

          AND INTEGRATOR_CODE = 'XXX';

          *** Pl make sure that this is a custom integrator.

           

          2.Update the document header by Bne API.

          API : BNE_INTEGRATOR_UTILS.UPDATE_INTERFACE_COLUMN_TEXT

           

          Regards,

          leno