This discussion is archived
4 Replies Latest reply: Feb 11, 2013 7:49 AM by user13574114 RSS

Create New WebADI Integrator

Waqas Hassan Newbie
Currently Being Moderated
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,

Legend

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