Oracle Apps DBA stuff

Tuesday, August 23, 2011

EBS: R12.1 Oracle Financials Recommended Patches [ID 954704.1]

EBS: R12.1 Oracle Financials Recommended Patches [ID 954704.1]

		Modified 21-JUL-2011 Type ALERT Status PUBLISHED

In this Document
Description
Product-Specific Recommended Patches
R12.1 Pre-Upgrade Patches
Likelihood of Occurrence
Possible Symptoms
Workaround or Resolution
Patches
Modification History
References

Applies to:

Oracle Assets - Version: 12.1 to 12.1.2 - Release: 12.1 to 12.1
Oracle Internet Expenses - Version: 12.1 to 12.1.2 [Release: 12.1 to 12.1]
Oracle Receivables - Version: 12.1 to 12.1.2 [Release: 12.0 to 12.1]
Oracle General Ledger - Version: 12.1 to 12.1.2 [Release: 12.1 to 12.1]
Oracle Payables - Version: 12.1.0 to 12.1.2 [Release: 12.0 to 12.0]
Information in this document applies to any platform.

Description

This document contains links to the Release 12.1 Financial products that have released Development Recommended one-off or rollup patches after the EBS suite-wide Release 12.1.x. Information about the patches are provided in the documents listed below.

Attention 11i Customers who are planning their upgrade to Release 12.1.x

If you are planning an upgrade from Release 11i to 12.1.x, please review the README for the
EBS Consolidated Upgrade Patch 7303029 AND Document 1127593.1 -- See information below.
Document 1127593.1 lists a number of Oracle Financials pre-upgrade patches that
are required in order for the Release 12.1 upgrade to complete successfully.

Product-Specific Recommended Patches

Product	Patch	Additional Included Fixes (or previous fixes in same codeline)	Description/Symptoms	Comments	Last Update
E-BUSINESS TAX (EBTAX)	Patch 8877828:R12.ZX.B (8877828:R12.ZX.B)	Bug 8251315, Bug 8307880, Bug 8351127,Bug 8371282, Bug 8394462, Bug 8412899,Bug 8502340, Bug 8540809, Bug 8564908	Bulk invoice validation failed with error - Ora-20001:Summary tax line deleted by ebtax or Ora-20001:Frozen Tax Distributions deleted by ebtax	Included in 12.1.2 (7303033) and above	21-July-11
E-BUSINESS TAX (EBTAX)	Patch 10072294 10072294:R12.ZX.B	Bug 10072294, Bug 8635182	Invoice Workbench will no longer error while saving PO matched invoices when tax amount on multiple lines is updated using Tax Details window (See Note 1288314.1).	Apply on top of any 12.1.x instance	12-Jul-11
E-BUSINESS TAX (EBTAX)	Patch 10296081 10296081:R12.ZX.B	Several, please see Patch Readme	Invoice validation program now successfully revalidates adjusted invoices having manual tax line associated with an offset tax rate code and no longer give 'Summary Tax Line deleted by EBTax' error (See Note 1316316.1).	Apply on top of any 12.1.x instance Further instructions on Patch Readme	12-Jul-11
ORACLE ASSETS (FA)	Document 944315.1 Patch 8706842 (8706842:R12.FA.B)	n.a.	n.a.	Included in 12.1.2 (7303033) and above Very important post-application steps in Patch Readme	21-July-11
PUBLIC SECTOR ACCOUNTING (PSA) - Critical Rollup Patch	Patch 9100984 9100984:R12.PSA.B	n.a.	n.a.	Included in 12.1.3 (9239090) and above Very important pre and post-requisites in Patch Readme	21-July-11
ORACLE PAYMENTS (IBY) Oracle Payment Application Data Security Standard PA-DSS Consolidated Patch	Document 981033.1 / Patch 8937577 8937577:R12.IBY.B	n.a.	n.a.	Included in 12.1.3 (9239090) and above This PA-DSS consolidated patch allows Oracle Payments customers to benefit from the ongoing enhancements made to conform to PA-DSS requirements.	21-July-11
ORACLE RECEIVABLES - Rollup Patches	Patch 11776066 11776066:R12.AR.B	n.a.	n.a.	Apply on top of any 12.1.x instance Important post application steps in Patch Readme	21-Jul-11
ORACLE PAYABLES - General	Patch 8638587 8638587:R12.AP.B	Bug 8264122, Bug 8328412, Bug 7339389,Bug 7831956, Bug 8219586	Not able to create Supplier Contact with Phone having more than 15 chars through the Supplier Site Contacts Import, even though user can entern Contact Phone with 40 characters through the App. Additionally, the Import was not working if the Interface record contained vendor_site_code but not vendor_site_id. Supplier Import does not process URL information.	Included in 12.1.2 (7303033) and above	21-Jul-11
ORACLE PAYABLES - Accounting	Patch 10148895 10148895:R12.AP.B	Several, please see Patch Readme.	For CASH SOB, if invoice is PO matched and Accrue On Receipt Flag is Yes, then during payment accounting the PO Charge Account is being considered as the Accrual account instead of the AP Accrual Account.	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Accounting, Payments	Patch 11777929 11777929:R12.AP.B	Several, please see Patch Readme.	Whenever a payment is voided, accounting will be generated using transaction reversal, which reverses any entry that were created earlier through bypassing the extract/JLTs. For Federal, there is a requirement, where for certain transactions (prior year transactions) a different account must be used for reversal accounting entries.	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Invoices	Patch 10288184 10288184:R12.AP.B	Several, please see Patch Readme.	Invoices that are matched with closed PO's (Changes PO approval from Approved to Approved/Close), cannot be imported and throws the rejection reason as 'Inactive PO'.	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Payments	Patch 11063950 11063950:R12.AP.B	Several, please see Patch Readme	PPR is getting terminated even though Concurrent program Build Payment has not completed. If concurrent program Build Payments is in progress, PPR is should not terminate when clicking the TERMINATE icon.	Apply on top of any 12.1.x instance	21-Jul-11
ORACLE PAYABLES - Payments, Accounting	Patch 11676632 11676632:R12.AP.B	Several, please see Patch Readme	Payment Workbench now successfully creates manual payment for multiple invoices belonging to different supplier sites, without giving the "Check data is out-of-sync for check number: &CHECK_ID" error (See Note 1337426.1). Create Accounting program now successfully accounts manually adjusted refunds accounting events (See Note 1280535.1). Create Acccounting program now successfully accounts the maturity accounting events for foreign currency invoices having Bill Payables payment method and paid through "Pay-in-Full" functionality (See Note 1239323.1).	Apply on top of any 12.1.x instance Important instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Invoices	Patch 9001504 9001504:R12.AP.B	Several, please see Patch Readme	IPV distributions from price corrected credit memo do not get transferred to FA for mass additions.	Included in 12.1.3 (9239090) and above	21-Jul-11
ORACLE PAYABLES - Invoices, Payments	Patch 9643901 9643901:R12.AP.B	Several, please see Patch Readme	System allowed to apply prepayments on a standard invoice for more than the invoice amount, when multiple prepayments were selected from prepayment apply/unapply window in the standard invoice context. This happened when the total sum of the prepayments was more than the standard invoice amount but their individual value was less than equal to the standard invoice.	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Invoices	Patch 9695849 9695849:R12.AP.B	Several, please see Patch Readme	The default distribution account is cleared when user changes the GL date on the Lines tab, after validating the invoice or after the distributions are generated for the invoice.	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Invoices	Patch 10052153 10052153:R12.AP.B	Several, please see Patch Readme	After Allocating Freight and/or Miscellaneous line to Item lines using 'FULLY PRORATED' rule type from allocations window, allocated charges on individual ITEM lines were not visible, when allocation window was opened from ITEM line context.	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Invoices, Payments	Patch 11720134 11720134:R12.AP.B	Several, please see Patch Readme	Format Payment Instruction no longer errors out with "ORA-01422: exact fetch returns more than requested number of rows" when submitted using a responsibility having access to multiple operating units with one or more operating units having automatic offset and payment time withholding enabled (See Note 1308616.1) Payables will no longer generate withholding invoices at the time of invoice cancellation if the 'Create Withholding Invoice' is set to 'Payment' time (See Note 1291134.1)	Apply on top of any 12.1.x instance	21-Jul-11
ORACLE PAYABLES - Invoices	Patch 10431161 10431161:R12.AP.B	Several, please see Patch Readme	Invoice Workbench now prevents saving the invoice when a new invoice line is copied from a previous invoice line that had the GL date in closed period (See Note 1264960.1). Invoice Validation program now exclusively locks the selected invoices and are not available for update from Invoice Workbench (SeeNote 1264960.1). Invoice Workbench no longer allows cancelation of summary tax lines generated as part of prepayment application on standard invoices from Tax Details and displays error message "Cancellation of the Summary line is not allowed" (SeeNote 1216453.1). Invoice Workbench now correctly allows the reversal of a posted invoice distribution without changing the approval status of the parent distribution (See Note 1266869.1). Invoice Workbench no longer allows following actions: a) update amount and distribution type for existing tax distributions b) create manual tax distributions under inclusive tax item lines from the All Distributions window (See Note 1338001.1).	Apply on top of any 12.1.x instance	21-Jul-11
ORACLE PAYABLES - Invoices	Patch 10353568 10353568:R12.AP.B	Several, please see Patch Readme	Payables now successfully calculates payment time withholding tax amounts for invoices having reversed/discarded item lines by successfully allocating withholding amount over cancelled tax distributions (See Note 1338164.1). Invoice Validation program now continues bulk processing of invoices even when the process encounters an error during tax validation on any of the invoices (See Note 1184876.1) Payables now correctly calculates taxes that are based on distribution accounts for imported PO matched invoices (See Note 1338164.1). Payables now correctly populates the GL date on tax distributions by taking the GL date from the credit memo line instead of the standard invoice for credit memos created using Quick Credit functionality (See Note 1338164.1 and Note 1220114.1). Payables now successfully validates existing invoices having system generated tax distributions on item lines that were discarded after accessing "All Distributions" window of the Invoice Workbench (See Note 1338370.1).	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	12-Jul-11
ORACLE PAYABLES - Accounting	Patch 10409166 10409166:R12.AP.B	Several, please see Patch Readme	Create Accounting program now correctly creates payment clearing accounting entries for payments having bank charges associated with them. The program no longer gives the error "The account on the gain or loss line is invalid" while accounting such accounting events (See Note 1323394.1). Create Accounting program now successfully create accounting entries for prepayments that were unapplied after upgrade. The program no longer gives the error ORA-00001: unique constraint (XLA.XLA_DISTRIBUTION_LINKS_U1) violated while processing Invoice_ID :XXX" for such accounting events. (See Note 1205084.1). Create Accounting program now successfully creates accounting entries for foreign currency invoice payments having discounts when the accounting option is set as "Always" and Gain/Loss Calculation option is set to "Clearing" time. The program no longer gives the error "The total debits and the total credits do not balance for this subledger journal entry." (See Note 1296239.1).	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	12-Jul-11
ORACLE PAYABLES - Payments	Patch 11699958 11699958:R12.IBY.B	Several, please see Patch Readme	Invoices no longer remain in selected for payment status when the Payment Process Request fails during payment completion stage (See Note 1338425.1).	Apply on top of any 12.1.x instance	12-Jul-11
ORACLE PAYABLES - Payments	Patch 10234963 10234963:R12.IBY.B	Several, please see Patch Readme	External bank account update page now successfully retains the IBAN updated by user. (See Note 1265328.1).	Apply on top of any 12.1.x instance	12-Jul-11
ORACLE SUBLEDGER ACCOUNTING	Patch 11903966 11903966:R12.XLA.B	Several, please see Patch Readme	Create Accounting program now successfully a) Gives a warning 'No eligible transactions to account' only when transaction details are missing for unprocessed events b) Stops when the Error Limit is reached whenever FND_CONNECTION_TAGGING profile is set to Yes (See Note 1315042.1).	Apply on top of any 12.1.x instance Further instructions in Patch Readme.	12-Jul-11
ORACLE SUBLEDGER ACCOUNTING	Patch 11666797 11666797:R12.XLA.B	Several, please see Patch Readme	Concurrent execution of Online Accounting creating journal entries against Control Accounts no longer ends in error due to locking issues in control account balances calculation. Third Party Control Account Balances report has been modified to display warning if journal entries pending balances computation exist for the period for which the report is executed (See Note 1304736.1).	Apply on top of any 12.1.x instance Further instructions in Patch Readme.	12-Jul-11
ORACLE SUBLEDGER ACCOUNTING	Patch 10649546 10649546:R12.XLA.B	Several, please see Patch Readme	Invoices no longer go on Funds Check holds when there exists multiple entities for the same invoice in Subledger Accounting repository due to prior Funds Check failures (See Note 1338429.1).	Apply on top of any 12.1.x instance Further instructions in Patch Readme.	12-Jul-11

