Desktop Integration Overview
Web Applications Desktop Integrator (Web ADI) is a self-service Oracle application, accessed using a browser. The Web ADI software is not installed on individual client machines, as the processing takes place on the server rather than on individual client PCs.
Web ADI generates Microsoft Excel or Word documents on your desktop, and downloads the data you have selected from the application. You can modify the data in the Microsoft Excel or Word documents, working either online or offline, and upload the data using Web ADI.
Customer Downloads. If you already have a commercial license, you should download your software from the Oracle Software Delivery Cloud, which is specifically designed for customer fulfillment. For patches, see My Oracle Support. Nov 06, 2008 Client Applications Desktop Integrator (ADI) is now certified with Oracle E-Business Suite Release 11i running on the 10gR2 Database. Customers may continue using the client-installed ADI even after upgrading their E-Business Suite Release 11i environment to the 10gR2 Database.
How Web ADI works
Configurable layouts determine the appearance of the spreadsheet or word processing document. System administrators can restrict the fields that users access in the spreadsheet, and can create different layouts for different users. Experienced users can also create their own layouts to include just the fields they need.
Web ADI is used in HRMS forms, such as Person, Assignment, People and Assignment folders, and Salary Approvals, in letter requests, in the Rapid Implementation Workbench, for reports in the Compensation Workbench, and for configuring links in Knowledge Integration.
See: Data Download and Upload using Web ADI
Alternatively, you can use the concurrent processing method to set up your standard letters. With concurrent processing, you generate and review your letters without interrupting other work you perform at your computer. You can control when a concurrent process runs and schedule long-running processes to run at times when the system is not busy.
There are two methods of using concurrent processing to set up your standard letters:
- Using word processors
- Using Oracle Reports
See: Concurrent Processing
Desktop Integration
You can download data from your Oracle HRMS application to spreadsheets or word processing documents on your desktop using Web ADI.
Can you download data from a window in Oracle HRMS?
Yes. Oracle HRMS is supplied with certain windows already set up to enable you to download data. In addition, your system administrator can configure the system so that you can download from other windows in the Professional User Interface (Forms interface).
Can you modify data downloaded from Oracle HRMS windows and upload the modified data back to the application?
Yes, provided that the system has been configured to enable upload, and that you have the appropriate upload access rights.
Can you upload data from legacy systems using Web ADI?
Yes. By incorporating a text file into the spreadsheet you create using Web ADI, and then uploading the data to the database, you can upload data from legacy systems.
Does Web ADI check that information is not being overwritten when you upload?
Yes. Error checking is carried out by the Application Programmatic Interfaces (APIs) used to upload the data. If errors are found, the data is not uploaded to the Oracle database.
Can you create standard letters using data from Oracle HRMS?
You can generate standard letters by downloading employee data into a template letter to form a mail merge letter. You can also save the template letter in the Oracle application database.
Do you need a separate licence for Web ADI?
No. Web ADI is available when you purchase Oracle HRMS.
Can you reuse ADE information with Web ADI?
Much of the information required by Application Data Exchange (ADE) can be converted for use with Web ADI. Views that you have created for use with ADE can be reused, and ADE style information can be converted to a format suitable for use by Web ADI.
Do you need to install Web ADI on individual user PCs?
No. Unlike ADE, Web ADI does not require separate installation on client PCs.
What types of standard letter can you create?
Standard letters enable you to manage your enterprise's recruitment or enrollment activities more easily. Using Oracle Human Resources or Oracle Learning Management (OLM), you can issue standard letters to applicants and students respectively, triggered by changes in assignment or enrollment status. For example, you can set up a standard enrollment confirmation letter that is triggered when a student's enrollment status is set to Placed, or you can set up a rejection letter that is triggered when an applicant's assignment status is set to Rejected.
Here are a few examples of letters you can set up to help you to manage recruitment or enrollment activities:
Oracle Human Resources | Oracle Learning Management |
---|---|
Acknowledgement letters (for all active applications) | Acknowledgement letters (for all requested enrollments) |
Confirmation letters (for interviews) | Confirmation letters (for placed enrollments, including event joining instructions based on the date, venue, and trainers) |
Reports for interviewers and schedules | Reports for trainers (listing the students to attend an event) |
Offer and Rejection letters (for applicants) | Chase-up letters (for non-response or non-payment) |
Acknowledgement letters (for cancellations) | |
Certificates (of successful course completion) |
Implementing Web ADI for use with Oracle HRMS
Implementing Web ADI for use with Oracle HRMS
The following implementation steps are required to implement Web ADI for use with Oracle HRMS. Ati rage 128 pro drivers.
See also the Oracle Web Applications Desktop Integrator Implementation and Administration Guide.
HR: Enable Web ADI Integration Profile Option
In the System Profile Values window, the HR: Enable Web ADI Integration profile option default is Yes. The Web ADI pages open when you choose the Export Data icon on the toolbar of an HRMS window.
To use Application Data Exchange (ADE) instead of Web ADI, change this profile option to No at Site level. This change enables the Export Data icon to launch Application Data Exchange (ADE) software.
Web ADI Menu Options
- The supplied Web ADI responsibility and self-service menu give access to the following menu options:
- Create Document
- Define Layout
- Define Mapping
- Manage Document Links
Give users access to this responsibility, or attach this menu to their responsibility, if they need to access Web ADI from the self-service menu (without going through one of the HRMS application windows), or if they need to define layouts or mappings, or create links between template letters and layouts.See the Oracle Web Applications Desktop Integrator Implementation and Administration Guide for further details about this menu. - A self-service menu 'HRMS ADI Document Manager Menu', is supplied for use with Web ADI. This contains the Document Management menu option and required functions. Add this menu to the main menu attached to the responsibilities of any users who need access to the Document Management features.
- The supplied function 'Web ADI Create Document' gives access to Web ADI from any HRMS window.Important: You must add this function to the main menu attached to the responsibilities of any users who need access to Web ADI from an HRMS application window.
- The Create Document menu option on the Web ADI menu includes integrators for all applications. An alternative self-service menu, 'HRMS ADI Create Document menu' is supplied, containing the menu option 'HRMS Create Document'. This restricts the list of integrators to HRMS application integrators that are not launched from a window (that is, where the FORM_NAME parameter for the integrator is 'GENERAL').If you create your own 'GENERAL' integrators, you need to change the parameters of this function from:
- &bne:integrator=800:GENERAL%25
to:- &bne:integrator=800:GENERAL%25,999:GENERAL%25
replacing 999 with your own Application ID. - If only one option is available in Web ADI, the page automatically defaults the option. If all the options on a screen are defaulted, the page is skipped, so that the end user does not have to fill them in. The user only sees the final 'Review' page. To remove the Review page that appears at the end of the Web ADI wizard, edit the 'HRMS Create Document' or 'Web ADI Create Document' function, and change the parameters of the function, by appending:
- &bne:noreview=true
- To restrict users to carrying out download-only operations, edit the 'HRMS Create Document' or 'Web ADI Create Document' function, and change the parameters of the function, by appending:
- &bne:reporting=Y
- Integrators provided by HRMS for setup purposes may be grouped by creating a function similar to the 'HRMS Create Document' by changing the following:
- &bne:integrator=800:GENERAL%25to
- &bne:intergator=800:HR_SETUP%25This function may be added to menus for users with privileges to create and edit integrators.
Macro Security Settings in Microsoft Excel
Web ADI integration with Microsoft Excel enables you to download, view, edit, and to create Oracle HRMS data. After editing the spreadsheet, you can use the Web ADI Integrator validation functionality to validate the data before uploading it to Oracle HRMS.
You must set the appropriate macro security settings in Microsoft Excel for Web ADI Integrator to work with Microsoft Excel. For more information, see: Selecting Macro Security Settings in Microsoft Excel topic in the Oracle Web Applications Desktop Integrator Implementation and Administration Guide
Data Download and Upload Using Web ADI
Data Download and Upload Using Web ADI - Overview
You can download data from your Oracle HRMS application to spreadsheets or word processing documents on your desktop using Web ADI.
You can query the data in a window, download the queried data to your desktop, and view the data in spreadsheet format or in a word processing document.
In some cases, you can manipulate the data you have downloaded and upload your changes to Oracle HRMS. Validation of the data takes place by the Application Programmatic Interfaces (APIs) used to upload the data, and any errors are flagged. If errors occur, no data is uploaded to the database.
You can create a mail merge by downloading the data directly into a template letter.
You can create an empty spreadsheet and enter new data or import data from a text file, and then upload the data to Oracle HRMS. The data is validated using the usual HRMS validation.
Standard Oracle security is maintained.
Note: Oracle Configuration Workbench provides a new framework to use spreadsheets. This framework provides additional capabilities such as customizing and downloading of spreadsheets to suite business requirements. See: Overview: Spread Sheets Framework, Oracle HRMS Implementation Guide
Methods of Running Web ADI
You can invoke Web ADI from an icon in an HRMS Professional User Interface window (including OLM windows), or you can launch it directly from a Web ADI self-service menu option.
You cannot invoke Web ADI from the People Management templates, nor the Self-Service HRMS (SSHR) pages, nor the following windows:
- Absence Detail
- Mass Update of Applicant Assignments
- Mass Update of Employee Assignments
- Mass Update of Assignments
- Position Copy
- Mass Position Update
In addition, you cannot invoke Web ADI from the Assignment window when you access it by task flow from the Person window.
Note: If you access the Assignment window by task flow from the Person window, you will not be able to invoke Web ADI from that Person window for the current person query. To restore Web ADI function, perform the query in the person form again.
You can invoke Web ADI from the Assignment window when you access it directly from the Navigator.
Your access to Web ADI depends on the access rights set up for your responsibility.
Integrators
Westwood monopoly download. The functionality available with Web ADI depends on the information stored in an 'integrator'. Each integrator contains all relevant information about a particular data download, upload, or create process, such as whether you are downloading data from an HRMS window, from a Web ADI self-service window, or from the Request Letter window. It also specifies whether you can download one-way or whether you require the ability to upload edited data again, whether the data is being downloaded into a mail merge, and so on. The integrator details also indicate whether you can use it to create new data or just update existing data.
When you create your spreadsheet or word processing document using Web ADI, you select an appropriate integrator, and Web ADI handles the transfer and validation of data accordingly.
Predefined Integrators
Oracle HRMS supplies some sample integrators that enable you to download data from the following windows and folders for reporting or analysis purposes:
Window or Folder | Integrator |
---|---|
People Window | HR People Details Integrator |
People Folder | HR People Folder Detail Integrator |
Assignment Window (accessed directly from the Navigator) | HR Assignment Detail Integrator |
Assignments Folder | HR Assignment Folder Detail Integrator |
Salary Management Folder | HR Update Salary Proposals Integrator |
Using the HR Update Salary Proposals integrator, you can edit the downloaded data and upload it to HRMS. The remaining four sample integrators support data download only.
Note: These five predefined integrators demonstrate the supplied function but are not supported solutions, and you cannot create your own layouts for these integrators. However, you can create your own integrators to enable download and upload of HRMS data.
See: Configuration of Data Download and Upload
Key Concepts
An understanding of the following terms may assist you in downloading and uploading data between Oracle HRMS and your desktop using Web ADI.
API
Application Programmatic Interfaces, used to upload data to the Oracle Applications database. APIs handle error checking and ensure that invalid data is not uploaded to the database.
Content
When you create a spreadsheet or word processing document, the layout defines the columns that appear in the document and the content identifies the data in the document. Content is usually downloaded from the Oracle application database, so that the spreadsheet contains the data you have queried from a window in Oracle HRMS. You can also create a spreadsheet with no content, so that you can enter new data using the spreadsheet and upload it to the application. Another method is to bring in the content of the spreadsheet from a text file on your desktop. This enables you to upload the data from the text file to the application, for example to upload legacy data or information from third-party applications to Oracle HRMS.
Download
This is the process of transferring data from the Oracle HRMS application to your desktop (the original data remains in the application database).
Integrator
An integrator defines all the information that you need to download or upload from a particular window or database view or for a particular purpose (the type of integrator determines the purpose for which you can use it). Your system administrator can set up the appropriate integrators depending on whether you want to download for reporting or mail merge purposes, or in order to manipulate the data and upload it again.
Interface
A Web ADI term for the item that specifies the columns to be transferred from the Oracle applications database to your desktop or vice versa. In HRMS, interfaces can be views (for downloading data) or APIs (for uploading data). The integratorincludes all the columns that are available in the interface, whereas the layout specifies only those that the user needs to see.
Layout
A layout identifies the columns to appear in a spreadsheet or Word document. A single integrator can have multiple layouts for different purposes. If more than one layout is available for an integrator, you select a layout when you create a document. If only one layout is available, the application selects it for you automatically.
Mapping
If you are bringing in data from a text file to Oracle HRMS using a spreadsheet created in Web ADI, you need to map the columns in the text file to the application's tables and columns. When Web ADI creates the spreadsheet, it ignores any columns from the text file not included in the mapping.
Template Letter
This is a form letter or skeleton letter that acts as the basis for creating mail merge letters. The template letter contains the standard text, and also contains field codes, which are replaced by data from the application during the mail merge process.
Upload
This is the process of transferring the data from a spreadsheet on your desktop back to the Oracle HRMS application, overwriting the existing data in the application database. This process can take place only if Web ADI created the spreadsheet.
View
A view is an example of an interface that you can use to download data from the application to a spreadsheet. The integrator definition includes the name of the view. Views to access many windows are already available with Oracle HRMS. System administrators can create additional views if necessary.
Viewer
A viewer is a desktop application, such as a spreadsheet or word processing tool, that you use to view the data downloaded from Oracle HRMS.
Data Download Using Web ADI
You can download data from your Oracle HRMS application to a spreadsheet or word processor on your desktop. You can then use the features of your spreadsheet or word processing tool to manipulate data for analysis and reporting purposes.
Note: When you download data from a spreadsheet, you have to select the appropriate security setting for macros in Microsoft Excel. See: Selecting Macro Security Settings in Microsoft Excel topic in the Oracle Web Applications Desktop Integrator Implementation and Administration Guide
You can download from within a window in the HRMS Professional User Interface (including OLM windows), or directly from a Web ADI self-service page.
You can save the spreadsheet that you have created and return to it later. The spreadsheet includes all the data you have downloaded. You can refresh the data without creating a new spreadsheet by carrying out a new download directly from the spreadsheet, without recreating the spreadsheet.
See: Data Upload Using Web ADI and Letter Generation Using Web ADI
Downloading from an HRMS Window
This method enables you to use the query you enter in the window to specify the records to download.
Downloading from a Self Service menu Function
This method enables you to apply values at runtime so that you can specify the records to download.
Downloading an Empty Spreadsheet
Python the complete reference pdf. You can download an empty spreadsheet from the ADI web page (that is, containing the columns you want, but no data), and then use the spreadsheet to enter new data.
Downloading an Empty Spreadsheet and Incorporating Data from a Text File
You can download the structure of your spreadsheet using Web ADI, but instead of downloading the content of the spreadsheet from the applications database, you can incorporate a text file in the spreadsheet as you create it, and then upload the data from the text file to the database. See: Data Upload Using Web ADI
Format of Text files
Text files must be in delimited format, separated by commas or other standard characters. You can use text files that include or exclude headings in the first line.
Data Upload Using Web ADI
You can use Web ADI to upload data that you have previously downloaded to a spreadsheet, or data that you have entered in an empty spreadsheet. You can do this only if the spreadsheet was created using an upload integrator.
Note: When you upload data from a spreadsheet, you have to select the appropriate security setting for macros in Microsoft Excel. See: Selecting Macro Security Settings in Microsoft Excel topic in the Oracle Web Applications Desktop Integrator Implementation and Administration Guide
Features of Data Upload
You can only upload data using an integrator that has been created for this purpose (for example, the HR Update Salary Proposals integrator available from the Salary Management folder). You must specify at the time you download the data that you intend to upload it again, by unchecking the Reporting check box. You must also have access to a responsibility that gives you access rights to upload data as well as download it.
Data to be uploaded is validated before the upload occurs. You must ensure that you enter values in all mandatory fields, so that validation is successful when the data is uploaded to the application. If you do not, the data is not uploaded, and an error message appears in the Messages column in the spreadsheet for the record with the invalid data.
For example, if you are using the HR Update Salary Proposals integrator, you must enter values in the Proposed_salary and Change_date fields, as a minimum, for any row you want to upload. If your organization has created its own integrators for uploading data, your system administrator can tell you which fields you must enter.
When you change any field in the spreadsheet, the row is flagged for upload. By default, only flagged rows are uploaded. You can change this setting so that all rows are uploaded.
Letter Generation Using Web ADI
You can generate mail merge letters from Oracle HRMS using Web ADI.
Web ADI retrieves the data and downloads it directly into a template letter (which you can also store in the Oracle applications database) to form the mail merge.
When you create a document for a mail merge, ensure that you select Word as the viewer, and check the Reporting check box.
Your system administrator must set up integrators to enable the letter generation to take place.
In addition, the layout associated with the letter generation process must have the same name as the letter created in the Letter window in the Oracle HRMS application. This associates a letter with an assignment status in Oracle HRMS or an enrollment status in OLM, and links the letter to the layout.
Configuration of Data Download and Upload Using Web ADI
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.
Views for Web ADI
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.
APIs for Web ADI
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, Oracle Integration Repository User Guide .
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.
Integrators for Web ADI
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
Layouts for Web ADI
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.
Additional Information
For information about setting up and configuring Web ADI, see the Oracle Web Applications Desktop Integrator Implementation and Administration Guide .
Controlling Access to HRMS Web ADI Integrators
You control access to HRMS Web ADI integrators using standard system-administration form functions and menus.
Controlling Access to Predefined Integrators
HRMS provides form functions for the predefined integrators. HRMS also automatically adds the form functions for some predefined integrators to the seeded menus from which they are accessed. The menus HR ADI Seeded Integrator Form Functions and HR ADI Skills Seeded Integrator Form Functions include the remaining form functions for predefined integrators. You can add these form functions to menus simply by adding the seeded menus HR ADI Seeded Integrator Form Functions and HR ADI Skills Seeded Integrator Form Functions (without the prompts) to any menu you use to access them. Alternatively, you can modify copies of the seeded menus and add them to existing menus, or you can add selected Web ADI functions directly to existing menus.
If you fail to add the predefined form functions to menus, the message 'You do not have permission to access this functionality' appears when you select an integrator.
The following table shows the predefined integrators and their associated form functions in menu HR ADI Seeded Integrator Form Functions (HR_ADI_CAG_FORM_FUNCTIONS):
Predefined Integrator | Form Function (Internal Name) | Form Function (User Name) |
---|---|---|
HR Assignment Detail | HR_ADI_CAG_ASG_DETAIL | HR Assignment Detail Integrator |
HR Assignment Folder Detail | HR_ADI_CAG_ASG_FOLDER | HR Assignment Folder Integrator |
HR People Details | HR_ADI_CAG_PEOPLE_DETAILS | HR People Details Integrator |
HR People Folder Detail | HR_ADI_CAG_PEOPLE_FOLDER | HR People Folder Detail Integrator |
HR Update Salary Proposals | HR_ADI_CAG_UPD_SAL_PROP | HR Update Salary Proposals Integrator |
HR Create Standalone Query | HR_ADI_CAG_SETUP_CREATE_QRY | HR Create Standalone Query Integrator |
HR Disable Integrator | HR_ADI_CAG_SETUP_DISABLE | HR Disable Integrator |
HR Create Integrator Responsibility Restrictions | HR_ADI_CAG_SETUP_INTG_RESP | HR Create Integrator Responsibility Restrictions |
HR Maintain Standalone Query | HR_ADI_CAG_SETUP_MAINTAIN_QRY | HR Maintain Standalone Query Integrator |
HR Maintain Integrator Form Function Associations | HR_ADI_CAG_SETUP_MAINT_FUNC | HR Maintain Integrator Form Functions |
HR Maintain Integrator Responsibility Restrictions | HR_ADI_CAG_SETUP_MAINT_RESP | HR Maintain Integrator Responsibility Restrictions |
HR Integrator Setup | HR_ADI_CAG_SETUP_SETUP | HR Integrator Setup |
Web ADI - Interface Columns Integrator | HR_ADI_CAG_INTERFACE_COLS | Web ADI - Interface Columns Integrator |
The following table shows the predefined integrators and their associated form functions in menu HR ADI Skills Seeded Integrator Form Functions (HR_ADI_SKILLS_FORM_FUNCTIONS):
Oracle Adi Download Torrent
Predefined Integrator | Form Function (Internal Name) | Form Function (User Name) |
---|---|---|
Upload Third Party Rating Scale | HR_ADI_SKILLS_RSC | HR Upload Third Party Rating Scale |
Upload Third Party Rating Level | HR_ADI_SKILLS_RTL | HR Upload Third Party Rating Level |
Upload Third Party Competence | HR_ADI_SKILLS_CPN | HR Upload Third Party |
Step 1: Upload Third Party Rating Scale | HR_ADI_SKILLS_STEP1_RSC | HR Upload Third Party Step 1 |
Step 2: Upload Third Party Rating Level | HR_ADI_SKILLS_STEP2_RTL | HR Upload Third Party Step 2 |
Step 3: Upload Third Party Competence | HR_ADI_SKILLS_STEP3_CPN | HR Upload Third Party Step 3 |
Controlling Access to Custom Integrators
Custom integrators, like predefined integrators, must be associated with form functions. Therefore, for custom integrators you must:
- Define at least one form function.
- Add the form function to appropriate menus.
- Associate the form function with one or more integrators using the HR Maintain Integrator Form Function Associations Integrator.
For detailed instructions for Step 3, see Controlling Integrator Access
Note that the form function HR Maintain Integrator Form Functions Integrator must be accessible from your menu before you can use the HR Maintain Integrator Form Function Associations integrator. You can associate:
- One custom integrator with one form function
- One custom integrator with many form functions
- Many custom integrators with one form function
Grouping custom integrators by form function improves integrator administration and gives you finer control over user access. For example, you can:
- Associate related integrators with a single form function, then add that form function to the menus of authorized users.
- Associate download integrators with one form function and upload integrators with a different form function to provide a restricted level of access to some users.
- Define a form function for each integrator, create a menu for each group of related integrators, and add those menus of functions to users' menus, as appropriate.
Controlling Access to Integrators Using Responsibilities
You can restrict access to integrators by responsibility using the HR Create Integrator Responsibility Restriction integrator. If you create a restriction for an integrator, only users who have access via the responsibility can access the integrator. You can link integrators to multiple responsibilities. The restriction applies only when you launch Web ADI from the Professional User Interface (PUI) window.
You can update or remove the restriction using the HR Maintain Integrator Responsibility Restrictions integrator.
Note: Oracle recommends that you control access to integrators using the form functions and menus instead of responsibility restrictions. Use of form functions and menus provides a greater degree of control over user access.
For information about restricting integrators by responsibility, see: Controlling Integrator Access
Upgrade Information for Converting from ADE to Web ADI
This section provides information about upgrading to Web ADI for customers who are currently using Application Data Exchange (ADE) to transfer information between Oracle HRMS applications and desktop tools.
Comparison of Features in ADE and Web ADI
For details of the features available in Web ADI, see: Data Download and Upload Using Web ADI: Overview
The method of operation of Web ADI is different from that of ADE, and terms used in ADE do not always have an exact equivalent. The following table lists terms used in ADE and the equivalent functionality in Web ADI.
ADE | Web ADI |
---|---|
Style | Integrator |
Style columns (columns set as displayed) | Layout |
View name | Content |
Style columns (queried from view) | Content columns |
API name | Interface |
Style columns (making up API parameters) | Interface columns |
Style columns (that are view columns and API parameters) | Mapping |
Style - Form Name | HR Integrator Setup - FORM_NAME parameter |
Style - Letter Name | Layout Name (for Letter Request integrators) |
Note: Customers converting from older versions of Oracle HRMS and ADE, in which ADE included hierarchy diagrammers, should note that the hierarchy diagrammers functionality is now available from standard windows in the HRMS Professional User Interface.
Additional Features in Web ADI
The following additional features are available in Web ADI:
- In addition to the ability to upload data that you have previously downloaded from a spreadsheet to the Oracle application database, Web ADI enables you to upload new data from legacy systems.
- Web ADI enables you to store your mail merge template letters in the Oracle application database
Prerequisites for Upgrading from ADE to Web ADI
The following information may assist you when upgrading from ADE to Web ADI.
Views
When creating new integrators for use with Web ADI, you may need to create a suitable view. If you have views that you have created for use with ADE, you can reuse these views.
Styles
You can convert existing styles in ADE to Integrators in Web ADI. See: Converting ADE styles to Web ADI Integrators
The conversion process uses the Upgrade from ADE to Web ADI concurrent process. This process is available in the Global SHRMS Reports & Processes request group, attached to the Global Super HRMS Manager responsibility.
Profile Option HR: Data Exchange Directory
Information about ADE styles is stored in an ADE.INI file located on either individual user desktops or a shared drive. The Upgrade from ADE to Web ADI concurrent process uses this file to convert ADE styles to Web ADI integrators.
To use this concurrent process, you need to copy the ADE.INI file to a directory accessible to the Oracle database. The path to this directory must be within the UTL_FILE_DIR setting for your database and must be specified on the HR: Data Exchange Directory profile option.
Downloading Data to your Desktop using Web ADI
You can download data from Oracle HRMS to a spreadsheet or word processor using Web ADI, either from within a window in the HRMS application, or directly from a Web ADI page without accessing HRMS.
See: Data Download Using Web ADI
To download data to a document from an HRMS window
- Navigate to the window from which you want to download the data, for example, the People window.
- Enter a query to return the records you want to download.
- Choose the Export Data icon on the toolbar. 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.
- Select the viewer you want to use to display the document. https://tradecelestial.weebly.com/download-buku-data-persamaan-transistor.html. If you intend t