New EPM Integration Agent Options

New EPM Integration Agent options are available in this update to help you manage auto-commit behavior and assure file upload reliability.

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting

The ENABLE_AUTO_COMMIT option determines the auto-commit behavior (every database operation is a transaction that is committed when performed.)  This option addresses errors that may occur during agent processing in some versions of the JDBC Driver (for example, IBM DB2), which perform the auto-commit by default. By default this option is set to  N.

To address network latency issues that may delay the upload of large data files to the EPM Cloud, two new options have been added to avoid time-out or other issues during the file upload.

  • The RETRY_INTERVAL option sets the retry the logic period after a specified number of seconds. The default is 10 (seconds).
  • The FILE_UPLOAD_SIZE option limits the size of the file upload in iteration by a specified megabyte (MB). By default the file upload size is 50 (MB).

The new EPM Integration options can be set in agentparams.ini.

Business Benefit: The new EPM Integration Agent options enable you manage auto-commit behavior and ensure file resiliency during the file upload.

Key Resources