Oracle Hyperion Tax Provision Readme

Caution: Oracle urges you 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 service interruptions, loss of data, or both.

Patch Type

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

New Features in this Release

No new features have been added to this patch.

Installation Information

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

Supported Platforms

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

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

Supported Paths to This Patch

You can apply this patch to Oracle Hyperion Tax Provision Release 11.1.2.4.000 or Oracle Hyperion Tax Provision Release 11.1.2.4.100 or Oracle Hyperion Tax Provision Release 11.1.2.4.200 or Oracle Hyperion Tax Provision Release 11.1.2.4.201.

Important: If you are upgrading from Oracle Hyperion Tax Provision 11.1.2.4.000 you need to incrementally follow all the upgrade instructions for releases leading up to 11.1.2.4.202.

For example, upgrading from HTP 11.1.2.4.000 to HTP 11.1.2.4.202 will require the following steps:

1. Perform the application upgrade steps from the 11.1.2.4.100 readme to upgrade your HTP application(s) to 11.1.2.4.100.

2. Performing the application upgrade steps from the 11.1.2.4.200 readme to upgrade your HTP application(s) to 11.1.2.4.200.

3. Perform the application upgrade steps from the 11.1.2.4.201 readme to upgrade your HTP application(s) to 11.1.2.4.201.

4. Perform the application upgrade steps from the 11.1.2.4.202 readme to upgrade your HTP application(s) to 11.1.2.4.202.

Prerequisites

Required Patches

Oracle Hyperion Financial Management 11.1.2.4.204 or later

Oracle Hyperion Smart View client 11.1.2.5.510 or later

Oracle Hyperion Financial Reports 11.1.2.4.000 or later

Applying this Patch

The section includes important information about applying this patch. All steps assume an upgrade from Oracle Hyperion Tax Provision 11.1.2.4.000 or 11.1.2.4.100 or 11.1.2.4.200 or 11.1.2.4.201. This patch needs to be applied on all hosts where Oracle Hyperion Financial Management, Oracle Hyperion Tax Provision or Oracle Hyperion Foundation Services are installed and deployed.

To apply this patch:

Ensure that all Oracle Hyperion services are stopped.
Download and unzip the downloaded patch file, <PATCH FILE NAME>.zip, to the <EPM_ORACLE_HOME>/OPatch directory (by default, Oracle/Middleware/EPMSystem11R1/OPatch).

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.

On the HFM Application Server, from a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.
To apply the patch, enter the following command on one line:

Windows:

opatch.bat apply <EPM_ORACLE_HOME>/OPatch/25316913-oh <EPM_ORACLE_HOME>

-jre <MIDDLEWARE_HOME>/jdk160_35

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_35 -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.

When applying this patch in an environment that is using IBM WebSphere, a manual redeployment is needed for HFM Web Application as per EPM Installation Guide.
All users should now clear cached files from their browsers.

Manual instructions to be performed after applying OPatch:

Rename old HTP Accelerator installer

Rename the file

<EPM_ORACLE_HOME>\products\TaxProvisioning\Utilities\HTPAccelerator\HTPInstaller.msi

<EPM_ORACLE_HOME>\products\TaxProvisioning\Utilities\HTPAccelerator\HTPInstaller.msi.orig

Update the WorkspaceConfig.xml on all hosts where Oracle Hyperion Financial Management is installed and deployed.

· Modify <EPM_ORACLE_HOME>\products\FinancialManagement\Web Server\xml\adf\WorkspaceConfig.xml to replace the reference to HTPInstaller.msi with HTPAcceleratorInstaller.svext.

· Update the Workspace menu. Perform these steps on all servers running Foundation Services and static content.

• Navigate to <EPM_ORACLE_INSTANCE>\bin. For example, C:\Oracle\Middleware\user_projects\epmsystem1\bin.

• Click epmsys_registry.bat(.sh), and in the report that displays search for the object ID for FINANCIAL_MANAGEMENT_ADF_LWA.

• Write down the ID for this object.

• Open a command prompt or terminal and go to <EPM_ORACLE_INSTANCE>\bin.

• Run this command:

epmsys_registry updatefile #11d1def534ea1be0S2f16fcf513423cbfb63S7801/@WorkspaceConfig <EPM_ORACLE_HOME>\products\FinancialManagement\Web Server\xml\adf\WorkspaceConfig.xml

where 11d1def534ea1be0S2f16fcf513423cbfb63S7801 is the Object ID of FINANCIAL_MANAGEMENT_ADF_LWA.

For example, the command for Windows is:

epmsys_registry updatefile #11d1def534ea1be0S2f16fcf513423cbfb63S7801/@WorkspaceConfig C:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Web Server\xml\adf \WorkspaceConfig.xml

• Restart Foundation services.

On the host where foundation services is installed and deployed make sure the element below is present for HTPAccelerator in <EPM_ORACLE_HOME>\common\epmstatic\SmartView\Client\UpdateList.xml.

