importAppSecurity
Loads access permissions for users or groups of an application from a CSV file available in the inbox.
Importing access permissions overwrites existing assignments only for imported members, data forms, data form folders, task lists, Calculation Manager business rules, and business rule folders. All other existing access permissions remain intact.
Applies to
Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Enterprise Profitability and Cost Management, Sales Planning, and Strategic Workforce Planning.Required Roles
Service AdministratorUsage
epmautomate importAppSecurity ACL_FILE_NAME ERROR_FILE [clearall=true|false]
where:
ACL_FILE_NAME
is the name of a CSV file containing access permissions that you want to import into the application. Before running this command, use theuploadFile
command to upload this file to the inbox. Contents of a sample input file may be as shown in the following image:For a description of the column headers and possible values, see Import Security in REST API for Oracle Enterprise Performance Management Cloud.
ERROR_FILE
is the name of a CSV file, which EPM Automate will create in the outbox, to record the errors that are detected during this operation. You can download this file to a local computer to analyze and correct the reported errors. Contents of a sample error file may be as shown in the following image. The columns of this file corresponds to the header columns of the input file:clearall
, optionally, specifies whether to delete the existing access permissions before loading new permissions from the file. Default isfalse
.
Example
epmautomate importAppSecurity Acl_file.CSV Acl_import_error.CSV clearall=true