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 Administrator

Usage

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 the uploadFile 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 is false.

Example

epmautomate importAppSecurity Acl_file.CSV Acl_import_error.CSV clearall=true