<name>Oracle Hyperion Tax Provision Accelerator</name>

<en>Oracle Hyperion Tax Provision metadata accelerator for Smart View</en>

</desc>

<owner>Oracle</owner>

<location>/epmstatic/wspace/taxprov/HTPAcceleratorInstaller.svext</location>

</extension

Rolling Back this Patch

To roll back a patch:

From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch (by default, Oracle/Middleware/EPMSystem11R1/OPatch).
To roll back the patch, enter the following command on one line:

Windows:

opatch.bat rollback -id 25316913 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>/jdk160_35

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_35 -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.

All users should now clear cached files from their browsers.

Manual instructions to be performed after rolling back OPatch:

Return the old installer

Rename the file

<EPM_ORACLE_HOME>\products\TaxProvisioning\Utilities\HTPAccelerator\HTPInstaller.msi.orig

<EPM_ORACLE_HOME>\products\TaxProvisioning\Utilities\HTPAccelerator\HTPInstaller.msi

Rename

<EPM_ORACLE_HOME>\products\TaxProvisioning\Utilities\HTPAccelerator\HTPAcceleratorInstaller.svext

<EPM_ORACLE_HOME>\products\TaxProvisioning\Utilities\HTPAccelerator\HTPAcceleratorInstaller.svext.orig

Update the WorkspaceConfig.xml on all hosts where Oracle Hyperion Financial Management is installed and deployed.

· Modify <EPM_ORACLE_HOME>\products\FinancialManagement\Web Server\xml\adf\WorkspaceConfig.xml to replace the reference to HTPAcceleratorInstaller.svext with HTPInstaller.msi.

· Update the Workspace menu. Perform these steps on all servers running Foundation Services and static content.

• Navigate to <EPM_ORACLE_INSTANCE>\bin. For example, C:\Oracle\Middleware\user_projects\epmsystem1\bin.

• Click epmsys_registry.bat, and in the report that displays search for the object ID for FINANCIAL_MANAGEMENT_ADF_LWA.

• Write down the ID for this object.

• Open a command prompt or terminal and go to <EPM_ORACLE_INSTANCE>\bin.

• Run this command:

epmsys_registry updatefile #11d1def534ea1be0S2f16fcf513423cbfb63S7801/@WorkspaceConfig <EPM_ORACLE_HOME>\products\FinancialManagement\Web Server\xml\adf\WorkspaceConfig.xml

where 11d1def534ea1be0S2f16fcf513423cbfb63S7801 is the Object ID of FINANCIAL_MANAGEMENT_ADF_LWA.

For example, the command for Windows is:

epmsys_registry updatefile #11d1def534ea1be0S2f16fcf513423cbfb63S7801/@WorkspaceConfig C:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Web Server\xml\adf \WorkspaceConfig.xml

• Restart Foundation services.

3. On the host where foundation services is installed and deployed remove the HTPAccelerator element below in <EPM_ORACLE_HOME>\common\epmstatic\SmartView\Client\UpdateList.xml.

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:

Windows:

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

UNIX/Linux:

./opatch lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_35 –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 in order 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

Upgrading to this patch

If you are upgrading from Oracle Hyperion Tax Provision 11.1.2.4.000 please follow all the upgrade instructions for upgrading from 11.1.2.4.000 to 11.1.2.4.100 to 11.1.2.4.200 and to 11.1.2.4.201 first.

Upgrading rules (TaxProv_Rules.rle) from 11.1.2.4.201 to 11.1.2.4.202:

(This step is required if there are any customizations applied to the provided rule file).

1. Open the TaxProv_Rules.rle rule file distributed with this patch in a text editor.

2. Open the customized rule file in a text editor.

3. Copy the entire custom implementation section including Pre and Post calculation blocks from the customized rules file. The beginning of the custom implementation section is clearly marked. See below:

'*******************************************************************

'* Sub routines for custom implementation

'*******************************************************************

Sub Pre_OpenBalances()

'===================================================================

' Method will be called before calling Calculate_OpenBalances sub

'===================================================================

End Sub

Sub Post_OpenBalances()

'===================================================================

' Method will be called after calling Calculate_OpenBalances sub

'===================================================================

End Sub

4. Replace the custom implementation section in the provided rules file with the copied section from your customized rules file.

5. Modifications to the provided rules outside the custom implementation section are not supported and will be lost during the upgrade.

Upgrading member lists (TaxProv_Memberlist.lst) from 11.1.2.4.201 to 11.1.2.4.202:

Apply any customizations that you previously made to the provided member list file.

Upgrading metadata from 11.1.2.4.201 to 11.1.2.4.202:

Account dimension:

Important: Take the properties of changed members from the metadata file that ships with this patch.

Changed “UD2” property:

