Oracle® Retail Store Inventory Operations Cloud Services Implementation Guide Release 19.7 F70122-01 |
|
Previous |
Next |
Use EICS Spreadsheet Data Loader to upload data to the EICS application tables from spreadsheets. Spreadsheet Data Loader is applicable to small or medium data file up to a few Megabytes.
EICS UI spreadsheets loader provides following features:
Download the templates
Upload user store assignments
Upload user role assignments
Data Validations
You can assign users to stores using EICS Spreadsheet data loader in EICS Admin Security screen. User must exist in credential store (for example, IDCS or OCI IAM).
You must have the Application Administrator job role or privileges.
UserAssignmentsTemplate.xlsx/Store Assignments:
Table 8-1 Spreadsheet Templates
Field | Description | Required |
---|---|---|
Action |
The assignment action, choose value from dropdown, assign, revoke. |
Yes |
Action Value |
N/A |
No |
Username |
The username to assign the store. |
Yes |
Store ID |
The store Id to assign to user. |
Yes |
See Oracle Retail Enterprise Inventory Cloud Service Security Guide and Oracle Retail Enterprise Inventory Cloud Service User Guide Security chapter.
You can assign users to roles using EICS Spreadsheet data loader in EICS Admin Security screen. User must exist in credential store (for example, IDCS or OCI IAM).
The role must exist in EICS.
You must have the Application Administrator job role or privileges.
UserAssignmentsTemplate.xlsx/Role Assignments:
Table 8-2 Spreadsheet Templates
Field | Description | Required |
---|---|---|
Action |
The assignment action, choose value from dropdown, assign, revoke. |
Yes |
Action Value |
N/A |
No |
Username |
The username to assign the store. |
Yes |
Role Name |
The role name to assign to user. |
Yes |
Store ID |
The store Id to assign to user. |
No |
Start Date |
User start date. |
No |
End Date |
User end date. |
No |
See Oracle Retail Enterprise Inventory Cloud Service Security Guide and Oracle Retail Enterprise Inventory Cloud Service User Guide Security chapter.