Calculation Script is Too Long or Complex

Scenario:

Use the Manage Currency Conversion page to generate application-wide calc scripts that you can launch from the Web to convert currencies. When generating calc scripts, if the following error displays, the calc script exceeds the 64K limit.

Calculation script is too long or complex

This can occur if an application has many periods (such as 500) included in a currency conversion calc script.

Solution:

  To resolve this issue:

  1. Limit the calc script to one scenario.

    If the calc script generates successfully, skip to the last step.

  2. If the error still displays, limit the calc script to one reporting currency.

    If the calc script generates successfully, try selecting two reporting currencies. If that works, continue adding reporting currencies until the error displays. Then skip to the last step. If the calc script does not generate with one reporting currency, remove some currencies from the application.

  3. Use the Manage Currency Conversion page to generate as many other, smaller currency conversion calc scripts as necessary to include your scenarios, reporting currencies, and versions.

    You can also give periods very short names.