*Member*	*Old Value*	*New Value*
TaxCredit0002	TaxDetail:TaxCreditD0002

RollForward dimension:

Important: Take the properties of changed members from the metadata file that ships with this patch.

Changed “SwitchTypeForFlow” property:

*Member*	*Old Value*	*New Value*
CbCCashTaxNet	No	Yes
CbCCashTaxReg	No	Yes
CbCCurProvisionNat	No	Yes
CbCCurProvisionReg	No	Yes
CbCEBIT	No	Yes
CbCRelRevenues	No	Yes
CbCTotalRevenues	No	Yes
CbCTotalTax	No	Yes
CbCUnRelRevenues	No	Yes

Changed “UD2” property:

*Member*	*Old “UD2” Value*	*New “UD2” value*
CbCCapital	UseNIBTOvRate:Yes
CbCCashTaxNet		UseNIBTOvRate:Yes
CbCCashTaxReg		UseNIBTOvRate:Yes
CbCCurProvisionNat		UseNIBTOvRate:Yes
CbCCurProvisionReg		UseNIBTOvRate:Yes
CbCRE	UseNIBTOvRate:Yes

Upgrading Web forms

It is a best practice to customize copies of out-of-the-box web forms instead of customizing out-of-the-box web forms directly. Customizations must be reapplied to copies of the upgraded web forms.

Upgrading Reports

It is a best practice to customize copies of out-of-the-box reports instead of customizing out-of-the-box reports directly. Customizations must be reapplied to copies of upgraded reports.

Configuration Steps

Instructions for HTP Accelerator users

1. On your client machine uninstall the old accelerator. It can be performed via HTPAccelerator.msi or from Control Panel under Programs and Features.

2. Upgrade to the latest release of the Smart View client (http://www.oracle.com/technetwork/middleware/smart-view-for-office/overview/index.html).

3. Install the new HTP Accelerator. Either

· Download the Tax Provision Metadata Accelerator extension from the Workspace (HTPAcceleratorInstaller.svext) and run the downloaded extension.

Note: In certain browsers, such as IE11 there may be a setting to sniff the MIME type of downloaded content. If the file is downloaded with a .zip extension, i.e. HTPAcceleratorInstaller.zip, change the extension to HTPAcceleratorInstaller.svext. Double click on HTPAcceleratorInstaller.svext to install the accelerator.

· Select Options in the Smart View ribbon in Excel. Make sure that the “Shared Connections URL” under Advanced is set to a valid workspace sever where this patch has been applied, e.g. http://<host>:19000/workspace/SmartViewProviders. Select “Check for Updates, New Installs, and Uninstalls” under the Extensions option. You should see the “Oracle Hyperion Tax Provision Accelerator” in the list of extensions available to be installed.

Defects Fixed in this Patch

24760693	DTA/DTL Classification not correct when closing balance is zero
24938538	Tax Loss Adjustment data getting doubled in temporary difference when both the UD Entry and NOL Automation are used
25609070	DTA/DTL Classification not correct when closing balance is zero
25316951	Tax Loss is not utilized based on the year of origination.
25190829	Encountering an Opatch conflict when upgrading to HTP patch 22983401
25316836	NOL Expiration data getting doubled when both the UD Entry and NOL Automation are used
25316959	Rate Change calculation is missing parentheses causing issues on all the rate change calculations when AcqNP/tax was different than AcqNP * CY Tax rate
25317047	Country by Country reporting translations according to wrong exchange rates.
24555313	Cannot add multiple rules for the same NOL Account
24570127	Tax Automation Trace does not work correct when source Reporting Standard is different to the target reporting standard
24969192	Tax Automation Trace does not work correct when source ICP is set to ICP TOP
24564713	Calculation order of TAR and interim is not correct.
24678895	Rate Change calculation provides wrong result and does not reconcile between TAR and Deferred Tax IFRS

Known Issues

17613251	When you change the domicile user-defined property for an Entity, the consolidation process will not work correctly, you must reload rules before performing consolidation or calculation.
20822999	When you load rules into a new application, the system sometimes times out after several minutes.
18276118	Class level validation doesn’t occur when parent is set to yes and children are set to blank.
22372015	Return to Accrual and Return to Accrual Regional reports must be manually edited when the scenario frequency is other than MTD (for example, QTD).

Supported Languages

This patch can be applied to all languages supported in Release 11.1.2.4.000 of Oracle Enterprise Performance Management System. For the Oracle Enterprise Performance Management System Supported Platform Matrix, go to: http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Documentation

For guidance on implementing and using Oracle Hyperion Tax Provision, refer to the Oracle Hyperion Tax Provision Administrator’s Guide and the Oracle Hyperion Tax Provision User Guide.

Periodic updates to the documentation for Oracle Hyperion Tax Provision will be available for downloading or viewing from the EPM System Documentation area of the OTN Web site (http://www.oracle.com/technology/documentation/epm.html).