To create an integrator:Creating integrators is a system administration step required to enable download or upload of data from and to windows for which no seeded integrator exists.
Web ADI has two types of integrators:
Application Integrators
Standalone Integrators
An Application Integrator links to a specific form. You typically use the form to download HRMS data, using some form restriction, modify the data, and then upload the data.
You use standalone integrators directly from the self-service menu function. These integrators allow you to create new data or download and update existing data. You can set up a query restriction to use at runtime. For Standalone Integrators the form name is GENERAL.
Note: You must not call Application Integrators directly from the self-service menu function. These integrators rely on information passed to them from the form for which they are defined. In addition, you can link custom Application Integrators to Oracle-supplied forms only.
To create an integrator:Select HR Create Document from the menu. The Settings page of the Web ADI wizard appears.
Caution: When moving between Web ADI pages, do not use your browser's Back or Forward buttons, as this causes information to be lost; instead, use the Back, Next and Cancel buttons displayed on the Web ADI page.
In the Settings page, select a spreadsheet viewer in the Viewer field.
Deselect the Reporting check box, as this integrator is used to upload data to the database.
In the Integrator page, select the seeded integrator "HR Integrator Setup".
In the Layout page, select the default layout "HR Integrator Setup".
In the Content page, select None.
In the Review page, you can see full details of the document that will be created. Choose the Back button if you want to change any of the information, or choose the Create Document button to continue.
A spreadsheet document is created, containing all the fields you need to enter to create your own integrator.
Download-only Integrators
If you are creating download-only integrators, including letter generation integrators, enter details in the following columns:
METADATA_TYPE - select DOWNLOAD from the list of values.
APPLICATION_SHORT_NAME - select the Application Short Name of your custom application from the list of values. The name appears from the FND_APPLICATION table.
INTEGRATOR_USER_NAME - the name that appears when the end user selects the integrator in the Web ADI Create Document pages.
VIEW_NAME - Web ADI uses a view to determine the tables and columns to download. Enter the name of the view you want to use to base the download on.
FORM_NAME - the name of the window from which you want the integrator to be available to the user. Select GENERAL from the list of values, or select LETTER for a letter generation integrator.
If you are creating download-only and letter generation integrators, leave the remaining columns blank.
To upload the integrator:Follow the steps for uploading a spreadsheet. See: Uploading Data using Web ADI
Controlling Access to the Integrator:You must associate at least one form function with the integrator for granting user access. See: Controlling Integrator Access
Note: Your System Administrator must grant access for each new integrator to the Web ADI responsibility. Without this, you cannot create layouts for the integrators.