R12.1 Pre-Upgrade Patches

EBS Consolidated Upgrade Patch - Feb 2010

Customers who are planning to upgrade from Release 11i to 12.1.x, should apply the R12.1 EBS Consolidated Upgrade Patch (CUP) - Patch 7303029. The CUP is only applicable to 11i customers who have NOT already upgraded to 12.1.x. The CUP must be applied on top of an R12.1.1 APPL_TOP.
Release 12.1.x customers need NOT apply the CUP patch.

Financials Pre-Upgrade Patches - April 2011

There are several Oracle Financials Release 12.1 pre-upgrade patches that were released after the EBS CUP in Feb 2010. We are tracking the list via Document 1127593.1. Please review its content and apply the pre-upgrade patches before you complete your upgrade to Release 12.1.

MD5 Checksums for R12.1.1 Rapid Install Media [ID 802195.1]

MD5 Checksums for R12.1.1 Rapid Install Media [ID 802195.1]
Modified 21-JAN-2011 Type WHITE PAPER Status PUBLISHED

View Change log
Oracle EBusiness Suite R12.1.x Rapid Install
md5 Checksums

October 2010

Section 1: Overview
Section 2: Download md5 checksum results from Oracle
Section 3: Compare md5 checksums
Section 4: Disk overview, to be used when corrupted files are found
Section 1: Overview

After staging the Rapid Install software with the adautostg.pl script or downloading the Rapid Install software from Oracle Electronic Delivery, the md5 checksums for the staged directory structure can be used to validate the software integrity. Do this by running the md5sum program against the stage area using the oracle created checksum file. This is not an official development document - this procedure was performed/tested using the downloadable Rapidwiz media.

Section 2: Download md5 checksum results from Oracle

Download the md5 checksum results from Oracle as posted below into a local file, for example md5sum_.txt.

The attached files contain the md5 checksum results for every R12.1.1 release. Download the file corresponding to the used release and platform. The md5 checksum has been created without the startCD as it is often being updated, the checksum for the startCD's can be tested separately.

Release 12.1.1 Checksums currently available:
R12.1.1 - Windows
R12.1.1 - IBM AIX
R12.1.2 - Linux on IBM System z
R12.1.1 - Linux 32-bit
R12.1.1 - Linux 64-bit
R12.1.1 - Solaris Sparc 64-Bit
R12.1.1 - HP_UX
R12.1.1 - HP_UX Itanium
Release 12.1.x StartCD Checksums:
R12.1.1 startCD - Version 12.1.1.9
R12.1.1 startCD - Version 12.1.1.10
R12.1.1 startCD - Version 12.1.1.11
R12.1.2 startCD (Linux on IBM System z only) - Version 12.1.1.12.ZLINUX

Section 3: Compare md5 checksums

Compare the Stage with the md5sums downloaded from Oracle (md5sum_.txt). There should not be any FAILED entry in the output. If a FAILED entrie was found, then the stage area was not created successfully. The stage have to be re-created for every component indicating differences (FAILED).

Note: The following example assumes the stage exists in /u01 for Unix and Linux, or F:\ for Windows customers.
Execute the following example commands to check stage using the the md5 checksums

On Unix/Linux:
Install the md5sum utility for your platform if md5sum is not present on your system. If md5sum is not available from your OS Vendor for your OS version (for example HP 11.0), download and install the coreutils package from gnu.org .
$ cd /u01/StageR12
$ md5sum --check md5sum_Linux32.txt > md5sum_result.txt

On Windows:
MKS Toolkit or cygwin needs to be installed to be able to use mdm5sum.
F:\> cd StageR12
F:\StageR12> md5sum --check md5sum_Windows.txt > md5sum_result.txt

Note: The md5 checksum will validate the entire stage area and may take 10 minutes or more depending on hardware resources and system load.
Section 4: Disk overview, to be used when corrupted files are found

When a corrupted file is found the following can be used to identify which part needs to be re-downloaded from edelivery.

Release 12.1.1 Disk overview:
R12.1.1 - Windows
R12.1.1 - IBM AIX
R12.1.2 - Linux on IBM System z
R12.1.1 - Linux 32-bit
R12.1.1 - Linux 64-bit
R12.1.1 - Solaris Sparc 64-Bit
R12.1.1 - HP_UX
R12.1.1 - HP_UX Itanium

Sunday, August 21, 2011

Utilities for Troubleshooting Oracle Hyperion Enterprise Performance Management

Utilities for Troubleshooting Oracle Hyperion Enterprise Performance Management 11.1.2.0 or 11.1.2.1 [ID 1303200.1]

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

Modified 11-AUG-2011 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution
References

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

Applies to:
Hyperion Essbase - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Hyperion BI+ - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion Planning - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion Financial Management - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion BI+ - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Information in this document applies to any platform.
(1) \Oracle\Middleware\user_projects\epmsystem1\bin\ziplogs.bat|.sh
(2) \Oracle\Middleware\ohs\ccr\bin\
(3) \Oracle\Middleware\ohs\rda\rda.cmd
(4) \Oracle\Middleware\user_projects\epmsystem1\bin\epmsys_registry.bat|.sh
(5) \Oracle\Middleware\user_projects\epmsystem1\bin\validate.bat
Goal
This article aims to help users use various troubleshooting tools to validate or troubleshoot an installation of Oracle EPM 11.1.2.0. or 11.1.2.1
Solution
(1) A new troubleshooting tool introduced in Oracle EPM 11.1.2.1 is \Oracle\Middleware\user_projects\epmsystem1\bin\ziplogs.bat|.sh file. The output of this is generated in \Oracle\Middleware\user_projects\epmsystem1\diagnostics\ziplogs\EPM_logs__11.1.2.1.0.zip

(2) Oracle Configuration Manager (OCM) is an advanced tool which collects and evaluates settings from configuration files (but not Hyperion Registry) and stores them in a central database administered by Oracle. It was first introduced into EPM in version 11.1.2.0

(3) Remote Desktop Assistant (RDA) collects and zips up a large amount of information concerning the software and hardware environments of Oracle products. If Perl 5.1 or later is installed on the computer and accessible from the command line (test: perl -version), then run: \Oracle\Middleware\ohs\rda\rda.cmd from the command line to access the RDA tool. Alternately, precompiled RDA executables are available for several platforms.

(4) Configuration settings have been moved from configuration files to a database repository associated with Shared Services. These may be extracted to an HTML formatted file by running \Oracle\Middleware\user_projects\epmsystem1\bin\epmsys_registry.bat|.sh without parameters from the command line. The output is generated to file \Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports\registry.html The username/login/jdbc URL for the Hyperion/HSS registry are kept in \Oracle\Middleware\user_projects\epmsystem1\config\foundation\11.1.2.0\reg.properties file.

(5) A much enhanced validation tool is available in \Oracle\Middleware\user_projects\epmsystem1\bin\validate.bat. In EPM 11.1.2.1 the output files are of the form \Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports\instance_report_20YYMMDD_######.html (where YY is the year, MM is the month, DD is the day, and ###### is a unique integer). It also runs the tool under (1) and gives the output of that tool.

(6) Individual log files may be found in subdirectories under (those 'starred' are not collected by ziplogs):
\Oracle\Middleware\user_projects\domains\EPMSystem\servers\\logs *
\Oracle\Middleware\logs *
\Oracle\Middleware\wlserver_10.3 *
\Oracle\Middleware\user_projects\epmsystem1\tmp *
\Oracle\Middleware\ohs\cfgtoollogs\opatch *
\Oracle\Middleware\EPMSystem11R1\diagnostics\logs
\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\
\Program Files\Oracle\Inventory\logs
C:\Users\\Oracle\oradiag_\diag\
C:\Users\\.oracle\logs\

