Oracle Hyperion Financial Close Management
Release 11.1.2.4.000 Patch Set Update (PSU): 11.1.2.4.251
Readme
Account Reconciliation Manager
Account Reconciliation Manager
Account Reconciliation Manager
Account Reconciliation Manager Defects
Why do I get the following patch conflict error message when running OPatch?
Why do I get the OUI-67078 warning message when applying OPatch?
How can I find out which releases and patches of EPM System products are installed in a deployment?
This Readme file describes the defects fixed in this patch and the requirements and instructions for applying this patch.
NOTE: If you have Tax Governance and Financial Close Management installed on same machine and have applied TAX 11.1.2.4.251 PSU (27479194), you need not apply this patch on that machine.
This patch may not be applied on top of the 11.1.2.4.250 pre-release patch.
Caution: You are urged to carefully read and understand the following requirements. Failure to comply may result in applying a patch that can cause your application to malfunction, including interruption of service and/or loss of data. Before installing or applying this patch:
· Verify that the issue described in the Readme matches the issue that you are encountering. Review the Bug Number referenced in the Readme for additional information.
· Verify that your system configuration (product version, patch level, and platform) exactly matches what is specified in the Readme.
This is a patch set update (PSU).
You can apply this patch to the following releases:
11.1.2.4.000
11.1.2.4.100 PSU
11.1.2.4.101 PSU
11.1.2.4.102 PSU
11.1.2.4.103 PSU
11.1.2.4.200 PSU
11.1.2.4.201 PSU
11.1.2.4.250 PSU
Microsoft has identified a security issue that could compromise Windows-based systems. Before installing this patch, verify that the Visual C++ 2005 Redistributable Package installed on the computer is current. You may search and download the latest Visual C++ 2005 Redistributable Package from:
http://www.microsoft.com/en-us/download/default.aspx
· Install the ADF patch 25113405, if not already installed.
· Install HFM patch 11.1.2.4.206 (26760297), if using HFM.
· Install FDMEE PSU 11.1.2.4.220 (25312033)
· Install SOA patch SOA_11.1.1.7.8_Patch_20900797
· Install WebLogic Server patch WLS_PSU_10.3.6.13_21984589
The user applying the patch should be the user who was set up to install and configure EPM System products. Required user privileges or rights:
Use the user account that has Local administrator rights and was set up for installation and configuration. This user is an administrator and is the same for all EPM System products. Assign local policies if required by the product. Such assignments typically are: “Act as part of the operating system, Bypass traverse checking, Log on as a batch job, Log on as a service.”
Use the account that was used to install EPM System products and has Read, Write, and Execute permissions on $MIDDLEWARE_HOME. If you installed other Oracle products, the user who installed EPM System products must be in the same group as the user who installed the other Oracle products. OPatches are not intended to be applied using a root user.
Applies to all supported platforms.
Applies to all languages supported by the product.
When you import a CSV file into Supplemental Data Manager, Close Manager or Account Reconciliation Manager, you can now select a Comma or a Tab as a file delimiter. The File Delimiter field was added to all import dialogs to allow users to select either a Comma or Tab delimiter.
New date calculation functions have been added to Supplemental Data Manager, Close Manager or Account Reconciliation Manager, including Year, Month, Day, Date, and Add Month. The Date Difference function now also supports years and months.
You can specify a negative Start Date for Supplemental Data Forms. See the “Assigning the Workflow” section in the Oracle Hyperion Financial Close Management Administrator's Guide.
You can specify the column width for Supplemental Data forms. You can specify Small, Medium, Large, Size to Fit, or a Custom width. See the “Form Template Sections: Columns Tab” section in the Oracle Hyperion Financial Close Management Administrator's Guide.
You can load viewer access to forms from files. You can also export viewer access to CSV files. See the “Setting Form Template Access for Users, Groups, or Teams and Bulk Uploading” section in the Oracle Hyperion Financial Close Management Administrator's Guide.
You can assign teams as users for Supplemental Data, for example in forms and dashboards.
Smart View now supports working directly with Close Manager tasks and schedules. Users can view a list of their current tasks and submit and approve them from Smart View. To accomplish this, you install the new Close Management Smart View extension.
After installation of the extension, when you open Excel, you will see new ribbons labeled Close Tasks. See “Updating Tasks From Smart View” in the Oracle Hyperion Financial Close Management User’s Guide.
In Close Manager, you now upload a File attachment or URL reference to multiple tasks at one time.
Close Manager and Account Reconciliation Manager now support archiving and purge of old financial data. Customers have found the need as the product grows in size to clean up old data which will also help keep the database size in check and enhance performance.
Archiving is now available using the Lifecycle Management export and import for run time objects like reconciliations in Account Reconciliation Manager and schedules in Close Manager. There is also additional capability to purge and restore data.
Reconciliation Compliance now supports the variance analysis process (also known as the flux analysis process) which is a key control in the overall account monitoring process to ensure balance fluctuations are monitored and explained if certain thresholds are exceeded. Variance Analysis automates the process by automatically comparing balances across periods for all account types including balance sheet, income, and expense accounts. The comparisons are selected as desired, for example, period over period, period over quarter, etc. When formats are set up, users can now choose from the Balance Comparison, Account Analysis, or Variance Analysis methods.
The same powerful rules engine that customers are using today to streamline their reconciliation process can be used for the Variance Analysis process to either automatically process accounts that do not require any user explanation or require the variance to be explained. The suggested best practice from best in class performing customers is to complete the Variance Analysis across all desired accounts prior to period-end close and certainly prior to reconciliation sign-off, so that the accounts can be as accurate as possible when the ledger closes for that period. See the Oracle Hyperion Financial Close Management Administrator's Guide.
A Service Administrator can use a new Configuration Setting in Reconciliation Compliance to allow users to perform Submit, Approve, Reject, Claim or Release on multiple reconciliations or transactions at one time.
Users now have the ability to upload a File attachment or URL reference to multiple reconciliations or transactions at one time.
Close Manager and Account Reconciliation Manager now support archiving and purge of old financial data. Customers have found the need as the product grows in size to clean up old data which will also help keep the database size in check and enhance performance.
Archiving is now available using the Lifecycle Management export and import for run time objects like reconciliations in Account Reconciliation Manager and schedules in Close Manager. There is also additional capability to purge and restore data.
The SOA engine has been removed from all workflow processing, notification, and system batch operations in all Financial Close Management modules resulting in simplified installation configuration and enhanced performance. SOA is now only required to run Close Manager system automated or event monitoring tasks. Many operations that take some time are performed in the background, can be managed through a new Manage Jobs dialog and allow users to continue on with their work while processing takes place.
Users may now name and save views of the various transactional dashboards (for example, Close Manager Task List, Account Reconciliation Manager Profiles, etc.). This includes the column layout, sort order and filters associated with the dashboard. Administrators may publish the saved dashboard views to make them available to all users.
Two new rule types have been added: prevent rejections and send email update. The prevent rejection rule prevents a reviewer from rejecting if certain conditions are not met. For example, an Administrator can set up the rule to prevent an ARM reviewer from rejecting a task until a custom 'Reject Reason' attribute has been set. The Send Email on Update rule sends emails to users if certain conditions being met. For example, this rule can be set up to send email a specified set of users if a custom 'Audit Required' attribute has been set to true.
Additionally, Administrators and Power Users will now be able to rerun rules that were previously only run during data loads. The rules that can be rerun are: Copy Transactions, Set Attribute, Auto Submit and Auto Approve.
Close Manager and Account Reconciliation Manager users now have the ability to return a task or reconciliation workflow directly to themselves. For example, a preparer can do more work on a task or a reviewer can take another look at a reconciliation.
Previously, an administrator would need to intervene to do this action. To maintain security, this new user capability is turned off by default and must be enabled by an Administrator.
User IDs will now appear next to the user names when picking users for various fields (preparer, reviewer, etc.). This will help make the correct decision when two or more users have the same name.
The limit on columns in transactional dashboards has been increased from 20 to 30.
The owner of tasks may now be changed after the schedule has been opened.
Tasks may now be deleted from Open and Closed Schedules. An administrator must enable this new capability as it may affect a company's compliance policies regarding deleting close history.
The action of submitting tasks has been made clearer to users through addition of a Submit Task button in an effort to prevent accidental submissions.
The option to export all columns from a transactional dashboard has been removed to prevent severe performance problems. Clients who require exporting their entire set of reconciliation data may set up custom reports to do this.
Administrators and Power Users may now set up currency translation calculations in data sets to allow global companies to enter data in local currency and translate into the currency of the parent company for reporting purposes. To support this, rate types and rate data may now be defined and loaded.
Administrators and Power users can now load data into datasets directly across multiple entities. This functionality can also be used to pre load certain columns of the dataset so that form preparer can input only those columns that are necessary.
Users are assigned workflow roles during form template creation, but in some cases, users need the flexibility to reassign workflow actions to a different user in the midst of a close process (i.e. after forms are deployed to data collection periods. To achieve this, SDM leverages the existing ‘Reassign User’ functionality in FCM.
One of the primary use cases of SDM is where a customer loads account balances from any of the various GL systems into their consolidation system which is HFM and requires the details or parts of the sum of that account balance to be collected in SDM. Once collected, the total of the supplemental data needs to match the account balance in HFM before the preparer can submit the data form. To achieve this, SDM provides the ability to validate the supplemental data against the balances in the consolidation system.
You can now upload dimension members to an attribute of type LIST from a csv file while creating dimensions.
For attributes which are referenced by a dimension, you can search for members in the dimension member lookup dialog while on a data collection form.
You can now make user assignments for workflow stages in bulk, by uploading the assignments from a csv file during a form template creation.
When you import data with dates, you can select the format from a designated list of formats. The format remedies the case where Excel changes the date format when files are opened in Excel.
Scripted attributes in Account Reconciliation Manager (ARM), Close Manager (CM), and Supplemental Data Management (SDM), share a common library of calculation functions:
Function |
Available In |
Purpose |
Average Over Prior Periods |
ARM, SDM |
Averages a numeric amount over the prior X periods. |
Date Difference |
ARM, CM, SDM |
Returns the difference in days, hours, minutes, or seconds between two dates |
Extract Text (SUBSTRING) |
ARM, CM, SDM |
Returns a string of text from within an attribute value, starting from a specified position |
If Then Else |
ARM, CM, SDM |
Enables creation of scripted calculations using If/Then/Else conditions |
Lower Case |
ARM, CM, SDM |
Returns the value of an attribute in lower case |
Maximum |
ARM, CM, SDM |
Returns the maximum value from a list of attributes |
Maximum Over Prior Periods |
ARM, SDM |
Returns the maximum value of an attribute over the prior X periods |
Minimum |
ARM, CM, SDM |
Returns the minimum value from a list of attributes |
Minimum Over Prior Periods |
ARM, SDM |
Returns the minimum value of an attribute over the prior X periods |
Prior Period Value |
ARM, SDM |
Returns the value of an attribute from the specified prior period |
Round |
ARM, CM, SDM |
Returns the value of an attribute rounded to the specified precision |
Text Location (INSTRING) |
ARM, CM, SDM |
Returns the location of a string of text within the attribute value |
Sum Over Prior Periods |
ARM, SDM |
Sums the value of an attribute over the prior X periods |
Translate |
ARM |
Translates a currency attribute to a different currency |
Uppercase |
ARM, CM, SDM |
Returns the value of an attribute in upper case |
· Assign Value to List: Assign a value to a list-type attribute (for example, to assign a numeric risk score to each reconciliation format)
· Assign List to Value: Assign a list value to some other type of attribute (for example, to normalize text values)
· Conditional: Perform if-then-else calculations
Rules affect the Close Manager workflow and can be assigned to Templates, Schedules, Task Types and Tasks. Workflow rules now include auto-submission and auto-approval of tasks as well as prevent submission and prevent approval.
You can import transactions across multiple reconciliations at a time; for example, General ledger transactions comprising account balances, and reconciling items identified using external transaction matching applications.
Rules affect the Account Reconciliation Manager workflow and can be assigned to Formats, Profiles, or Profile Attributes. Workflow rules now include auto-submission and auto-approval of reconciliation as well as prevent submission, prevent approval, and require reconciliation attachments for submission or approval. Profile copy to period now supports rules for setting profile properties and attributes.
You can use LCM to migrate all artifacts except form instances and report definitions.
You can now use an editor to create calculations.
Defect Number |
Defect Fixed |
· 25917846 |
In Account Reconciliation Manager, logging on and off as a particular role no longer loses the user settings for that role. |
· 26810981 |
In Supplemental Data Management, complex calculation, involving PRIOR function and dimension reference attributes, is fixed |
· 27180339 |
In Account Reconciliation Manager, rules are included with export reconciliations. |
· 27192758 |
In Account Reconciliation Manager, using Open in Manage Period with no transactional view tabs does not cause an error. |
· 27243758 |
In Close Manager, user is able to get back ownership of reconciliations after a status change. |
· 27275705 |
In Account Reconciliation Manager, opening the Reconciliation List by using the View menu or toolbar icon, while filtered profiles are displayed, no longer causes error. |
· 27306574 |
In Close Manager, generate report binder works properly for attachments. |
· 27339368 |
In Close Manager, export of selected tasks works properly. |
· 27031351 |
In Account Reconciliation Manager, auto close of null balance reconciliations has been corrected. |
· 27339509 |
In Account Reconciliation Manager, restore an archive for a locked period works correctly. |
· 27358418 |
In Close Manager, early start of task now transforming from task type. |
· 27363684 |
In Close Manager, reopen task with approver aligns to the user selection of approver. |
· 27371256 |
In Close Manager, early start selection in task type now gets inherited by template task. |
· 27375741 |
In Close Manager, reopen task is now available to an approver if task status is more than one level beyond that approver. |
· 27392823 |
In Close Manager, correction for movement between tasks in Workspace. |
· 27423381 |
In Close Manager, opening a schedule with (Argentina) es-ar language works properly. |
· 27425514 |
In Account Reconciliation Manager, period start and end date no longer change when the time zone is changed. |
· 27431218 |
In Account Reconciliation Manager, a preparer will no longer get an error running Copy Transactions from Prior Reconciliation on reconciliations using a quarterly frequency. |
· 27432120 |
In Close Manager, if task type has Allow Early Start set, the issue with replacing or updating during export and reimport. |
· 27438811 |
In Account Reconciliation Manager, attributes with an attachment in reconciliation are no longer taking the Administrator’s name as owner. |
· 27444098 |
In Account Reconciliation Manager, user can now be added to a team using the Manage Users dialog. |
· 27456431 |
In Account Reconciliation Manager, if Set Attribute is used on reconciliation, the Copy Reconciliation Changes to Profile works. |
· 27517363 |
In Financial Close Management, LCM export fails if user does not have roles for all of the modules: CM, ARM and SDM |
· 27525432 |
In Account Reconciliation Manager, fixed conditions causing database stuck threads. |
· 27533811 |
In Account Reconciliation Manager, during an archive restore, profile segments can be created properly. |
· 27553484 |
In Supplemental Data Management, user with appropriate access can see the data in Data Set Dashboard even after form is approved/closed. |
· 27559778 |
In Account Reconciliation Manager, a period check added to correct data load post process error. |
· 27554582 |
In Account Reconciliation Manager, transaction tab in Account Reconciliation Manager does not lose attributes when saving. |
· 27563211 |
In Close Manager, answers to questions in Close Manager are retained. |
· 27573132 |
In Account Reconciliation Manager, added period check so previous child reconciliations and summary reconciliations will not interfere with current period. |
· 27573199 |
In Account Reconciliation Manager, random error seen in profile sections. |
· 27654437 |
In Close Manager, server no longer has out of memory issues during LCM export of Close Manager artifacts. |
· 27661998 |
In Account Reconciliation Manager, auto approve rules now working in Account Reconciliation Manager. |
· 27678157 |
In Close Manager, when creating a new schedule from template, the Period drop down list now displays more rows. |
· 27689755 |
In Account Reconciliation Manager, saved view no longer resets when selecting export after adding columns. |
· 27691832 |
In Account Reconciliation Manager, error message now displays if start/end time is left blank in User Details dialog in Close Manager. |
· 27716542 |
In Account Reconciliation Manager, report binder now displays balances when downloading multiple reconciliations. |
· 27724814 |
In Account Reconciliation Manager, LCM export of large number of reconciliations with large number of transactions is successful. |
· 27740627 |
In Account Reconciliation Manager, unexplained difference for variance analysis corrected. |
· 27747766 |
In Account Reconciliation Manager, copy transactions correctly displaying values in the Amount columns. |
· 27777105 |
In Close Manager, flagging at risk tasks working properly. |
· 27796362 |
In Account Reconciliation Manager, LCM import no longer having out of memory issues. |
· 27803906 |
In Account Reconciliation Manager, create reconciliations no longer fails if profile's attribute default includes attachment. |
· 27803953 |
In Close Manager, task question field does not cut off at 255 characters. |
· 27818536 |
In Account Reconciliation Manager, system maintenance job no longer fails for Account Reconciliation Manager. |
· 27818805 |
In Account Reconciliation Manager, history not updated if profile update fails. |
· 27822231 |
In Close Manager, No error when adding a primary approver to a Task List. |
· 27833912 |
In Account Reconciliation Manager, upload of pre-mapped transactions before reconciliation copy to period now appear in the Transaction list. |
· 27831546 |
In Supplemental Data Management, added validation to not allow “Start Date” and “End Date” as attributes in Data Set because those are system reserved attribute names |
· 26834513 |
In Supplemental Data Management, form data entry issue is fixed for complex calculation with PRIOR, TRANSLATE and new entity combination. |
· 27616481 |
In Supplemental Data Management, restriction added to display only 30 attributes during first time display in Data Set Dashboard. |
Defect Number |
Defect Fixed |
· 25170020 |
In Account Reconciliation Manager, calendars displaying in Spanish and dates forcing EURO format during amount update transactions. |
· 25215842 |
In Account Reconciliation Manager, in some cases, the aging value was showing a positive number when it should've been negative. |
· 25248264 |
In Close Manager, task start date/time don't match between task list and Smart view. |
· 25303517 |
In Close Manager, unable to export/import primary user team setting from/to FCM via LCM. |
· 25309404 |
In Close Manager, if a user tried to change the status of 1000 or more tasks via the Actions Panel, an error occurred. |
· 25361150 |
In Account Reconciliation Manager, when ARM data load was run using command line, the LDAP ids are showing as Administrator instead of LDAP id in the Data load monitor. |
· 25389298 |
In Financial Close Management, error seen in user notification preferences. |
· 25779921 |
In Close Manager, in rare circumstances, the user was unable to access the Web Data Entry Form in the View Task Dialog from My Worklist. |
· 26121526 |
In Account Reconciliation Manager, when a Reconciliation was reopened, the preparer and approver actions were still displaying as complete in the Workflow section of Recon Actions. |
· 25924521 |
In Close Manager, in rare circumstances during template creation, when all available templates were embedded, an error occurred. |
· 26198849 |
In Account Reconciliation Manager, if the user reordered or changed columns in either of the transaction tabs in Recon Actions, the changes did not get saved. |
· 26330376 |
In Close Manager, the Approve and Reject buttons for alerts lacked text. |
· 26597297 |
In Supplemental Data Manager, decimal places were getting lost in Currency rates in MSSQL Database |
· 26703198 |
In Supplemental Data Manager, report query validation was failing in MSSQL Database when data set attribute was using TRANSLATE function in calculated attribute. |
· 25962878 |
In Financial Close Management, LCM import does not import certain artifacts in a clustered FCM setup. |
· 25790346 |
In Account Reconciliation Manager, Account Types are not migrated via LCM. |
· 25789870 |
In Account Reconciliation Manager, LCM import of a period can fail when it has a prior-period associated. |
· 25303517 |
In Financial Close Management, LCM export of Teams does not include primary user information. |
· 25248264 |
In Close Manager, task date and times do not match between task list and smart view. |
· 25392149 |
In Smart view, updating the screen after all cell populate in excel to minimise response time. |
· 25690357 |
In Close Manager, added task column to list of errors during deploy template |
· 25981915 |
In Close Manager, tasks no longer open in Closed/Locked schedules |
· 26021433 |
In Close Manager, fixed an issue where empty instructions caused deploy template to fail |
· 25488196 |
In Account Reconciliation Manager , calculations with number formatting sometimes show the wrong number in certain languages |
· 25415982 |
In Account Reconciliation Manager, fixed issues with list values being updated while creating an Assign List to Value calculation |
· 25446348 |
In Account Reconciliation Manager, fixed an issue generating reports with more than 14 columns |
· 25438058 |
In Account Reconciliation Manager, calcs with numeric formatting not displaying properly in reconciliation actions |
· 25608134 |
In Account Reconciliation Manager, fix filtering using the Last Balance Loaded By attribute |
· 25553332 |
In Account Reconciliation Manager, allow multi-select of users in advanced filter. |
· 25779356 |
In Account Reconciliation Manager ,fixed an issue where sometimes running a filter against a user attribute while selecting multiple users would return all rows |
· 26274402 |
In Account Reconciliation Manager, fixed an issue which would sometimes clear out attribute values in the reconciliation actions dialog |
· 26782627 |
In Close Manager, approving or rejecting multiple tasks at once would fail in languages other than English |
· 25170020 |
In Account Reconciliation Manager, fixed an issue where in rare cases dates would by using the wrong locale formatting |
· 25852948 |
In Account Reconciliation Manager, fixed an issue where the progress bar during Create Reconciliations would be incorrect |
· 25634648 |
In Close Manager, task end date and time are not exported or imported for event monitoring tasks. |
· 25798860 |
In Close Manager, re-opening system automated tasks do not re-execute the task. |
· 25813846 |
In Account Reconciliation Manager, email notifications were sent for closed reconciliations. |
· 26444167 |
In Account Reconciliation Manager, drill through to FDMEE does not work in non-English languages due to currency bucket labels. |
· 26718778 |
In Account Reconciliation Manager, preparer should not be allowed to import pre-mapped balances to reconciliations with enter balances manually options enabled. |
· 26803866 |
In Account Reconciliation Manager, email notifications should always use from address set in system settings. |
· 25558069 |
In Account Reconciliation Manager, alternating between the BI dashboard tab and reconciliation, transaction, or profile tabs could result in dashboard portlets displaying duplicated values in table cells |
· 25593554 |
In Account Reconciliation Manager, users preference for not showing the BI dashboard tips window is not being stored when user's actions do not trigger a commit of the preference |
· 25683743 |
In Account Reconciliation Manager, preparers alternating between reconciliations actions transactions tabs while creating new transactions sometimes have to refresh the transactions list to see data |
· 25856660 |
In Close Manager, BI dashboard scheduled tasks portlet, inclusion of end date columns causes inclusion of the late column whether it is selected or not |
· 25890005 |
In Account Reconciliation, reconciliations actions tab transactions tabs user modified column order is not being persisted |
· 25916092 |
In Close Manager, BI dashboard My Worklist portlet user modified column order was not being persisted |
· 26102628 |
In Account Reconciliation Manager, exporting profiles in LCM is extremely slow when profiles or formats include file references |
· 26997565 |
In Account Reconciliation Manager, the transaction short description is now restricted to 50 chars. |
· 26868243 |
In Close Manager, if a user edits a task and changes the Approver from one user to another, the task will no longer be reopened to the Assignee. It will stay open with the new Approver. |
· 27069987 |
In Account Reconciliation, reconciliations actions tab transactions tab list column keep changing. |
· 26999142 |
In Account Reconciliation, error seen in creating report binder |
· 26963442 |
In Account Reconciliation, Reviewers are receiving error message when trying to open a reconciliation |
· 26451848 |
In Account Reconciliation, error seen on click of transaction list |
· 26031260 |
In Account Reconciliation, submit and approve reconciliation takes 2 to 15 minutes to complete |
· 25891427 |
In Account Reconciliation, commentator can delete other commentator comments |
· 25862391 |
In Account Reconciliation, filters have very poor performance |
· 25713611 |
In Account Reconciliation, error seen on copying to period using a filter |
· 26968956 |
In Supplemental Data Management, for report writer, dataset access security was not implemented properly so the any user was able to see all the data using this. |
· 27061557 |
In Close Manager, apply button in actions panel add/set user won't enable if only end date is set |
· 27023274 |
In Close Manager, my worklist not automatically refreshing after task submit |
· 25801645 |
In Close Manager, greater flexibility to lock FDMEE locations (via an approver) from within FCM. |
· 26887101 |
In Supplemental Data Management, dataset dashboards showing N/A for all the filterable attributes. |
· 25510480 |
In Supplemental Data Management, in form, after completion of the data import, it was not refreshing the data grid to show modified data. |
· 25456963 |
In Close Manager, user should see time based on the timezone set in user’s profile. If Org unit and holidays are associated then those should be taken in consideration too |
· 27098192 |
In Account Reconciliation Manager, system adjustment rule "Prevent Transaction Save" is omitted if user selects Save and Create Another |
· 25856660 |
In Close Manager, the late attribute does reappear after removing it under 'schedule tasks' |
· 25877288 |
In Account Reconciliation, experiencing slow performance. |
· 26282872 |
In Close Manager, experiencing slow performance in the UI for most tasks. |
· 24827513 |
In Close Manager, question list of values became empty after updating one of the questions. |
· 26564533 |
In Account Reconciliation Manager, idle time between data load rules could be as long as 5 minutes, which is not efficient. |
· 27092921 |
In Account Reconciliation Manager, error seen when generating report binder for 1000+ reconciliation. |
Defect Number |
Defect Fixed |
· 23549524 |
In Close Manager, task parameters values overridden while scheduling do not reflect in schedule tasks |
· 25034899 |
In Account Reconciliation Manager, accounts show normal balance violation flag even when the balances are 0 or are as expected |
· 25103313 |
In Close Manager, Russian characters are seen incorrectly in notification emails |
· 25225605 |
In Account Reconciliation Manager, format rules are not working as expected for some users |
· 25302606 |
In Close Manager, BI dashboard portlets do not refresh automatically when task statuses change |
· 25337711 |
In Close Manager, certain end-user URL integration tasks cannot be closed once opened. |
· 25354881 |
In Close Manager, there is a possibility of all comments getting deleted on deleting a single comment |
· 25356306 |
In Close Manager, a warning message is seen on switching to task parameters tab |
· 25356451 |
In Financial Close Management, cannot launch FCM modules in workspace if OAM is enabled |
· 25356465 |
In Financial Close Management, re-deploy of FCM applications after upgrading to PSU200 causes Reconciliation Manager menu to be hidden from workspace Navigator |
· 25356495 |
In Account Reconciliation Manager, after importing transactions into reconciliation on a transaction tab and then navigating back to the Summary tab, some information on that tab is missing. |
· 25394383 |
In Close Manager, error is seen on opening an aborted task |
· 25412491 |
In Account Reconciliation Manager, unmapped accounts screen is missing important columns |
· 25298032 |
In Close Manager, error is seen on clicking Expand All in task list view |
Defect Number |
Defect Fixed |
· 16746240 |
In Close Manager, running tasks assigned to users that were removed from LDAP directories can not be edited or re-assigned. |
· 20903721 |
In Account Reconciliation Manager, Reconciliation audit trail report has issues with some of the audit fields and values |
· 21135395 |
In Supplemental Data Management, error seen in some cases on opening form instance in Smart view |
· 22232900 |
In Account Reconciliation Manager, if profile's currency bucket is defaulted to a newly added custom currency, copy profile to period fails |
· 22855166 |
In Account Reconciliation Manager, double click on an attachment link causes in an error |
· 23201869 |
In Close Manager, Status chart for open alerts also shows closed alerts |
· 23231014 |
In Account Reconciliation Manager, Custom Currencies with more than 3 characters do not work as expected |
· 23232570 |
In Account Reconciliation Manager, UI allows circular references when setting prior period. |
· 23237845 |
In Account Reconciliation Manager, reconciliation actions dialog takes much longer to load if reconciliation has questions. |
· 23271341 |
In Close Manager, Unavailable users can perform actions on tasks from task list using Right-click or Actions menu |
· 23276898 |
In Account Reconciliation Manager, Export All operation on list views times-out |
· 23287538 |
In Account Reconciliation Manager, numeric columns like currency are left-aligned in BI Dashboards instead of right. |
· 23293007 |
DUPLICATE OF ABOVE BUG |
· 23294290 |
In Close Manager, Task without required attachment can be submitted from task list using Right-click or Actions menu |
· 23300659 |
In Account Reconciliation Manager, reconciliation list filter on account id is lost on returning from a reconciliation actions dialog |
· 23314619 |
In Close Manager, Task owner or administrator cannot submit tasks from task list using Right-click or Actions menu |
· 23321977 |
In Close Manager, Scheduled tasks portlet shows task as running even after it has been closed |
· 23322388 |
In Close Manager, My Worklist portlet does not show a newly created alert unless refreshed manually |
· 23549524 |
In Close Manager, parameter values overridden during scheduling do not reflect in the resulting schedule's tasks |
· 23556824 |
In Account Reconciliation Manager, Power user with other non-admin user roles cannot view profiles |
· 23557670 |
In Close Manager, removing primary user from a team results in incorrect assignee for tasks in new schedules |
· 23562920 |
In Account Reconciliation Manager, amortization schedule does not allow more than 240 periods |
· 23592513 |
In Close Manager, Print function on Gantt view is not working |
· 23600535 |
In Account Reconciliation Manager, power user security with a combination of OR statements would not work properly |
· 23635239 |
In Account Reconciliation Manager, auto-submit and auto-approve rules do not trigger on running dataloads |
· 23709730 |
In Close Manager, pubic filters are not exposed on Status chart portlet |
· 23719826 |
In Account Reconciliation Manager, users see error message when working on reconciliation actions dialog and trying to save changes |
· 23721325 |
In Close Manager, schedule workflow is frozen if a schedule owner is deleted from user directory |
· 23725409 |
In Close Manager, many tasks are incorrectly flagged as being at risk |
· 23755160 |
In Close Manager, closing Manage Attributes dialog sometimes shows an error message |
· 23857745 |
In Close Manager, unable to save comments with URL attachments in a parent task |
· 24286625 |
In Account Reconciliation Manager, filter drop-down menu in Create Reconciliations dialog is not sensitive to the selected copy option |
· 24307192 |
In Account Reconciliation Manager, auto reconciled reconciliations show up in my worklist |
· 24312851 |
In Close Manager, edit alert dialog does not show the information for selected alert type |
· 24340980 |
In Financial Close Management, error is seen when trying to create a new team in a MSSQL setup |
· 24347413 |
In Account Reconciliation Manager, a user with Commentator role can delete a comment created by a Reviewer |
· 24386517 |
In Close Manager, cannot select more than 20 columns in transactional dashboard list view |
· 24386535 |
In Account Reconciliation Manager, cannot select more than 20 columns in transactional dashboard list view |
· 24400697 |
In Account Reconciliation Manager, calculations with numeric formatting were not calculated on the BI Dashboards properly |
· 24455990 |
In Financial Close Management, LCM Import of User Preferences fails in some cases |
· 24473443 |
In Close Manager, parent task does not close when child task is submitted using right-click or actions menu in task list |
· 24490702 |
Do not display attributes used in calculations end up being displayed to end users |
· 24598568 |
In Close Manager, users can delete comments at any stage during the close process. This needs to be restricted |
· 24666649 |
In Close Manager, smart view task list does not consider tasks assigned to teams or groups |
· 24696482 |
In Account Reconciliation Manager, amortized transactions copied from prior period are calculated incorrectly |
· 24697245 |
In Account Reconciliation Manager, questions are not displayed in reconciliation actions dialog for a reconciliation that was auto submitted via a format rule |
· 24717471 |
In Account Reconciliation Manager, unexplained difference always included subsystem balance regardless of reconciliation method type |
Defect Number |
Defect Fixed |
• 23011904 |
In Account Reconciliation Manager, ARM canned reports are not formatted correctly when old value is a date. |
• 22880963 |
In Account Reconciliation Manager, FDMEE data loads will fail if a source account is longer than 75 characters. |
• 22834797 |
In Account Reconciliation Manager, rules not enforced when users have been assigned more than one role. |
• 22831095 |
In Close Manager, task entry is not getting deleted from FCM predecessor task table upon deleting task. |
• 22966083 |
In Financial Close Management - 11.1.2.4, exception errors occur when logging in. |
• 22958371 |
In Account Reconciliation Manager, system hangs when applying filter for unexplained difference. |
• 22166226 |
In Close Manager, deleting a template with large number of tasks causes a timeout error. |
• 22085584 |
In Account Reconciliation Manager, error occurs when user opens a large number of tabs. |
• 22723743 |
In Close Manager, do not allow Submit, Approve or Reject for tasks in locked schedules. |
• 22357912 |
In Account Reconciliation Manager, put reconciliations in 'READ ONLY' mode while data load or post processing is happening. |
• 23018627 |
In Account Reconciliation Manager, if HFM is a source in FDMEE for loading data then locations are not displayed in ARM. |
• 22468309 |
In Close Manager, end date and end time cannot be modified for any task. |
• 22152862 |
In Close Manager, null pointer exception when custom system automated integrations have no response transformation specified. |
• 23064407 |
In Account Reconciliation Manager, status chart shows delinquent reconciliations when all reconciliations are closed. |
• 22910775 |
In Account Reconciliation Manager, unassigned attribute prevents ability to copy profiles between periods. |
• 22846781 |
In Account Reconciliation Manager, entered bucket currencies can duplicate or get removed while creating transactions. |
• 22845439 |
In Account Reconciliation Manager, error when importing a report with "List of Currency buckets". |
• 21328884 |
In Account Reconciliation Manager, remove radio button for multiple and single currencies. |
• 22852072 |
In Account Reconciliation Manager, filter reconciliations view by account Id then open reconciliations and go to transactions tab removes filter. |
• 23108152 |
In Account Reconciliation Manager, emails being sent even though reconciliations are closed. |
Defect Fixed |
|
• 22619074 |
In Account Reconciliation Manager, incorrect balances appear when Portuguese settings are applied in IE11. |
• 22736001 |
In Account Reconciliation Manager, ARM transactions including calculated attributes does not calculate in the Transaction Detail window even after selecting Save but does calculate in the Transactions list. |
• 22672688 |
In Account Reconciliation Manager, LCM import of calculated attributes fails. |
• 22013102 |
In Account Reconciliation Manager, data load fails frequently. |
• 21959763 |
In Close Manager, submitting a task throws NullPointerException trying to refresh UI. |
• 22152005 |
In Account Reconciliation Manager, bad SQL gets generated while data load for a period. Click unmapped accounts link for Data Load Execution. |
• 22322629 |
In Account Reconciliation Manager, Calculated Attribute "isAged" not working as expected even if it meets the rule’s criteria. |
• 22308034 |
In Account Reconciliation Manager, error is seen when creating a transaction with an action plan and a calculated attribute. |
• 22309122 |
In Account Reconciliation Manager, Prevent Reconciliation Approval rule based on calculated attributes not working as expected. |
• 22307681 |
In Account Reconciliation Manager, multiple reassignments of a reconciliation allow submit & approve by same user. |
• 22113018 |
In Account Reconciliation Manager, validation errors when saving a non-amortized transaction even when transaction values are entered correctly. |
• 22080216 |
In Account Reconciliation Manager, errors seen when adding a filter with balance attribute like 'Balance Exists' in Profile list view. |
• 22080018 |
In Account Reconciliation Manager, errors seen in logs indicating failure in looking up a UI component. |
• 21975400 |
In Account Reconciliation Manager, if we create a filter with a multi-select on user-based attributes, the resultant filter is constructed with multiple OR conditions rather than AND. |
• 22610164 |
In Account Reconciliation Manager, when creating a Filter for transaction, the Attribute field flips to the previous Attribute. It seems to occur on Attributes that have the same name with the addition of (Action Plan). |
• 22765964 |
In Close Manager, User is not allowed to approve the task if assignee was changed. |
• 22765877 |
In Close Manager, the owner of a task’s alert is unable to approve it. |
• 21969392 |
In Account Reconciliation Manager, an unassigned attribute referenced in rules prevents copying profiles to a period. |
• 22813722 |
In Account Reconciliation Manager, for creating transactions with Amortization, the system should allow periods up to 240. |
• 22985455 |
In Account Reconciliation Manager, LCM artifacts only available with reconciliation administrator. Users having other ARM provisions won't find any artifacts under Reconciliation Manager. |
Defect Number |
Defect Fixed |
• 21928349
|
In Account Reconciliation Manager, after maintenance upgrade to 11.1.2.4.000 from 11.1.2.2.350+ or 11.1.2.3.xxx, list views show "User Id Invalid" for user columns with a team or group instead of Team/Group name. Clicking on the hyperlink displays User Details dialog with correct Team/Group name.
NOTE: This patch should be applied immediately after upgrading to 11.1.2.4 while all of the Reconciliations are still closed. If the patch is applied after Reconciliations are open and claimed, the users may lose their claims in the following circumstances: 1. A User claimed a Reconciliation, but has not submitted or approved it. 2. A Reconciliation was rejected. In either case, the user(s) will simply need to reclaim the Reconciliation. |
• 21876489
|
In Close Manager, when you import a template from a csv file containing more than 100 entries, the connection may fail and generate an error message. |
• 21654570
|
In Account Reconciliation Manager, Copy to Period was creating issues due to some fault in queries. |
• 21654580
|
In Account Reconciliation Manager, Copy to Period was creating issues due to an unbounded query. |
• 21444061
|
In Account Reconciliation Manager, when we rename currency bucket "Reporting" to "Translated" from FDMEE side, drill through does not work from ARM. It returns "NO DATA TO DISPLAY". |
• 21577461
|
In Close Manager, when you create a schedule from an embedded template you cannot override the HFM POV parameters. |
• 21391947
|
In Account Reconciliation Manager, clicking release before saving or cancelling unsaved transaction causes deadlock. |
• 21867151 |
Supplemental Data Manager has the following performance issues. It takes more than 60 seconds to switch from the workflow to the Access tab, or make changes to access, and deployments run for a number of minutes and then time out. |
• 21239739 |
In Account Reconciliation Manager, when navigating to Manage, then Periods, the browser is suspended and a 503 error is returned. |
• 21479716 |
In Account Reconciliation Manager, when a Preparer or Reviewer is reassigned a reconciliation with an org unit using the action panel, the due dates are recalculated without taking into account any non-working days which were part of the calculation for the original due date. |
• 21452422 |
In Account Reconciliation Manager, you are not able to submit a reconciliation if a prior reconciliation is also open at same time. |
• 21968250
|
In Account Reconciliation Manager, exporting transactions from one tab using formatted option exports transactions from the other tab. |
• 22046642 |
In Close Manager, receive IllegalArgumentException/Illegal Group Reference when opening a schedule containing tasks with predecessors both inside and outside the schedule. |
Defect Number |
Defect Fixed |
• 20334217 |
Financial Close Managed server uses up too much memory due to some inefficient queries. |
• 20638017 |
In Financial Close Management, if you collapse 'My Worklist' panel, the state is not persisted between sessions. |
• 20903526 |
In Financial Close Management, the basic filter panel shows incorrect numbers next to certain filter attributes. |
Defect Number |
Defect Fixed |
• 20530439 |
In Close Manager, a previously deleted custom attribute prevents creation of a new attribute with the same name. |
• 20632463 |
In Close Manager Dashboard portlets, under the Schedule selection dialog, it is not possible to deselect all schedules with one click. |
• 20933254 |
In Close Manager, an administrator cannot edit tasks in a base template if the edit task dialog was opened earlier for an embedded task in the same session. |
Defect Number |
Defect Fixed |
• 20205657 |
In Account Reconciliation Manager, when creating transactions, you will see a JBO error if you enter text of over 150 characters into the Short Description field. |
• 20371421 |
In Account Reconciliation Manager, importing profiles from CSV file throws an exception when the 'Preparer Frequency' column is left blank. |
• 20696431 |
In Account Reconciliation Manager, a reconciliation with auto-reconciliation method 'Balance match (# tolerance)' would auto-reconcile even though there is no balance loaded in some currency bucket. |
• 20957140 |
In Account Reconciliation Manager, when creating a profile, an unbounded query runs, taking longer than usual, causing application to stop. |
• 21092730 |
In Account Reconciliation Manager, if a reconciliation is set to enter balances manually, it is not possible to drill-through any balances that are loaded from ERPI. |
• 21136131 |
In Account Reconciliation Manager, in some cases, incorrect attachments appear under the Instructions tab of the Format definition dialog. |
Defect Number |
Description |
· 25415982 |
In Account Reconciliation Manager, list of values in Assigned Values table in a list type calculation attribute do not automatically refresh on adding a new item in List Values table. |
· 25309404 |
In Close Manager, updating more than 1000 tasks in task list using Actions panel throws an error. |
· 25223601 |
In Financial Close Management, URL attachments pointing to files in shared folder do not work as expected. |
· 23271582 |
In Account Reconciliation Manager, email notification are not sent immediately for reassignment requests |
· 22918359 |
In Account Reconciliation Manager, in accreting transactions, the ending amount that appears in the ending amount column of the transaction may actually be the beginning amount (i.e. the ending amount for the previous period). This differs from the correct ending amount that appears for the same period in the accretion schedule of the transaction. |
· 22158466 |
In Close Manager, reopening a task does not reopen dependent tasks. |
· 21952815 |
In Supplemental Data Manager, use of Prior function in combination with dimension reference attributes throws error when opening the form |
This section includes important information about applying this patch for Oracle Hyperion Financial Close Management.
CAUTION: Because of the extensive database changes that result from applying this patch, rolling back the patch is not supported. Before you apply the patch, be sure to perform an entire system backup.
NOTE: If you wish to, take a backup of Canned Reports folders in LCM import-export location (by default, Oracle/Middleware/user_projects/epmsystem1/import_export). Applying this patch will overwrite the existing reports with latest ones.
To apply this patch:
1. All Financial Close Management patches should be installed on all the boxes that host the below managed servers:
o Financial Close Management managed server
o Foundation Services managed server
o Admin server
o SOA server
2. Since ARM Dataload no longer requires SOA, the following must be performed.
Oracle Financial Data Quality
Management (FDMEE) should be installed (but not necessarily configured) on all
the boxes that host Financial Close Management managed servers.
If FDMEE has never been installed in the WebLogic domain, please first install
FDMEE 11.1.2.4 following Oracle EPM Installation Guide. Then apply FDMEE
version 11.1.2.4.210 (Patch 23041471).
3.
Before applying this patch, confirm the environment is running properly:
Windows:
Go to Start, then Programs, then Oracle EPM System, then Foundation Services, then epmsystem1, and then EPM System Diagnostic.
Linux:
Run this command:
<Middleware_Home>/user_projects/epmsystem1/bin/validate.sh
All tests should display PASSED.
4. Stop Financial Close Managed Server, Foundation Services Managed Server and SOA managed server.
5. Download and unzip the downloaded patch file, <PATCH FILE NAME>.zip, to the <EPM_ORACLE_HOME>/OPatch directory (by default, Oracle/Middleware/EPMSystem11R1/OPatch).
NOTE: <PATCH FILE NAME>.zip is the name that My Oracle Support assigns to this patch. When you download the file, a message indicates the file name.
6. From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.
7. To apply the patch, enter the following command on one line:
Windows:
opatch.bat apply
<EPM_ORACLE_HOME>/OPatch/27479194 -oh <EPM_ORACLE_HOME>
-jdk <MIDDLEWARE_HOME>/jdk160_35
NOTE: The default for <EPM_ORACLE_HOME> is C:/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:/Oracle/Middleware.
UNIX/Linux:
./opatch apply <EPM_ORACLE_HOME>/OPatch/27479194 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_35 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc
NOTE: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.
Update mod_wl_ohs.conf file to increase the HTTP timeout setting. This is required to avoid errors in long-running LCM operations. LCM operations can take considerable time depending on the volume of data in Financial Close Management application.
1. Make a copy of this file for backup: <EPM_ORACLE_INSTANCE>\httpConfig\ohs\config\OHS\ohs_component\mod_wl_ohs.conf
2. Edit mod_wl_ohs.conf to add the entry “WLIOTimeoutSecs 7200” under the following items
a. <LocationMatch ^/arm>
b. <LocationMatch ^/fcc>
c. <LocationMatch ^/sdm>
d. <LocationMatch ^/taxop>
e. <LocationMatch ^/tss>
NOTE: If you have not installed Tax Governance, entries for d. and e. may not exist and can be skipped.
Example:
Change
<LocationMatch ^/arm>
SetHandler weblogic-handler
WeblogicCluster <server>:<port>
</LocationMatch>
To
<LocationMatch ^/arm>
SetHandler weblogic-handler
WeblogicCluster <server>:<port>
WLIOTimeoutSecs 7200
</LocationMatch>
NOTE: This step could be skipped if you are applying this patch on top of 11.1.2.4.200 PSU or later.
Starting in version 11.1.2.4.200, ARM invokes FDMEE RESTful APIs for creating data load definitions or executing data load rules, which depends on json libraries. Starting in version 11.1.2.4.200, ARM also invokes ODI agent remotely in Java, therefore it depends on ODI libraries too. Those libraries need to be added to FCM managed server’s classpath for ARM data load to work.
1. Log into WebLogic admin console.
2. Go to Deployments
3. Click on epm-misc-libraries, and add FinancialClose cluster as its target.
4. Click on epm-aif-odi-libraries, and add FinancialClose cluster as its target.
NOTE: This step could be skipped if you are applying this patch on top of 11.1.2.4.250 PSU.
Archive feature introduced in 11.1.2.4.250 (for Close Manager, Tax Operations and Account Reconciliation Manager) makes use of SharedServices library APIs to make LCM calls. SharedServices library needs to be added to FCM and TAX managed server's classpath for this feature to work.
1. Log into WebLogic admin console.
2. Go to Deployments
3. Click on epm-hss-libraries, and add FinancialClose and TaxManagement cluster as its target.
NOTE: This step could be skipped if you are applying this patch on top of 11.1.2.4.250 PSU.
Archive feature also needs a new log-handler
1. Take a backup of existing file <DOMAIN_HOME>\config\fmwconfig\servers\FinancialClose0\logging.xml
2. Edit the file to add below entry under <log_handlers> XML tag
<log_handler name='epmlcm-handler' class='oracle.core.ojdl.logging.ODLHandlerFactory' level='TRACE:32'>
<property name='useDefaultAttributes' value='false'/>
<property name='format' value='ODL-Text'/>
<property name='path' value='${domain.home}/servers/${weblogic.Name}/logs/SharedServices_FCM_LCM.log'/>
<property name='maxFileSize' value='1000000'/>
<property name='maxLogSize' value='5000000'/>
<property name='useSourceClassAndMethod' value='true'/>
</log_handler>
3. Add the below entry under <loggers> XML tag
<logger name='oracle.EPMLCM' level='NOTIFICATION' useParentHandlers='false'>
<handler name='epmlcm-handler'/>
</logger>
4. Take a backup of existing file <DOMAIN_HOME>\config\fmwconfig\servers\TaxManagement0\logging.xml
NOTE: If you have not installed Tax Governance, this file may not exist and can be skipped.
5. Edit the file to add below entry under <log_handlers> XML tag
<log_handler name='epmlcm-handler' class='oracle.core.ojdl.logging.ODLHandlerFactory' level='TRACE:32'>
<property name='useDefaultAttributes' value='false'/>
<property name='format' value='ODL-Text'/>
<property name='path' value='${domain.home}/servers/${weblogic.Name}/logs/SharedServices_TAX_LCM.log'/>
<property name='maxFileSize' value='1000000'/>
<property name='maxLogSize' value='5000000'/>
<property name='useSourceClassAndMethod' value='true'/>
</log_handler>
6. Add the below entry under <loggers> XML tag
<logger name='oracle.EPMLCM' level='NOTIFICATION' useParentHandlers='false'>
<handler name='epmlcm-handler'/>
</logger>
1. Make sure there are NO running system automated tasks or event monitoring tasks in Close Manager.
2. Shutdown Financial Close Managed Server if it is running.
3. Make sure Admin Server, Foundation Services Managed Server and SOA managed server are running.
4. On the Financial Close Management Managed server(s), open the command line window and change the directory to <EPM_ORACLE_HOME>\products\FinancialCloseManagement-Common\scripts
5. Set the environment variables:
Windows:
1. Set the EPM_ORACLE_INSTANCE environment variable by running the below command in the command line. Ensure that there is no space before and after =.
set EPM_ORACLE_INSTANCE=<MIDDLEWARE_HOME>\user_projects\<INSTANCE_NAME>
Example:
set EPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1
UNIX/Linux:
1. Set the EPM_ORACLE_HOME environment variable by running the below command in the command line based on shell.
setenv EPM_ORACLE_HOME <MIDDLEWARE_HOME>\EPMSystem11R1
or
export EPM_ORACLE_HOME=<MIDDLEWARE_HOME>\EPMSystem11R1
Example:
setenv EPM_ORACLE_HOME \Oracle\Middleware\EPMSystem11R1
2. Set the EPM_ORACLE_INSTANCE environment variable by running the below command in the command line based on shell.
setenv EPM_ORACLE_INSTANCE <MIDDLEWARE_HOME>\user_projects\<INSTANCE_NAME>
or
export EPM_ORACLE_INSTANCE=\Oracle\Middleware\user_projects\<INSTANCE_NAME>
Example:
setenv EPM_ORACLE_INSTANCE \Oracle\Middleware\user_projects\epmsystem1
6. Run the database and SOA Deployment/Cleanup script:
In the same command line window, run the below command
Windows:
PS4251.bat
Linux:
PS4251.sh
NOTE: Make sure there are no errors displayed in the command window after execution of PS4251 script. If there are any, go to the Troubleshooting section below before contacting Oracle Support.
7. Start Financial Close Managed Server.
8. Confirm the environment is running properly after the patch has been applied:
Windows:
Go to Start, then Programs, then Oracle EPM System, then Foundation Services, then epmsystem1, and then EPM System Diagnostic.
Linux:
Run this command: <MIDDLEWARE_HOME>/user_projects/epmsystem1/bin/validate.sh
All tests should display PASSED.
9. Validating Close Manager Configuration:
f. Launch the Close Manager validation tool from a web browser:
http://<FCMHOST>:<FCMPORT>/fcc/faces/oracle/apps/epm/fcc/ui/page/FCCValidation.jspx
Where FCMHOST is the name of the machine where FinancialClose0 managed server is configured and where FCMPORT is the Listening port of FinancialClose0 managed Server in the WebLogic console.
The default FCMPORT is 8700.
g. Log on with Close Manager administrator credentials.
h. To validate the Close Manager configuration, click the Validate Close Manager Configuration button.
i. All results should have check marks instead of an X.
10. Validating Account Reconciliation Manager Configuration.
a. Launch the Account Reconciliation Manager validation tool from a web browser:
http://<FCMHOST>:<FCMPORT>/arm/faces/oracle/apps/epm/arm/ui/page/common/ARMValidation.jspx
Where FCMHOST is the name of the machine where FinancialClose0 managed server is configured and where FCMPORT is the Listening port of FinancialClose0 managed Server in the WebLogic console.
The default FCMPORT is 8700
b. Log on with Account Reconciliation Manager administrator credentials.
c. To validate the Account Reconciliation Manager configuration, click the Validate Account Reconciliation Manager Configuration button.
d. All results should have check marks instead of an X.
11. All users should now clear cached files from their browsers.
12. Optionally import latest Canned Reports by running LCM import from Shared Services.
13. If System automated and Event monitoring integrations are not being used, SOA server could be shutdown to save resources.
Run this command to shut down SOA server:
Windows: <MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/bin/stopManagedWeblogic.cmd <SOA_SERVER_NAME>
Linux: <MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/bin/stopManagedWeblogic.sh <SOA_SERVER_NAME>
You could also shutdown the server from WLS admin console. Go to Servers -> Control page, select SOA server and click Shutdown
Close Manager
For pre-existing installations which have been tuned for
increased SOA Server utilization, it is possible to reduce the memory
allocation of the SOA Server managed Weblogic server. The memory allocation
settings are specified in the startup script file SOADomainEnv
Windows: <MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/bin/
setSOADomainEnv.cmd
Linux: <MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/bin/
setSOADomainEnv.sh
The
JVM heap settings can be modified to:
set DEFAULT_MEM_ARGS = -Xms768m -Xmx1200m
Account Reconciliation Manager, Supplemental Data Management
If Close Manager is not being used, the SOA server could
be shut down.
Data Source Connection Pool Tuning
If connection pool Statement
Cache Size values have been increased, they may be decreased to reduce the
per-session JVM memory consumption without impacting performance. The maximum
recommended value is 30 for the data sources: accountreconciliation_datasource,
financialclose_datasource, financialclosecommon_datasource,
taxoperations_datasource, taxsupplementalschedules_datasource
The SOA relateddata sources EDNDataSource, EDNLocalTxDataSource, SOADataSource,
SOALocalTxDataSource can have their statement cache sizes reduced to a maximum
value of 20.
If the patch that you apply conflicts with a previously applied patch, you may receive the following error message when running OPatch:
Patch(es) <PreviousPatch#> conflict with the patch currently being installed (27479194).
If you continue, patch(es) <PreviousPatch#> will be rolled back and the new patch (27479194) will be installed.
If a merge of the new patch (27479194) and the conflicting patch(es) (<PreviousPatch#>) is required, contact Oracle Support Services and request a Merged patch.
This error is returned when one patch attempts to update a previously patched file. When this conflict happens, you can do either of the below
1. Do not rollback if you see a conflict message for any 11.1.2.3.xxx patch. Contact Oracle Support representative.
2. Roll back the previous patch and apply the new patch (this action might be appropriate if the previous patch was not critical).
3. Request a merged patch consisting of the new patch and the patch that it conflicts with. To request a merged patch, contact your Oracle Support representative.
This warning means that the patch being applied is a superset of a patch already on the deployment and the existing patch will be rolled back. The following snippet shows the context of this warning.
The following warnings have occurred during OPatch
execution:
1) OUI-67078:Interim patch 12345678 is a superset of the patch(es) [77777777]
in OH C:\Hyperion
-----------------------------------------------------------------------------------
OPatch Session completed with warnings.
In EPM System Release 11.x, you can use the lsinventory command to OPatch to find the release and patches that are installed in an Oracle Home. For example, enter the following command on one line:
Windows:
opatch.bat lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_35
UNIX/Linux:
./opatch lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_35 –invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc
When patching an .EAR file for an application, you may need to delete the cached files in the following folders in order to see the changes provided with the patch:
<MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/
<MANAGED_SERVER_NAME/tmp/
<MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/
<MANAGED_SERVER_NAME/cache
Copyright © 2017,Oracle and / or its affiliates. All rights reserved. http://www.oracle.com