Oracle EPM Automate updates for April 2021

 A new version of EPM Automate is now available. This version introduces the exportCellLevelSecurity, exportValidIntersections, extractDimension, importCellLevelSecurity, importReconciliationAttrbutes, importValidIntersections, and sendMail commands.

Applies To: Account Reconciliation, Enterprise Data Management, Financial Consolidation and Close, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting

exportCellLevelSecurity Command

This command exports cell-level security settings from a Planning or Tax Reporting business process into a ZIP file.

exportValidIntersections Command

This command exports valid intersection groups from a Planning, Consolidation and Close or Tax Reporting business process into a ZIP file. Valid intersections are cell interactions that are filtered based on rules you define, called valid intersection rules, which filter certain cell intersections to users when they enter data or select runtime prompts.

extractDimension Command

This command extracts an Oracle Enterprise Data Management Cloud dimension to a file or to a global connection.

importCellLevelSecurity Command

This command imports cell-level security settings from a ZIP file that contains an Excel file with cell-level security definitions into Planning or Tax Reporting business process.

importReconciliationAttributes Command

This command imports reconciliations attributes from a file into existing reconciliations.

importValidIntersections Command

This command imports valid intersection groups from a ZIP file that contains an Excel file with valid intersection definitions into a Planning, Consolidation and Close or Tax Reporting business process.

sendMail Command

This command sends an email to specified recipients with the option to attach files from EPM Cloud. This command can be incorporated into EPM Automate scripts to notify users of various conditions or to send reports.