There are two ways to download the project costs from Oracle using the Cost Adjustments Integrator.
● Download via Form
● Download via Sheet
More information about downloading can be found here.
Download via Form
The Download Form will be displayed when the ‘Download via Form’ is selected. Here, you can enter values into the available fields to set the download criteria. Click the ‘Download’ button to download data onto the sheet.
Data can be entered directly on the download form to be searched. The example below will return all the project costs that belong to the Expenditure Batch ‘WTBatch290422-1’:
More4apps recommend entering more values on the download form to narrow down the search criteria. Some of the fields on the download form have dependent values. A dependent field appears based on the values entered in other fields on the form. The example below shows the List of Values for the Project Number field that match the criteria entered in the previous fields. This is useful when you’re interested in downloading project costs for just one project. The Project Number field can be left blank to return all the projects that match the criteria entered in the other fields:
Download via Sheet
When the option to Download via Sheet is selected, the Integrator will use the data entered in the columns that allow sheet values to be used as the download criteria to download data to the sheet. These columns are indicated by a white triangle above the column name. Note that not all the columns available on the Download Form are available as values to be used in the ‘Download via Sheet’ option. Please also note that query conditions on the sheet and in the Download form are treated as AND clauses rather than OR in the download query.
