Oracle Enterprise Performance Management System

Release 11.1.2.2.000 Patch Set Update (PSU): 11.1.2.2.500

Readme

 [NOTE TO WRITERS: Go to the File or Document properties and change the “title.” The correct entry for “Author” and “Company” are provided in the template.]

About this Patch. 2

Patch Type. 3

Supported Paths to this Patch. 3

Supported Platforms. 3

Supported Languages. 3

New Features. 3

Profitability and Cost Management 3

Shared Services. 5

Hyperion Planning. 5

Prerequisites. 5

Required Microsoft Patch. 5

Other Required Patches. 5

Required User Rights. 5

Applying this Patch. 6

Additional Steps for Hyperion Planning. 7

Additional Steps for Profitability and Cost Management 8

Additional Steps for Financial Data Quality Management 10

Additional Steps for Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications. 11

Additional Steps for Financial Close Management 12

Additional Steps for Oracle Hyperion Interactive Reporting. 15

Additional Step for IBM WebSphere Users. 15

Installing Oracle Hyperion Smart View for Office. 15

Installing the EPM Client Installers Patch Set Update (PSU) 18856417. 15

Installing Hyperion Strategic Finance Client 15

Installing Hyperion Financial Management Client 16

Rolling Back this Patch. 16

Additional Steps for Hyperion Planning. 17

Additional Steps for Financial Management 17

Additional Steps for Financial Data Quality Management 17

Additional Step for Financial Close Management 18

Additional Step for IBM WebSphere Users. 18

Troubleshooting FAQs. 18

Why do I get the following patch conflict error message when running OPatch?. 18

Why do I get the OUI-67078 warning message when applying OPatch?. 19

How can I find out which releases and patches of EPM System products are installed in a deployment?. 19

I applied the patch successfully, but I don’t see the changes from the patch in the product. What should I do?. 19

Opatch failed on Prerequisite check because LCMAMService-Client.jar is still active. 19

Failed to deploy SOA Composites by the script in post-installation step. 20

After Applying this Patch, New Features Do Not Display in Financial Close Management 20

Products Included in this Patch. 21

Oracle Hyperion Planning. 21

Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications. 24

Oracle Hyperion EPM Architect 25

Oracle Hyperion Enterprise Performance Management Workspace. 31

Oracle Hyperion Financial Reporting. 32

Oracle Hyperion Reporting and Analysis Framework. 33

Oracle Crystal Ball 33

Oracle Hyperion Strategic Finance. 33

Oracle Hyperion Profitability and Cost Management 34

Oracle Hyperion Web Analysis. 35

Oracle Hyperion Interactive Reporting. 35

Oracle Hyperion Financial Management 36

Oracle Hyperion Shared Services. 38

Oracle Hyperion Calculation Manager 39

Oracle Hyperion Financial Close Management 42

About this Patch

This cumulative patch set update includes previously released patches up to 11.1.2.2.500 (18659116).

This Readme describes the defects fixed in this patch and the requirements and instructions for applying this patch.

This document includes only the defects fixed and known issues between the last PSU on the PS2 code line and this one. For information about other defects fixed and known issues in interim PSUs, refer to individual product PSU readmes.

Caution: You are urged to carefully read and understand the following requirements. Failure to comply may result in applying a patch that can cause your application to malfunction, including interruption of service and/or loss of data. Before installing or applying this patch:

Verify that your system configuration (product version, patch level, and platform) exactly matches what is specified in the Readme.

Patch Type

This is a patch set update (PSU). This patch replaces files in the existing installation and does not require a full installation. This PSU is a standalone patch.

Supported Paths to this Patch

You can apply this patch to the following releases: 11.1.2.2.x (where x is less than .500).

Note: Data Relationship Manager, Hyperion Performance Scorecard, Disclosure Management, and Smart View are not part of this Patch Set Update.

Note: If you are upgrading from 11.1.2.2.000 in a UNIX deployment, and you have not manually updated <EPM_ORACLE_HOME>/products/financialreporting/lib/FOProcessor/xdo.cfg, then you must follow the steps below.

In <EPM_ORACLE_HOME>/products/financialreporting/lib/FOProcessor/xdo.cfg, make the following changes:

1.  Remove the line <property name="system-temp-dir">c:/temp</property>

2.    Delete the </font> tag at the end of the file.

3.    Save the updated xdo.cfg file.

4.    Run the Financial Reporting Print Server Utility in <EPM_ORACLE_HOME>/products/financialreporting/bin/FRPrintServerUtility.sh.

Supported Platforms

Applies to all supported platforms. For the Oracle Enterprise Performance Management System Supported Platform Matrix, go to:

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

Supported Languages

Information about supported languages is provided in the Oracle Enterprise Performance Management System Certification Matrix, Translation Support tab, available on OTN at the Oracle Fusion Middleware Supported System Configurations page:

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

New Features

Profitability and Cost Management

This patch introduces a new Web Service to support multi-POV calculations for Standard Profitability applications.

processMultiPOVCalcScripts

Use this operation to initiate the process and run calculation scripts for a selected Standard Profitability application for a selected range of POVs. The following actions relate to the check boxes on the Manage Calculation tab of the application:

·       Clear Calculated

·       Generate

·       Calculate

Note:

The operations will be performed for all the stages in the application.

Calculation scripts generated are distinct from the ones generated for a single POV from UI or Single Calc web service.

Generated calculation scripts will cover all members between starting POV group (startPovGrp) and ending POV group (endPovGrp).

Only one dimension can change between the starting and ending group. Users may have to issue more than one invocation if it is not possible to express all POVs using a single expression of the starting (startPovGrp) and ending Grp (endPovGrp).

Input Parameters

·       String applicationName: Name of the Standard Profitability and Cost Management application for which calculation scripts should be generated and executed, depending on the options selected.

·       MultiPOVCalcScriptOptionsDTO options: Selection details for processing calculation scripts.

Table 5. MultiPOVCalcScriptOptionsDTO

startPovGrp

Starting POV information for which calculation script generation and execution should be performed. See Table 2, POVMemberGroupDTO.

povDimensionMember1=2012

povDimensionMember2=March

povDimensionMember3=Actual

povState=Draft

endPovGrp

Ending POV information for which calculation script generation and execution should be performed. See Table 2, POVMemberGroupDTO.

povDimensionMember1=2012

povDimensionMember2=June

povDimensionMember3=Actual

povState=Draft

layerName

Layer name for which calculation scripts should be generated and executed. Valid values:

COST

REVENUE

COST

clearCalculatedData

Boolean flag specifying whether clear calculated data for all stages is desired

TRUE

saveScripts

Boolean flag specifying whether the generated calculation scripts should be saved

FALSE

Output Parameters

@return String: CES Task ID generated for this operation.

Note:

Use the getTaskflowStatusByProcessName operation to get the status of this CES taskflow name (as it is displayed on the Taskflow Status Summary).

Details

The processMultiPOVCalcScripts method takes in a range of POVs to do the calculation for all stages in the application. It clears all the calculated data (if clearCalculatedData flag is set to TRUE) and then generates and executes the calculation scripts for the POV range specified. The saveScripts flag determines whether the generated scripts are saved at the end of execution.

When the method is run the next time, the generated scripts will be cleared if they exist.

The scripts will have names as below:

·       mxxxd_kk.csc and zxxxd_kk.csc for interstage scripts for Cost and Revenue layers, respectively.

·       nxxxd_kk.csc and yxxxd_kk.csc for intrastage scripts for Cost and Revenue layers, respectively.

o   m and z are the suffixes indicating multi POV run for interstage scripts for Cost and Revenue layers respectively, and

o   n and y are the suffixes indicating multi POV run for intrastage scripts for Cost and Revenue layers, respectively

o   xxx are three digits for the root POV identifier

o   d is the stage order number, and

o   kk is the calculation script sequence number

Shared Services

You can now select and delete all taskflows listed on the Taskflows screen.

Hyperion Planning

Response time has improved for Hyperion Planning 11.1.2.2.500 functionality in a browser. The Hyperion Planning response time for functionality within a browser is faster in the 11.1.2.2.500 release. For example, the 11.1.2.2.500 end-to-end response times through the browser averaged 41% faster than 11.1.2.2.300, with up to 200 users on the system. Some actions, such as scrolling forms, completed 70% faster in 11.1.2.2.500.

Prerequisites

Required Microsoft Patch

Microsoft has identified a security issue that could compromise Windows-based systems. Before installing this patch, verify that the Visual C++ 2005 Redistributable Package installed on the computer is current. You may search and download the latest Visual C++ 2005 Redistributable Package from:

http://www.microsoft.com/en-us/download/default.aspx

Other Required Patches

Required User Rights

The user applying the patch should be the user who was set up to install and configure EPM System products. Required user privileges or rights:

Windows

Use the user account that has Local administrator rights and was set up for installation and configuration. This user is an administrator and is the same for all EPM System products. Assign local policies if required by the product. Such assignments typically are: “Act as part of the operating system, Bypass traverse checking, Log on as a batch job, Log on as a service.”

UNIX/Linux

Use the account that was used to install EPM System products and has Read, Write, and Execute permissions on $MIDDLEWARE_HOME. If you installed other Oracle products, the user who installed EPM System products must be in the same group as the user who installed the other Oracle products. OPatches are not intended to be applied using a root user.

Applying this Patch

This section includes important information about applying this patch for EPM System Portfolio.

·       For HP-IA64 and Solaris platforms, a workaround is required before applying the patch. Append the argument -d64 in the file <MIDDLEWARE_HOME>/oracle_common/oui/oraparam.ini to the JRE_MEMORY_OPTIONS property.

Example:

JRE_MEMORY_OPTIONS=" -mx512m -XX:MaxPermSize=256m -d64"

·       If IIS is on this system, and EPMA, HSF, HFM, or FDM is patched on the system, then: "Enable 32-Bit Application" property of IIS DefaultAppPool should be set to false on a 64-bit OS. And add LOCAL SERVICE and NETWORK SERVICE users to the "Bypass traverse checking" policy in Local Security Policy.

