To manipulate salary proposals in a spreadsheet:Using the Salary Management Folder, you can select sets of assignments for which you want to enter or approve salary proposals. For each assignment, the folder can display the current approved salary and proposed new salary, including up to ten salary components.
Using Web Applications Desktop Integrator (Web ADI), you can download information from the Salary Management folder to a spreadsheet. Here you can manipulate the data to create new salary proposals or to modify existing proposals. You can then upload your revised salary information to the database. If your responsibility permits, you can approve all or selected proposals in the folder.
See: Data Download Using Web ADI
See: Data Upload Using Web ADI
To manipulate salary proposals in a spreadsheet:In the Salary Management folder, query the assignments you want to process.
Display the folder columns that you want to export.
Choose the Export Data icon on the Oracle HRMS tool bar to display the Settings page of the Web ADI wizard.
Note: You need to be logged into your self-service home page for the Web ADI settings page to appear. Otherwise, you will be prompted with the self-service applications login screen.
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 a spreadsheet viewer. If several versions of the viewer are available, your system administrator can tell you which version is appropriate.
Ensure that the Reporting check box is unchecked. You cannot upload data if the Reporting check box is selected when you download the data.
Note: You can upload data only if the HR Update Salary Proposals integrator has been set up to allow upload. Check with your system administrator that the required integrator is available.
All other information is defaulted and a Review page displays the parameters that will be used to create the document. Choose the Create Document button to continue.
A spreadsheet document is created and displayed, and the data from the records you queried is added to the spreadsheet. A number of confirmation messages appear as the document is created.
The data downloaded to the document depends on the query you entered in the window and the columns in your layout.
Note: You may want to save the spreadsheet on your desktop at this stage, as otherwise the spreadsheet and the data it contains will be lost from your desktop when you close the spreadsheet (the data remains in the Oracle application).
Edit the data in the spreadsheet. Save the spreadsheet with a new name (to prevent it being overwritten the next time Web ADI is run).
For further information about the rules to follow when editing the data in your spreadsheet, see: Salary Spreadsheets.
In the Upl column of the spreadsheet, each row where you have changed data in any field is flagged for upload. As you change data in a field, the row is flagged for upload.
Select the Oracle menu on your spreadsheet viewer toolbar, and choose Upload
If you are not already logged in to Oracle applications, a login page appears. Enter your user name and password, then choose the Login button.
In the Set Responsibility page, choose your responsibility and then choose Select.
In the Upload Parameters page, choose the Parameters button. If you only want to upload flagged rows, choose the Flagged Rows option button. To upload all rows choose the All Rows option button.
Choose the Proceed to Upload button, then choose the Upload button in the page that appears next. The upload takes place, and a series of upload messages is displayed, indicating the success or failure of the upload.
If the upload fails, return to the spreadsheet and correct any errors, then retry the upload. Further details of errors are available in the Messages column at the end of each row of the spreadsheet. If the upload is successful, the data is uploaded to the database. Confirmation messages indicate the success of the upload.
Note: Web ADI uploads all rows to the database if the data is error-free. If any errors occur, no rows are uploaded.
To view your new proposals in the Salary Management folder, re-query the data.
If the Approve button is displayed in the Salary Management folder, you can select multiple assignments in the folder and approve them.
Note: If the Approve button is not displayed, you cannot approve salaries. This is controlled by a menu function set up by your system administrator.
When you approve a salary, Oracle HRMS creates or updates a salary element entry for the assignment. You can view this entry in the Element Entries window, but you cannot change it there.
To approve multiple salary proposals
In the Salary Management folder, query the assignments you want to process.
Select the assignments you want to approve and choose the Approve button. To select multiple assignments, hold down the CTRL key and click on the assignment records you want to select.
Note: The Salary Management folder is not designed for mass approvals. Do not try to approve hundreds of salary proposals together using this window.