Oracle® Hyperion Profitability and Cost Management

Readme

Release 11.1.2.2


Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

Authors: EPM Information Development Team

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS:

Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.


Table of Contents:

Purpose

New Features

Installation Information

Supported Platforms

Supported Languages

Supported Paths to this Release

Defects Fixed in this Release

Known Issues

Tips and Troubleshooting

Documentation Updates

Accessibility Considerations

Purpose

This document includes important, late-breaking information about this release of Oracle Hyperion Profitability and Cost Management. Review this Readme thoroughly before installing Profitability and Cost Management.

New Features

For information about the new or extended functionality in this release, see the Oracle Hyperion Profitability and Cost Management New Features.

For new features relating to installation, architecture, and deployment changes in this release, see "New Features" in the Oracle Enterprise Performance Management System Installation and Configuration Readme.

Installation Information

Late-breaking information about installation of Oracle Enterprise Performance Management System products is provided in the Oracle Enterprise Performance Management System Installation and Configuration Readme. Review this information thoroughly before installing EPM System products.

Supported Platforms

Information about system requirements and supported platforms for EPM System products is available in a spreadsheet format in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on the Oracle Technology Network (OTN):

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Supported Languages

Information about supported languages for EPM System products is available in a spreadsheet format on the Translation Support tab of the Oracle Fusion Middleware Supported System Configurations page on OTN:

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Supported Paths to this Release

You can upgrade to EPM System 11.1.2.2 from the following releases.

Note:

For instructions, see the Oracle Enterprise Performance Management System Installation and Configuration Guide and “Upgrading EPM System Products”.

Table 1. Supported Paths to this Release

Release Upgrade Path FromTo

11.1.2.x

11.1.2.2

Note:

If moving from Release 11.1.2.0.x or 11.1.2.1.x to Release 11.1.2.2, use the "Apply Maintenance Release" option in the EPM System Installer, instead of following the documented upgrade procedures.

For Financial Close Management, applying the maintenance release is supported only from Release 11.1.2.1.

11.1.1.3.x

11.1.2.2

11.1.1.4.x

11.1.2.2

An environment that includes multiple releases, which can include an environment with one instance of Oracle Hyperion Shared Services or an environment with two instances of Shared Services

See "Upgrading from an Environment with Multiple Releases" in the "Upgrading EPM System Products" chapter in the Oracle Enterprise Performance Management System Installation and Configuration Guide.

Notes:

  • If you are starting from Release 9.2.0.3+, 9.3.0.x, 9.3.1.x (except for Oracle Essbase 9.3.1.4.1, 9.3.1.5, 9.3.1.6, and 9.3.1.7), or 11.1.1.x, upgrade to Release 11.1.1.3 as your interim release.

  • If you are starting from an earlier release, Oracle recommends that you upgrade to the highest level release that directly supports upgrade from your starting release.

  • Security Synchronization between Essbase and Oracle Hyperion Shared Services was removed in Essbase 9.3, starting with Release 9.3.1.4.1. Consequently, if you use Essbase Release 9.3.1.4.1, 9.3.1.5, 9.3.1.6, or 9.3.1.7, upgrade all products to Release 9.3.3, not 11.1.1.3.

Defects Fixed in this Release

If you are coming from Release 11.1.2.0 or 11.1.2.1, use the Defects Fixed Finder tool to review the list of defects fixed between those releases and Release 11.1.2.2. This tool is available here: https://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1292603.1

  • 13577161 -- When redeploying a Profitability and Cost Management application (BSO cube) to Essbase, if the Update database option is selected as well as Archive Data and Reload after deploy, Essbase fails to load data back into the BSO cube.

  • 13532628 -- When using MS SQL, if you update staging tables to use an Object Calculation driver, the import task fails; and error messages are not displayed in hpcm log.

  • 12981414 -- It is not possible to use Oracle Hyperion Enterprise Performance Management System Lifecycle Management export with Profitability and Cost Management when in Compact deployment mode.

  • 12931223 -- Error messages are generated when running model validations.

  • 12709730, 12693108 -- Errors for large IDs received on multiple applications.

  • 12704623 -- Deployment of an application takes a long time to complete.

  • 12623571, 12623563 -- When performing trace allocations, the CPU was at 100% usage.

  • 12577391 -- Import of assignments is very slow.

  • 12557684 -- Trace allocations cannot be performed for a large core application although it is working for smaller applications.

  • 12351827-- A Copy POV operation takes a long time to be completed.

  • 12351800-- Staging load is very slow.

  • 12316225 -- If the "Allow Intrastage Assignments" option is disabled on all stages, a POV Copy operation will fail.

