Oracle Hyperion Tax Provision Readme

To use Internet Explorer release 11 in standard mode instead of in Enterprise Mode you must apply the 11.1.2.3.700 PSU for all EPM products in your deployment. After you apply this patch, you can no longer use Internet Explorer 11 in Enterprise Mode.

For details, see the "Prerequisites" section.

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

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

Prerequisites

The application has been developed and tested on Oracle Enterprise Performance Management System 11.1.2.3.700.

Patch 11.1.2.3.702 is also backwards compatible with Oracle Enterprise Performance Management System 11.1.2.3.500.

Required Patches for installing with Oracle Enterprise Performance Management System 11.1.2.3.500

Oracle Hyperion Financial Management 11.1.2.3.503 (*At a minimum 11.1.2.3.501 or newer version is recommended)

Oracle Hyperion Financial Reporting 11.1.2.3.505

Oracle Hyperion Enterprise Performance Architect 11.1.2.3.510

Required Patches for installing with Oracle Enterprise Performance Management System 11.1.2.3.700

Ensure that this product's 11.1.2.3.503 (20464607) patch is applied first.
If you are using WebLogic Application Server, apply WebLogic Application Server patch 17437110 for Release 10.3.6 to use Simplified Chinese and Traditional Chinese language settings when using Internet Explorer 10 and Internet Explorer 11 on Windows 8 and Windows 8.1. For instructions on applying the patch, see Oracle Smart Update: Applying Patches to Oracle WebLogic Server.
Apply ADF MLR patch 21240419.
Apply these required EPM System release 11.1.2.3.700 PSUs first:

Apply Oracle Hyperion Shared Services 11.1.2.3.700 PSU - 20675028. Apply the patch to all computers in the deployment.
Apply Oracle Hyperion Enterprise Performance Management Workspace 11.1.2.3.700 PSU - 20612400. Apply to all computers with Foundation Services deployed.

5. For the rest of the products, apply the product patch on the computer where the product is deployed. Use the table below to find EPM product 11.1.2.3.700 PSU patch numbers. If the product is not listed, then it does not have a 11.1.2.3.700 PSU, and no action is needed.

Note: For Oracle Hyperion Calculation Manager, apply the patch on all computers where Oracle Hyperion Planning, or Oracle Hyperion Financial Data Quality Management Enterprise Edition, or Oracle Essbase is deployed.

Note: If you are using IBM WebSphere Application Server, you must redeploy the EPM System web applications after applying EPM System release11.1.2.3.700 PSUs.

Product Name	11.1.2.3.700 PSU Patch Number
Oracle Data Relationship Management	21107706
Oracle Financial Reporting	20838970
Oracle Hyperion Calculation Manager	21292109
Oracle Hyperion Disclosure Management	20619384
Oracle Hyperion Financial Close Management	20768349
Oracle Hyperion Financial Data Quality Management Enterprise Edition	20779592
Oracle Hyperion Financial Management	20955781
Oracle Hyperion Performance Management Architect	20929659
Oracle Hyperion Planning	20643564
Oracle Hyperion Profitability and Cost Management	20915688
Oracle Hyperion Reporting and Analysis Framework	20768325
Oracle Hyperion Tax Provision	22450346
Oracle Hyperion Web Analysis	20880421

Applying this Patch

The section includes important information about applying this patch. All steps assume an upgrade from HTP 11.1.2.3.701.

Deploying the EAR File

It is recommended to unzip the TaxProvApplication.ear file at a location under $EPM_ORACLE_HOME, e.g. C:\Oracle\Middleware\EPMSystem11R1\products\TaxProvisioning\ AppServer\InstallableApps. You must deploy the EAR file to the Application Server used, such as WebLogic. You can use a batch file to automatically deploy the EAR file. The file is named deploy.bat and is located in the same Custom UI Components directory as the EAR file.

To update custom screens:

1. From the Custom UI Components directory, open and edit the deploy.properties file.

You must edit the information in this file with your WebLogic Server information.

2. From the Custom UI Components directory, run the deploy.bat file.

3. Restart the Hyperion Financial Management Web Tier service.

Upgrading application artifacts with those included in this patch

All HTP applications have to be upgraded to the artifacts in this patch.

Upgrading rules (TaxProv_Rules.rle) from 11.1.2.3.701 to 11.1.2.3.702:

(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. Customized rules that you added to the previous rules file will be lost during the upgrade; manually apply any previous customized rule to the upgraded rules file.

Upgrading member lists (TaxProv_Memberlist.lst) from 11.1.2.3.701 to 11.1.2.3.702:

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

Upgrading metadata from 11.1.2.3.701 to 11.1.2.3.702:

Rollforward dimension:

Changed Members:

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

Changed “SwitchTypeForFlow” property:

*Member*	*Old value*	*New value*
CbCCapital	No	Yes
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. Otherwise customizations must be reapplied to copies of the upgraded web forms.

No new Web forms have been added to this patch.

No existing Web forms have been updated in this patch.

Grids:

No new grids have been added to this patch.

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. Otherwise customizations must be reapplied to copies of upgraded reports. The following reports have been renamed. The old copies can be deleted:

No new Reports have been added to this patch.

No existing Reports have been updated in this patch.

Caution: Loading Web forms / Reports using LCM package will overwrite all existing web forms / reports that have the same label and consequently any customization that you made to original/existing web-forms / reports in use.

Defects Fixed in this Patch

23748710	When within Tax Automation a dynamic entity memberlist is used e.g. { (JD) Domicile Entities} base entity data can change during consolidation.
23748707	Copying NOL Automation rules can fail in some cases because of a missing constant
23748702	When applying the “annualize” logic in tax automation, numbers are not annualized correctly. The annualize logic takes a wrong number of periods into account if the application contains over 13 months or over 5 quarters.
23748693	When you allow including ICP details on accounts, tax automation with trace fails if these accounts are used as either a source or target account.
23748346	Country by Country reporting translations according to wrong exchange rates.
23748324	TARF translation of CTA accounts not correct, CTA accounts were translated against the wrong rate.
23596098	Rate Change calculation is missing parentheses causing issues on all the rate change calculations when AcqNP/tax was different than AcqNP * CY Tax rate

Known Issues

22695874	Tax Automation screen filter functionality Workaround: You can filter out the records using filter functionality and modify them accordingly but before submitting changes remove the filter and submit, this way it won’t overwrite any records.
20822999	When you load rules into a new application, the system sometimes times out after several minutes.
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 / calculation.
19048767	Return to Accrual and Return to Accrual Regional reports must be manually edited when the scenario frequency is other than MTD (for example, QTD).
22259430	When NOL Deferral Automation rules are set up so that multiple target accounts have the same detail account, the system posts the deferral to one of the target accounts in no particular order/sequence.
18276118	Class level doesn’t occur when parent is set to yes and children are set to blank.
21298729	Cannot open TAR automation/taxadmin custom links using HFM 11.1.2.3.700 Note: this bug is fixed in HFM PSU 11.1.2.3.702 (PSU 22323578)

Supported Languages

This patch can be applied to all languages supported in Release 11.1.2.3.700 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).