(7) Some debug tools (*) can be activated if under http://:19000/workspace/index.jsp > Navigate > Administration > Workspace Server Settings > Client Debug Enabled: is set to Yes (then click 'OK' button, close all browser windows, and restart browser).
* http://hostname:19000/workspace/debug/configInfo.jsp
* http://hostname:19000/workspace/debug/userInfo.jsp
* http://hostname:19000/workspace/debug/userGroupQuery.jsp

Other tools are available at these URLs (largely derived from validate.bat output). A non-Error response indicates that the web service of each particular application is active.:
http://hostname:19000/workspace/status
http://hostname:19000/workspace/BPMContext
http://hostname:8600/mappingtool/faces/info.jspx
http://hostname:10080/easconsole/console.html
http://hostname:16000/WebAnalysis
http://hostname:6373/oracle-epm-fm-webservices/ApplicationService
http://hostname:8300/HyperionPlanning/
http://hostname:13080/aps/APS
http://hostname:8200/hr/status.jsp
http://hostname:19091/awb/conf/AwbConfig.xml
http://hostname:8500/calcmgr/index.htm

References

Related

--------------------------------------------------------------------------------
Products
--------------------------------------------------------------------------------

•Middleware > Enterprise Performance Management > Essbase > Hyperion Essbase
•Middleware > Business Intelligence > Hyperion Query & Reporting > Hyperion BI+
•Middleware > Enterprise Performance Management > Planning > Hyperion Planning
•Middleware > Enterprise Performance Management > Financial Management > Hyperion Financial Management
•Middleware > Business Intelligence > Hyperion Query & Reporting > Hyperion BI+
Keywords
--------------------------------------------------------------------------------
CONFIGURATION; CONFIGURATION FILE; DEBUGGING; LOG FILE; PERFORMANCE MANAGEMENT; PERL; RDA; TROUBLESHOOT

Back to top

Copyright (c) 2007, 2010, Oracle. All rights reserved. Legal Notices and Terms of Use | Privacy Statement Rate this document
Article Rating Rate this document
Excellent
Good
Poor

Did this document help you?
Yes
No
Just browsing

How easy was it to find this document?
Very easy
Somewhat easy
Not easy
CommentsProvide feedback for this article. Please use 'Contact Us' for other feedback. Important Note: this feedback may be anonymously visible to other customers until processed by Oracle Support.

Cancel

EPM Suit Log Locations

EPM Suit Log Locations

\Middleware\user_projects\epmsystem1\diagnostics\logs\registry
\Middleware\user_projects\epmsystem1\diagnostics\logs\ReportingAnalysis
\Middleware\user_projects\epmsystem1\diagnostics\logs\services
\Middleware\user_projects\epmsystem1\diagnostics\logs\starter
\Middleware\user_projects\domains\EPMSystem\servers\FoundationServices0\logs
\Middleware\user_projects\domains\EPMSystem\servers\RaFramework0\logs
\Middleware\EPMSystem11R1\diagnostics\logs\install
\Middleware\user_projects\epmsystem1\diagnostics\logs\config
The reg.properties file located in \Middleware\user_projects\epmsystem\logs\config\foundation\11.1.2.0
ORACLE_MIDDLEWARE_HOME\user_projects\domains\EPMSystem\Servers\FinancialReporting0\logs

ORA-12504 When Using (HOSTNAME) Method For 11G Client/Database [ID 556996.1]

ORA-12504 When Using (HOSTNAME) Method For 11G Client/Database [ID 556996.1]

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

Modified 03-DEC-2010 Type PROBLEM Status PUBLISHED

In this Document
Symptoms
Cause
Solution
References

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

Applies to:
Oracle Net Services - Version: 11.1.0.6.0 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Checked for relevance on 14-MAY-2010.

The issue documented here has been resolved in an enhancement request since the original writing. Please refer to the notes below.
Symptoms
Connecting from an 11.1.0.x client using the HOSTNAME adapter fails with the error:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

However, the same client connection works fine using the LDAP, TNSNAMES, or EZCONNECT methods.

Cause
From 11g onwards, the feature of using the hostname provided in the /etc/hosts file, as the alias / service name has been changed. As a result, the user will have to provide the service name while connecting OR configure the target listener with a default service name:

This was justified by Bug.6374523 "CAN NOT USE HOSTNAME NAMING METHOD FROM 11G DATABASE" (which was closed as not a bug).

IMPORTANT NOTE: This issue was resolved by way of an enhancement request. The issue was handled in unpublished BUG 9271246 Abstract: REINTRODUCE DEPRECATED 10G EZCONNECT FUNCTIONALITY TO 11G.
There are interim patches available for multiple platforms on My Oracle Support. The patch will restore the functionality to pre-11g behavior.

Further clarification from the bug as to why there is a difference between 10g and 11g:

While connecting when you issue the following :
CONNECT username@alias

We get the following results depending on the version:

10g working case (when hostname would be used as the default service) -->
- The 'alias' gets resolved using the hostname adapter to the respective host.
- HOWEVER, you have not specified the service name, so the alias is itself used as the service name and the connect string generated has the service name filled up with the alias you specified.
- This string goes to the listener and the connection is fine.