Known Issues

The following are the noteworthy known issues in this release:

  • 13838989 -- In both Standard and Detailed Profitability, if a POV with a status of either “Archived” or “Published” is selected, the new POV seems to be correctly applied. If you then select a valid POV with a “Draft” status and create or edit a driver association using the double-click and <...> option, or select it from drop-down list, the driver rule cannot be created or modified, and the changes are not saved.

    Note:

    This defect does not apply if the Add icon is selected to create or edit the driver rule.

  • 13832599 -- For Detailed Profitability, if a source stage table has a joined lookup table, the Stage Balancing report is not created because both the source table and its associated lookup table have the same system column, and the column is registered as a measure column on either the source table or its lookup.

  • 13810867-- For Detailed Profitability only, if Measures contain different types of data (for example, numerical headcount versus monetary values), the Stage Balancing report may provide incorrect results because the different value types cannot be properly distinguished. The accuracy of the results are determined as outlined below:

    • For Vertical Source Tables, the Stage Balance view results are correct if you put all your statistical measures on a joined lookup table; however if you have statistical measures directly on your source table, the results are incorrect.

    • For Horizontal Source Tables, the Stage Balance view results are incorrect if you have ANY statistical measures, either on a joined lookup table or directly on the source table itself.

  • 13803615 -- After creating and successfully deploying a Standard Profitability application to Profitability and Cost Management, if you go to the Data Entry screen and redeploy the calculation cube using the “Replace”' option, the redeployment fails and an error is generated in the hpcm.log.

    To work around this issue, unload the Essbase application using any of the Essbase clients.

  • 13800625 -- For Detailed Profitability, additional Model Validations are required to check for missing database privileges.

    After installation, the following privileges should be assigned:

    • For Oracle database, Detailed Profitability requires that these system privileges (or roles that include them) be granted to the Product Schema:

      • CREATE TABLE

      • CREATE VIEW

      • CREATE ANY SYNONYM

      • DROP ANY SYNONYM

    • For SQL Server, Detailed Profitability requires that these system privileges (or roles that include them) be granted to the Product Schema:

      • CREATE TABLE

      • CREATE VIEW

      • ALTER or CONTROL

        Note:

        In Oracle, users and schemas are the same thing. In SQL Server, they are separate. For SQL Server-based installations, Detailed Profitability requires you to create a user with the same name as the Model Data Schema, and that user must have privileges on all the objects in the model data schema.

  • 13772443 -- If you try to delete or edit an assignment that had the same dimension member set as Source One, an error is generated.

  • 13713095 -- For Detailed Profitability, when you create a new assignment rule, if you select the Same As Source check box, only the Same As Source members are listed.

  • 13702673 -- In the Assignment Rules dialog box, when you open a Destination Rule and the focus is on the first dimension, if you select the Same As Source check box, the browser freezes.

  • 13700793 -- On the Stage screen, you cannot change the stage table selection to a new stage table after a calculation has been run.

  • 13768324 -- When using Internet Explorer 10, if you change the Destination pane mode without saving data, no confirmation is displayed, and the Save icon remains enabled.

  • 13742313 -- When using Internet Explorer 9 with Standard Profitability, if you select Tracing Allocations, no links are displayed.

  • 13723174 -- For Detailed Profitability applications, if a source stage table has a vertical format, the Stage Balancing Report does not contain the source measures from a joined Lookup table.

  • 13717938 -- For both Standard and Detailed Profitability, when importing using staging tables, if an extra dimension is added, the task seems to finish successfully; however, no errors are generated for driver exceptions and assignment rule selections. The “Exceptions” column shows a status of “OK_IMPORTED”; although no data is actually imported into the model.

  • 13682525 -- When completing Model Data Registration for Detailed Profitability applications, after editing the tables or columns, if you go directly to Finish without making any selections on the Mapping Measures step, a warning message is displayed. For example, the message may read “Selected measure does not exist: 'Quantity'. Select another measure.

    To work around this issue, you must go back and reselect all measures.

  • 13644803 -- In either Standard or Detailed Profitability applications, if you select an application (select Navigate, then Applications, then Profitability, and then the application), the first application is correctly selected. However, if you select a second application, an error message is generated.

  • 13613585 -- If the Override Total Driver Value is used in a Ratio-Based driver, and its value is greater than the calculated Total Driver Value, the Idle_Cost column is not calculated. The Stage Balancing report displays an empty Idle_Cost column, and the corresponding idle values are shown in the Unassigned column of the report.

  • 13591567 -- If two instances of EPM System share a database and a model schema, both applications use the same names for temporary objects. Multiple EPM System instances cannot share the same model data schema.

    To work around this issue, you can create another model data schema.

  • 13537329 -- For MS SQL Server only, if horizontal source tables in Detailed Profitability contain incompatible datatypes (for example, a precision value of numeric 10,4 and numeric 10,2), validation during creation of the Stage Balance view does not generate a warning in the hpcm.log.

  • 13328441 -- When calculating Standard Profitability models, if you select the check box “Transfer data after calculation” on the Allocation tab of the Manage Calculation screen, both the Cost and Revenue data will be transferred after calculation. This information will be added to the documentation for the next release.

  • 13491128 -- After successfully calculating models that have checked options for Level-0 contribution and stage balancing, when you run Clear Calculation, the Stage Balancing and Source Destination Level-0 tables, and the sum results for all tables, are not cleared.

  • 12704464 -- If errors are generated for ID column values that display negative values because of overflow in any of the Profitability and Cost Management tables, you must run a specific script to correct the situation.

    See Running the defragment_ids.sql Script in the Tips and Troubleshooting section of this document for instructions on running the SQL script.

    Note:

    This workaround is applicable only for an installation which has Profitability and Cost Management configured with an Oracle database.

  • 11742793 -- In instances where the name of a new Profitability and Cost Management application contains foreign characters, which may result in longer names, you may not be able deploy the application in EPM Architect.

  • 13324110 -- Numbers between 0 and 1 are handled incorrectly in Data and Custom Filters. For example the number '0.002' is treated as '.002', so the corresponding query does not return the necessary records.

  • 12562262 -- For a Detailed Profitability application, if an application containing invalid artifacts is imported using Oracle Hyperion Enterprise Performance Management System Lifecycle Management, there is no validation of the artifacts. The import seems to be successful, and the invalid artifacts are imported.

  • 12560535 -- When performing Model Data Registration for a Detailed Profitability application, if you add new tables in the wizard, and then click Back to change a selection, the original selections cannot be modified. This same behavior also occurs in the Table type combo-box and Column type combo-boxes in the Table Registration wizard and the External Table, Table type combo-boxes in the Create New Join wizard.

    To work around this issue, exit the wizard and start again.

  • 10278828 -- If you enter unexpected or restricted words or characters in the Driver Editor, the validation error message is not explicit.

    To work around this issue, exit the wizard and start again.

    • Do not use the following Windows reserved names for Calculation/Reporting Application or Database names: CON, PRN, AUX, CLOCK$, NUL, COM0, COM1, COM2, COM3, COM4, COM5, COM6, COM7, COM8, COM9, LPT0, LPT1, LPT2, LPT3, LPT4, LPT5, LPT6, LPT7, LPT8, LPT9

    • Do not use Essbase reserved words for Calculation or Reporting database names. See Oracle Essbase Database Administrator's Guide.

  • 10008989 -- If the sum of the lengths of the prefix and the dimension name exceeds 80 characters, deployment to Essbase will fail. The concatenation of dimension and prefix names must not exceed 80 characters.

  • 10007895 -- When upgrading from Release 11.1.1.3.x to Release 11.1.2.1, the upgrade may fail if the EPM_ORACLE_INSTANCE variable is not set.

    To work around this issue, ensure that the EPM_ORACLE_INSTANCE variable is set before running the upgrade_reregister_ps1.bat (sh) script. For instructions, see the Oracle Enterprise Performance Management System Installation and Configuration Guide.

  • 9562829 -- On the Driver Data tab of the Data Entry screen, when you double-click a non-0-level member that had not been previously selected, a busy indicator is displayed and the selected non-0 level member is not expanded correctly.

    To work around this issue, click on the row to select it first, and then double-click to expand the selection.

  • 9289136 -- Occasionally, the first time you create a new import configuration after an installation, when the import configuration is opened, the data source details are missing and the configuration cannot be edited or run.

    To work around this issue, restart the services, and then open the import configuration.

  • 8449860 -- If global drivers have been loaded into a model, when you select “Clear All” for all stages after running the calculation scripts, the global driver measures are not deleted. When the stages are cleared, the global data is not cleared because they do not have stage specifications.

  • 8208784 -- For MS SQL Server, when creating the Import Staging Tables configuration, the application does not respond, and the screen is disabled during loading.

    To work around this issue, ensure the credentials for both MS SQL Server and the database type are correct, and retry the operation.

  • 7394379 -- When starting a taskflow, the following error message may be displayed: “oracle.classloader.util.AnnotatedNoClassDefFoundError

    To work around this issue, from the Task Areas, select Jobs Status, then Search Process, and stop the current job. Select Jobs Status, then Manage Task Flow to restart the task.

  • 7228966 -- When a Profitability and Cost Management application is deployed to Essbase, the stage dimensions are created in Essbase with the dimension name prefixed with the defined stage prefix. If the resulting dimension name is the same as any existing member name or dimension name in the application, the Essbase cube deployment will fail.

    To work around this issue, when creating definitions in the model, ensure that the resulting Essbasedimension names are unique in the resulting outline.

  • 7192173 -- Filtering on Aliases in the user interface is not supported in this release.

    When you filter on names in assignment rules, matching is performed on both names and aliases.

  • 7113198 -- If you are using Firefox 2.0 as your browser, the cursor is not displayed in a number of locations on the screen, such as edit fields, name, description, and so on. This issue is fixed by using Firefox 3.0.

  • 6979777 -- It is possible to incorrectly import negative, empty, and duplicated order driver records using the import from the HPM_STG_DRIVER.

  • 6979576 -- The stage order is not correctly updated when using the import from the HPM_STG_STAGE table.

