You can create integrators to download and upload data from Oracle HRMS windows or directly from Web ADI, create merge letters, and upload data from text files.
Depending on the information you want to download, you may need to create new views for use with Web ADI. You can use existing HRMS views, if appropriate.
To identify a view used by a window in Oracle HRMS, display a record in the window, and select Help > Diagnostics > Examine from the menu. In the Examine Field and Variable Values dialog box, select SYSTEM in the Block list of values and LAST_QUERY in the Field list of values. Scroll through the SQL query that appears in the Value field to obtain the view name.
Note: If you define a new view for downloading data from a form, the new view must include at least the same columns as the view used by the form. This restriction is necessary because the integrator uses the query you use in the window to restrict the data. If the query restricts on columns that do not appear in your view, the query fails.
The seeded HR Update Salary Proposals integrator, available from the Salary Management folder, uses the HR_UPLOAD_PROPOSAL_API.
The details of APIs that you can use for uploading data are available in the Oracle Integration Repository. See: Oracle Integration Repository Overview.
Note: HRMS APIs use IDs in their parameters rather than user-friendly data. Therefore, when you define Upload or Update Integrators, write wrapper packages to convert or preprocess the data before calling the APIs.
To enable users to download, create merge letters, or upload newly created or updated data, either from within an HRMS window or direct from Web ADI, you need to create integrators of the appropriate types.
To create new integrators, you use the Create Document menu option in Web ADI to create an empty spreadsheet containing all the columns you need to fill in to create an integrator. Oracle supplies an integrator for this purpose: the "HR Integrator Setup" integrator. You then enter the relevant data into the spreadsheet and upload it to the database.
You can apply a restriction to a standalone integrator using the "HR Create Standalone Query" integrator, and you can update a runtime restriction using the "HR Maintain Standalone Query" integrator.
You can disable Integrators using the HR Disable Integrator integrator.
Note: This integrator does not disable integrators created for the HRMS Application which are delivered with the application. Therefore, if you create your own integrator, you should specify your own custom application name when creating the new integrator, so that you can disable it if required.
So that your users can easily identify the integrator they need to use, use a standard naming convention for the integrators. For example, names could begin with HR, include the name of the window or a clear indication of the type of information they contain, and indicate whether they are for download only, download and upload, or letter generation.
For information about defining standalone queries, see: Defining Standalone Integrator Queries
For information about maintaining standalone queries, see: Maintaining Standalone Queries
For information about disabling queries, see: Disabling Standalone Integrator Queries
To use the integrator, you must set up at least one layout. If there is more than one layout, users must choose one. Ensure that the layout contains all mandatory fields and any other fields the user will need.
You should ensure that the name of the layout gives a clear indication of its purpose.
For information about setting up and configuring Web ADI, see the Oracle Web Applications Desktop Integrator Implementation and Administration Guide .