4 Replies Latest reply: Feb 11, 2013 9:49 AM by user13574114 RSS

    Create New WebADI Integrator

    Waqas Hassan
      Hi,

      I am creating new integrator using following code and this code successfully applies:

      DECLARE
      P_INTEGRATOR_CODE VARCHAR2(30);
      P_INTERFACE_CODE VARCHAR2(30);
      P_LAYOUT_CODE VARCHAR2(30);
      P_APPLICATION_ID NUMBER(15);
      P_OBJECT_CODE VARCHAR2(20);
      P_INTEGRATOR_USER_NAME VARCHAR2(240);
      P_LANGUAGE VARCHAR2(4);
      P_SOURCE_LANGUAGE VARCHAR2(4);
      P_USER_ID NUMBER(15);
      P_INTERFACE_TABLE_NAME VARCHAR2(50);
      P_INTERFACE_USER_NAME VARCHAR2(240);
      P_FORCE BOOLEAN;
      P_ALL_COLUMNS BOOLEAN :=FALSE;

      BEGIN
      -- Define Constants
      /*
      **
      ** USE FOLLOWING QUERY TO GET APPROPRIATE APPLICATION_ID **
      **
      SELECT application_id
      FROM fnd_application
      WHERE application_short_name = 'AR';
      */

      -- Application ID of the product that will own this Integrator
      P_APPLICATION_ID := 200; -- Find APPLICATIOM_ID from APPLSYS.FND_APPLICATION
      P_LANGUAGE := 'US';
      P_SOURCE_LANGUAGE := 'US';

      -- Applications Database User ID that owns this Integrator
      P_USER_ID := fnd_global.user_id; -- replace with your id or fnd_global.user_id
      P_OBJECT_CODE := 'TEST_SUPP_TAB'; -- Object Code is used to generate the codes for Integrator, Interface and Layout

      -- ADI details
      P_INTEGRATOR_USER_NAME := 'TEST - Enter New Suppliers'; -- Name of the Integrator that will be displayed in the User Interface
      P_INTERFACE_TABLE_NAME := 'AP_SUPPLIERS_INT'; -- Name of the Database table that data from the desktop application will be uploaded to.
      P_INTERFACE_USER_NAME := 'New Suppliers Open Interface'; -- Name of the table that will be displayed in
      P_FORCE := FALSE; -- When TRUE - all existing layout data will be removed before recreating. Set to FALSE as there will be no layout data at this point
      P_ALL_COLUMNS := FALSE; -- All columns will be included in the layout when TRUE (otherwise only required columns are included)

      BNE_INTEGRATOR_UTILS.CREATE_INTEGRATOR (
      P_APPLICATION_ID,
      P_OBJECT_CODE,
      P_INTEGRATOR_USER_NAME,
      P_LANGUAGE,
      P_SOURCE_LANGUAGE,
      P_USER_ID,
      P_INTEGRATOR_CODE
      );

      BNE_INTEGRATOR_UTILS.CREATE_INTERFACE_FOR_TABLE (
      P_APPLICATION_ID,
      P_OBJECT_CODE,
      P_INTEGRATOR_CODE,
      P_INTERFACE_TABLE_NAME,
      P_INTERFACE_USER_NAME,
      P_LANGUAGE,
      P_SOURCE_LANGUAGE,
      P_USER_ID,
      P_INTERFACE_CODE
      );


      BNE_INTEGRATOR_UTILS.CREATE_DEFAULT_LAYOUT(
      P_APPLICATION_ID,
      P_OBJECT_CODE,
      P_INTEGRATOR_CODE,
      P_INTERFACE_CODE,
      P_USER_ID,
      P_FORCE,
      P_ALL_COLUMNS,
      P_LAYOUT_CODE
      );

      COMMIT;
      END;

      but when i open Desktop Integrator-->: Create Document-->: Select Integrator-->: nothing shows in the list.... while
      Desktop Integrator-->: Define Layout-->: Select Integrator-->: here shows

      Plz, Help me out why this is happening?

      Waqas Hassan,