Tips and Troubleshooting

Web Services Sample Client and Readme

To assist you in creating your custom scripts, a Sample Client and Sample Client Readme are also included with the installation (%EPM_ORACLE_HOME%\products\Profitability\samples\wsclient).

The Sample Client File for Web Services displays the commands that can be used in your custom script for automating Profitability and Cost Management tasks, and identifies data within your Profitability and Cost Management model. The sample client file is intended as a guide only, to assist you in creating your custom scripts.

For information on each operation, and its input and output parameters, see the Oracle Hyperion Profitability and Cost Management Web Service API Reference - Profitability Services.

Running the defragment_ids.sql Script

If errors are generated for ID column values that run into negative values due to overflow in any of the Profitability and Cost Management tables, you must run a specific script to correct the situation. (See Defect `1704464 or 12704452) This is a release-specific script that scans all the tables in the Profitability and Cost Management product schema to defragment any sequence number loss. The file is available at %HYPERION_HOME%\products\Profitability\database\Common\Oracle.

Note:

This workaround is applicable only for an installation which has Profitability and Cost Management configured with an Oracle database.

See the following procedures:

Running the defragment_ids.sql Script

To run the defragment_ids.sql script:

  1. Stop all instances of the Profitability and Cost Management service: "Hyperion Profitability - Web Application."

  2. Perform a full system backup of the Profitability and Cost Management database schema.

    Caution!

    Oracle strongly recommends that you back up the database schema in case you need to roll back to the state that existed before the ID value defragmentation.

  3. From the command line, connect to the Profitability and Cost Management database, and then run the defragmentation SQL script, using the following command:

    sqlplus <user_name>/<password>@<SID> @defragment_ids.sql

    Caution!

    Wait for the SQL script to finish running before proceeding to the next step. If any errors are logged during execution, use the procedure, Backing Out the defragment_ids.sql Scriptand contact Oracle Support for further assistance.

  4. When the SQL script completes execution, start all instances of the Profitability and Cost Management service: "Hyperion Profitability - Web Application."

  5. Navigate through all screens in the Profitability and Cost Management application to verify if any errors are displayed when accessing the application.

  6. If any errors are discovered, back out of the changes made by the defragmentation script, as outlined in the procedure, Backing Out the defragment_ids.sql Script and contact Oracle Support for further assistance.

Backing Out the defragment_ids.sql Script

To back out the defragmentation script:

  1. Stop all instances of the Profitability and Cost Management service: "Hyperion Profitability - Web Application."

  2. Navigate to %HYPERION_HOME%\products\Profitability\database\Common\Oracle to locate the file, drop.sql.

  3. Run drop.sql on the Profitability and Cost Management database schema, using the following command:

    sqlplus <user_name>/<password>@<SID> @drop.sql

  4. Restore the database schema using the backup version created in Step 2 of the procedure, Running the defragment_ids.sql Script.

  5. Start all instances of the Profitability and Cost Management service: "Hyperion Profitability - Web Application."

  6. Navigate through all screens in the Profitability and Cost Management application to validate that your original database schema has been restored. Contact Support if additional assistance is required.

Entering Filters

For Standard Profitability only, when entering a search value in a filter, enter the entire string if the filters are UDA-based. Trailing wildcard symbols, such as asterisks (*) and question marks (?) are supported in assignment rule name and alias filters. For example, enter "B*" to filter members having names or aliases beginning with the letter "B". You cannot use "*B" as this means that the filter is beginning with a wildcard, which is not allowed.

For assignment rule filters:

  • Both the EQUAL and NOT EQUAL operations are currently supported to filter Names, Aliases and Attributes.

  • Only the EQUAL operation is currently supported for UDAs.

  • When "Name" is selected as the parameter, matching is performed on both names and aliases.

Setting the Hierarchy Type Property

The ‘Hierarchy Type’ property applies only to Aggregate Storage Databases in Essbase. (The Reporting Cube is generated by Profitability and Cost Management).

If a Dimension Hierarchy Type is set to “Stored” in Oracle Hyperion EPM Architect, all its members must have the consolidation set to “+ (addition)”. The only exception is if the Dimension root member has the “Data Storage (ASO)” set to “LabelOnly,” then generation 2 children of the root member which are not the first child can have the consolidation set to “~ (ignore)”, (for example, “NoMember”). Any dimension members that use a consolidation symbol other than ADDITION and IGNORE in the Stored hierarchy type (for example, - SUBTRACT) will cause error messages while generating the reporting cube.

To be able to use other consolidation type symbols (other than ADDITION and IGNORE) the hierarchy type should be set to “DYNAMIC”.

To set the hierarchy type:

  1. From Oracle Hyperion Enterprise Performance Management Workspace, select Navigate, then Administer, and then Dimension Library.

  2. Under the application, select Measures, and then UserDefinedDriverMeasures.

  3. In the Property Grid, select the appropriate Hierarchy Type property:

    • Select Stored for any dimension members that use the following consolidation symbols:

      • + ADDITION

      • ~ IGNORE (only underneath LABEL ONLY members.)

    • Select Dynamic for any business dimension that needs to use all supported consolidation symbols, or that has a formula.

  4. Redeploy the application to Profitability and Cost Management, and then Essbase.

Solving Issues with Profitability and Cost Management Connection Type

By default, Profitability and Cost Management uses “Embedded mode” to connect to Essbase. If you are using APS, the APS mode uses many TCP ports while deploying the Essbase cubes. This situation may cause a network error which is displayed in the Profitability and Cost Management log file.

Changing the Connection Type to Embedded Mode

If you receive a network error when using the APS Connection Type, switch the Connection Type to embedded mode, and redeploy the cube.

To set the Connection Type to Embedded mode:

  1. In Profitability and Cost Management, from Task Areas, select Manage Model, and then Model Summary.

  2. On the Model Summary screen, select the Model Level Preference tab.

  3. Under Essbase Information, select “embedded” f rom the Connection Type drop-down list.

  4. Click the Save icon.

If the cube deployment fails in embedded mode, or you have to use APS mode, you can modify the Windows registry TCPIP parameters - TcpTimedWaitDelay and MaxUserPort - as recommended by the Windows Operating System documentation.

Caution!

Before making any changes to the Windows Registry, consult the Microsoft Windows Operating System documentation for the correct settings and best practices to avoid any risk of corrupting the registry.

Setting the JVMOption for Embedded Connection Type

If you are experiencing difficulties using the ‘embedded’ Connection Type mode in Profitability and Cost Management to connect to Oracle Essbase (especially in distributed configurations), you must set the environment variable ESS_ES_HOME as a JVMOption for Oracle Hyperion Profitability and Cost Management to point to any local folder which contains two empty folders called “bin” and “data”.

  • If APS is installed on the system, set ESS_ES_HOME to the same value as the APS_HOME environment variable. (APS_HOME should have the required folder structure.)

  • If APS is not installed, set ESS_ES_HOME to any folder which contains empty ‘bin’ and ‘data’ folders.

    Note:

    No changes are required if you are using the ‘APS’ Connection Type mode.

To set the JVMOption for the Embedded Connection Type:

  1. Stop the Profitability and Cost Management server.

  2. Edit the Windows registry for HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Profitability0\HyS9HyS9PftWeb.

  3. Add a JVMOptionX (where X is the next integer, based on the existing number of JVMOptions). For example, if the current JVMOptionCount is set to decimal 17, then add JVMOption18.

  4. Set the string value for the new JVMOptionX to -DESS_ES_HOME= where folder name is the name of the folder that contains the empty “bin” and “data” folders.

  5. Increment the JVMOptionCount to the next integer. For example, if JVMOption18 is added, then set JVMOptionCount to decimal 18.

  6. Start the Profitability and Cost Management server.

Setting for High Rate of Network Connections for Windows

To improve the ability of the Windows operating system to deal with a high rate of network connections:

  1. From the Windows Registry, navigate to KEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TCPIP\Parameters.

  2. Add or modify the following registry entries:

    • TcpTimedWaitDelay - Set this to a low value (for example, 30) for the sockets to be released quickly. This DWORD value ranges between 30-300.

    • MaxUserPort - Set this to a high value (for example, 33000) to increase the total number of sockets that can be connected to the port. This is a DWORD value.

    Caution!

    Before modifying these parameters, refer to the Microsoft Windows operating system documentation for more details.

  3. Reboot the system for the changes to take effect.

Increasing Local Port Range for Linux

Caution!

Oracle recommends that only a system administrator who is very familiar with the system should make this change. The system administrator should consider all the effects on the Operating System before making this change.

To improve the ability of the Linux server to deal with a high number of outgoing network connections, increase the local port range:

  1. From a Linux shell, enter the following command to find the current range:

    $ sysctl net.ipv4.ip_local_port_range
    

    Sample Output:

    net.ipv4.ip_local_port_range = 32768    61000

    Note:

    The available parameters are listed under /proc/sys/. This option is only useful for high bandwidth, busy Linux servers or large scale grid servers.

  2. Set the new local range using one of the following commands:

    # echo 1024 65535 > /proc/sys/net/ipv4/ip_local_port_range

    OR

    $ sudo sysctl -w net.ipv4.ip_local_port_range="1024 64000"
  3. To permanently modify /proc filesystem (the local port range), edit the /etc/sysctl.conf file to append the following to your /etc/sysctl.conf file:

    # increase system IP port limits
    net.ipv4.ip_local_port_range = 1024 65535
    

Modifying Default Timeout Settings for Lifecycle Management

If you are using Lifecycle Management to import large models, the import may take longer to process than the time specified in the default timeout settings on the Oracle WebLogic Server. To work around this issue, you must reset the default timeout settings.

To modify the default timeout for WebLogic Server:

  1. Navigate to EPM_ORACLE_INSTANCE\httpConfig\OHS\ohs_component\mod_wl_ohs.conf.

  2. In the configuration file, locate the section LocationMatch/profitability, and add the line WLIOTimeoutSecs 3000, as shown below:

    SetHandler weblogic-handler

    PathTrim

    KeepAliveEnabled ON

    KeepAliveSecs 20

    WLIOTimeoutSecs 3000

    WeblogicCluster servername:6756

  3. Navigate to EPM_ORACLE_INSTANCE\httpConfig\OHS\ophs_component\htppd.conf

  4. Set Timeout to 3000, as shown in the following text:

    # Timeout: The number of seconds before receives and sends time out. Timeout 3000

    Note:

    The server timeout shown above is a suggested limit. Because timeout settings vary from application server to application server, refer to the timeout settings specific to your application server.

Accessing EPM System Product Documentation

The most recent version of each EPM System product guide is available for downloading or viewing from the EPM System Documentation area of the OTN Web site (http://www.oracle.com/technology/documentation/epm.html). You can also use the EPM System Documentation Portal (http://www.oracle.com/us/solutions/ent-performance-bi/technical-information-147174.html), which also links to EPM Supported Platform Matrices, My Oracle Support, and other information resources.

Deployment-related documentation is also available from the Oracle Software Delivery Cloud Web site (http://edelivery.oracle.com/EPD/WelcomePage/get_form).

Individual product guides are available for download on the Oracle Technology Network Web site only.

Copying and Pasting Code Snippets from PDFs

When you cut and paste code snippets from a PDF file, some characters can be lost during the paste operation, making the code snippet invalid. Workaround: Cut and paste from the HTML version of the document.

Accessibility Considerations

It is our goal to make Oracle products, services, and supporting documentation accessible to the disabled community. EPM System products support accessibility features, which are described in the product's Accessibility Guide. The most up-to-date version of this guide can be found in the Oracle Enterprise Performance Management System Documentation Library on the Oracle Technology Network (http://www.oracle.com/technology/documentation/epm.html).

In addition, this Readme file is accessible in HTML format.