11g non-working case (when the hostname cannot be used as the default service and the listener's default service is expected to be used) -->
- The 'alias' gets resolved using the hostname adapter to the respective host.
- HOWEVER, you have not specified the service name, so the alias is not used as the service name, and the service name is left blank in the connect string generated (the reason being is that we expect the listener to use the default service configured at its end, such as older versions used to do).
- This string with the "blank" service name goes to the listener and the ORA-12504 error is thrown, correctly indicating that the listener is not configured with the default service name.

Solution
With 11g, the way the HOSTNAME adapter is used has changed. You now have to use the hostname adapter as per the Net Services Administrator's guide.

**See IMPORTANT NOTE above. An enhancement request has been worked and a patch is available that will return the HOSTNAME adapter to pre-11g behavior.

Reference
The following is taken from the Oracle� Database Net Services Reference, 11g Release 1 (11.1), Part Number B28317-02 -- Chapter 7, Oracle Net Listener Parameters (listener.ora) :

"7.2.4.3 DEFAULT_SERVICE_listener_name

Purpose
Use the DEFAULT_SERVICE_listener_name parameter to enable users to connect to the database without having to specify a service name from client side.

In Oracle Database 11g, when a client tries to connect to the database the connection request passes through the listener. The listener may be servicing several different databases. If a service name is configured in this parameter, users may not necessarily need to specify a service name in the connect syntax. If a user specifies a service name, the listener will connect the user to that specific database, otherwise the listener will connect to the service name specified by the DEFAULT_SERVICE_listener_name parameter.

See Also:
Oracle Database Net Services Administrator's Guide for more information about the easy connect naming method

Default
There is no default value for the DEFAULT_SERVICE_listener_name parameter. If this parameter is not configured and a user does not specify a fully qualified service name in the connect syntax, the connection attempt fails. This parameter only accepts one value.

Example
DEFAULT_SERVICE_LISTENER=sales.us.acme.com "

1. Obtain and apply the interim patch for unpublished Bug 9271246 which will restore the functionality to pre-11g. If a patch does not exist for your platform, please request a backport from Oracle Support.

2. As one example, use the host / service_name in the connect string:
CONNECT username/password@host/service_name

OR

3. Configure the listener with a default service name as follows:
You need to add the following parameter to the listener.ora file for the 11g tns listener
DEFAULT_SERVICE_listener_name= ( service_name )
where service_name is the target database name.
After these changes you need to restart the listener for the changes to take place.

References
http://st-doc.us.oracle.com/11/111/network.111/b28317/toc.htm
BUG:6374523 - CAN NOT USE HOSTNAME NAMING METHOD FROM 11G DATABASE

Related

--------------------------------------------------------------------------------
Products
--------------------------------------------------------------------------------

•Oracle Database Products > Oracle Database > Net Services > Oracle Net Services
Keywords
--------------------------------------------------------------------------------
EASY CONNECT; TNSNAMES; EZCONNECT; HOSTNAME; ADAPTER
Errors
--------------------------------------------------------------------------------
ORA-12504; 12504 ERROR

Back to top

Copyright (c) 2007, 2010, Oracle. All rights reserved. Legal Notices and Terms of Use | Privacy Statement Rate this document
Article Rating Rate this document
Excellent
Good
Poor

Did this document help you?
Yes
No
Just browsing

How easy was it to find this document?
Very easy
Somewhat easy
Not easy
CommentsProvide feedback for this article. Please use 'Contact Us' for other feedback. Important Note: this feedback may be anonymously visible to other customers until processed by Oracle Support.

Cancel

ORA-12514

===============================================================================================

SQL> ALTER SYSTEM SET LOCAL_LISTENER="(address=(protocol=TCP)(host=10.10.10.99)(port=1523))"SCOPE=BOTH;

SQL> ALTER SYSTEM SET LOCAL_LISTENER='EPMDB' SCOPE=BOTH;

For instance specific include the sid='instance_name' parameter:

SQL>ALTER SYSTEM SET LOCAL_LISTENER="(address=(protocol=TCP)(host=10.10.10.99)(port=1523))" SCOPE=BOTH SID='instance_name';
Where instance_name is the unique name for the instance.

Saturday, August 20, 2011

Financial Management Error: "Illegal operation attempted on a registry key that has been marked for deletion" during HFM related activities.

Financial Management Error: "Illegal operation attempted on a registry key that has been marked for deletion" during HFM related activities. [ID 1303843.1]

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

Modified 01-JUN-2011 Type PROBLEM Status PUBLISHED

In this Document
Symptoms
Changes
Cause
Solution
References

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

Applies to:
Hyperion Financial Management - Version: 11.1.2.0.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms
In Financial Management (HFM) application , you may receive the following error message when attempting various HFM related operations such as Journal Entries, connecting via Smartview to HFM, or with Financial Reporting:

Illegal operation attempted on a registry key that has been marked for deletion.

An error has occurred. Please contact your administrator.
Error Number:70
Error Description:Permission denied
Error Source:Microsoft VBScript runtime error
Page On which Error Occurred:/hfm/loadextract/ExtractJournals.asp
Changes
This issue occurs only in EPM systems deployed on Windows 2008 server, so if a OS upgrade had occurred, this error may be thrown.
Cause
The identity user initially logged on to the server when the application launched. The issue happens when the identity user logs off and the COM+ application can no longer read registry keys in the profile of the identity user because of a new User Profile Service functionality of forcing the unload of the user profile on Windows 2008 when the user logs off.

Solution
To resolve this issue, make the following change on all Financial Management servers in the environment:

1.Run group policy editor (gpedit.msc)
2.Expand to: Computer Configuration -> Administrative Templates -> System -> UserProfiles -> Do not forcefully unload the user registry at user logoff
3.Check the settings and change it from “Not Configured” to “Enabled”
4.Reboot the servers

Best Practice For Hyperion Enterprise Backups and Virus Scanning

Best Practice For Hyperion Enterprise Backups and Virus Scanning. [ID 1100507.1]

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

Modified 31-MAR-2011 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution
Best practices for backing up an Hyperion Enterprise Application
Terminology
Backing up the application
Backup an Enterprise application using an AutoPilot taskflow
Is it possible to create the application backup profile and the scheduling on a different server to where the application directory is located?
Disconnect Citrix users from system before taking backups
Restoring the application
Virus Scanning
Versions 6.5 and above
Incremental Backups
Still have questions?

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

Applies to:
Hyperion Enterprise - Version: 5.0.1.0.00 and later [Release: 5.0 and later ]
Information in this document applies to any platform.
This knowledge document is a replacement for Document 588295.1, 587370.1, 584893.1, 763059.1, 585106.1 and 585862.1 which have been deleted.
Goal

Back-up guidelines for backing up an Oracle Hyperion Enterprise Application where Internal back-up is not used or in version where it is not available.

Virus Scanning best practice for Hyperion Enterprise Applications.

Solution
Best practices for backing up an Hyperion Enterprise Application
Terminology
This article uses the term “Application Folder” (App Folder) to describe the Enterprise Database folder containing the Database files.
This is not the same as the “Software Folder” which contains the Executable code and associated DLL files etc.

Note : the App Folder may be a sub folder of the Software Folder, please be aware of this. The location of both these folders are user definable at install/app creation time.

The default Software Folder being C:\Progam files\Hyperion solutions\Hyperion Enterprise.

Application Name (APPNAME) this is the “name “ of a particular Enterprise Database created by the user..

To identify your Software Folder, search for the file Hypent.exe, your should only have one copy, resident in your Software Folder.

The App Folder contains the following files amongst other.

APPNAME.EXA
APPNAME.INI
APPNAME.lok
APPNAME.use

It also has sub folders:

\data
\reports
\inbox
\outbox

The App folder is again user definable but, the above sub folders are the default sub folder names.

The Application folder is defined by the APPPATH parameter in your Hypent.ini under each [APPNAME] section. You will find the hypent.ini in the citrix home folder or user profile folder.

Note the hypent.ini may contain several Application defined by the appropriate [APPNAME] sections.

Backing up the application

We do not recommend the use of software that will backup Enterprise files even if they are open. The common name for this process is "Open File Agent". The possibility for corrupting all or part of the database with files open during a backup process is too great.

Always back up your applications and data before and after you perform significant work on your applications. You should back up an application when
you perform the following operations:

•Install software upgrades.
•Implement new applications.
•Application Maintainance.

•Run rollovers.
•Conduct closings.
•Enter a large amount of data.
Develop a process for performing backups that is separate from network and corporate backup procedures. Network and corporate backup procedures might not consider your closing cycles and other aspects of your financial data.
You should schedule backups based on how much and how often your data changes.
You should be able to go back to any definitive point to evaluate your data. For example, if you conduct month-end closings, you should be able to access your month-end closing data from previous months or years.

Always ensure there are no users logged on to any Enterprise or Reporting module when the back-up starts.
Set a Back-Up Window (time) in which users know not to log on to the application while the back-up takes place.

An alternative that some clients use when there is no time when all users are out of the database would be to create an AutoPilot routine that extracts security, system, formulas, journals, and data for all categories daily or as often as needed. Then if you cannot get to a clean backup to restore an application, you have the means to rebuild the database. A further precaution would be to have two different routines that extract to different filenames. By running each on alternate days, you will be assured of good extracts no more than one or two days old. AutoPilot can also be used to build a new application.

Always back-up entire APP FOLDER never parts of APP FOLDER

Backup an Enterprise application using an AutoPilot taskflow

When creating the AutoPilot routine, the steps may look like this:

1. Change Application.

Change from a local dummy application to the production application.
Log into the application with an admin account.

2. Extract Security.
3. Extract an Enterprise Application.
4. Extract Logic.
5. Change Category.
6. Extract Enterprise data.

Use an entity list with all base entities.
Use an account list with all accounts.
Include Global.

7. Extract Journals.

Include all periods.

8. Change Category.
9. Extract Enterprise data.
10. Extract Journals.
11. Repeat steps 8-10 for all categories.
12. Copy reports from the Reports folder.

Use Execute File Management Commands and use the Copy function.

13. Change Application.
Change back to dummy application.

By changing from a local dummy application to the production app on the server, then back to it when done, any automated backup can still run without a user in the production application

Is it possible to create the application backup profile and the scheduling on a different server to where the application directory is located?
No, it is not possible to have the application backup profile and the scheduling on a different server to where the application files are located. It should be set up on the same server as the application directory.

Disconnect Citrix users from system before taking backups
We cannot recommend to use any kind of script to perform logout/disconnect before backup is taken.

We strongly advise NOT to use the 'kill' command to terminate Hyperion Enterprise sessions. This command has been known to cause issues with the software. It has resulted in clients having to reinstall software.

Below is a method that some clients are using to get users to logout before taking a backup:
1. Prevent new logons (could be done through Citrix Metaframe).
2. Prompt users to logout from the application several times (could be done through Citrix Metaframe).
3. If users still in the system, a reboot would be preferred instead of the 'kill' command as the Operating System takes care of the disconnection in a milder way than the 'kill' command.

Test in a test environment first. Make sure that the routine minimizes the risk of users doing any changes to the system, data loads, consolidations, etc. when the disconnection is performed.

Restoring the application

The entire database must be restored from the same backup tape.
We do not recommend partial restores under any circumstances. With a partial restore, there is a potential for internal signatures to no longer match causing data to be "lost".

Before restoring a back-up, ensure users are not logged in to any Enterprise module, Enterprise Reporting or any addons i.e Retrieve, Schedules, Dataextend.

When restoring you have the option to either overwrite the present app folder (suggest you clear it first). If you do overwrite the users will be able to connect to the restore with no changes needed.

If you restore to a new App Folder , the users will have to use the “Add Application” option at their logon screen to locate the restored folder and then add the restored application. When they do this, the reference to that particular application is overwritten with the new location within hypent.ini.

Note you can only have one instance of an APPNAME in your hypent.ini file at any one time.

When the users add an APPNAME that is already there, they get a message warning this will Overwrite the Application. It is only the link via the hypent.ini file that gets overwritten and not the Application itself.

Never restore partial applications. ALWAYS THE COMPLETE APP FOLDER.

If the software folder is damaged, run the install program again and select the REPAIR OPTION or run a complete re-install. If you restore a Software Folder form back-up you may run into file registration issues.

Virus Scanning

The APP FOLDER should not be scanned live scanned for viruses.

Exclude the APP FOLDERS form live virus scanning.

Run a full scan over the APP FOLDERS daily when users are not active.

The danger is that the virus scanning software locks a file while scanning, and Enterprise cannot then lock the file itself.

Make sure users do not store office documents in the APP FOLDER as these can harbor viruses and need to be live scanned.

Versions 6.5 and above

Enterprise version 6.5.x and 6,5,1.x include an internal back-up routine which does allow back-ups to be taken with active users.

This functionality was not available in earlier versions…

Incremental Backups

Incremental backups are not recommended for Hyperion Enterprise applications.
The recommended method is to make a backup of the entire application folder including all subfolders whilst all users are logged out of the application
If it is not possible to ensure all users are logged out an application before performing a backup, consider upgrading to Enterprise 6.5 or later where backups can occur whilst users are logged into the application.

Still have questions?
To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the Hyperion Enterprise Community.

Related

Recommendations Regarding Antivirus Settings for Enterprise Performance Management (EPM) System Products

Recommendations Regarding Antivirus Settings for Enterprise Performance Management (EPM) System Products [ID 1315173.1]

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

Modified 28-JUL-2011 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution

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

Applies to:
Hyperion Essbase - Version: 9.3.0.0.00 to 11.1.2.1.000 - Release: 9.3 to 11.1
Information in this document applies to any platform.
Checked for relevance on 27-JUL-2011
Goal
Are there any recommendations with regards to antivirus settings for the EPM System?

Solution
The scanning executed by anti-virus software can be a source of performance issues with EPM System products. Each time a user accesses any resource on the server, anti-virus software will try to open the object and scan it. Typically when files are updated or accessed, anti-virus software will lock the object to scan the file.

The recommendation is for the HYPERION_HOME or MIDDLEWARE_HOME directories to be excluded from anti-virus software scans and only scanned on a scheduled basis while the EPM products are shutdown.

This information is documented in the Oracle Hyperion Enterprise Performance
Management System Tips and Tricks from EPM System Infrastructure Development: Issues 1-72 which is accessible online:

http://www.oracle.com/technology/products/bi/resource-library.html

Related

--------------------------------------------------------------------------------
Products
--------------------------------------------------------------------------------

•Middleware > Enterprise Performance Management > Essbase > Hyperion Essbase
Keywords
--------------------------------------------------------------------------------
ANTIVIRUS; ENTERPRISE PERFORMANCE MANAGEMENT; PERFORMANCE MANAGEMENT; SCAN

Back to top

Copyright (c) 2007, 2010, Oracle. All rights reserved. Legal Notices and Terms of Use | Privacy Statement Rate this document
Article Rating Rate this document
Excellent
Good
Poor

Did this document help you?
Yes
No
Just browsing

How easy was it to find this document?
Very easy
Somewhat easy
Not easy
CommentsProvide feedback for this article. Please use 'Contact Us' for other feedback. Important Note: this feedback may be anonymously visible to other customers until processed by Oracle Support.

Cancel

How To Successfully Install The Oracle EPM System 11.1.2.0.0 Essbase In A Windows Server

How To Successfully Install The Oracle EPM System 11.1.2.0.0 Essbase In A Windows Server [ID 1110424.1]

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

Modified 22-DEC-2010 Type FAQ Status PUBLISHED

In this Document
Purpose
Questions and Answers

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

Applies to:
Hyperion Essbase - Version: 11.1.2.0.00 to 11.1.2.0.00 - Release: 11.1 to 11.1
Information in this document applies to any platform.

Purpose
Oracle Essbase is a multi-dimensional database that is globally used to process financial data. With the new installer and the numerous assemblies, at times it becomes a challenge to properly install the server. This note intends to provide you some information that may help with the installation.

Questions and Answers
Where can I get the Installer and the Assemblies to install Essbase 11.1.2.0.0?

•To obtain the installer, go to the Oracle eDelivery website ( http://edelivery.oracle.com ) and follow the next steps:
•Log in to the download site
•Select the Product Pack: Oracle Enterprise Performance Management System
•Select the Platform: Microsoft Windows (32-bit) or the Platform of your choice
•Push the Go button
•Click on the link "Oracle Enterprise Performance Management (11.1.2.0.0) Media Pack for Microsoft Windows (32-bit)"

What do I need to download from the eDelivery site?

Note: The part numbers listed in the example below are for the Windows 32-Bit Platform only, the part number will vary depending on the platform.

V20850-01 Oracle Hyperion Enterprise Performance Management System Installer, Fusion Edition Release 11.1.2.0.0 for Microsoft Windows (32-bit)
V20799-01 Hyperion Enterprise Performance Management System Foundation Services Release 11.1.2.0.0 for Microsoft Windows (32-bit) Part 1 of 4
V20800-01 Hyperion Enterprise Performance Management System Foundation Services Release 11.1.2.0.0 for Microsoft Windows (32-bit) Part 2 of 4
V20801-01 Hyperion Enterprise Performance Management System Foundation Services Release 11.1.2.0.0 for Microsoft Windows (32-bit) Part 3 of 4
V20802-01 Hyperion Enterprise Performance Management System Foundation Services Release 11.1.2.0.0 Part 4 of 4
V20843-01 Oracle Hyperion Enterprise Performance Management System Additional Content Release 11.1.2.0.0
V20779-01 Oracle Hyperion Calculation Manager Release 11.1.2.0.0
V20782-01 Oracle Hyperion Enterprise Performance Management Architect, Fusion Edition Release 11.1.2.0.0
V20783-01 Oracle Essbase Release 11.1.2.0.0 Part 1 of 2
V20790-01 Oracle Essbase Release 11.1.2.0.0 Part 2 of 2 for Microsoft Windows (32-bit)
V20792-01 Oracle Essbase Clients Release 11.1.2.0.0
V18591-01 Oracle WebLogic Server 11gR1 (10.3.2) for Microsoft Windows (32-bit)

Optional Deliverables (Recommended)
V20778-01 Oracle Hyperion EPM System Release 11.1.2.0.0 - Start Here: Installation Documents and Readmes - English
V20791-01 Oracle Essbase Spreadsheet Add-in Release 11.1.2.0.0
V20842-01 Oracle Hyperion Smart View for Office, Fusion Edition Release 11.1.2.0.0 for Microsoft Windows

•On your server, create a directory where the compressed files are going to be stored: (i.e. [Drive]:\EPM11R2_ZIPS )
•Download the files to the designated target directory.

What am I going to do with all the compressed files?

•Uncompress all the files, starting with the Installer, to a directory whose name does not contain any spaces.You could create a directory at the root level (i.e. C:\EPM11R2_Installer )
•When done, ensure that the "assemblies" directory is populated with the files you uncompressed.
How do I run the installer?

•To run the installer, go to the installer directory ( i.e. C:\EPM11R2_Installer ) and run the following command: installTool.cmd, this will start a console that will launch the Oracle Universal Installer.

What do I select during the installation?

•After you pass the initial panels, you can select the New Installation and the radio button "Chose components individually" This will give you the ability to select the components by product instead of by tier.
•For Essbase, check all the options that you would like to install.
•Continue with the installation
What do I need to configure after the installation?

•You need to configure Shared Services (Foundation, EPMA and Calc Manager) and the Essbase products that you installed.
•Ensure that you have the Relational Database information ready before you start the configuration phase.
How can I test if Essbase is working?

•You could connect to the Essbase server via EAS, ESSCMD or MaxL to ensure that is fully operational.
•You could also check the Essbase.log and ensure that the correct initialization took place.

Related

--------------------------------------------------------------------------------
Products
--------------------------------------------------------------------------------

•Middleware > Enterprise Performance Management > Essbase > Hyperion Essbase
Keywords
--------------------------------------------------------------------------------
DYNAMIC ADV FAQ; DYNAMIC ADV INSTALL INDEX; INSTALL; INSTALLATION; DYNAMIC ADVSETUP

Back to top

Copyright (c) 2007, 2010, Oracle. All rights reserved. Legal Notices and Terms of Use | Privacy Statement Rate this document Article Rating Rate this document
Excellent
Good
Poor

Did this document help you?
Yes
No
Just browsing

How easy was it to find this document?
Very easy
Somewhat easy
Not easy
CommentsProvide feedback for this article. Please use 'Contact Us' for other feedback. Important Note: this feedback may be anonymously visible to other customers until processed by Oracle Support.

Cancel

Internet Explorer 7 (IE7) and Internet Explorer 8 (IE8) Recommended Settings for Oracle Hyperion Products

Internet Explorer 7 (IE7) and Internet Explorer 8 (IE8) Recommended Settings for Oracle Hyperion Products [ID 820892.1]

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

Modified 08-AUG-2011 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution

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

Applies to:
Hyperion Financial Management - Version: 9.2.1.0.00 to 11.1.2.0.00 - Release: 9.2 to 11.1
Information in this document applies to any platform.

Goal
Following settings should be applied in order for Oracle Hyperion Products to work correctly with Internet Explorer 7 (IE 7) and Internet Explorer 8 (IE 8).
IE 8 is supported with versions 11.1.2 and 9.3.3 of Oracle Hyperion Products. For version 11.1.1.3 it is supported only for: Shared Services, Performance Management Architect, Calculation Manager, Planning, Financial Management, EPM Workspace with Patch:9314073, Financial Reporting with Patch:9657652, Interactive Reporting, Web Analysis, FDM.

For more details about supported software versions visit Oracle Enterprise Performance Management Products Supported Platforms Matrices.

Solution
1. Configure browser to check for new version every time user visits a page

•Open Internet Explorer
•Go to Tools > Internet options > General

•In 'Browsing history' section select 'Every time I visit the webpage'

•Click Ok, then Apply.
2. Disable default pop-up blocking

•Open Internet Explorer
•Go to Tools > Internet options > Privacy tab

•Uncheck 'Turn on Pop-up Blocker'
3. Add workspace URL to trusted sites

•Open Internet Explorer
•Go to Tools > Internet options > Security tab

•Select Trusted sites from Select a zone to view or change security settings.

•Type your workspace URL in form http://workspaceserver:portnumber in 'Add this website to the zone'
•Uncheck 'Require server verification (https:) for all sites in this zone'
•Click Add, then Close.
•Click Ok and Apply.
4. Minimize security setting for trusted sites

•Open Internet Explorer
•Go to Tools > Internet options > Security tab
•Select Trusted Sites from select a zone to view or change security settings

•Select custom level

•From Reset to list select Low
•Click Ok
•Click Apply, then Ok
5. Customize security settings

•Open Internet Explorer
•Go to Tools > Internet options > Security Tab > Custom Level
•In 'Miscellaneous' section enable the option "Allow script-initiated windows without size or position constraints"
•In 'ActiveX controls and plug-ins' section enable “Run ActiveX controls and plug-ins” and “Script ActiveX controls marked safe for scripting.”
6. Enable option "Always allow session cookies".

•Open Internet Explorer
•Go to Tools > Internet options > Privacy Tab > Advanced > Check the "Override automatic cookie handling" and accept the first and third party cookies and check the "Always allow session cookies" option.
7. Disable option "Enable Native XMLHTTP".

•Open Internet Explorer
•Go to Tools > Internet options > Advanced Tab > Uncheck the option "Enable Native XMLHTTP".

Related

--------------------------------------------------------------------------------
Products
--------------------------------------------------------------------------------

•Middleware > Enterprise Performance Management > Financial Management > Hyperion Financial Management
Keywords
--------------------------------------------------------------------------------
DYNAMIC ADV OVERVIEW; DYNAMIC ADV TROUBLESHOOT; HFM; IE 7; IE 8; INSTALL & CONFIGURE; WORKSPACE; DYNAMIC ADV BEST PRACTICES

Back to top

Copyright (c) 2007, 2010, Oracle. All rights reserved. Legal Notices and Terms of Use | Privacy Statement Rate this document Article Rating Rate this document
Excellent
Good
Poor

Did this document help you?
Yes
No
Just browsing

How easy was it to find this document?
Very easy
Somewhat easy
Not easy
CommentsProvide feedback for this article. Please use 'Contact Us' for other feedback. Important Note: this feedback may be anonymously visible to other customers until processed by Oracle Support.

Cancel

Friday, August 19, 2011

Utilities for Troubleshooting Oracle Hyperion Enterprise Performance Management

Operating System Files Are Unstable Following EPM System 11.1.2 Installation on Windows 2008 Server

Operating System Files Are Unstable Following EPM System 11.1.2 Installation on Windows 2008 Server [ID 1243494.1]

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

Modified 26-OCT-2010 Type PROBLEM Status PUBLISHED

In this Document
Symptoms
Cause
Solution

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

Applies to:
Hyperion Financial Data Quality Management - Version: 11.1.2.0.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms
After running the EPM system installer and rebooting the Windows 2008 server the machine is unreachable.

The 'Server' service (Lanman) is not running successfully.

The Server is a brand new server with the Operating System installed from scratch. The EPM System is installed using the installer. Following the installation the server is rebooted. When the reboot is complete, the connection to the server with RDP does not function.

Many windows services are not running (i.e Server service).

OS is Windows 2008 Standard x64 with SP2

Cause

The Windows System File Checker was ran on the server following the installation. According to the logs generated from the file checker the 'atl.dll' file was corrupted. The atl.dll file is part of Microsoft Visual C++ 2005 SP1 (vc2005sp1) (a component of the EPM installer) and Microsoft Visual C++ 2008 SP1 (vc2008sp1) which was installed before the EPM installation process.

Solution

In safe mode run the windows system file checker tool:

System File Checker gives an administrator the ability to scan all protected files to verify their versions. If System File Checker discovers that a protected file has been overwritten, it retrieves the correct version of the file from the cache folder (%Systemroot%\System32\Dllcache) or the Windows installation source files, and then replaces the incorrect file. System File Checker also checks and repopulates the cache folder.

You must be logged on as an administrator or as a member of the Administrators group to run System File Checker. If the cache folder becomes damaged or unusable, you can use the sfc /scannow, the sfc /scanonce, or the sfc /scanboot commands to repair its contents.

System File Checker Tool Syntax
Sfc [/Scannow] [/Scanonce] [/Scanboot] [/Revert] [/Purgecache] [/Cachesize=x]

/Scannow: Scans all protected system files immediately and replaces incorrect versions with correct Microsoft versions. This command may require access to the Windows installation source files.

Thursday, August 18, 2011

Script to start HFM

Script to start HFM

cd "C:\Oracle\Middleware\user_projects\epmsystem1\bin"
#Mandate:
call startFoundationServices.bat
call startRaFrameworkAgent.bat
call startRaFramework.bat
call startOHS.bat

#HFM:
call startHFMManagementService.bat
call startHFMWebServiceManager.bat

#Essbase:
#call startEssbase.bat
#call startEssbaseAdminServices.bat
#call startAnalyticProviderServices.bat
#call startPlanning.bat
#call startRMI.bat

#Optional:
#call startFinancialReporting.bat
#call startWebAnalysis.bat
#call startErpIntegrator.bat
call startFDMTaskManager.bat
call startFMWebServices.bat
call startHFMDMEListener.bat

EPM Session Time Out Errors [ID 1110718.1]

EPM Session Time Out Errors [ID 1110718.1]
Modified 10-AUG-2011 Type TROUBLESHOOTING Status PUBLISHED
In this Document
Purpose
Last Review Date
Instructions for the Reader
Troubleshooting Details
Planning
EAS
BI+
HFM
FDM
Performance Suite

Applies to:

Middleware > Enterprise Performance Management
Information in this document applies to any platform.
Purpose

The purpose of this article is a quick reference to documents to help you troubleshoot time out issues pertaining to various Hyperion EPM Products
Last Review Date

August 10, 2011
Instructions for the Reader

A Troubleshooting Guide is provided to assist in debugging a specific issue. When possible, diagnostic tools are included in the document to assist in troubleshooting.
Troubleshooting Details

SmartView
Doc ID 1056749.1 Increase Timeout Settings for Smart View in IIS (Internet Information Services)
Doc ID 865581.1 Increase Timeout Settings for Smart View in IIS (Internet Information Services)
Doc ID 985628.1 Smart View Connection Timing Out After 30 Minutes of Inactivity
Doc ID 1075232.1 Get error: The request timed out. Contact your administrator to increase netRetrycount and netRetryinterval when running a report in Smart View
Doc ID 872242.1 Getting Time Out Error While Running A Calc Script Using Smart View in Excel.

Planning

Doc ID 755406.1 Business Rules that take more then Five Minutes to Execute from Workspace Replicate Sessions
Doc ID 1050602.1 Workspace/Planning/Business Rules Deployed on WebLogic Timing Out

EAS

Doc ID 751857.1 Set the Essbase Administration Services Session Timeout Interval

BI+

Doc ID 748586.1 How to change Workspace, WebAnalysis and HFM Timeout Values
Doc ID 803523.1 New Session Timeouts Do Not Apply to Analyzer User Sessions

HFM

Doc ID 583878.1 Change Session Timeout in Financial Management

FDM

Doc ID 731324.1 Time-out Setting Change

Performance Suite

Doc ID 583349.1 Change the session timeout for Hyperion Performance Suite

Where are Application Install Inventories Stored in Oracle EPM 11.1.2.1

Where are Application Install Inventories Stored in Oracle EPM 11.1.2.1 [ID 1304532.1]
Modified 20-APR-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution

Applies to:

Hyperion BI+ - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Hyperion Essbase - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion Planning - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Information in this document applies to any platform.
Goal

Identify the location of software inventories associated with Oracle EPM 11.1.2.1.
Solution

It is important to know where installation inventory lists are stored: to detect the completeness of an install, to determine whether a patch has been applied, or to delete as part of a reinstall.
\Oracle\Middleware\EPMSystem11R1\oraInst.loc points to the location of the central inventory. oraInst.loc may have been installed in a previous Oracle install on Unix in: /var/opt/oracle or /etc or $HOME (of the user installing Oracle software), preventing the 'reinstall' of OHS or other software.

\Program Files\Oracle\Inventory is typically the location of the central inventory (despite the name 'central inventory', there may exist mutually exclusive inventories generated with the install of other Oracle products). On Unix/Linux the central inventory is in the installer's 'home' directory.

A local inventory is typically found in \Oracle\Middleware\EPMSystem11R1\.oracle.products

A local pointer (.oracle.instances) to the instance(s) set by EPM 11.1.2.0 and EPM 11.1.2.1 (and referenced by EPM 11.1.2.1 Installer for 'Apply Maintenance Release' option) is put in C:\Users\\ Ensure the same user installs both versions.

\Oracle\Middleware\EPMSystem11R1\.oracle.products is used to recreate an inventory if need be (but a regeneration of an inventory will exclude service fixes/patches installed via OPatch. To recreate an inventory after one is corrupted...run \Oracle\Middleware\EPMSystem11R1\OPatch\createInventory.bat.)

\Oracle\Middleware\ohs\.patch_storage (holds records of previous OPatches)

Preparing a Microsoft Windows Server for Installation of EPM 11.1.2.x

Preparing a Microsoft Windows Server for Installation of EPM 11.1.2.x [ID 1303078.1]
Modified 27-JUL-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
References

Applies to:

Hyperion Essbase - Version: 11.1.2.1.000 to 11.1.2.1.000 - Release: 11.1 to 11.1
Hyperion BI+ - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion Planning - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Microsoft Windows x64 (64-bit) - Version: 2008 R2
The compression/decompression utility should be capable of handling long file paths (a free utility which fulfills this requirement may be downloaded from http://www.7-zip.org)

Database clients (in a preferred 64-bit environment) should be installed in the order of 32-bit then 64-bit. Products which require 32-bit clients include Interactive Reporting and Financial Data Quality Management.
Goal

Many applications can be installed in EPM 11.1.2.0 and EPM 11.1.2.1 environments. These require careful preparation to prevent installation and configuration failures. This article makes some best practice recommendations that will allow a new installation to be robust. The EPM 11.1.2.0 release did not offer upgrade or migration features, so many customers are expected to move up to and take advantage of the new features of EPM 11.1.2.1. In most cases customers who have production environments containing earlier versions of the Hyperion System 9 or Oracle EPM 11 families will need to and want to move to higher specification environments to meet the certification requirements of the environment of this set of products.
Solution

(1) GREENFIELD/CLEAN INSTALL
It is recommended to start with a clean install. An attempt to install on top of a pre-existing Hyperion System 9.2.1, 9.3.3, or 11.1.1.3 installation would likely lead to the loss of essential data and configuration files needed for moving to 11.1.2.1 while simultaneously disabling the prior version.

(2) MICROSOFT WINDOWS VERSION
Earlier versions of Hyperion System 9 and Oracle Hyperion EPM 11.1.1.x were not certified against currently supported operating systems and databases so it is unlikely that they were installed in environments certified to work with EPM 11.1.2.1.

Since many of the applications of EPM 11.1.2.1 are 64-bit savvy and could benefit from the optimization features of Microsoft Windows 2008 R2 64-bit...that would be recommended.

(3) COMPRESSION/DECOMPRESSION
As mentioned above, ensure that your compression/decompression utility will handle long file path names (greater than the 260 character Microsoft Windows path limitation).

http://msdn.microsoft.com/en-us/library/aa365247%28VS.85%29.aspx#maxpath

(4) TURN OFF MICROSOFT'S USER ACCOUNT CONTROL
UAC (Microsoft User Account Control) is a feature of Microsoft Vista and Windows 2008.

When the hyperlink is clicked, the next window should NOT have a check box checked.

The screen layout for Microsoft Windows 2008 R2 is:

(5) ENSURE MEMORY AND CPU NUMBERS ARE ADEQUATE
If all Hyperion products that can be accessed via Oracle EPM Foundation 11.1.2.x were installed and activated it could easily require around 14 gigabytes or more of RAM. This pretty much eliminates consideration of a 32-bit install (where each machine can access at best 4 gigabytes of memory...and no less than 1 gigabyte of that would be for the operating system). The processing load for many separate Java virtual machines would also make it practical to have four or more CPUs. The memory and CPU requirements might be reduced somewhat if fewer applications or JVMs were run, but it would not be advisable to run even a test and development install with fewer than two CPUs and 8 gigabytes of RAM as there are around two dozen processes to support. Technical support is not equipped to estimate the actual production capacity of an environment...there are too many variables involved. It would be best to ramp up the system with actual processes and loads and project from that.

(6) PREPARING DATABASE CLIENTS
The following applications require the installation of a full Oracle database client on the machines where they will be installed.

Performance Management Architect Dimension server
Financial Management application server
FDM Application Server and any machine that has FDM Workbench
Strategic Finance
If an Oracle database is used, a full database client with Oracle Call Interface (Oracle 11.1.0.6 or later) must be installed. Ensure a Net Service Name/tnsnames.ora is configured for remote databases.

(7) PREPARING DATABASE REPOSITORIES
A number of different relational database repositories must be prepared if their matching applications will be configured, preferably with different schema owners. Ideally the database will be on a separate stand alone server behind a firewall.
CalcManager
DisclosureManagement
EnterprisePerformanceManagementArchitect
ERPIntegrator
Essbase
FDM
FinancialClose
FinancialManagement
PerformanceScorecard
PlanningApplication
PlanningSystem
ProfitabilityAndCostManagement
ReportingAndAnalysis
SharedServices
ORACLE DATABASE REPOSITORY:
Server versions supported include: Oracle 10.2.0.4+, 11.1.0.7+, or 11.2.0.1+
HFM, HSS, and/or EPMA instances require at least 1GB of RAM and Automatic Memory Management.
The database encoding should preferably be AL32UTF8 (UTF8 is fallback option) and NLS_NUMERIC_CHARACTERS should be in order ',.' (confirm by running: SELECT * FROM NLS_DATABASE_PARAMETERS;)
Each EPM user must have the RESOURCE role and the CREATE SESSION and
CREATE VIEW privileges.

Note that Oracle recommends a separate Oracle database instance and other specific adjustments to work with FDM.

Oracle Data Provider (ODP) for .NET 2.0 (from the Oracle Data Access Component (ODAC) package) is required and must be installed by a user with Windows administrator rights for the following products: FDM or Performance Management Architect Dimension Server.

MICROSOFT SQL SERVER DATABASE REPOSITORY
Microsoft SQL Server 2008 R2 is certified.
Run the following two commands against each database used by EPM:
alter database set READ_COMMITTED_SNAPSHOT ON
alter database set ALLOW_SNAPSHOT_ISOLATION ON

IBM DB2 DATABASE REPOSITORY
IBM DB2 9.7 FP3a+ is certified.
(8) MICROSOFT INTERNET INFORMATION SERVER
For Microsoft Windows 2008 servers, ensure that IIS 7 is installed with IIS 6 compatibility features (needed for HFM). Ensure that ASP.NET has been installed as well. In Windows 2008: Start > All Programs > Administrative Tools > Server Manager (or use icon in tool-bar) > Roles Summary > click Add Roles > ...complete verifications... > On Select Server Roles screen select Web Server (IIS) > et cetera.
(9) PREPARE A DOMAIN USER FOR INSTALL
The Microsoft Windows Services control panel should have a domain user with rights to start a service as the owner of each Oracle EPM service, so that user should be determined before installation.
(10) CONFIGURE INTERNET EXPLORER 8 (if not using Firefox)
Internet Options > Security Settings tab > Custom level...
Allow script-initiated windows without size or position constraints (Enable)
Allow websites to open windows without address or status bar (Enable)

Internet Options > Security tab > Enable Protected Mode (Uncheck)

If multiple open windows are needed: http://forums.oracle.com/forums/thread.jspa?messageID=9391075
(11) INSTALL A 32-BIT GNU (7.06) or AFPL (8.5.4 or 8.51or 8.14 ) GHOSTSCRIPT OR ADOBE ACROBAT DISTILLER (6.0 or 8.0)
This is needed for Oracle Hyperion Financial Report PDF output.

Enhanced display of charts (via Adobe SVG Viewer) is only possible when using Adobe Acrobat Distiller.
(12) ENSURE THERE ARE NO SPACES IN THE INSTALL PATH

Epm System Diagnostics Doesn'T Work Correctly After Changing Default Admin Password

Epm System Diagnostics Doesn'T Work Correctly After Changing Default Admin Password [ID 1307681.1]
Modified 07-APR-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
References

Applies to:

Hyperion Essbase - Version: 11.1.1.1.00 to 11.1.1.3.00 - Release: 11.1 to 11.1
Information in this document applies to any platform.
Symptoms

Having installed Hyperion products and changed the default admin password, how can I then get 'EPM System Diagnostics' to work correctly for the Essbase Java API? It currently produces:

Test Status: FAILED

Service: SVR: Essbase Java API

Description: Launch external checker with next command: D:\Hyperion\common\validation\9.5.0.0\launchEssbaseJavaAPI.bat EssbaseJAPIConnect admin ****** localhost Embedded
Error: Result: -1; Error message: Cannot connect to olap service. Cannot connect to Essbase Server at MG1VAPPP16. Timed out waiting to connect to the Essbase Agent/Server using TCP/IP. Check your network connections.
Recommended Action: Make sure external checker is working.
Cause

This is a known issue and caused due to unpublished bug 8509441: EPM SYSTEM DIAGNOSTIC REPORTS "FAILED" AFTER CHANGING ADMIN PASSWORD IN HSS (Fixed in Product Version 11.1.2.0.00 Product Version11.1.1.1.00)
Note: SDK checkers are additional checkers based on external checker API. It means all parameters are passing via vtconfig.xml file in core or encrypted (like should update vtconfig.xml with new encrypted value), but configtool includes SDK in 11.1.2.0 release.

Solution

This issue is resolved in version 11.1.2.

Workaround:
Apply these steps to encrypt the password with the encryptString.bat tool which is in the structure. Then, update the vtconfig file with the new encrypted password.

Steps to apply:
1. Open a command prompt and navigate to HYPERION_HOME/common/config/9.5.0.0 directory.
2. Execute encryptString.bat using the newly changed password of the default admin user as the only parameter.
For example, if myPasswor12 is the new password, use the command:
encryptString.bat myPasswor12
To encrypt it. The encrypted password appears in the command prompt window.

3. Copy the encrypted password from the command prompt window.
4. Using a text editor, open the vtconfig.xml file, this file is available in HYPERION_HOME\common\validation\9.5.0.0\vtconfig.xml
5. Replace the existing password with the encrypted password that you copied in step 3.
6. Save and close the file.

Startup EPM SUit

<<< Mandate:
startFoundationServices.bat
startRaFrameworkAgent.bat
startRaFramework.bat
startOHS.bat

HFM:
startHFMManagementService.bat
startHFMWebServiceManager.bat

Essbase:
startEssbase.bat
startEssbaseAdminServices.bat
startAnalyticProviderServices.bat
startPlanning.bat
startRMI.bat

Optional:
startFinancialReporting.bat
startWebAnalysis.bat
startErpIntegrator.bat
startFDMTaskManager.bat
startFMWebServices.bat
startHFMDMEListener.bat

Thank to Mohammed Abdul Muqeet

Wednesday, August 17, 2011

How to Reset "root" Password with GRUB on Enterprise Linux

How to Reset "root" Password with GRUB on Enterprise Linux [ID 431260.1]
Modified 10-JUN-2009 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
References

Applies to:

Linux Kernel - Version: 4.4 to 5.3
Linux x86-64
Goal

If somehow you have lost the password for the system administrator user "root" you will need to reset it. This document provides a practical method to do that if you have configured system with the GRUB boot loader during the OS installation.
Solution

It procedure is to boot the system in the "single user" mode and to be able to do that you must be on the system console. Please follow the steps below:

1. Reboot the system
2. When the GRUB menu is shown with list of kernels to boot or count down for boot kernel is seen immediately do the following.
3. Use the arrow key and choose the kernel you want to boot
4. Press key a to append kernel arguments before booting
5. Next line will look something like this:
grub append> ro root=/dev/VolGroup00/LogVol00 rhgb quiet
6. At the end of the line press space bar once, then add text single or 1:
grub append> ro root=/dev/VolGroup00/LogVol00 rhgb quiet single
or
grub append> ro root=/dev/VolGroup00/LogVol00 rhgb quiet 1
7. Then press enter/return, system will start to boot. The esc key will cancel your edit.

8. This will bring you to a shell prompt and now you can use the passwd command to change the password for the "root" account:
sh-3.00## passwd
Changing password for user root.
New UNIX password:
...
...
After the password is reset type
# reboot
and after system has been completed booting you can logon with the new root password.

Tuesday, August 16, 2011

Common Components Fail During Hyperion EPM Installation on French OS Windows: "Error setting file permissions". [ID 1322277.1]

Common Components Fail During Hyperion EPM Installation on French OS Windows: "Error setting file permissions". [ID 1322277.1]
Modified 24-MAY-2011 Type PROBLEM Status PUBLISHED

In this Document
Symptoms
Cause
Solution
References

Applies to:
Hyperion BI+ - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms
Hyperion Common Components Installation fails throwing error:
"Error setting file permissions.
Le mappage entre les noms de compte et les ID de sÃ©curitÃ© n'a pas Ã©tÃ© effectuÃ©."
(The mapping between account names and security IDs has not been done).

This is a fresh installation on French Windows 2003 Server operating system.

The following is an extract of the log "install-core-4-27-2011..log" :
13:15:08 postinstall.vbs: Exec: C:\WINDOWS\system32\cmd.exe /C echo y| cacls "c:\oracle\middle~1\epmsys~1\ccr" /T /G SYSTEM:F Administrateurs:F "Creator Owner":F > C:\DOCUME~1\epm_user\LOCALS~1\Temp\radB1C80.tmp 2>&1
Error setting file permissions.
Le mappage entre les noms de compte et les ID de securite n'a pas ete effectue.
--------------------------------------

Cause
As the Windows server is in French, the command should be :
C:\WINDOWS\system32\cmd.exe /C echo y| cacls "c:\oracle\middle~1\epmsys~1\ccr" /T /G SYSTEM:F Administrateurs:F "Createur proprietaire":F > C:\DOCUME~1\epm_user\LOCALS~1\Temp\radB1C80.tmp 2>&1
This command works properly.

BUG 9800347 - CANNOT INSTALL OCM ON WINDOWS XP (NON-ENGLISH).

This was fixed in OCM 10.3.4 and 10.3.3.1. An older version (10.3.3.1) is in this kit.
Solution
1- Proceed with the EPM installation and ignore the error from the step that configures OCM.
2- Retrieve version 10.3.4 of the OCM kit from My Oracle Support and install it in the EPM environment (use Patch 5567658 for windows 32-bit and select version 10.3.4),
3- The kit should be unzipped under C:\Oracle\Middleware\EPMSystem11R1. (this kit has only one ccr folder that should override the existing folder under EPMSystem11R1).
4- Be sure to set the ORACLE_HOME and JAVA_HOME environment variables, i.e. set ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 & set JAVA_HOME=C:\Oracle\Middleware\jdk160_21.
5- Then run ccr\bin\setupCCR.exe and provide the credentials in response to the prompts.
6- After successful installation of the newer OCM version, run the EPM installer (installTools.cmd) and reinstall all your already installed components /products (this will reinstall the Common Components again).
7- Verify the Common Components are installed without errors at the final stage.

Friday, August 12, 2011

How to Verify EBS Setup for DrillBack to EBS in FDM [ID 780874.1]

How to Verify EBS Setup for DrillBack to EBS in FDM [ID 780874.1]
Modified 26-MAY-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution

Applies to:

Hyperion Financial Data Quality Management - Version: 11.1.1.0.00 to 11.1.1.1.00 - Release: 11.1 to 11.1
Information in this document applies to any platform.
Goal

What is the process to verify that Oracle EBS is setup to allow FDM to drillback into EBS to view the source data that was loaded into FDM?

Solution

The following steps can be performed against the EBS database to verify correct setup on the EBS side for FDM drillback functionality:

1. Verify that all patches documented in the Financial Data Quality Management readme guide have been applied, and that the EBS middle tier has been restarted after the patches have been applied successfully by running the following query:

select * from ad_bugs where bug_number = '(bugnumber)';

Oracle E-Business Suite Compatibility and Patches
The FDM drill-back feature supports Oracle E-Business Suite versions 11.5, 12.0.6, and 12.1.1. The following patches are required for Oracle E-Business Suite version 11.5:
• 4396821 and 8307232 (replaces patch 6902648)
Pre-requisite patches for patch 4396821:
• 3262919 - Patch 11i.FWK.H
• 2032040 - WORKFLOW 2.6 FOR APPLICATIONS 11i
• 3180816 - Patch 11i.AD.I
• 2917019 - New Profile Hierarchies: Security, Server and Organization
• 3313291 - AOL JAVA ROLLUP PATCH J
The following patch is required Only for Oracle E-Business Suite version 12.0.6:
• 8345468:R12.GL.A
Patches are available on the Oracle Support site.
There are no patches for R12.1.x onward.

These can be verified with the following query for EBS 11:

SELECT * FROM AD_BUGS WHERE BUG_NUMBER IN ('4396821','8307232','3262919','2032040','3180816','2917019','3313291','8345468');

and the following query for EBS 12:

SELECT * FROM AD_BUGS WHERE BUG_NUMBER = '8345468';

2. Locate the proper function id to set in the source adapters option menu by running the following query:

select function_id, function_name from fnd_form_functions
where function_name = 'GLAADPAGE';

3. Locate the proper responsibility_id to set in the source adapters option menu by running the following query:

select RESPONSIBILITY_ID , RESPONSIBILITY_KEY , RESPONSIBILITY_NAME,
MENU_ID
from FND_RESPONSIBILITY_VL
where RESPONSIBILITY_NAME like &responsibility_name;

The responsibility_name parameter is the responsibility name which is being
used for the drillback functionality.

4. Verify that for the menu_id returned in step #3, that the GLAADPAGE function is attached. The following query should be ran to verify this, it should return the menu id returned in step #3:

select menu_id, menu_name from fnd_menus where
menu_id in ( select c.menu_id from fnd_compiled_menu_functions c,
fnd_form_functions f
where c.function_id = f.function_id and
f.function_name = 'GLAADPAGE' );

Related
Products
Middleware > Enterprise Performance Management > Financial Data Quality Management > Hyperion Financial Data Quality Management

Back to top

Rate this document

High Virtual Memory Usage By HsvDatasource.exe When Using Oracle Provider For OLE DB

High Virtual Memory Usage By HsvDatasource.exe When Using Oracle Provider For OLE DB [ID 761418.1]
Modified 23-MAY-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
References

Applies to:

Hyperion Financial Management - Version: 9.2.0.0.00 to 11.1.2.1.000 - Release: 9.2 to 11.1
Oracle Provider for OLE DB - Version: 10.2.0.1 to 11.1.0.7 [Release: 10.2 to 11.1]
Information in this document applies to any platform.
Symptoms

Virtual and private memory usage of the Hyperion Financial Management (HFM) application process HsvDatasource.exe, continues to increase over time.
Cause

This issue is caused by a feature in the Oracle Provider for OLE DB client release 10.2 and later, called Statement Caching and how HFM uses its database connections. Unpublished BUG 6827563 has been submitted for this issue.

Solution

To resolve the high memory usage enable Statement Caching, but set the configured value to a low setting. Recommended value is between 1 and 10. To implement this solution, edit the following value in Windows Registry on HFM application server:

Key: Hkey_Local_Machine\Software\Oracle\Key_Homename\Oledb
Value Name: StmtCacheSize
Value (decimal): 10
Where, Key_Homename refers to the appropriate Oracle home. After registry modification stop and restart the HFM application processes.

Thursday, August 11, 2011

Error "Unable to retrieve target system data" When Browsing to HFM from FDM Control Tables

Error "Unable to retrieve target system data" When Browsing to HFM from FDM Control Tables [ID 1162694.1]
Modified 02-AUG-2010 Type PROBLEM Status PUBLISHED

In this Document
Symptoms
Cause
Solution

Applies to:
Hyperion Financial Data Quality Management - Version: 11.1.2.0.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms

When choosing Metadata > Control Tables within FDM end users receive the error "Unable to retrieve target system ". The control table would normally return a drop down list of target values from the HFM application.
Cause

The environment contains two FDM application servers. In order for FDM to properly integrate with HFM on both application servers, the HFM adapter must be registered and configured on both application servers in the environment. Currently the adapter is only registered and configured on one of the two application servers.

Solution

The adapters should be unzipped to the Adapters Components or the Shared Components folder on each server and then registered from there.
To register the adapter use the following steps
1. Launch the FDM Workbench
2. Select File-> Register Adapter
3. Browse to the location of the adapter (see above) and select the appropriate file (upsFM11xG5*.dll)

4. Right-Click on the adapter and choose "configure"

5. Enter the FDM Service account username, password, confirm password, and domain and click OK to save the change.

Show Related Information Related
Products

* Middleware > Enterprise Performance Management > Financial Data Quality Management > Hyperion Financial Data Quality Management

Keywords
ADAPTER; FDM

Back to topBack to top
Copyright (c) 2007, 2010, Oracle. All rights reserved. Legal Notices and Terms of Use | Privacy Statement
Rate this document
Article Rating
Rate this document
Excellent
Good
Poor
Did this document help you?
Yes
No
Just browsing
How easy was it to find this document?
Very easy
Somewhat easy
Not easy

Comments
Provide feedback for this article. Please use 'Contact Us' for other feedback.

Important Note: this feedback may be anonymously visible to other customers until processed by Oracle Support.
Cancel

Wednesday, August 10, 2011

How To Recreate the /appsutil/scripts/ directory [ID 377495.1]

How To Recreate the /appsutil/scripts/ directory [ID 377495.1]
Modified 07-FEB-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
References

Applies to:

Oracle Applications Manager - Version: 11.5.7 to 11.5.10.2 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Goal

***Checked for relevance on 07-FEB-2011***

The $ORACLE_HOME/appsutil directory or subdirectories of appsutil are missing.

How to recreate this directory with its subdirectories and contents?
How can I run AutoConfig on Database Tier without this directory, since adautocfg.sh exists in /appsutil/scripts/?

Solution

To implement the solution, please update the RDBMS ORACLE_HOME file system with AutoConfig files from the AppsTier by performing the following steps exactly:

1. On the Application Tier (as the APPLMGR user):

2. Log in to the APPL_TOP environment and source the environment file

3. Create appsutil.zip file: "perl /bin/admkappsutil.pl"
(This will create appsutil.zip in $APPL_TOP/admin/out/appsutil.zip)

4. Copy or FTP the appsutil.zip file to the RDBMS $ORACLE_HOME

5. On the Database Tier (as the ORACLE user):
$ cd $ORACLE_HOME
$ unzip -o appsutil.zip

6. Generate the Database Context File:

Context File Creation on UNIX

$ cd $ORACLE_HOME

$ . _.env

$ cd $ORACLE_HOME/appsutil/bin

$ perl adbldxml.pl tier=db appsuser= appspasswd=

$ cd $ORACLE_HOME/appsutil/bin

$ adconfig.sh contextfile= appspass=

After running the these steps, all files and directories for Autoconfig are now present, including "$ORACLE_HOME/appsutil/bin/adautocfg.sh" and the "$ORACLE_HOME/appsutil/scripts" directory.

How To Recreate the /appsutil/scripts/ directory [ID 377495.1]

Thursday, August 4, 2011

Sequence to start the EPM Suit

Sequence to start the Hyperion Services

1. Hyperion Foundation OpenLDAP
2. Hyperion Foundation Shared Services - Web Application
3. Hyperion Workspace - Agent Service
4. Hyperion Annotation Server
5. Hyperion Apache 2.0
6. Hyperion EPM Architect - Process Manager (This service will start the immediate next 4 services)
7. Hyperion EPM Architect - Engine Manager
8. Hyperion EPM Architect - Job Manager
9. Hyperion EPM Architect - Event Manager
10. Hyperion EPM Architect - .Net JNI Bridge
11. IIS Admin Service
12. Hyperion Essbase Services 11.1.1 - hypservice_1
13. Hyperion Administration Services - Web Application
14. Hyperion Integration Services
15. Hyperion RMI Registry
16. Hyperion EPM Architect - Web Application
17. Hyperion EPM Architect Data Synchronization - Web Application
18. Hyperion CALC Manager - Web Application
19. Hyperion Planning - Web Application
20. Hyperion Workspace - Web Application

Tuesday, August 23, 2011

Applies to:

Description

Product-Specific Recommended Patches

R12.1 Pre-Upgrade Patches

EBS Consolidated Upgrade Patch - Feb 2010

Financials Pre-Upgrade Patches - April 2011

Sunday, August 21, 2011

Saturday, August 20, 2011

Friday, August 19, 2011

Thursday, August 18, 2011

Wednesday, August 17, 2011

Tuesday, August 16, 2011

Friday, August 12, 2011

Thursday, August 11, 2011

Wednesday, August 10, 2011

Thursday, August 4, 2011