Download and Edit U.S. Federal Financials Data in the Corresponding Spreadsheets
The downloaded spreadsheets include all the columns that are available in the corresponding work areas. For fields that contain a list of values, the list of values is also available in the spreadsheets.
Tip: If you don’t see the complete list of values
for a particular field in the spreadsheet, you might need to clear the cache in
the spreadsheet. To do so, click the Oracle Visual
Builder menu and select Advanced, Clear List of
Values cache.
In the spreadsheet, you can edit only the fields and perform only the actions that
are supported on the corresponding page for a particular record. For example, in the
spreadsheet downloaded from the Manage SAM Trading Partners page, on the SAM
Business Unit Assignments worksheet, you can:
- Override or change only the values that you're allowed to change on the Manage Business Unit Assignments page. For example, you can update the Supplier Site and Main Address Site values.
- Add a new record to assign a business unit to a trading partner.
The spreadsheets include three more columns, two in the beginning (Change and Status) and one at the end (Key). The Change and Status columns indicate whether a row was changed, created, and whether the action on the row was successful.
The following steps illustrate how to download SAM data to a spreadsheet using business unit assignments data as an example: