Increased Limit and New Set Limit Option for SQL Batch Processing in Data Integration

Currently the load process uses batch processing to insert and delete rows when the number of records exceed 1 million. This limit has now been increased to 3 million.

In addition, a new Record Limit for Database Batch Processing option in System Settings is available so customer can adjust the limit setting when the number of records is slightly higher than the current limit, and this will allow the user to set the limit above the 3 million row default.

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

Business Benefit: The limit increase improves performance when loading data for more than 1 million records.

Key Resources

• In Administering Data Integration for Oracle Enterprise Performance Management Cloud, see:
  • System Settings