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
This method enables you to use the query you enter in the window to specify the records to download.
This method enables you to apply values at runtime so that you can specify the records to download.
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.
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
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.