CAUTION: For all steps that involve the Arbortext website, use Internet Explorer as the browser.

 [NOTE TO WRITERS:  Make sure that instructions for applying the PATCH indicate specifically which components are being patched and which machines in a distributed installation should be patched. for example, “on the machine hosting the shared services web application, …”]

[NOTE TO WRITERS:  For web applications, make sure you provide instructions for all supported application servers.]

To apply this patch:

1.    On all machines where EPM 11.1.2.2.x software is running for this release, stop all processes.

2.    Back up your database.

Note: If Financial Close Management is in the deployment at release earlier than 11.1.2.2.353, a full system backup including the file system, is required because you cannot rollback this patch.

 

3.    Download OPatch to <EPM_ORACLE_HOME>/OPatch based on the OS of the machine where EPM 11.1.2.2 software is running. For example, for Windows 64: Download and unzip the downloaded patch file, 18659116_WIN64.zip, to the <EPM_ORACLE_HOME>/OPatch directory (by default, Oracle/Middleware/EPMSystem11R1/OPatch).

4.    NOTE: <PATCH FILE NAME>.zip is the name that My Oracle Support assigns to this patch. When you download the file, a message indicates the file name. Unzip the downloaded patch file, 18659116_WIN64.zip, to the <EPM_ORACLE_HOME>/OPatch directory.

5.    If the patch size is greater than 2 GB, use the jar --xvf <{RELEASE_ID}.zip> command to unzip/extract the patch.

6.    Rename the folder 18659116_WIN64 to 18659116 in the <EPM_ORACLE_HOME>/OPatch directory after unzip is completed successfully.

7.    On all machines where EPM 11.1.2.2 software is running for this release, from a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.

8.    To apply the patch, enter the following command on one line:

[NOTE TO WRITERS: very important! the jdk version in the apply command is different for 11.1.2.0, 11.1.2.1, and 11.1.2.2. change the jdk160_xx directory as follows:

11.1.2.3: JDK160_35

11.1.2.2: jdk160_29

11.1.2.1: jdk160_21

11.1.2.0: jdk160_11

The example here is for 11.1.2.2.

Windows:

opatch.bat apply <EPM_ORACLE_HOME>/OPatch/<PATCH DIRECTORY> -oh <EPM_ORACLE_HOME>

-jdk <MIDDLEWARE_HOME>/jdk160_29

Note: The default for <EPM_ORACLE_HOME> is C:/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:/Oracle/Middleware.

UNIX/Linux:

./opatch apply <EPM_ORACLE_HOME>/OPatch/<PATCH DIRECTORY> -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc

Note: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.

9.    For Planning and Calc Manager:

Delete the tmp directory for the Planning server and Calc Manager in: <MIDDLEWARE_HOME>/user_projects/domains/EPMSystem/servers/<server>

where <server> is the Planning server (for example, Planning0) or is Calc Manager <server> (for example, CalcMgr0).

The full path for tmp: <MIDDLEWARE_HOME>/user_projects/domains/EPMSystem/servers/<server>.

10. Restart all processes.

11. All users should now clear cached files from their browsers.

Additional Steps for Hyperion Planning

Defect 18650678 requires additional installation instructions after the patch has been applied.

Note: These steps are needed only for existing Project Financial Applications created before applying this patch.

Before doing these steps, create a backup of any business rules that you modified. Following these steps will reload the default business rules supplied with Project Financial Planning application, and any changes made to business rules will be lost.

1.    Log on to EPM Workspace.

2.    Select Administer, and then Calculation Manager.

3.    Expand Planning.

4.    From the list of applications, select the existing application, where this fix is required.

5.    Right-click the application, and then select Load Predefined Rules.

6.    Right-click application again, and then select Deploy.

Additional Steps for Profitability and Cost Management

After installing the patch, you must finalize the post-patch configuration, as described in the following procedure for Profitability.

1.    Back up your Profitability and Cost Management product schema.

2.    Run the appropriate database update patch script for your database type and release. Run each script from the Profitability and Cost Management product schema/user.

Release

Database Type

Database Patch Files

From Release

11.1.2.2.00

MSSQL Server

Apply the following patch scripts using MSSQL Server Management Studio:

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.300.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.301.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.350.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.351.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.353.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.500.sql

From Release

11.1.2.2.00

Oracle

Apply the following patch scripts using SQL Developer:

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.300.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.301.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.350.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.351.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.353.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.500.sql

From Release

11.1.2.2.300

MSSQL Server

Apply the following patch scripts using MSSQL Server Management Studio:

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.301.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.350.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.351.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.353.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.500.sql

From Release

11.1.2.2.300

Oracle

Apply the following patch scripts using SQL Developer:

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.301.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.350.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.351.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.353.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.500.sql

From Release

11.1.2.2.301

MSSQL Server

Apply the following patch scripts using MSSQL Server Management Studio:

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.350.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.351.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.353.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.500.sql

From Release

11.1.2.2.301

Oracle

Apply the following patch scripts using SQL Developer:

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.350.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.351.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.353.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.500.sql

From Release

11.1.2.2.350

MSSQL Server

Apply the following patch scripts using MSSQL Server Management Studio:

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.351.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.353.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.500.sql

From Release

11.1.2.2.350

Oracle

Apply the following patch scripts using SQL Developer:

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.351.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.353.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.500.sql

From Release

11.1.2.2.351 or

11.1.2.2.352

MSSQL Server

Apply the following patch scripts using MSSQL Server Management Studio:

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.353.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.500.sql

From Release

11.1.2.2.351 or

11.1.2.2.352

Oracle

Apply the following patch scripts using SQL Developer:

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.353.sql

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.500.sql

From Release

11.1.2.2.353

MSSQL Server

Apply the following patch scripts using MSSQL Server Management Studio:

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer/create_11.1.2.2.500.sql

From Release

11.1.2.2.353

Oracle

Apply the following patch scripts using SQL Developer:

·   %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle/create_11.1.2.2.500.sql

 

3.    Applying any Profitability and Cost Management Patch Set Update (PSU) resets the current security policy defined for the Profitability Web Service within Oracle Web Services Manager (OWSM). If web services are used, it is important to perform the web services security policy setup steps now. For instructions on setting up Web Services security policies, refer to the Oracle® Hyperion Profitability and Cost Management External Automation Processes Guide.

4.    Restart all processes.

5.    All users should now clear cached files from their browsers.

6.    Invoke Profitability and Cost Management, open an application, and check in the System Information tab under Model Summary to verify that the Schema Version is 1.06.

7.    Important: Reregister each of your Profitability and Cost Management applications using Application Library.

8.    If you already ran the create_staging.sql script in a previous release to create staging import tables, you must recreate the HPM_STG_ASSIGNMENT staging import table in the schema that you created for staging imports.

You can do so by dropping the HPM_STG_ASSIGNMENT table and then running the statements from the create_staging.sql script that are related to the HPM_STG_ASSIGNMENT table, or you can drop all of your HPM_STG% staging tables and rerun the entire create_staging.sql script. The script is in:

%EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer

%EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle

Additional Steps for Financial Data Quality Management

To add the HTTP Response header for IIS 7:

1.    Open IIS.

2.    Expand the server name in left pane: Expand Sites, then expand Default Website, and then select HyperionFDM.

3.    In the right pane, under IIS, double-click the HTTP Response Headers.

4.    On the right, under Actions, click Add.

5.    Add the new HTTP Response header name X-UA-Compatible and value IE=EmulateIE9.

6.    Save changes.

7.    Recycle the HyperionFDMAppPool application pool.

To add the HTTP Response header for IIS 6:

1.    Open IIS.

2.    Expand the server name in the left pane: expand Web Sites, then expand Default Web Site, and then select HyperionFDM.

3.    Right-click the HyperionFDM website, and then click Properties.

4.    Select the HTTP Headers tab.

5.    Under custom HTTP headers, click Add.

6.    Add the new HTTP Response header name X-UA-Compatible and value IE=EmulateIE9.

7.    Save changes.

8.    Recycle the HyperionFDMAppPool application pool.

Register New FDM DLL

1.    Open a command prompt and run the following commands if your server is 32-bit:

a.  %windir%/system32/regsvr32.exe /u
C:/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/SharedComponents/upsWAppMgrDM.dll

b.  %windir%/system32/regsvr32.exe
C:/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/SharedComponents/upsWAppMgrDM.dll

2.    Open a command prompt and run the following commands if your server is 64-bit:

a.  %windir%/SysWOW64/regsvr32.exe /u
C:/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/SharedComponents/upsWAppMgrDM.dll

b.  %windir%/SysWOW64/regsvr32.exe
C:/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/SharedComponents/upsWAppMgrDM.dll

Additional Steps for Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications

Back up your ERP Integrator product schema.

Update the database schema by completing these steps

1.    Run SQL commands

a.    For Oracle, run:
<EPM_ORACLE_HOME>/products/FinancialDataQuality/database/Common/Oracle/aif_objects_Oracle_TR_PS25.sql

b.    For SQL Server, run:
<EPM_ORACLE_HOME>/products/FinancialDataQuality/database/Common/MSSQLServer/aif_objects_MSSQLServer_TR_PS25.sql

Note: Ensure that the Batch separator is set to semicolon in Query Execution Option in the Options Menu in SQL Server Studio before running the script.

2.    Update the ODI Scenario

a.    Import the following projects from odi/11.1.2.2.00/workrep in INSERT_UPDATE mode:

- PROJ_AIF_File_Project.xml
- PROJ_JDE_Adapter_Project.xml

b.    Import all scenarios from odi/11.1.2.2.00/workrep in INSERT_UPDATE mode

Configuring Web Services Security

If you are upgrading from 11.1.2.2.000, run the OWSM configuration scripts. These steps are required only if the ERP Integrator is integrated with Account Reconciliation Manager (ARM), PeopleSoft Commitment Control, or Fusion Financials and have not applied 11.1.2.2.300.

1.    Ensure that the ERP Integrator patch has been applied and ERP Integrator is configured successfully.

2.    Ensure that the ERP Integrator and the WebLogic administration server are in running condition.

3.    Run the scripts from the server on which ERP Integrator is deployed. To run the scripts:

a.    Launch a command prompt on Windows.

b.    In UNIX/Linux, open a terminal shell.

4.    Navigate to <EPM_ORACLE_HOME>/products/FinancialDataQuality/bin.

5.    To configure ERP Integrator web services with ARM:

a.    Update wls-ARM.properties with the WebLogic administrator user name, password, and the administrator server URL.

b.    In Windows, run wlsConfigARM.bat, or, in UNIX/Linux, run wlsConfigARM.sh.

c.    Restart the ERP Integrator and WebLogic administration server.

6.    To configure ERP Integrator Web Services for PeopleSoft-Planning Integration and for Fusion Write-back:

a.    Update wls-infra.properties with the correct values.

b.    Make a backup of the existing aif.ear file from the InstallableApps folder.

c.    In Windows, run wlsConfigMDS.bat, or, in UNIX/Linux, run wlsConfigMDS.sh.

7.    Restart the ERP Integrator Server.

In Windows, run wlsCOnfigOWSM.bat, or, in UNIX/Linux, run wlsCOnfigOWSM.sh.

8.    Restart ERPI and the WebLogic administration server.

Additional Steps for Financial Close Management

Note: DO NOT perform steps 4, 5, 6, and 7 if you are applying the patch on 11.1.2.2.353.

Note: DO NOT perform step 6 if you are applying the patch on 11.1.2.2.350/11.1.2.2.351/11.1.2.2.352.

1.    At this point, you should have just run Opatch, and all the servers are still shut down. If not, shut them down now.

2.    Start Admin Server, Foundation Services Managed Server, and SOA managed server.

3.    Wait for SOA Managed Server to be up and running.

4.    On the Financial Close Management Managed server, open the command-line window.

5.    Set the environment variables:

Windows:

Set the EPM_ORACLE_INSTANCE environment variable by running the below command in the command line. Ensure that there is no space before and after =.

set EPM_ORACLE_INSTANCE=<MIDDLEWARE_HOME>/user_projects/<INSTANCE_NAME>

Example:

set EPM_ORACLE_INSTANCE=C:/Oracle/Middleware/user_projects/epmsystem1

UNIX/Linux:

a.    Set the EPM_ORACLE_HOME environment variable by running the below command in the command line based on shell.

setenv EPM_ORACLE_HOME <MIDDLEWARE_HOME>/EPMSystem11R1

          or

export EPM_ORACLE_HOME=<MIDDLEWARE_HOME>/EPMSystem11R1

Example:

setenv EPM_ORACLE_HOME /Oracle/Middleware/EPMSystem11R1

b.    Set the EPM_ORACLE_INSTANCE environment variable by running the below command in the command line based on shell.

setenv EPM_ORACLE_INSTANCE <MIDDLEWARE_HOME>/user_projects/<INSTANCE_NAME>

          or

export EPM_ORACLE_INSTANCE=/Oracle/Middleware/user_projects/<INSTANCE_NAME>

Example:

setenv EPM_ORACLE_INSTANCE /Oracle/Middleware/user_projects/epmsystem1

6.    Perform the below steps (6a through 6d) to set configure Logical Address for Web Applications:

a.    Run EPM System Configurator: Select Programs, then Oracle EPM System, then Foundation Services, and then EPM System Configurator.

b.    Clear all the nodes, and then, under Hyperion Foundation, select "Configure Logical Address for Web Applications."

c.    Verify that the host and port for Financial Close and Account Reconciliation Manager are set with your load balancer server’s host and port (if you use a load balancer; for example, OHS, IIS, or external load balancer).

If no change is made, click Cancel to exit the EPM System Configurator; otherwise, click Next, and then Finish to complete the configuration changes.

7.    Run the database and SOA Deployment script

NOTE: Make sure that no errors are displayed in the command window after executing the FCMPS2500 script. If there are errors, go to the Troubleshooting section below before contacting Oracle Support.

In the same command-line window, change the directory to <EPM_ORACLE_HOME>/products/FinancialCloseManagement-Common/scripts

Windows:

Run FCMPS2500.bat

Linux:

Run FCMPS2500.sh

8.    Start Financial Close Managed Server.

9.    After the patch has been applied, confirm the environment is running properly:

Windows:

Go to Start, then Programs, then EPM System, then Foundation Services, then epmsystem1, and then EPM System Diagnostic.

Linux:

Run this command: <MIDDLEWARE_HOME>/user_projects/<INSTANCE_NAME>/bin/validate.sh

10. All tests should display PASSED.

11. Validate the Financial Close Management Configuration.

a.    Launch the Financial Close Management validation tool from a web browser using this URL:

http://<FCMHOST>:<FCMPORT>/fcc/faces/oracle/apps/epm/fcc/ui/page/FCCValidation.jspx

where FCMHOST is the name of the machine where the FinancialClose0 managed server is configured

where FCMPORT is the Listening port of the FinancialClose0 managed server in the WebLogic console

The default FCMPORT is 8700.

b.    Log in with Financial Close administrator credentials.

c.    To validate the Close Manager configuration, click Validate Financial Close Manager Configuration.

All results should be marked with check marks instead of an X.

d.    To run validate the test schedule, click Validate Test Schedule.

All results should be marked with check marks instead of an X.

12. Validate the Account Reconciliation Manager Configuration.

Launch the Account Reconciliation Manager validation tool from a web browser using this URL:

http://<FCMHOST>:<FCMPORT>/arm/faces/oracle/apps/epm/arm/ui/page/common/ARMValidation.jspx

Where FCMHOST is the name of the machine where the FinancialClose0 managed server is configured.

Where FCMPORT is Listening port of FinancialClose0 managed Server in the WebLogic console.

The default FCMPORT is 8700.

13. Log in with Account Reconciliation Manager administrator credentials.

To validate the account reconciliation manager configuration, click Validate Account Reconciliation Manager Configuration.

All results should be marked with checkmarks instead of an X.

To run validate the test schedule, click Validate Test Scheduler.

All results should be marked with check marks instead of an X.

14. All users should now clear cached files from their browsers.

Additional Steps for Oracle Hyperion Interactive Reporting

After you deploy Opack to the PS2 install area, you must run the following:

1.    Copy the folder <EPM_ORACLE_HOME>/products/biplus/InstallableApps/raframework/zeroadmin/component/
Insight
to
<EPM_ORACLE_INSTANCE>/ReportingAnalysis/RAFrameworkWebapp/zeroadmin/component/
Insight
.

2.    Ensure that both Insight folders contain updated Opack contents.

3.    Restart all services.

Additional Step for IBM WebSphere Users

Run manual web applications redeployment from the WebSphere Integrated Console as described in the Oracle Enterprise Performance Management System Installation and Configuration Guide.

 

Installing Oracle Hyperion Smart View for Office

Smart View is no longer packaged with Workspace or the EPM common installer. You must download the latest Smart View installation file from Oracle Technology Network or My Oracle Support. Note that Oracle provides a single Smart View installation file for both 64-bit and 32-bit Office systems, Smart View.exe.

Installing the EPM Client Installers Patch Set Update (PSU) 18856417

Installing Hyperion Strategic Finance Client

You must remove any existing Hyperion Strategic Finance Client installations before running the new Hyperion Strategic Finance Client installer.

For Hyperion Strategic Finance, when running the client installer on Windows 7 and Windows 8 machines, you must either run the installer using the "Run as administrator" option or set the User Account Control setting to "Never Notify" before running the installer. Note: when changing the User Account Control setting, you must reboot the machine for the changed setting to take effect.

Installing Hyperion Financial Management Client

You must remove any existing Hyperion Financial Management Client installations before running the new Hyperion Financial Management Client installer.

For Hyperion Financial Management, when running the client installer on Windows 7 and Windows 8 machines, you must either run the installer using the "Run as administrator" option or set the User Account Control setting to "Never Notify" before running the installer. Note: when changing the User Account Control setting, you must reboot the machine for the changed setting to take effect.

 

Rolling Back this Patch

To roll back a patch:

1.    On all machines where EPM 11.1.2.2.500 software is running, stop all processes.

2.    Back up your database

Note: You cannot roll back this patch if your deployment includes Financial Close
Management prior to release 11.1.2.2.353.  Instead, you must restore your
deployment from backup.  

3.    From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch (by default, Oracle/Middleware/EPMSystem11R1/OPatch).

[NOTE TO WRITERS: very important! the jdk version in the apply command is different for 11.1.2.0, 11.1.2.1, 11.1.2.2, and 11.1.2.3. change the jdk160_xx directory as follows:

11.1.2.3: JDK160_35

11.1.2.2: jdk160_29

11.1.2.1: jdk160_21

11.1.2.0: jdk160_11

The example here is for 11.1.2.2.

4.    To roll back the patch, enter the following command on one line:

Windows:

opatch.bat rollback -id <PATCH ID> -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29

Note: The default for <EPM_ORACLE_HOME> is C:/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:/Oracle/Middleware.

UNIX/Linux:

./opatch rollback -id <PATCH ID> -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME> /jdk160_29 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc

Note: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.

For Profitability and Cost Management, if you have already run the create_11.1.2.2.*.sql scripts, you must restore your Profitability and Cost Management product schema from a backup taken before running that script.

For ERP Integrator, if you have already run the aif_objects.sql script, you must restore your ERP Integrator product schema from a backup taken before running that script.

5.    For Planning and Calc Manager:

Delete the tmp directory for the Planning server and Calc Manager in: <MIDDLEWARE_HOME>/user_projects/domains/EPMSystem/servers/<server>

where <server> is the Planning server (for example, Planning0) or is the Calc Manager server (for example, CalcMgr0).

The full path for tmp: <MIDDLEWARE_HOME>/user_projects/domains/EPMSystem/servers/<server>.

6.    Restart all processes.

7.    All users should now clear cached files from their browsers.

Additional Steps for Hyperion Planning

Note: If you installed 11.1.2.2.500 on 11.1.2.2.30x and roll back 11.1.2.2.500, you will be required to manually reapply ADF patches 13952743 and 14339256 for 11.1.2.2.300 and ADF patch 16763038 for 11.1.2.2.304. These ADF patches are available from My Oracle Support.

Additional Steps for Financial Management

Note: If you installed 11.1.2.2.500 on 11.1.2.2.30x and roll back 11.1.2.2.500, you will be required to manually reapply ADF patches 13952743 and 14263103. These ADF patches are available from My Oracle Support.

Additional Steps for Financial Data Quality Management

To remove the HTTP Response header for IIS 7:

1.    Open IIS.

Expand the server name in left pane: Expand Sites, then expand Default Website, and then select HyperionFDM.

In the right pane, under IIS, double-click the HTTP Response Headers.

2.    Select "X-UA-Compatible: IE=EmulateIE9".

3.    On the right side, click Remove under Actions.

4.    Save the changes.

5.    Recycle the HyperionFDMAppPool application pool.

 

To remove the HTTP Response header for IIS 6:

1.    Open IIS.

Expand the server name in the left pane: expand Web Sites, then expand Default Web Site, and then select HyperionFDM.

2.    Right-click the HyperionFDM website, and then click Properties.

3.    Select the HTTP Headers tab.

4.    Under custom HTTP headers, select "X-UA-Compatible: IE=EmulateIE9," and then click Remove.

5.    Save the changes.

6.    Recycle the HyperionFDMAppPool application pool.

 

Register FDM DLL:

Open a command prompt and run the following commands if your server is 32-bit:

1.  %windir%/system32/regsvr32.exe /u

C:/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/SharedComponents/upsWAppMgrDM.dll

2.  %windir%/system32/regsvr32.exe

C:/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/SharedComponents/upsWAppMgrDM.dll

Open a command prompt and run the following commands if your server is 64-bit:

1.  %windir%/SysWOW64/regsvr32.exe /u

C:/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/SharedComponents/upsWAppMgrDM.dll

2.  %windir%/SysWOW64/regsvr32.exe

C:/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/SharedComponents/upsWAppMgrDM.dll

 

Additional Step for Financial Close Management

Note: EPM system deployments that include Financial Close Manager prior to 11.1.2.2.353 (patch #17473661) will not support rollback for any EPM products. Back up your entire system and restore from backup if needed.

Additional Step for IBM WebSphere Users

Run manual web applications redeployment from the WebSphere Integrated Console as described in the Oracle Enterprise Performance Management System Installation and Configuration Guide.

[NOTE TO WRITERS: IF THIS PATCH INCLUDES CHANGES TO A JAVASCRIPT FILE, YOU NEED TO INCLUDE THE STEP ABOVE AS A FINAL STEP. IF IT DOESN’T, DELETE THIS STEP.]

Troubleshooting FAQs

Why do I get the following patch conflict error message when running OPatch?

If the patch that you apply conflicts with a previously applied patch, you may receive the following error message when running OPatch:

Patch(es) <PreviousPatch#> conflict with the patch currently being installed (<NewPatch#>).

If you continue, patch(es) <PreviousPatch#> will be rolled back and the new patch (<NewPatch#>) will be installed.

If a merge of the new patch (<NewPatch#>) and the conflicting patch(es) (<PreviousPatch#>) is required, contact Oracle Support Services and request a Merged patch.

This error is returned when one patch attempts to update a previously patched file. When this conflict happens, you can either (1) roll back the previous patch and apply the new patch (this action might be appropriate if the previous patch was not critical) or (2) request a “merged patch” consisting of the new patch and the patch that it conflicts with. To request a merged patch, contact your Oracle Support representative.

Why do I get the OUI-67078 warning message when applying OPatch?

This warning means that the patch being applied is a superset of a patch already on the deployment, and the existing patch will be rolled back. The following snippet shows the context of this warning:

The following warnings have occurred during OPatch execution:

1) OUI-67078:Interim patch 12345678 is a superset of the patch(es) [77777777] in OH C:/Hyperion

-----------------------------------------------------------------------------------

OPatch Session completed with warnings.

How can I find out which releases and patches of EPM System products are installed in a deployment?

In EPM System Release 11.x, you can use the lsinventory command to OPatch to find the release and patches that are installed in an Oracle Home. For example, enter the following command on one line:

[NOTE TO WRITERS: very important! the jdk version in the apply command is different for 11.1.2.0, 11.1.2.1, and 11.1.2.2. change the jdk160_xx directory as follows:

11.1.2.2: jdk160_29

11.1.2.1: jdk160_21

11.1.2.0: jdk160_11

The example here is for 11.1.2.2.

Windows:

opatch.bat lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29

UNIX/Linux:

./opatch lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29 –invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc

I applied the patch successfully, but I don’t see the changes from the patch in the product. What should I do?

When patching an .ear file for an application, you may need to delete the cached files in the following folders to see the changes provided with the patch:

<MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/

<MANAGED_SERVER_NAME/tmp/

<MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/

<MANAGED_SERVER_NAME/cache

Opatch failed on Prerequisite check because LCMAMService-Client.jar is still active.

When Opatch is applied, and Opatch checks the prerequisites, if you see the following error message:

Running prerequisite checks...

Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

 

Following files are active :

C:/Oracle/Middleware/EPMSystem11R1/common/FCMProxy/11.1.2.0/LCMAMService-Client.jar

ApplySession failed during prerequisite checks: Prerequisite check "CheckActiveFilesAndExecutables" failed.

System intact, OPatch will not attempt to restore the system

 

1.    Verify that Shared Services is stopped and wait for 10 minutes, and then try to run OPatch again.

2.    If you still get the same error, run a free utility from Microsoft called Process Explorer to detect the process holding local files.

>To run Process Explorer:

1.    Download and extract the ZIP to a directory:

http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx

2.    Launch procexp.exe.

3.    Accept the agreement message from Microsoft (first time only).

4.    When Process Explorer is launched:

a.    Navigate to View, and then Show Lower Pane.

b.    Navigate to View Menu, then Lower Pane View, and then Handles.

5.    To find which process is holding LCMAMSERVICE-CLIENT.JAR:

a.    Click Find, and then Find Handle or DLL.

b.    Mention LCMAMSERVICE-CLIENT.JAR in the Handle or DLL substring box.

c.    Click Search, which lists the processes.

Failed to deploy SOA Composites by the script in post-installation step

If you see errors related to SOA composite deployment failure when running FCMPS2500.bat/sh (usually it will be shown as 'Failed to deploy FCCXXXComposite or ARMXXXComposite' under the section Retire and Deploy CM SOA Composites/Retire and Deploy ARM SOA Composites) in FCMPS2500.log located at <EPM_ORACLE_HOME>/products/FinancialCloseManagement-Common/scripts.

1.    Fix the reason behind the error. For example, check whether the SOA server and admin server are up and running.

2.    Set the environment variables as stated in Step 5 of Post Installation Steps Section.

3.  In the same command-line window, change the directory to <EPM_ORACLE_HOME>/products/ FinancialCloseManagement-Common/scripts.

4.    Run FCMPS2500.bat/sh after setting the necessary environment variables.

After Applying this Patch, New Features Do Not Display in Financial Close Management

In some cases, the user interface may not reflect the new code applied by this patch.

To confirm that this is not an issue:

·       For Account Reconciliation Manager, the Account Reconciliation Manager Validation Tool should display the build version as 11.1.2.2.500.XXXX. See step 12 of the Post-Installation Steps to launch the Validation Tool.

·       For Close Manager, the Financial Close Management Validation Tool should display the build version as 11.1.2.2.500.XXXX. See step 11 of the Post-Installation Steps to launch the Validation Tool.

If the build version does not display as 11.1.2.2.500.XXXX, follow these steps to force the user interface to display the new code by forcing WebLogic to check for JSP pages:

1.    Open the WebLogic Administration Console (http://<SERVER>:<PORT>/console).

2.    Go to Home, and then Deployments.

3.    Expand Financial Close under deployments, select fcc, and then select the Configuration tab.

4.    Update JSP Page Check (in seconds) to a non-negative number (for example, 1).

5.    Save to update the deployment plan.

6.    After saving, set the JSP Page Check (in seconds) to the original value (for example, -1).

Note: If you do not reset the value to -1, you may experience WebLogic performance issues.

7.    Save again.

Products Included in this Patch

Note: This document includes only the defects fixed and known issues between the last PSU on the PS2 code line and this one. For information about other defects fixed and known issues in interim PSUs, refer to individual product PSU readmes.

Oracle Hyperion Planning

Defects Fixed in this Patch

Defect Number

Defect Fixed

·   18529305, 18117701

When using member selector to select members, not all members selected from the member list are added to the right pane of member selection.

·   13714769

If a data validation rule defined on a web form fails during PU approval process, the task list report generated for failed PU promote process may display LABEL_PM_VALIDATION_REPORT_DEFAULT_PAGE instead of the form name.

·   18529423

If a large number of entity members are defined in the Planning Unit definition, searching for entity member in assign owners tab may result in an error.

·   18439149, 18146910

Data Validation Message pane shows up blank in forms that contain "run on save" rules.

·   18405433

Cells containing supporting detail are not indicated for Read Only users.

·   18297128, 18061470

As a planner user, expanding task lists may not work after user has navigated to another page in Planning web.

·   18297102, 17713202

17567857

Financial report gets opened twice if it is launched through Planning task list.

·   18297072, 17987358

When trying to save data in Composite Forms, you may encounter an ArrayIndexOutOfBounds Error.

·   18282388

When using Firefox 10, if a web form contains text data type members, the row headers do not align with the data grid.

·   18259065

When retrieving data through Smart View Ad-Hoc Analysis, any number of rows or columns is retrieved, regardless of the preferences that were set.

After applying this patch, you must set the ERROR_THRESHOLD_NUM_OF_CELLS property on the Administrator > Application > Properties screen. The value for this property is the maximum number of cells for which the error message is displayed during Ad Hoc Grid operation.

Note 1: This fix applies to Planning data simple forms, Smart View Ad Hoc, and Financial Reports against the Planning application.

Note 2: Unless overridden, the default value of the ERROR_THRESHOLD_NUM_OF_CELLS property is 250,000 cells.

·   18650678

Some business rules in Project Financial Planning application do not honor approval process security, and users can launch these rules even if they are not current owners of the Planning unit.

Note: Refer post installation steps for upgrading Project Financial applications created before applying this patch.

·   18284950

Smart Lists defined on Planning data forms may not auto fill selection when user enters first character of available Smart List values in non-ADF mode.

·   18232514

Smart Lists defined on Planning data forms may not display drop down in non-ADF mode.

·   17973442

Using the Outline load utility, if you export the dimensions where member alias or description contains a comma, editing such export files using Microsoft Excel may not work.

·   16700904

Rearranging selected members in member selector may not work.

·   16207758,

·   16899231

The scroll bar for task instructions is not displayed for tasks with long instructions.

·   18145947

You may not be able to enter text type data in Planning web form when accessed through Internet Explorer 8.

·   17256142, 17262700

Planning data form does not display data values with full precision when you click a data cell.

Known Issues in this Patch

The following issues are the noteworthy known issues of this patch.

Defect Number

Issue

·   18620222

If you are using Internet Explorer 10 on the Microsoft Windows 8 platform, invoking a dialog box from Planning web might make the UI very slow to respond; update your Internet Explorer version to 10.0.9200.16863 or later to resolve.

·   18311348

When entering runtime prompts in the business rule runtime prompt window, you might receive the following message while using Internet Explorer 10: "To display the webpage again, the web browser needs to resend the information you have previously submitted." Click Cancel when this message is displayed, and enter the prompt value again.

·   18338153

If a Planning data form has multiple formula rows with repeating formula labels defined for them, toolbar buttons may become unresponsive as you scroll through the data form.

·   17984046

When logged in as an Ad Hoc user and selecting Analyze on a Planning web data form, you cannot save data or edit, because the toolbar is not available. Workaround: Press Ctrl+S to save the data when analyzing, or save it as new ad hoc grid using the save button at the bottom of the page, and then reopen this ad hoc grid to enable the toolbar and perform edit operations.

·   17500823

In Smart View, when running a business rule that is created for Workforce plan type and contains runtime prompts, you can select members from both Workforce and Capital Assets plan types.

·   16845918

In Position only Budget Detail, when calculate compensation budget is run from a task list, the Decision Package total is not updated.

·   14822095

The member name displays in Copy Version instead of alias.

·   14548188

Project Financial Planning users may receive a "No planning unit matches the filter criteria" message and be unable to display and access planning units using Manage Approvals as expected.

·   14547372

Project Financial Planning users may find that some unit prices are displayed without their unit numbers on the Revenue Assumptions page.

·   14536175

If Smart View is on a locale not supported by Planning, then messages returned by Planning are in the Planning server locale instead of English.

·   14464462

If you open a Planning Ad hoc grid in Smart View, and are on a Chinese or Japanese locale, you may receive an "Ad hoc grid cannot be opened as there are no valid rows of data" error.

·   18873435

Data form decimal precision settings are lost when you click read-only values, and it starts to show complete decimal values entered.

·   18866014

With Internet Explorer 10, Manage Task Lists page is Missing the Security Icon. Workaround: Use Menu drop down list Actions > Assign Access

·   18772756

If the suppress missing blocks option is enabled on data form, and if changing page members in a grid results in varying size in grid, no error message is displayed if the grid size exceeds the threshold limit defined.

 

Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications

Defects Fixed in this Patch

Defect Number

Defect Fixed

• 18491966

When running an EBS data load in Snapshot mode, in some cases, delta changes are not imported. To identify these issues, create a trial balance report with control totals to compare with the source system control totals.

• 17785227

Drill-down from Smart View does not work if you are not logged in to Workspace.

Known Issues in this Patch

[NOTE TO WRITERS: This section is required.  If the patch doesn’t have any known issues, INCLUDE THIS SENTENCE.] 

 [NOTE TO WRITERS: Per Legal: This sentence must be included IF THERE ARE KNOWN ISSUES.]

The following issues are the noteworthy known issues of this patch.

Defect Number

Issue

·   13831793

The number format is not locale-sensitive in the Japanese version, because there is no decimal for Japanese currency.

·   13821445

The "Total number of rows imported" message is incorrect after a data load mapping import.

·   13775349

Oracle Essbase applications should be fully functional after upgrade. If you are upgrading from 11.1.1.3 and use an Essbase application, go to the Target Application page and select Refresh Metadata for each Essbase application before using it.

·   13743427

The target account is not displayed for data load mappings in Edit mode. Workaround: Change the target member by clicking Edit next to the source, and then update the target in the Multi-Dimension window.

·   13567704

Export mapping does not work when ERP Integrator and ODI run on different operating systems.

·   13558551

You cannot select the Accounting Entity when ERP Integrator is deployed on the WebSphere Application Server. Workaround: Create an accounting entity group for the source system, and then select the accounting entity on the Entity tab.

·   13520277

ERP Integrator is not accessible after the first startup of ERP Integrator when deployed on the WebSphere Application Server. Workaround: Restart the ERP Integrator Server.

·   13502900

You cannot click and make selections from drop-down lists in the Multi-Dimension window. Workaround: Use keyboard arrow keys to select items.

·   13414983

You cannot load metadata when a prefix or suffix is added to a source member. This issue affects only PeopleSoft Spring Trees (that is, ChartField members are participating as parents in the hierarchy). Workaround: Do not use a member prefix or suffix, or a parent member prefix or suffix, on dimensions where the user has selected a PeopleSoft Spring Tree in the Metadata mapping.

·   13104202

Write-back fails for an EPMA deployed ASO Oracle Essbase application.

·   13087477

The source system initialize fails to update the language column in the source system when run the first time after an agent start. Workaround: Rerun the load.

Oracle Hyperion EPM Architect

Defects Fixed in this Patch

Defect Number

Defect Fixed

• 18381604

When Shared dimensions have an association and the Base dimension is made Local, associated property values in the Base dimension are lost.

• 18825512

In an application, if a dimension has a shared member that precedes the primary member, EPM Architect deployment should be allowed for Financial Management, allowed with warning for Hyperion Planning and Essbase BSO; and not allowed with validation error in case of Essbase ASO.

• 18364272

Hyperion Shared Service permissions are checked for EPM Architect applications using "contains" instead of "is equal to" operator thereby causing user provisioning related failures while performing tasks.

• 18364297

Hyperion Planning generic dimension member has TwoPassCalc property missing in EPM Architect.

• 18381522

Different letter case (uppercase and lowercase letters) of parameter names in SQL strings, and their values, causes Duplicate Application action to fail with the error: "Must declare the scalar variable."

• 18364280

The data synchronization step in Task flow remains in active status if it becomes Completed with Errors; it should continue with the next step instead.

• 18364304

Lifecycle Management exports dimension association property label instead of name, causing dynamic dimension association creation failure upon import.

• 18364320

Importing dimensions into the Shared library creates a dimension association between the imported dimensions that does not exist in the source ADS file

• 18465063

Oracle Access Manager version 11g has logon redirect, and EPM Architect Batch client must be modified to support it (to retrieve the SSO Token based on redirection).

• 18381564

Lifecycle Management import fails if null is used as member property value; blank string ("") should be used instead.

• 18251441

You cannot log in to the Batch Client if the password contains an exclamation (!) or ampersand (@) character.

• 16180061

In the Italian locale, three Task Flow actions (Import Dimension from flat file, Import Dimension from Interface tables, and Profitability Redeploy) are missing. Workaround:

1. Apply EPM Architect 11.1.2.2.500 Opatch.

2. Stop EPM Architect services.

3. Copy 16180061.bat from OPatch/18659116/files/products/Foundation/BPMA to <EPM_ORACLE_INSTANCE>/bin. (The default directory for <EPM_ORACLE_INSTANCE> is C:\Oracle\Middleware\user_projects\epmsystem1).

4. From the command line, go to <EPM_ORACLE_INSTANCE>/bin.

5. Run 16180061.bat.

Known Issues in this Patch

The following issues are the noteworthy known issues of this patch.

Defect Number

Issue

• 11924751

When you share a Planning attribute dimension, the members may lose the shared values.

• 17580481

When you set up the Holding Company property for an entity member (for example, Entity1), you can select the same entity member (Entity1) as the Holding Company property. That is, you can set up the entity incorrectly as its own holding company.

• 9446072

When you run EPM System Configurator for Performance Management Architect database and interface data source configuration, if you are using an SQL Server named instance, you must specify a fixed port.

• 10033681

When creating a multicurrency Planning application using the Performance Management Architect Application Wizard, there are only 13 currencies available to be used as the default currency. However, when creating an application using the Planning Application Wizard, more than 150 currencies are available. The same currencies should be available in the Performance Management Architect Application Wizard.

• 13770092

In a Linux environment, you cannot run the Batch Client from a location different from the one that contains the empa-batch-client.sh file. Workaround: Update ciclos.sh as follows: "cd/scratch/aime/Oracle/Middleware/EPMSystem11R1/products/Foundation/BPMA/EPMABatchClient/ sh epma-batch-client.sh".

• 13742698

The Dimension Server may fail to start when you try to connect to DB2 in Secure Sockets Layer (SSL) mode.

• 13473968

Data synchronization validation may fail if you are using non-ASCII member names.

• 13622511

After performing a schema upgrade from 11.1.1.3 to 11.1.2.2.000, in which the 11.1.2.2.000 upgrade exists separately from 11.1.1.3, when you validate an Essbase aggregate storage (ASO) or a Hyperion Profitability and Cost Management application, you may receive a validation warning message letting you know that the default values for some members' properties have changed. Run a CompareTODeployedApplication task so you know which members' properties have changed. When you run this task, the changed properties found may differ from the changed properties shown in the validation warning message.

• 12731406

If you run the Batch Client in a Unix or Linux environment, you may receive the error, "ERROR .HYPERION.<Machine Name> does not exist". Workaround: Create a file with the name hyperion.<Machine Name> in the path where the Batch Client is being run, and add the EPM_ORACLE_HOME path variable and its value (for example, EPM_ORACLE_HOME=/scratch/oracle11/Middleware/EPMSystem11R1).

• 16984252

In Dimension Library, if you create a Hyperion Planning member with the percent character (%) in it, the character is redisplayed as ü. Workaround: Rename the member to get back the percent (%) character; further member name gets displayed correctly in Hyperion Planning after deployment.

• 14731832

In 64-bit Microsoft Excel; File generator fails with the error: "Compile error in hidden module; frmFlatFileGeneration".

• 17400451

User with either Create Integrations or Run Integrations role can view, modify, copy, delete dimensions, view other users’ jobs, and delete them.

• 14731832

In Dimension Library, expand two member trees, select the base member of the second tree, and left-click the first member tree to collapse and select it; now the second tree’s base member is still not unselected, and its properties are loaded in the property grid editor.

• 16085631

File generator does not write the dimension association if property value to base member relation does not exist between associated dimensions. Workaround: Use LCM instead of File generator or create one property value to base member relation between associated dimensions.

• 13737561

If you try to convert a local account dimension to a shared dimension using either merge or replace mode, you may receive a warning message, the conversion may stop abnormally, and the local account dimension may not be converted into a shared dimension.

• 13865990

In a Unix or Linux environment, when you perform data synchronization between Essbase aggregate storage applications or between an Essbase aggregate storage and an Essbase block storage application, the data synchronization runs successfully, and data is copied successfully, but some decimal values may be added to whole numbers.

• 13772846

After performing a schema upgrade from 11.1.1.3 to 11.1.2.2.000, in which the 11.1.2.2.000 upgrade exists separately from 11.1.1.3, when you run a CompareTODeployedApplication task, results may indicate that Financial Management custom Account members have property differences (for example, Custom Top Member and Enable Custom Aggregation), although there are no property differences.

• 13850698

The installer may not create the full set of Performance Management Architect folders for data synchronization debug files when the debug feature is enabled in a Linux environment.

• 12661080

Data Synchronization may fail when you use an Essbase block storage or Profitability and Cost Management application as the source application in a Linux or Unix environment.

• 12991606

Data Synchronization may be successful even though the interface table or flat file has invalid members. The synchronization process should show the invalid members in the log, and should state that the synchronization is successful with errors when loading data via interface table.

• 13731838

If a Data Relationship Management export fails because of validation errors in Oracle Hyperion Data Relationship Management, an error message should be displayed in the Performance Management Architect Job Console.

• 8254818

In a Turkish operating environment, you may be unable to use a right-click to deploy a Oracle Hyperion Capital Asset Planning application.

• 7675626

None of the following pages and text is localized into German, Danish, and Turkish languages, but display in English instead: 1) On the Job Console page, the description and type columns are not localized. 2) On the Job Summary Page, the Detail and Status sections are not localized. 3) None of the job attachments are localized. For example, if you open any application validation job and its validation log attachment, the attachment is in English only.

• 12338099

Unmapped source dimensions may fail to execute data synchronizations successfully.

• 13468449

If you upgrade to this release, and try to perform a Financial Management to Planning data synchronization, the data synchronization may fail with this error message: "Could not retrieve the application instance document for application <xxxapplication> from Shared Services."

• 13541402, 13541496

If you try to perform a Duplicate->Deployed Application (Migrate) on a Financial Management application, you may receive this error message: "Internal Server Error. Error occurred communicating with the server. Status: 500 - Internal Server Error."

• 13571448

After you run a task flow in a Kerberos environment and check the Performance Management Architect Job Console, the task flow may display as active although it is completed.

• 13621627

The File Generator may export the Entity and Currency dimensions as generic dimensions for Essbase aggregate storage and block storage applications.

• 13742698

The Performance Management Architect Dimension Server may fail to start when connecting to IBM DB2 in Secure Socket Layer (SSL) mode.

• 13788710

Validating a member formula in a Planning application may cause a 500 internal server error. Workaround: Use the Diagnostics option in the Application Library to fix the "Invalid deployment information status" message.

• 13800193

Performance Management Architect components may be unavailable from Oracle Hyperion Enterprise Performance Management Workspace after you upgrade from 11.1.2.1 to this release. Workaround: Change the application pool that the hyperion-bpma-server virtual directory is using.

1. In IIS Manager, click Advanced Settings.

2. Click the "..." button in the Application Pool setting, and then choose Classic .NET AppPool.

3. Click OK.

The Application Pool is now using NET 2.0 rather than 4.0. You must use NET 2.0 for hyperion-bpma-server.

• 13737561

After you create a new interface data source, if you select the interface data source created earlier, the server name and the JDBCL URL is incorrectly appended with //. If you try to import via the interface table, you may receive this error: "ORA-12545: Connect failed because target host or object does not exist." Workaround: Edit and save the server name by removing the // from the server name in the JDBC URL and in the Database Server field.

• 13860305

If you create and deploy an Essbase aggregate storage application in release 11.1.1.4, and then perform a schema upgrade from 11.1.1.4 to this release, in which the upgraded installation exists separately from the original installation, the deployed Essbase aggregate storage application's Account and Entity member property value for the Primary Level Weighting property may be changed from TopLevelOnly to Default.

• 13622169, 13622443

After you create and deploy a Profitability and Cost Management application in release 11.1.1.3, and perform a schema upgrade from 11.1.1.3 to this release, in which the upgraded installation exists separately from the original installation, the deployed in sync Profitability and Cost Management application Allocation Type dimension member (that is, SysAllocVar2) member formula may be changed.

• 13622511

After you create and deploy a Profitability and Cost Management application using the Bikes52.ads flat file in release 11.1.1.3, and perform a schema upgrade from 11.1.1.3 to this release, in which the upgraded installation exists separately from the original installation, the deployed in sync Profitability and Cost Management application Measures Type dimension member, DriverMeasures Hierarchy Type, may be changed from blank to disabled.

• 13643622

After you create and deploy an Oracle Hyperion Planning application using the SampleApp.ads flat file in release 11.1.1.4, and perform a schema upgrade from 11.1.1.4 to this release, in which the upgraded installation exists separately from the original installation, the value of the Currency Dim Property, Use for Mapping, may be changed to False.

• 13643910

After you create and deploy an Essbase aggregate storage application with an Account dimension in release 11.1.1.4, and perform a schema upgrade from 11.1.1.4 to this release, in which the upgraded installation exists separately from the original installation, when you perform a CompareToDeployed Application task, the value of the Account dimension property, Hierarchy Type, may be changed from Stored to Dynamic.

• 13644443

After you create and deploy a Profitability and Cost Management application in release 11.1.1.4, and perform a schema upgrade from 11.1.1.4 to this release, in which the upgraded installation exists separately from the original installation, when you perform a CompareToDeployed Application task, Oracle Hyperion Profitability and Cost Management, the Measures dimension member property, Data Storage(BSO), may be changed from DynamicCalc to StoreData.

• 13865990

In a Unix or Linux environment, when you perform data synchronization between Essbase aggregate storage applications or between an Essbase aggregate storage and an Essbase block storage application, the data synchronization runs successfully, and data is copied successfully, but some decimal values may be added to whole numbers.

• 13866730

Support for duplicate outlines is required so members defined as shared in Oracle Hyperion EPM Architect are created as duplicate members in Oracle Essbase.

• 14398952, 13862759

When you make a change to a user-defined attribute, the change may not be reflected in the Shared Library.

• 17516833

In Batch Client, while deploying or redeploying applications, transaction history does not get purged even if the 'purgeTransactions' parameter is used, because the support for the same has been removed.

Oracle Hyperion Enterprise Performance Management Workspace

Defects Fixed in this Patch

Defect Number

Defect Fixed

• 17312895

Internet Explorer 9: No message is displayed when a profile to be imported already exists.

• 18309225

The show scrollbars functionality on Workspace pages does not work.

• 16091951

Clicking to expand a Workspace folder expands the wrong folder.

• 18050671

Shared Services Console in Workspace is disabled for some users.

• 13683135

Internet Explorer 9: The menu is sized incorrectly and is missing the bottom border.

• 13683154

Internet Explorer 9: Content tabs are not displayed correctly.

• 13722049

Internet Explorer 9: Table columns and checkboxes inside tables are shifted.

• 13740181

Internet Explorer 9: You cannot resize Explorer columns by dragging the lines.

• 13799612

The Hyperion Strategic Finance Installer menu item should not be displayed if Hyperion Strategic Finance is not installed.

• 13900121

Internet Explorer 9: Links in Profitability and Performance Management Architect may not be displayed.

• 16411559

HTML Preview of a large report causes Internet Explorer 8 to stop responding.

• 16881328

Pass-through authentication does not work after a second Workspace managed server starts.

Known Issues in this Patch

This patch does not contain any known issues.

 

Oracle Hyperion Financial Reporting

Defects Fixed in this Patch

Defect Number

Defect Fixed

• 17474319

The Financial Reporting report page margins are narrower in reports displayed in PDF Preview.

• 18397374

The substitution variable name is not displaying correctly when used in the User POV or in a grid in a Financial Reporting report.

• 18467193

A Financial Reporting report with a chart containing an Essbase alias attribute that contains an apostrophe does not display the chart.

• 18519845

The grid positioning and formatting of Financial Reporting reports is not consistent in PDF Preview.

• 18519890

When a Financial Reporting report is imported some column widths are adjusted that result in format changes in PDF Preview.

• 18536030

A Financial Reporting report containing multiple grids with multiple database connections does not complete successfully in PDF Preview.

• 18560765

When running Financial Reporting Studio on a Windows 7 64-bit client machine and you insert a grid or open member selection and then click ALT-Tab to switch applications, the client machine will become unresponsive.

Known Issues in this Patch

[NOTE TO WRITERS: This section is required.  If the patch doesn’t have any known issues, INCLUDE THIS SENTENCE.] 

 [NOTE TO WRITERS: Per Legal: This sentence must be included IF THERE ARE KNOWN ISSUES.]

The following issues are the noteworthy known issues of this patch.

Defect Number

Issue

• 18433829

Exporting a Financial Reporting report to Microsoft PowerPoint 2010 or later is not supported in 11.1.2.2.x. but it is supported in 11.1.2.3.500.

Workaround: Export the Financial Reporting report to Microsoft Word 2010 or Microsoft Excel 2010 or later. 

• 18671582

In Batch Scheduler, output as a static HTML web site may fail on Windows environments that implement Kerberos SSO.

Oracle Hyperion Reporting and Analysis Framework

Defects Fixed in this Patch

This patch does not contain any customer issues.

Known Issues in this Patch

This patch does not contain any known issues.

Oracle Crystal Ball

Defects Fixed in this Patch

Defect Number

Defect Fixed

• 15897786

Simulation stops if Crystal Ball is not the active window.

• 13960853

Missing .xlsx error occurs when launching Crystal Ball from Windows Explorer with autopreview active.

Known Issues in this Patch

This patch does not contain any known issues.

Oracle Hyperion Strategic Finance

Defects Fixed in this Patch

Defect Number

Defect Fixed

• 18262942

For Crystal Ball to successfully launch Oracle Hyperion Strategic Finance, it may be necessary to register the HSF.exe program first.

• 18307703

Entity change management cannot delete freestyle reports.

• 18315518

Renumbering subaccounts that include subtotals can cause subaccounts to be deleted.

• 18321899

When changing the input type of the @input function in freeform formulas, the input type does not update correctly.

• 18329989

Comma-separator formatting is not saved on the accounts tab.

• 18435365

Opening a report that has a special character in the name returns an XML load error exception.

Known Issues in this Patch

The following issues are the noteworthy known issues of this patch.

Defect Number

Issue

• 18239723

For Oracle Hyperion Strategic Finance to work correctly, the Oracle Hyperion Strategic Finance Java Web App, the Oracle Hyperion Strategic Finance .NET Web Services, and the Oracle Hyperion Strategic Finance Server need to be deployed on the same machine.

• 18239740

Attempting to enumerate the Oracle Hyperion Strategic Finance databases in Smart View fails if more than one Oracle Hyperion Strategic Finance web app is configured and running.

• 18025364

When logging on to Oracle Hyperion Strategic Finance from Crystal Ball by using the More Tools > Strategic Finance option, the Oracle Hyperion Strategic Finance log on page fails to receive focus.

• 17945959

Due to a file structure change, entities from Oracle Hyperion Strategic Finance versions earlier than 11.1.2.1 must be updated to 11.1.2.1 before they are run through the Conversion Utility for Smart View compatibility.  This can be done by opening an entity in the Oracle Hyperion Strategic Finance client or by using the Edit/Convert menu option from the entities tab of the Oracle Hyperion Strategic Finance Administrator.

Oracle Hyperion Profitability and Cost Management

Defects Fixed in this Patch

Defect Number

Defect Fixed

·   18460290

When running multiple Copy POV taskflows concurrently, various model artifact integrity violations could occur:

1. ORA-01400: cannot insert NULL into
("HPCM_451"."HPM_MDL_SRC_ND_CTX"."HPM_MDL_CTX_ID")

2. ORA-00001: unique constraint (PCM.XPKHPM_MODEL_CONTEXT) violated

3. Duplicate Logical Key entries within HPM_MODEL_CONTEXT

To resolve this issue, certain parts of the Copy POV operation are now synchronized to run serially to avoid potential artifact integrity violations.  You can still submit multiple Copy POV taskflows to run concurrently.

Note:  This fix is effective when the EPM Foundation Services are not clustered.

·   18377475

When running multiple Copy POV taskflows concurrently, some of the Copy POV taskflows could fail due to deadlock in the database.

It is important to keep HPCM internal model metadata clean and consistent.  As part of the Copy POV operation, unused internal references are deleted from the database.  The deadlock occurred due to the lack of indexes on foreign key columns where database constraints are enabled.

This patch creates 8 new non-unique indexes to support existing foreign key constraints:

* HPM_DIM_MEM_GRP (2 indexes)
* HPM_BULK_EDIT (2 indexes)
* HPM_ASSIGNMENT_RULE (4 indexes)

·   18356111

Sometimes when data copy is selected as part of POV Copy, the calculation script name used to do the copy might conflict with another POV copy running at the same time.
Changes are made in this patch to not copy the script to Essbase as an object, but rather to use it to directly run the calc using the JAPI, avoiding the potential name collision.

Known Issues in this Patch

 [NOTE TO WRITERS: Per Legal: This sentence must be included IF THERE ARE KNOWN ISSUES.]

This patch does not contain any new known issues.

 

Oracle Hyperion Web Analysis

Defects Fixed in this Patch

Defect Number

Defect Fixed

• 17383891

Entering a string, for example, CO, in the combo box does not cause the matching records, such as COLA, to be displayed.

• 18548936

All Web Analysis reports are not displayed when accessed from the Firefox 24.2.0 browser.

Known Issues in this Patch

 [NOTE TO WRITERS: Per Legal: This sentence must be included IF THERE ARE KNOWN ISSUES.]

This patch does not contain any known issues.

Oracle Hyperion Interactive Reporting

Defects Fixed in this Patch

Defect Number

Defect Fixed

• 16243711

Save to repository was not working in IRWC when using Internet Explorer 9.

Known Issues in this Patch

[NOTE TO WRITERS: This section is required.  If the patch doesn’t have any known issues, INCLUDE THIS SENTENCE.] 

 [NOTE TO WRITERS: Per Legal: This sentence must be included IF THERE ARE KNOWN ISSUES.]

This patch does not contain any known issues.

Oracle Hyperion Financial Management

Defects Fixed in this Patch

Defect Number

Defect Fixed

17376467

Some Financial Reports cause high memory usage and poor performance for other tasks.

Known Issues in this Patch

[NOTE TO WRITERS: This section is required.  If the patch doesn’t have any known issues, INCLUDE THIS SENTENCE.] 

 [NOTE TO WRITERS: Per Legal: This sentence must be included IF THERE ARE KNOWN ISSUES.]

The following issues are the noteworthy known issues of this patch.

Defect Number

Issue

·   14461734

Server cluster registration is not possible in Release 11.1.2.2.x.

·   15830423

The Manage Ownership screen is not refreshed after you clear ownership data in Manage Data.

·   16005476

Deleting a currency prevents the Calculation Status from updating correctly.

·   16098454

When you run a Security report in HFM format, it may not complete in Internet Explorer 9.

·   16825135

Financial Management application extract logs cannot be retained.

·   16841386

Running task logs and extended analytics does not work correctly for multiple extracts.

·   16858318

The Member name as an alias is not imported in custom dimensions.

·   16881461

After migration, task flow does not reflect multiple selections for dimensions.

·   16920194

The Validation account does not show any data even when it has data.

·   16935308

You cannot extract POV data to a flat file with a 10 custom dimension application.

·   16973552

In a task flow, you cannot display the top member.

·   17036500

Journal templates do not refresh after you print a template.

·   17170275

The Process control “Show active only” option affects entities in Web Data forms.

·   17173462

An error message occurs when you try to copy a journal entry list.

·   17561345

You cannot see the Manage Process option in data grids if you select the entire column.

·   17556454

When you create a new journal, the Variance tab does not display.

·   17543581

In the Task Flow POV, you cannot select the parent.[BASE].

·   17495066

HFM IIS web URLs contain double-slash characters.

·   17447965

In a data form, you can view some lines in the form, but not in the Design or Script mode.

·   17431501

In Taskflow actions, you cannot use member lists.

·   17418945

The security for Custom dimensions restricts the Calculation status in Process Control.

·   17356658

In Intercompany reports, an incorrect Custom Top Member error occurs.

·   17289030

The Equity Pickup report displays only 100 lines.

·   17253849

When you delete journal rows, errors occur and the journals are not deleted.

·   17220228

In the HFM application toolbox, when you try to access the Custom1 dimension in application information, an error occurs.

·   17213135

Journal lines are saved with an invalid parent/child combination without displaying an error.

·   17895599

Intercompany transactions are not all posted when many are selected at once.

·   17784852

The Smart View HSDESCRIPTION function does not work for languages other than English.

·   17740419

After migrating to 11.1.2.2, Data Forms do not completely display the bottom row.

·   17666145

In data forms, the SCALC() function does not work as expected.

·   17641625

The Extract Data template does not save the defined account members.

·   17638802

Non-admin users cannot view certain rows in data forms.

·   17871408

Smart View connection shows both the clusters and servers.

·   17350309

Search option in the member selector does not work when the application has a large number of base entities.

·   18670510

When loading ICT data with multiple entries for the same POV, only the last amount in the file gets loaded.

·   18643940

ICP report does not honor the value specified for Matching Tolerance.

·   18639925

Financial reporting reports run much longer when they contain cell text.

·   18528346

Financial reports using "Base of Current POV for entity" is not working with conditional suppression.

·   18504682

When MaxNumConcurrentConsolidations is reached, nonconsolidation tasks are also queued.

·   18497985

Data load generates errors when cell text is included.

·   18490958

Error running Financial report with a dynamic POV member list in the dimension selection.

·   18460306

You cannot unlock data if only one dimension is on the row and the other dimensions are in columns.

·   18371462

Clicking the "open in smart view" button does not work without Smart View suppression options.

·   18367991

You cannot see forms in the web UI that can be accessed in Smart View.

·   18285056

When trying to view the documents with the filter "all," you receive an error.

·   18275504

Empty cell text columns do not display the attached document.

·   18260119

When extracting data with cell text data for Entities and not Custom Members is extracted.

·   18222251

When opening a WDEF containing rows that you do not have security access to, the rows are misaligned.

·   18169689

When opening a WDEF you may receive the message "Selected member is not valid for the specified member list."

·   18140524

When changing the POV in a WDEF, any expanded rows or columns will become collapsed.

·   18108578

Users with limited access to "Manage Journals" receive an error when they do not have access to the first journal in the list of available journals.

·   18089538

WDEFs with suppression on rows and override on columns does not display rows properly.

·   18061552

When exporting entity details to Excel from a web grid, the data is displayed twice.

·   18011084

When creating rules in calculation manager, members in custom dimensions above 4 are not recognized.

·   17922628

Users with only the "Manage Taskflow" and "Run Taskflow" roles cannot access taskflows.

Oracle Hyperion Shared Services

Defects Fixed in this Patch

This patch does not contain any customer issues.

Known Issues in this Patch

The following are noteworthy issues in this patch:

Defect Number

Issue

·       19077746

If the browser is configured to use a non-English locale, a 404 (File not found) error is displayed when you access Shared Services help by selecting EPM Security Help from the Help menu.

Oracle Hyperion Calculation Manager

Defects Fixed in this Patch

Defect Number

Defect Fixed

• 18345487

If you use copy to on a rule in script mode that contains a macro, the copied to rule may not display the comments from the copied rule.

Known Issues in this Patch

The following issues are the noteworthy known issues of this patch.

Defect Number

Issue

• 8860666

To read a script using screen reader software, you must copy the script to an alternate text editor.

• 8866203

If you are using screen reader software, when you open the Rule Designer or the Template Designer, the screen reader software reads out 10%, 20%, and so on, which indicates that the page load is in progress, even after the module is completely loaded and a confirmation message is announced.

• 8894789

You may receive the error message, "Error: Index: 1, Size: 1" if you paste a component after expanding or collapsing a loop or condition component. To work around this issue, use Ctrl+Shift+E to move the component within a loop or condition to the end of the loop or condition. To paste a component in the Else part of the condition, press Ctrl+Shift+I.

• 9593036

If you create a business rule using an allocation component, save and validate the rule, and then double-click on the allocation component in the Rule Designer, the Allocation wizard may not open. To work around this issue, from the Summary tab, click Edit.

• 9593061

Assume that you create a business rule with an allocation component, validate and save the business rule, and then edit the allocation component. When you click the Source tab, delete the existing account, click the Action icon, and try to select a member from the Account dimension, the Member Selector may not open. Workaround: After deleting the existing account, press Enter. Click the Action icon, select Member, and the Member Selector will be displayed.

• 9781874

In Internet Explorer, when you are working with a business rule in script mode, and you receive an error, the line in the script with the error may not be highlighted. In Firefox, when you are working with a business rule in script mode, and you receive an error, the line in the script with the error is not highlighted.

• 9795243

If you have a business rule with two formula components, each with an IF condition and a common member block, the generated script of the business rule may contain two member blocks. In graphical mode, the same business rule contains only one (correct) member block.

• 9798363

If you are working with a business rule in script mode, and you open the Find and Replace dialog, the "Wrap Search" option is not displayed in the dialog box.

• 9799861

If you create a business rule with a script or formula component that has more than 5,000 lines and then save the rule, the browser may be suspended for a few minutes. Workaround: If you have a formula or script component with more than 400 lines, split them so that each formula or script contains one to 400 lines.

• 9801375

If you are using a template that has POV as the first tab in the template wizard, when you click the Action icon on the POV, the member, variable, and function menu is displayed, but it may be displayed in the top left of your screen. Workaround: Press Enter before you click the Action icon.

• 9804886

If you are using Internet Explorer 8 to create a business rule in script mode, and you copy text from the script to the clipboard using the "Copy to Clipboard" option, you may receive an error message.

•9815870

If you are working with a business rule in script mode, and you edit the script of the business rule, when you return to graphical mode, the edits that you made may not be retained. Modifications made to the generated comments (conversion helper tags) also may not be recognized.

• 9852647

If you use the Allocate Level to Level template in a business rule, define the offset member on the allocation dimension, save the business rule, and then edit the dimension to which to allocate the data, the offset member may still display the dimension that you selected before editing the business rule.

• 9862094

If you are working for more than eight hours, your session may expire. Workaround: Change the token timeout setting. In Shared Services, select Administration, then Configure User Directories, and then Security Options to change the Token Timeout setting.

• 9964305

If you create two business rules in Calculation Manager, and the names of the rules use the same words with different spacing, such as Rule 1 and Rule   1, the spacing is not retained within Planning, and the rules are displayed with the same name. In the database, the rule names are displayed correctly.

• 12746625

If you upgrade to this release, business rule level variables may not be migrated unless you restart Calculation Manager in Release 11.1.1.4.

• 13086605

If you are debugging a business rule in Calculation Manager, and another user is trying to work with data forms, refresh the application, or perform other Essbase operations on the same application, that user may be unable to perform these tasks. For example, if you are working on a data form in the application, App1, and another user is debugging a business rule for App1 in Calculation Manager, you might be unable to save the data form.

• 13450828, 13767552

If you are working in an environment with a bidirectional language, when you are in the Component Designer, the Formula drop-down list may not display all of its selections.

• 13525497

If you are editing a Financial Management business rule with a data range loop in script mode, when you return to editing in graphical mode, the data range loop's definition may be empty.

• 13602784

The Rule Designer might not work on Windows 2008 Server R2 64-bit operating systems, because Flash is not available for these operating systems.

• 13655734

In script components, the cursor may not be displayed consistently. Workaround: Click your left mouse button.

• 13683588

You should not be able to name a business rule or function with the same name as a major Financial Management subroutine (for example, Allocate, Calculate, Consolidate, Dynamic).

• 13729396

Values for the member range or cross-dimensional variables may not validate if they are used in two applications that do not use the same dimensions.

•14332909

Ctrl+F3 may not work for Find Next. Workaround: Use the menu option Edit, Find Next.

•14332962

The @MDALLOCATE function may require you to enter no required parameters. If you do not enter these parameters, you may receive a message stating, "Enter values for these field(s): Round Member, Skip Flag." You should not have to enter members for these fields. RoundMbr is optional, unless you choose the errorsToMbr for rounder. SkipFlag is required only when the method is Spread, but the function selector will not let you click OK until you enter members. Workaround: Enter values for these fields: For the Round Member, enter a space. For Skip Flag, use the drop-down list, click OK, edit the script, and replace the skip method with a space.

•18727269

If you use Firefox 24.5.0 and you hide the menu, right-click a component in the rule designer may not work correctly. Workaround: Unhide the Firefox menu.

•18771970

If you use Internet Explorer 10, the member/variable selector may return a white box, instead of the Member/Variable Selector. Workaround: Use Internet Explorer 10 version 10.0.9200.16897 or later.

Oracle Hyperion Financial Close Management

Defects Fixed in this Patch

Defect Number

Defect Fixed

• 12712242

In Close Manager, when you create a schedule from a template and then remap a close day, the prior close day tasks are incorrectly assigned.

• 18530228

In a SQL Server environment, the postinstallation .bat file stops responding.

• 18443848

In Close Manager, the Schedule owner cannot add Predecessor tasks from other schedules.

• 18061398

In Reconciliation Manager, enabling Copy From Prior Period does not discriminate by Transaction Type.

Known Issues in this Patch

The following issues are the noteworthy known issues of this patch.

Defect Number

Issue

• 11869333

Financial Close Management forces WebLogic to check for JSP Pages.

• 9356443

Under certain heavy load conditions, a user session may freeze when using Internet Explorer. Workaround: Increase OHS: KeepAliveTimeout to 61 seconds.

• 13366076

In the View menu, you cannot scroll to the bottom of the list using "Scroll to last" of the tree table.

• 14695470

The time zone of some countries has been changed; therefore, the time zone displayed is not correct.

• 8921652

Status Chart and Overview portlets do not swap when you drag in Internet Explorer.

• 9761181

An error message may be displayed if you attempt to drill into the Alerts bar in the Status Chart control after printing the control.

• 16746240

If an open task is assigned to an external user who no longer exists in the directory, you cannot edit the task. Workaround: Delete the task, and recreate the task with a different user assignment.

• 16745794

When a user imports a schedule from a template using a time zone different from the server time zone, the start date and time are the same as the server's. The start date and time should be the same as the user's.

• 16935604

When you launch the Task Actions Dialog from email, the dialog box does not close after you select an action. Workaround: Close the browser window.

• 14780216

In Close Manager, when you open the alerts tab, you receive a null pointer exception. Workaround: In the Smart View Task Actions window, click Actions, and then Refresh before you open the Alerts tab.

• 14382235

In Close Manager, when you use the Esc key in various manage dialog boxes, either data is partially saved or no data is saved. Workaround: To check whether the data was saved, reopen the dialog box.

• 12962672

Oracle Hyperion Shared Services Account Reconciliation Manager and Close Manager submenus list both Account Reconciliation Manager and Financial Close Management roles.

• 14390242

Account Reconciliation Manager roles and application are not available if only the Account Reconciliation Manager module is installed.

• 14368407

When you import a global integration token, which is dependent on a new attribute, the import fails.

• 15917071

Importing custom currency with replace all option fails and returns an array out of bounds error.

• 16051716

In Account Reconciliation Manager, in a single currency system with a single currency bucket, the Generate All option generates a “Currency bucket not enabled” error.

• 15856161

In Account Reconciliation Manager, when a scheduled data load is set to run at the same time as another data load that references the same location, the second data load should not run, and an error message should report a data load error. However, the error message is not visible in the Task Scheduler UI. Workaround: Retrieve the error message from the Account Reconciliation Manager logs in <MIDDLEWARE_HOME>/user_projects/<INSTANCE_NAME>/diagnostics/logs/arm.