The ribbon is used to perform actions within the modules.
The table below describes the functions of each ribbon button.
Icon
Functionality
Opens the ERP Cloud login screen to secure a connection to Oracle and create a session in ERP Cloud Toolbox Add-in.
Logs out of Oracle ERP Cloud and the Excel Add-in.
Login offers both SSO and basic authentication support.
Create New Sheet:
Opens a form to select your desired columns or create an entire sheet with all columns for your integrator selected.
Edit Existing Sheet:
Opens a form representing your current sheet you are on. Letting you to either select(add) or deselect(remove) fields from your template. This will create a new sheet based on your edits but keep your original sheet.
Copy Active Sheet:
Will create a new blank sheet based on your current template you have set up. Note that data won’t be copied across when using this option.
Opens the Data Forms for the section selected.
Provides formatting options that can be applied to the spreadsheet data.
Denormalize: Formats all sheet data into singular rows for re-ordering.
Normalize: Returns values to its original hierarchical state.
Sheet Ordering: Opens a form to specify columns to reorder sheet values.
For more information on formatting refer to the Formatting section.
Downloads data from Oracle ERP Cloud printing data to the sheet.
Clicking the icon will give you two options for downloading:
