(完整版)Oracle Hyperion Financial Close Applications简介 - 翻译版

Oracle Hyperion PlanningOracle Hyperion Planning is an agile planning solution that supports enterprise wide planning, budgeting, and forecasting using desktop, mobile and Microsoft Office interfaces. It provides a robust modeling framework that helps develop reliable financial forecasts based on sales and operational assumptions to produce cost effective enterprise alignment. With Oracle Hyperion Planning, you have a solution that is best in class and proven in the market place to provide timely, actionable plans to help make informed business decisions. Oracle Hyperion Planning can be deployed on-site or in the Cloud.K E Y B U S I N E S S B E N E F I T S• Reduce budgeting and planning cycles by weeks or months• Improve forecast reliability• Appeal to a wider user community through an intuitive Web user interface• Provide familiar user interface for users with full Microsoft Office integration• Reduce planning cycles with anywhere, anytime mobile• Eliminate time lag between when plans are updated and reports are refreshed• Reduce cost of ownership through superior application deployment, management tools and packaged data integration• Lay the foundation for making the transition to Enterprise Business Planning Streamline Enterprise-wide Planning and Budgeting ProcessEnterprise alignment is challenging to achieve in financial plans due to disconnect between the office of finance and sales and operational business units. Financial planning and forecasting often ends up being a resource and time consuming process of gathering information spread across a multitude of disconnected spreadsheets or point solutions used by the office of finance and various sales and operational business units.Oracle Hyperion Planning provides the required agility to the enterprise planning process by quickly aligning financial plans, models and forecasts across cost centers and lines of business thus enabling decisions to be made at a speed which business demands. The impact of changes to key plan drivers and assumptions can be evaluated instantaneously, and revisions made available immediately to all stakeholders without the reliability risks from manual interventions. Oracle Hyperion Planning has built in time intelligence and allocation logic and comes with a powerful calculation engine that can be used to express a range of business requirements, from simple arithmetic formulae to complex allocations. Oracle Hyperion Planning offers guided task flows and supports both bottom-up and top-down agile planning processes. Its robust workflow capabilities support efficient review and approval processes.Ensure Reliability with Predictive Planning and Rolling ForecastsCompanies today are faced with a rapidly changing business environment. Constantly changing market dynamics can bring in demand, supply and price fluctuations that require decisions based on alternate outcomes. A key need to make informed decisions in such a market is to be able to understand the financial impact of key business driversand revise forecasts reliably and quickly.K E Y F E A T U R E S• Hybrid data model facilitates planning, analysis and commentary • Flexible workflow capabilities• Reliability with predictive planning capabilities• Seamless Microsoft Office integration • Collaboration and alignment with easy to use mobile friendly web interface• Built in reporting and dashboards • Proven and scalable architecture • Robust integration with ERP sources with drill back• Enterprise grade deployment and backups• Agility with full mobile planning and workflow capabilities• Instant calculations and fast aggregations Oracle Hyperion Planning provides sophisticated predictive planning capabilities that can generate reliable statistical predictions based on time series data over long periods of history while capturing seasonality impacts along the way thus enabling forecasts to be more reliable. Oracle Hyperion Planning also provides on the fly what if modeling capabilities for planners to assess the impact of various combinations of business assumptions on key financial outcomes. To facilitate planners’ ability to revise business and market impacts on forecasts quickly, Oracle Hyperion Planning comes out of the box with rolling forecast capabilities that makes the whole planning process even more agile from the get go.Collaborative Planning within an Intuitive Scalable Web InterfaceOracle Hyperion Planning enables business users to concurrently collaborate on their plans and report in an easy to use mobile friendly web interface with instant calculation and dynamic fast aggregation for large volumes of data making it perfectly suited for enterprise grade deployments. It is built with device form factor in mind with intuitive navigation enabling users manipulate and adjust plans drivers, or perform allocation and spread actions across multiple data intersections. For sophisticated users, Oracle Hyperion Planning supports advanced yet intuitive ad-hoc modeling capabilities to quickly zoom in to relevant data intersections using pivot and drill capabilities. It provides guided task flows for less-frequent users’ intuitive guidance. This ensures that everyone can participate in the planning process.Figure 1: The intuitive mobile friendly web interface of Oracle Hyperion Planningcombines task flows, templates and ad-hoc models, dashboards and reportsEnhance Productivity with Full Microsoft Office Suite IntegrationOracle Hyperion Planning leverages Oracle Hyperion Smart View for Office as the Microsoft Office interface allowing for planning actions within Outlook, Excel, Word and PowerPoint with built in prediction capabilities. Users can take all actions and engage in a collaborative planning process while working within the comfort of Microsoft Excel.Modeling in Excel during the planning phase is facilitated with sophisticated ad hoccapabilities where rows, columns and other axis can be pivoted on the fly to view the information from different points of view for quick analysis and forecasting. Common planning actions, such as spreading and allocation, are provided as context sensitive menus within input templates rendered within Microsoft Excel.Creating customized input templates in Oracle Hyperion Planning is very simple. Users can create input grids and format them using familiar Excel font and number formats and on the click of a button generate input templates targeted at specific business units. Additionally, users can seamlessly move planning data across Excel, PowerPoint and Microsoft Word. This allows the creation of customized dynamic reports and presentations with accurate information and users can refresh the document to automatically consume the collaborative changes in the underlying database. The end result is intuitive usability, reduced manual intervention, improved reliability, and increased agility.Figure 2: The built-in Microsoft Office integration in Oracle Hyperion Planning allows users to update, format and perform on the fly predictive modeling in Microsoft Office.Enable Agility with Mobile AccessBusiness users can perform common planning, budgeting and forecasting tasks with a fully functional browser based experience from their iOS, Android or Windows tablets. The commonly used features available via a tablet-optimized user experience include accessing task lists, viewing dashboards and reports, entering data and performing ad-hoc modeling. In addition workflow review and approvals processes can be executed on-the-go via the Oracle EPM Mobile App on iOS and Android phones. These mobilecapabilities help improve user productivity and reduce planning cycle times.Figure 3: A fully mobile optimized browser experience for tablets and desktops facilitates planning when you need and where you want.Integrate Planning and Management Reporting SeamlesslyReports and dashboards that display planning information can be created in minutes, and any changes made to the plans in Oracle Hyperion Planning are instantaneously reflected in the content of the reports and dashboards. Using the web interface, users can access user-friendly dashboards, interactive analytics, and richly formatted financial reports while interacting with the planning system. Users can create book reports for management reporting and these can be accessed on demand on a desktop or on mobile.Figure 4: Fully formatted reporting capabilities facilitate enterprise wide distributedreporting and quick generation of management book reports.Oracle Hyperion Planning’s powerful workflow functionality, including e-mail notifications, alerts, and dashboards, empowers users to track and communicate the progress of plans and budgets. Ownership of plans can be designated based on a specified intersection of key plan dimensions. Approval paths can be altered based on data changes to provide true matrix approval. When a planner “promotes” a plan for approval, the system can automatically identify the next approver. All of the above processes can also be performed in conjunction with what-if analysis and scenario testing that allows users to compare and contrast multiple scenarios prior to promoting the selected scenario for approval up the management chain.Figure 5: Flexible and powerful planning workflow capability allows sophisticated yet snappy review and approval processes with a new mobile application.Large Deployments with Scalable Architecture at Low Cost of OwnershipOracle Hyperion Planning is built to scale with the organization’s growth. It is based on hybrid architecture, which makes optimal use of relational and MOLAP technologies to facilitate a variety of planning needs including annotations and commentary which are essential for variance analysis. The scalable architecture enables organizations to start with an initially small deployment before extending it out to hundreds or thousands of concurrent users. The architecture allows for flexible data entry, analysis, and frequent real-time updates from anywhere, in a safe and secure environment.Moreover, Oracle Hyperion Planning provides collaborative planning processes and dependable, centralized user and data management, significantly reducing maintenance and distribution costs. Oracle Hyperion Planning interoperates with accepted user management systems to help ensure maintenance and security consistency.Robust Data Integration and DeploymentsOracle Hyperion Planning facilitates bidirectional data integration with ERP systems, legacy applications, data warehouses, and other enterprise data sources. The solutionO R A C L E E N T E R P R I S E P E R F O R M A N C E M A N A G E M E N T A P P L I C A T I O N SOracle enterprise performance management applications are an integrated, modular suite that supports a broad range of strategic and financial performance management processes and helps unlock business potential.R E L A T E D P R O D U C T SOracle enterprise performance management applications provide the following capabilities:• Strategy Management• Financial Close and Reporting• Planning, Budgeting and Forecasting • Profitability and Cost Management • Enterprise Data Governance is built to be flexible to the organization’s needs. All system artifacts and data can be imported and exported or for backups using flat files or using out of box mapping features. Users can drill back from their planning data into the details in their source systems. Deployments can be easily categorized as development, test and production environments with easy movement of data models across these environments for quick and fast deployments.Lay the Foundation for Enterprise Business PlanningOracle Hyperion Planning is the center piece of Oracle’s broader solution for Enterprise Business Planning. The Enterprise Business Planning process spans strategic planning, budgeting and forecasting, workforce planning, capital asset planning, project financial planning and other elements of operational planning that have a significant impact on financial performance. It also involves an ongoing evaluation of business costs and profitability analysis and uses those insights to drive change in business plans. In addition, Enterprise Business Planning can leverage predictive analysis and simulation techniques to constantly evaluate and quantify risk and uncertainty, inherent to all of these plans, and takes actions to mitigate those risks as appropriate.CO N TAC TU SFor more information about [insert product name], visit or call +1.800.ORACLE1 to speak to an Oracle representative.C O N N E C T W I T H U S/oracle/oracle/oracleCopyright © 2015, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. 0115。

Oracle银行财务管理系统解决方案范文2022银行财务管理<InertPictureHere>驾驭风险创造价值银行财务管理为什么要实现财务信息化？关键的业务驱动力和需求业务驱动力中国加入世贸后，承诺进一步开放，必须采用国际化战略来应对国外同行的竞争和挑战。

必须尽快从规模上和管理水平上向行业领导者看齐通过成功的上市(IPO),快速的融入国际市场，提高竞争力适应国内和国际监管机构的需求，包括多会计准则、BaelII、萨班斯-奥克斯利(SarbaneO某ley)法案及行业的监管条例管理需求整合业务处理流程，以加强科学的决策制定、内部控制和风险管理提高内部管理和控制能力，在一个谨慎的、稳定的原则下，加强管理、预算控制、标准化业务流程和工作流控制满足多会计准则(Multi-GAAP)要求，为透明的信息披露和监管要求提供及时的报告有效的集成新的业务系统和其它的IT系统，符合IT蓝图的要求以股东价值最大化为目标，优化内部流程和提升盈利能力、风险控制能力系统目标优化会计核算流程，提高会计处理的自动化水平；提高会计信息质量，及时、准确地生成各类财务会计报告，满足信息披露要求；建立科学、集中、统一、规范的财务管理体系，提高各类财务资源的使用、监督及控制水平；提高成本管理及控制水平，逐步实施全面成本管理制度；建立电子化的财务管理流程，提高工作效率，规范操作流程，完善管理及核算制度；建立科学的预算管理体系，为经营决策及业绩评价提供丰富的信息。

银行财务管理现代企业财务管理目标及时、可控、可测、全面、透明、正确新的流程决策支持精密的分析&提前发现问题事后发现问题决策支持控制内含的人工、事后控制报告集成事务处理优化复杂的技术报告基于手工事务处理传统流程银行财务管理Oracle财务管理蓝图绩效管理计划和预算财务合并财务流程信用到收入现金和金库管理采购到付款差旅和费用管理监管、风险和法规遵从流程管理监管架构技术架构和工具端到端业务流程主数据管理完善安全性企业分析套件内部洞察财务控制&报表资产生命周期&不动产管理盈利分析和业务智能银行财务管理Oracle帮助银行应对财务管理挑战挑战分散的财务系统造成信息和业务流程不统一内部管理和对外披露的要求不断变化，很难及时获得相关信息。

Release 9.3.3.0.00ReadmeTo view the most recent version of this Readme, see the 9.3.x documentation library on OracleTechnology Network (OTN) at /technology/documentation/epm.html.[Skip Navigation Links]About This Release (1)Release Type (2)Supported Installation Paths (2)Supported Platforms (2)Supported Languages (2)Release Compatibility (2)Installation Updates (2)Security for Relational Database Export and Analytic Services (2)Security for the HSF Service (3)Security for Strategic Finance Server Directories (3)Security for the Admin Doc (3)Log Files and Documentation Moved to HYPERION_HOME (3)Migration Considerations (4)Migrating Users from Standard NTLM to Hyperion® Shared Services (4)Changes to the Security Regime Migration Utility (4)Defects Fixed in Release 9.3.1.0.1 (4)Defects Fixed in Release 9.3.1.1.0 (4)Defects Fixed in Release 9.3.1.2.0 (5)Defects Fixed in Release 9.3.1.3 (5)Defects Fixed in Release 9.3.1.4 (5)Defects Fixed in Release 9.3.3 (6)Known Issues in Release 9.3.3 (7)Installing Release 9.3.3 (7)Modifying JVM Settings (8)Documentation Update (9)About This ReleaseThis Readme file describes the defects fixed in Oracle’s Hyperion Strategic Finance Release 9.3.3.0.00 as well as the necessary instructions for installing this release.Release TypeThis maintenance release is cumulative and incorporates all service fixes and packs to the 9.3.1release. This release is a full installation.Supported Installation PathsThe supported installation path for Release 9.3.3 is from Release 9.3.1 and subsequent service fixes and packs only.Supported PlatformsInformation about system requirements for Release 9.3.3 products is available in the HyperionInstallation Start Here. See /technology/documentation/epm.html. Supported LanguagesRelease 9.3.3 is English only.Release CompatibilityFor most deployment scenarios, Release 9.3.3 is interoperable only with other Release 9.3.3 products.This means that you must upgrade all products in your environment to Release 9.3.3.However, note these exceptions: If you are using Performance Management Architect 9.3.1.x, you must upgrade Performance Management Architect to Release 11.1.1.3. In addition, if you areupgrading to Release 9.3.3 in order to integrate with EPM System Financial Close Management Release11.1.2 and/or EPM System Disclosure Management Release 11.1.2, some additional releases arecompatible. For more information, see the Hyperion Installation Start Here chapter, "Using Release9.3.3 Product With Components From Later Releases" and "Release Compatibility". See/technetwork/middleware/performance-management/documentation/index.htmlTop of Document Installation UpdatesThis section contains the latest information for installing this release.Security for Relational Database Export and Analytic ServicesWhen installing relational database export or Extended Analytics, when you setup login properties and secure user mapping for the database user, ensure you select, at minimum, the following database role membership options:Customer_Interfacedb_ownerdb_securityadminHSFServicepublicSecurity for the HSF ServiceThe HSF Service is installed with standard security. To secure it further, it is recommended you limit access to the minimum options necessary.On the Advanced Security Settings for HSFService – Permissions tab, select the following:Allow inheritable permissions from the parent to propagate to this object and all child objects.Include these with entries explicitly defined here.Replace permission entities on all child objects with entities shown here that apply to child objects.On the Permission Entity for HSFService – Object tab, select Allow for the following:Query ValueSet ValueCreate SubkeyDeleteRead ControlSecurity for Strategic Finance Server DirectoriesThe \Hyperion\StrategicFinance\Server, \HSFData, and \HYPERION_HOME\logs\hsf directories are created with standard read/write/access permissions. To secure it further, it is recommended you limit access to the minimum options necessary.On the Advanced Security Settings for Server/HSFData/hsf – Permissions tab, select the following:Allow inheritable permissions from the parent to propagate to this object and all child objects.Include these with entries explicitly defined here.Replace permission entities on all child objects with entities shown here that apply to child objects.On the Permission Entity for Server/HSFData/hsf – Object tab, select Allow for all options except Full Control.Security for the Admin DocThe Admin Doc (user.adm) is installed with standard security. To secure it further, it is recommended you limit access to the minimum necessary.Log Files and Documentation Moved to HYPERION_HOMEThe following log file directories have been moved into HYPERION_HOME\logs\hsf:\debug\eventLogs\userLogsThe following help directories have been moved into HYPERION_HOME\common\docs\hsf:\admin\clientMigration ConsiderationsNote the following before installing this release.Migrating Users from Standard NTLM to Hyperion® Shared Services If you are upgrading from a previous version of Strategic Finance and you are migrating to Shared Services for the first time, you must migrate users from Standard NTLM to Shared Services before upgrading to this release of Strategic Finance, or migrate users manually. Migration is performed automatically during installation. For more information, see the Oracle® Hyperion EnterprisePerformance Management System Security Administration Guide.Changes to the Security Regime Migration UtilityWhen migrating the security regime from Native NTLM to External Authentication (using Hyperion Shared Services), Strategic Finance user groups are migrated to groups in the Shared Services Native Directory. The group names are prefixed with “HSF_” to avoid conflict with other groups that may exist. After migration, the new groups are not provisioned for Strategic Finance. In order to honor any group-specific access control in Strategic Finance, you will have to provision the group.Top of Document Defects Fixed in Release 9.3.1.0.1The following accounts are adjusted:Total Shares Outstanding: Wtd. Avg. (v3410.00.0000)Potentially Dilutive Securities (Wtd. Avg.) (v3430.00.0000)Common Shares Issued (Wtd. Avg.) (v3460.05.0000)New Common Shares Issued (Wtd. Avg.) (v3465.05.0000)Treasury Shares (Wtd. Avg.) (v3470.05.0000)New Treasury Shares (Wtd. Avg.) (v3475.05.0000)The following accounts are adjusted:Common Shares Issued (Year End) (v3460.00.0000)Fixed Cover Charge (v6400.00.0000)Top of Document Defects Fixed in Release 9.3.1.1.06574237: After the Strategic Finance server has migrated from Standard NTLM to Shared Services, the Administration utility no longer allows switching back from External Authentication to Standard NTLM on the Security Mechanism control of the Server Settings – General tab.7016609: When creating new databases using the Create Database as a Copy Of feature, to fixEntity Change Manager and Assumptions Change Manager files, you can modify the files toreference the new database.6999311: On the spreadsheet, an issue with deleting rows in reports has been fixed.6999083: In Extended Analytics, SQL Server processes are closed when finished.6983297: When upgrading, an issue with existing import and export maps not displaying in thenew environment has been fixed.6918788: When logging on, an issue with illegitimate passwords suspending the authenticationprocess has been fixed.6743924: In Freestyle Reports, an issue causing newly-created entities to abort abnormally hasbeen fixed.6711998: In Excel import, an issue with importing data into custom accounts has been fixed.6710793: In Entity Change Manager, an issue with copying reports has been fixed.6701357: When modifying dimensional accounts, the scenario is now flagged for recalculation.6592002: In the uninstaller, an issue with not entirely removing files has been fixed.6588242: On the Accounts spreadsheet and in reports tabs, an issue with the Search and Replace dialog remaining open after closing a file or entity and causing the system to abort abnormally has been fixed.6581684: On the Strategic Finance server, a collision between the previous port number (1493)and the new port number (7750) has been fixed.Top of Document Defects Fixed in Release 9.3.1.2.07572347: On reports tabs, the Expand option now correctly populates newly-created subaccounts.7568422: In batch export to Essbase, an issue with no values in Scale / Currency causing novalues to be exported has been fixed.7519622: In batch import from Planning, decimal values import properly.7510179: You can now edit entity groups even when some entities are missing.7492643: In batch Essbase and Planning maps, Combined Scenarios are now available.7452290: In batch import and export maps, changing the map owner now changes the owner for the selected map.7284195: An issue with deleted ECM documents reappearing has been fixed.7272443: Opening Hyperion Strategic Finance no longer affects files open in Excel.6588241: In Entity Change Manager, all accounts are now copied from source to target regardless of dimensionality.Defects Fixed in Release 9.3.1.37492530 – You cannot copy and paste multiple cells on the Accounts tab.7503327 – The Entity Change Manager does not retain report formatting.8239897 - The Currency Translator calculates incorrectly with taxes.7492655 – You cannot copy and paste on reports.Top of Document Defects Fixed in Release 9.3.1.48397785 – The balance sheet, when using the Utility/Merger template and currency translation,becomes out of balance if there are non-zero numbers in accounts 2652.01, 2660.01, and 2654.017622828 - In the currency translation manager, you may receive incorrect period of forecasttranslations.8251706 – After upgrading, control access to maps may reference the wrong map.8209735 – The Include Sub accounts setting is not fully applied to user defined accounts.8408559 – Maps and batches do not display as expected in their corresponding tabs in theStrategic Finance Administrator.8426406 - Export batches do not display as expected on the Strategic Finance client.8372558 – Permissions do not work as expected.8429876 – The Alias Manager does not display the correct value in freestyle reports.8436467 – Formatting is inconsistently applied in reports.8486632 – Detail notes for consolidation labels are missing.8584804 – Consolidation deal periods do not roll up and aggregate correctly.8472401 – The alias entity name does not display after you refresh.8650398 - Account V2660.14.XXX does not translate.8476529 - You receive a file general point failure after selecting yes to update links whenretrieving a report from the server.8327314 – You cannot create a server based on Hyperion Financial Management import maps.8650732 – You cannot assign different scenario types to different combined scenarios.8412680 – You cannot check out Hyperion Planning batches after you create them.7622828 – The translation of the period of forecast is incorrect in the currency translator.8431598 – In some environments, after a user specifies an incorrect password, the system tries to authenticate them, but they are ultimately locked out of an MSAD provider.8585804 – Consolidation deal periods may not roll up correctly.8436467 - If formatting is inconsistent across reports, copy TTF16.oxc from the HSF Clientdirectory, paste it in the Windows System 32 directory, and run register.bat in the HSF Clientdirectory.8484000 – You receive a server busy error when importing from Hyperion Financial Management. Defects Fixed in Release 9.3.39566273 - When adding HSF entity links, window that prompts to select which source Entity to use does not appear.9527783 & 9077696 - When different time periods exist across entities, consolidation does notcomplete and error messages are noted in the log file.9129017 - When the valuation accounts are blocked, the valuation method should not change to the liquidation method. It should remain unchanged.8921556 - The page setup for report values is resolved. You can save the print or page settings to fit to page size.8742328 – Out-of-memory errors occur when checking in and pushing global assumption data.8402647 – Toolbar cannot be customized further after initial customization.8580670 - After migration, the new entity groups do not have access control to Strategic Finance.In order to honor any group-specific access control in Strategic Finance, you will have to re-provision the group.8876178 – When you create a new database from a consolidation label, the archive rules are not being followed. As a workaround, you must manually purge the archives after the copying the files.8971997 – If you do not have the access rights to edit the entity characteristics, you can create a groups access control for the consolidation structure and also can add the entities to theconsolidation group.8446717 & 8977809- If Microsoft Excel is closed and you import and try to run a selected map, you may receive a message stating that the Microsoft Excel file is already open, a subsequent Strategic Finance error, and then Strategic Finance shuts down.8968549 – Data export fails due to funds flow out of balance error.8977809 – During long-running Excel imports, error dialogs appear.9343983 – After conversion, file will not calculate after check-in.9371454 – Database export for field 164.00.000 Date Financials Received exports as null.9379958 – Excel columns display incorrectly in client-defined field.9388189 – Changing fiscal year-end is removing boundary and time periods.9475932 – Error occurs when saving file as template without time period information.Top of Document Known Issues in Release 9.3.3The following issues are the noteworthy known issues of this release.9712338 – Getting breakpoint error when copying database.9532857 - Columns display incorrectly in client defined field.8294125 – In certain cases, running multiple sub-consolidations causes issues.8247455 - Subtotals of memo subaccounts calculate incorrectly.7455465 - Changes to notes are not retained after updating a note and recalculating.7331375 - References to cells on other reports in freestyle reports do not work.7268716 – Sometimes, when running a batch of excel interface, HSF displays a server busymessage.6941125 - ECM for reports does not push account attribute.6826801 - Excel add-ins interfere with import into Strategic Finance.6591338 - When import values through a Planning/Essbase map with regional settings inPortuguese-Brazil values with decimal places are not imported.6580231 - Copying a database from labels causes access breakpoint violation.6577949 - Pushing multiple entities into SQL via extended analytics may cause performance issue.6577546 - Currency translation on consolidation where there is minority interest could causeissues.Top of Document Installing Release 9.3.3The section includes important information about installing this maintenance release of Hyperion Strategic Finance.Note: Be sure to make a backup of your hsfdata folder and any entity or consolidation files.Next, uninstall the current release of HSF.Then, install the 9.3.3.0.00 release of HSF as follows:1.From the server folder, run setup.exe to install server components. During the server install,you may specify an existing HSF database to automatically upgrade to the 9.3.3.0.00 level.2.From the reader folder, run setup.exe to install the reader components.3.On each client machine, run setup.exe to install client components.This completes the installation process.For more information, refer to the Oracle’s Hyperion Strategic Finance Installation Guide for Release9.3.1.Modifying JVM SettingsTo ensure that your Web application servers work correctly with the JVM (Java Virtual Machine), you must modify the JVM settings.Note: You can also pass the property to the JVM by updating the JVMsettings using the application server’s Administration Console.For WebLogic, WebSphere, and Tomcat Web application servers:To update the Hyperion Strategic Finance file that sets custom parameters:ing a text editor, open setCustomParamsStrategicFinance.bat (Windows) orsetCustomParamsStrategicFinance.sh (UNIX).This file is located in , whereindicates the name of your application server.This file is located in2.Specify the Java system property by modifying the directive to include:-After you make the changes, your directive may be as follows:3.Save and close the file.For Oracle Application Server:To add a Java option:1.On the Oracle Enterprise Manager Application Server Main page, in System Components,select Hyperion Strategic Finance.2.On the OC4J: Planning page, select Administration.3.On the Administration page, select Server Properties.4.Add a row for the following Java Option:5.Apply the changes and restart the Strategic Finance OPMN instance.Documentation UpdateWhen opening HTML documentation or HTML Help in Firefox 3.5.9 or later, or in Internet Explorer 8.0 or later, you may experience some display or navigational anomalies, including images not loading.This does not affect the integrity of the application content.Top of DocumentCopyright © 2010, Oracle and/or its affiliates. All rights reserved.。

Oracle Consulting Rapid Start for Oracle Hyperion Financial Close Management for AccountReconciliationsDEPLOY ACCOUNT RECONCILIATIONQUICKLY WITH ORACLE’S RAPIDSTART SERVICEThe account reconciliation functionality included in the latestrelease of Oracle’s Hyperion Financial Close Management softwareimproves data access, data quality and eases regulatorycompliance. This functionality can also help reduce risk by providingreal-time visibility into the status of the reconciliations, ensuring thatall reconciliations prepared are properly qualified. Oracle ConsultingRapid Start for Oracle Hyperion Financial Close ManagementAccount Reconciliations provides a comprehensive applicationframework, implementation methodology, and consulting services tohelp you efficiently and successfully deploy an accountreconciliation solution.K E Y F E A T U R E S•Installation of Oracle HyperionFinancial Close Managementincluding account reconciliation inyour current EPM environment.•Automated and auditablereconciliation between two systems.Choose to reconcile:o General Ledger and HFMo General Ledger and HyperionPlanningo One Sub-ledger and your GeneralLedger•Direct interfacing between the GL andaccount reconciliation for supportedERP releases using Oracle’s ERPIntegrator solution.•Automatic or manually justifiedreconciliation of up to 500 accountsusing predefined methods.•Full audit trail of all reconciliations in acentral data repository.•Consulting support to verifyreconciliation against your currentaccount reconciliation mechanisms.•Solution documentation including anAdministrators Guide.•On-site knowledge sharingService Features – Rapid Deployment and ImplementationExpertiseOracle Consulting has developed a unique approach to help you rapidly deploy theaccount reconciliation functionality. This methodology combines Oracle Consulting’sextensive implementation experience with a unique set of tools and templates thatreduce the amount of time and effort needed to deploy the reconciliation features.∙Scope: To ensure the most effective implementation, OracleConsulting Rapid Start for Hyperion Financial Close ManagementAccount Reconciliations provides a set of structured templates, to becompleted by you as part of the implementation. The templatesguide you through the process of integrating your information intothe account reconciliation solution. The templates outline all therequired information including:o Data Source Locationso Import Formatso Data Load Ruleso Data Load Mappingso ProfilesOracle Consulting will also work with your IT staff to install, configureand optimize the software in your environment.∙Approach: Oracle Consulting will support you while you completethe implementation templates. Once the templates have beenK E Y B E N E F I T S•Proven methodology for rapid application implementations•Rapid time to value for your organization•Reduced implementation risk •Lower implementation cost as compared to traditional implementation methodologiesR E L A T E D P R O D U C T SOracle Consulting offers the following, related Business Intelligence Modules: •Essbase for Financial Reporting •FCM Close Management Module •Financial Analytics•Oracle Financial Management Analytics•Human Resource Analytics •Procurement and Spend AnalyticsR E L A T E D S E R V I C E SThe following services are available from Oracle Consulting Services:: •Oracle Consulting Rapid Start for Oracle Hyperion Planning•Oracle Consulting Assessment for Oracle Hyperion Financial Management•Oracle Consulting Migration for Exalytics for Oracle Hyperion Planning and Oracle EssbaseW H Y O R A C L E C O N S U L T I N G•Leading Expertise: Oracle's own experts providing thought leadership for every Oracle solution•Broad Coverage: “End-to-end” lifecycle services across the entire Oracle product footprint•Global Scale: 13,000 Oracle experts in 145 countries, serving over 20 million users•Unified Methodology: Based on industry standards, high quality results across complex projects•Flexible Delivery: Onsite, offsite, and offshore, along with innovative solutions such as Expert Services and Architecture Servicescompleted, Oracle Consulting will use this information as the basisfor your implementation. Oracle Consulting account reconciliation,FDM and ERPi experts will deliver the completed solution to you.Your Oracle consultants will deploy the solution in your environment,answer any questions you may have about the solution and shareinformation important to your ability to manage and administer thesolution.Service BenefitsOracle Hyperion Financial Close Management Rapid Start Service for Account Reconciliations provides the following key benefits:∙Proven methodology for rapid application implementation – Oracle Consulting has strong skills and long experience in integrating ERPand EPM solutions. We have combined that experience with ourknowledge of account reconciliation solutions into this Rapid Startprogram.∙Rapid time to value for your organization – Deploy the solution in a short time period leveraging a rapid start approach.∙Reduced implementation risk – This service brings structure to not only the approach but also to the underlying solution. This structureallows us to deploy quickly and with better accuracy.∙Quickly adapt to change – Optimize your existing solution so that you can more easily adapt to your organization’s ongoing changes.∙Lower implementation cost as compared to traditionalimplementation approaches – The rapid start approach is designedto reduce the time and effort needed to deploy your accountreconciliation solution. This rapid project approach reduces theimplementation costs and can dramatically improve your ROI. RequirementsYour organization will need to have licensed the Oracle Financial Close Management solution and Oracle Hyperion Financial Data Quality Management including the adapter pack that contains the ERP Integration Adapter(s) prior to engaging Oracle Consulting. If you already have Oracle’s Hyperion EPM software in place, this service can include an option to upgrade your existing environments.Oracle Consulting strongly recommends that at least one individual from your organization attends the Oracle Financial Close Management training. To learn more about the training, please visit 2 ORACLE CONSULTING RAPID START FOR ORACLE HYPERION FINANCIAL CLOSE MANAGEMENT ACCOUNT RECONCILIATIONSHow We Are DifferentThe Oracle Consulting team is focused exclusively on Oracle Technologies, andwe have the experts that others turn to for leading practices in Oracle hardwareand software implementations. We know how to best optimize your investment inOracle products and can provide your business with tightly integrated,comprehensive, superior services throughout your ownership experience.Getting StartedLeverage Oracle’s methods, tools, and extensive experience with customerimplementations across diverse industries and geographies. Tight integrationacross Consulting, Development, Support, Education, and Global Delivery puts theentire Oracle team behind your success. To learn more, contact your local OracleConsulting representative, or visit /consulting .。

ORACLE HYPERION FINANCIAL CLOSE MANAGEMENTORACLE’S FINANCIAL CLOSE MANAGEMENT SOLUTION IS THE FIRST OF ITS KIND – A FINANCIAL CLOSE MANAGEMENT SOLUTION THAT SPANS THE EXTENDED FINANCIAL CLOSE CYCLEFEATURES•Web-Based Task Scheduling •Pre-built dashboards •Active Calendars•Task automationBENEFITS•Process consistency •Improved control•Clear communication•Easy to identify bottlenecks The Oracle Hyperion Financial Close Management application is built for centralized, web-based management of period-end close activities across the extended financial close cycle. The first application of its kind, Oracle Hyperion Financial Close Management will help manage all financial close cycle tasks including ledger and sub-ledger close, data loading and mapping, financial consolidation, reconciliation, tax/treasury and internal and external reporting processes – any task associated with the extended financial close.Get Control of the Extended Financial CloseMost companies manage the extended financial close process using offline spreadsheets, emails and phone calls. This is cumbersome and time-consuming and can often slow the financial close and make it more error-prone. Another challenge is the wide diversity of the tasks themselves - the financial close can mean different things to different people. To a divisional controller it may mean closing out the sub-ledgers and general ledger at month end or quarter end and submitting the results to corporate. To a headquarters accountant the financial close is about collecting the details from the divisions, making final adjustments and performing the corporate financial consolidation and reporting. And, to the CFO and other finance executives it’s about finalizing the results, announcing earnings and creating 10Q/10K’s and other regulatory filings for the SEC and other stakeholders. The extended financial close and reporting process is all of the tasks and processes from closing out the sub-ledgers to creating and delivering financial filings to the SEC and other regulatory bodies – which involves many systems, departments and individuals. This process is very complex to manage and too important to control using “hope and email.”Ultimately, without a centralized approach to task management, it becomes more difficult to deliver results quickly to both internal and external stakeholders – while ensuring compliance, auditability and accuracy. And, without an automated system for coordinating and tracking the entire process, identifying bottlenecks and areas for potential improvement, it’s very difficult to shave time from the extended close and reporting process.Example of the Extended Financial Close CycleKey FeaturesFunctionality includes:•An easy to use task scheduling and management feature to ensure the correct prioritization of closing tasks.•Pre-built, web-based dashboards for monitoring the progress of the financial close. Common calendar views, task list views, and Gantt views are leveraged for each user’s tasks based on security.•Active calendars and task lists that allow you to launch applications to complete tasks from the calendar itself.•An automation feature – allows you to schedule tasks for lights-out processing.• A roll-forward feature that allows you to quickly set up new financial close calendars based on the prior financial close.Tasks can be anything that needs to be done during the close process – whether in the transaction system, general ledger, consolidation system or reporting system. Employees are assigned to each task and the tasks are given a due date relative to each period end date so it’s also easy to identify bottlenecks in the process.Oracle Hyperion Financial Close Management Dashboard Summary With Oracle Hyperion Financial Close Management, companies can begin managing the financial close process proactively, rather than being surprised by failures in the process that can cause extensive delays. In addition, once bottlenecks and inefficient processes are made visible, they can be dealt with through process improvements and clear communication of objectives. Oracle Hyperion Financial Close Management can be the first step to a world-class financial close. Contact Us For more information about Oracle Hyperion Financial Close Management, please visit or call +1.800.ORACLE1 to speak to an Oracle representative. Copyright © March 2010, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.ORACLE’SPERFORMANCE MANAGEMENTAPPLICATIONSOracle’s performance management applications comprise a modular suite of integrated applications that support a broad range of strategic and financialperformance management processes to enablemanagement excellence. Part of Oracle’s enterprise performance management system, theseapplications can be quickly deployed out of the box, extended with Oracle’s business intelligenceproduct family, or tailored to meet your organization's specific needs.RELATED PRODUCTS: Oracle’s performance management applications include the following products:Strategy Management SolutionsFinancial Close and Reporting Solutions• Oracle Hyperion Financial Management• Oracle HyperionDisclosure Management • Oracle Hyperion Financial Data Quality Management • Oracle Hyperion Analytics Link for Oracle Hyperion Financial Management • Oracle Hyperion Financial Reporting• Hyperion Enterprise Enterprise Business Planning Solutions Profitability and Cost Management Solutions Enterprise Dimension Management Solutions。

Oracle EPM 产品线Oracle EPM 产品线Oracle Hyperion Planning(HP): Oracle Hyperion 财务计划软件是一个基于Excel 和Web 集中进行计划、预算和预测的解决方案。

该解决方案集成了财务和运营计划流程。

它通过紧密集成财务和运营计划模型提供有关业务运营及其对财务的影响的深入洞察力。

借助该软件，企业可以满足当前的各种财务计划需要，同时构建一个支持未来跨职能扩展和自动化流程集成的平台。

Hyperion Planning 提供：同步的财务和运营规划流程集成的、同类最佳的分析功能Microsoft Office 集成，包括分散的脱机规划功能简化的Web 界面预定义的功能解决方案强大的工作流功能可伸缩的体系结构强健的数据集成主要益处：确保准确性——通过一流的集成分析功能验证各项预测缩短预算时间——将预算时间缩短几周或几个月使机构协调一致——将财务和运营计划整合在一个系统中快速满足财务需要——满足当前的财务需要，同时支持针对特定运营机构的预算流程最大限度地增强建模功能——通过与Microsoft Excel 近乎无缝的集成来支持高级、强大的用户建模功能获得广大用户的认可——通过简化的Web 界面赢得更广泛的用户群缩短实施时间——增加了可快速实施的打包的计划功能模块Oracle Hyperion Financial Management(HFM):Oracle 的Hyperion Financial Management (Financial Management) 软件是一个基于Web 的综合企业绩效管理应用程序，它在单一、高度伸缩的财务分析软件解决方案中提供了全局采集、财务整合、报表和分析功能。

Financial Management 有助于财务部门改善财务结算和报告过程，降低风险，以及与企业其他部门达成积极的业务伙伴关系。

通过各组件的彼此协作，Oracles Hyperion Performance Management 应用程序可以帮助企业聚焦于资源，改进运营效率，有效管理以创造收益，以及抓住发展机遇。

Oracle Hyperion财务管理主要特性和益处主要特性z全球合并功能z可伸缩的 Web 架构z智能维度z完善的审计跟踪z功能强大的报表编制和分析工具z强健的数据集成主要益处z将合并、结算和报表编制周期缩短数天或数周，在内部和外部提供及时的结果z削减合规成本，通过 Web 提供单一版本信息，以提高内部和外部透明度z维护针对总账审计跟踪的 10 K/Q，增强对数字的信心z轻松对关键绩效指标和运营指标执行深入分析z从公司、产品、品牌和客户群方面发现新的盈利来源和现金流z通过与现有 IT 投资集成的打包财务智能功能，快速实现新的效益z根据需要并按预算从一整套企业绩效管理软件中添加功能 Oracle Hyperion财务管理是一个利用高级 Web 技术构建的财务合并和报告管理软件，由财务团队使用和维护。

它赋予了财务经理快速结算并报告财务结果的能力，满足了全球法规要求，降低了合规成本，增强了对数字的信心。

满足了当今严格的报表规定许多财务主管都面临着使用难以维护和审计的电子数据表来整合公司财务和运营结果的艰巨任务。

一些人为定制的报表解决方案所累，因为其无法伸缩或者满足全球需求，而其他一些则依赖基于总账的方法，但是如果没有 IT 的大力支持，该方法无法从众多的事务处理系统中提取数据。

解决之道在于提供单一版本数据源——一个集成来自多个系统财务和运营结果的视图，而且不存在任何延迟。

借助作为Oracle企业绩效管理软件之一的Oracle Hyperion 财务管理，您可以改进结算和报表编制流程，降低内部控制风险。

财务经理可从记分员的角色转变为业务合作伙伴，从而提供可支持战略和运营管理决策的财务分析。

通过针对特定用途构建的功能，Oracle Hyperion财务管理可作为可持续合规框架的基础，并帮助企业遵守严格的报表规定。

与那些依赖特定事务处理系统的解决方案或那些无法成功专注于许多不同业务流程的“一体化”管理软件不同，Oracle Hyperion财务管理软件提供了财务合并和报表方面的企业级功能和深度。

Oracle Financial ServicesTrading ComplianceRegulatory agencies have set clear mandates for financial institutions to intensify compliance initiatives and ensure that a culture of compliance prevails throughout the organization. A rigorous approach to monitoring and surveillance of trading activity that generates meaningful alerts, enables efficient investigation and analysis, and streamlines the ongoing management and r eporting of relevant information is key to a firm’s ability to meet more stringent regulatory expectations and achieve an operating environment that protects the firm’s reputation and customers. The proven capabilities of the Oracle Financial Services Trading Compliance solution for monitoring proprietary, employee, and customer trading can serve as a cornerstone of a Financial Crime and Compliance Management strategy.K E Y F E A T U R E S•Prebuilt scenarios and detectiontechniques•Tools for custom, ad hoc scenariocreation•Comprehensive instrument coveragewith trader, customer, security andaccount alert focuses•Adaptability to industry regulatorychanges•Extensive monitoring of potential market abuse/manipulation•Full documentation of ingestionprocess, data model and scenario logic •Iterative data ingestion process allowsfor efficient behavior detectionexpansion•Market replay and ad hoc reporting •Complete documentation, workflow, and audit trail Identify Potentially Problematic Behavior across Asset ClassesOracle Financial Services Trading Compliance leverages a robust and comprehensive list of trading behavior detection scenarios to help firms monitor activities and detect actions that can lead to non-compliance with regulation and loss of reputation in the market. A sample of the areas of coverage include:∙Market Manipulation and Abuse: Representative scenarios in this area include Marking the Open/Close, Spoofing and Layering, Wash Trading and Parking,Spoofing and others.∙Insider Trading and Control Room: Representative scenarios in this area include Trading Ahead of Material Events, Front Running Related Products, Trading Against Restricted Lists, and others.∙Off Market Pricing and Best Execution: Representative scenarios include Off Market Fair Pricing, Excessive Markups/Markdowns, Price Dis-improvement, Order Execution Un-timeliness, and others.Key Features and FunctionalityDetection of complex behaviors through “scenarios” that apply sophisticated data mining tools and algorithms has been the hallmark of the Oracle Financial Services since 1996. In addition to a comprehensive offering of scenarios that remain widely recognized as the most configurable of detection techniques, Oracle Financial Services Trading Compliance offers the following key capabilities:∙Flexibility and Configurability: Throughout the application, from the user interface to the underlying alert generation approach, users can readily tailor the application to meet any specific needs of the firm or an individual user.K E Y B E N E F I T S•Provide proactive view of all trading activity•Increase customer satisfaction & loyalty •Improve regulator relationships •Extend compliance process efficiencies with a configurable platform and a thoroughly documented solution •Reduced time to market and cost of complianceR E L A T E D P R O D U C T SThe following products are also available from Oracle Financial Services Analytical Applications:•Oracle Financial Services Broker Compliance•Oracle Financial Services Crime and Compliance Management Analytics •Oracle Financial Services Trade Blotter •Oracle Financial Services Anti Money Laundering•Oracle Financial Services Fraud •Oracle Financial Services Know Your Customer•Oracle Financial Services Enterprise Case Management•Oracle Financial Services Currency Transaction Reporting ∙Oracle Business Intelligence (OBI) Reporting, Analytics, and Dashboards: Oracle Financial Services Trading Compliance offers a range of behavioridentification approaches ranging from the simple to the complex. Oracle Business Intelligence complements scenario detection with a robust set of tools for analytics and reporting.∙Expedited Implementation Processes: Quality data will always be the driver of quality alerts. Oracle Financial Services provides multiple approaches to dataacquisition that can get you up and running faster than ever.∙Extended Scenario Library: With over 200 unique patterns for detecting unusual trading activity, Oracle Financial Services Trading Compliance meets requirements of financial institutions of all sizes in every global market.∙Highly Configurable Scenarios: Compliance is not a one-size-fits-all business.Oracle Financial Services' pre-built scenarios are easily configured with parameters that allow institutions to match their individual compliance philosophy, risk tolerance, and personnel resource availability with the appropriate level of monitoring andanalysis.∙Threshold Analyzer: Regulators routinely drill compliance personnel on the selected settings for their monitoring efforts. Threshold Analyzer looks at historic alerts to help firms hone in on the ideal settings and demonstrate quantitatively to regulators the rationale for the firm’s decisions.∙Automated Alert Correlation: A compliance officer’s best friend, the Alert Correlation tool automatically searches across all Oracle Financial Services alerts to identify potentially undiscovered relationships.∙Enterprise Case Management: Designed to meet the specific needs of the financial crime and compliance management user community, the Oracle Financial Services Case Management component offers a separate case management workflowintegrated with the alert workflow. Users can generate new cases or promote existing alerts to cases enabling a more holistic and enterprise approach to compliance risk management.∙More Alert Perspectives: Core scenarios generate alerts from multiple perspectives, or “focus types,” enabling alerts on individual traders, trading desks/benches/books, customer accounts, other firm employees, individual securities, orders, and/orexecutions.∙Mature Data Model: Experienced compliance personnel understand that a rich data set enables quality alerts and the efficient analysis of those alerts. Oracle Financial Services leverages a robust data model for compliance risk management that is essential for identifying the complex behaviors that most threaten the financial firm in the form of reputational and regulatory risk.∙Comprehensive Instrument Coverage: As regulatory inspection and global regulatory reform extends to more complex asset classes, Oracle Financial Services can easily adapt. When combined with existing scenarios for Equities, Fixed Income, and Mutual Funds, firms can re-purpose scenarios against other asset classes thru performance-engineered threshold settings and updated presentation layersdesigned expressly for the dramatic variations in trading different asset classes. Monitor Trading In Line with Regulatory and Customer ExpectationsSecurities fraud and market abuse —often committed through manipulation of market or customer trades and accounts— is an ever-present problem for the global financial services industry. Rogue traders, bad employees, and changing economic conditions, can all drive individual and organizational behaviors that range from questionable and manipulative to fraudulent and criminal. Regulatory demands continue to exert pressure around trading compliance issues such as market manipulation, insider dealing, and fairdealing with customers.Oracle Financial Services Trading Compliance applies sophisticated pattern recognition techniques to monitor trading activities regarding global regulatory compliance. The solution provides trade-by-trade visibility into interactions between traders and other market participants to identify potentially problematic practices.Oracle Financial Services Trading Compliance allows you to achieve:∙ A Proactive View of All Trading Activities. By allowing you to discern intentional from unintentional trading behaviors and detect trader and customer behaviors,Oracle Financial Services Trading Compliance gives you greater insight into your trading activities like the ability to identify trade-by-trade detail at the exact time an event occurs and its resulting impact.∙Improved Regulator Relationships. Oracle Financial Services Trading Compliance covers numerous asset classes, market segments and jurisdictions, through the use of industry-proven scenarios to identify key behaviors. Leveraging multiple detection cycles (for example, intra-day, daily, multi-day), you can readily respond to regulator inquiries by indicating that a potential problem has been identified and corrected.∙Compliance Process Efficiencies. Using market-driven approaches for identifying hundreds of behaviors of interest, compliance personnel can shift from time-consuming and manual methods of data gathering and hunting for anomalies, to focusing on the most urgent and threatening issues that are automatically identified through alerting algorithms. Additionally, Oracle Financial Services TradingCompliance provides compliance analysts with market and reference data thatenables the rapid disposition and routing of alerts, efficient management ofsubsequent investigations, and a simple escalation process where further casemanagement is required.∙Reduced Cost of Compliance. Oracle Financial Services Trading Compliance is offered as part of a broad, integrated compliance platform that helps firms: »Achieve a holistic view of their traders, employees, and customers»Overcome the inadequacies of silo-driven approach to compliance»Reduce total cost of ownership by consolidating onto a single platform»Reduce time by implementing an application immediately ready for use “Future-Proof” Your Compliance InvestmentOracle Financial Services Trading Compliance operates within the Oracle Financial Services Financial Crime and Compliance family of solutions, the first comprehensive set of applications to meet the particular needs of the financial services community. This solution comprises Oracle Financial Services’ best-in-class risk and compliance behavior detection solutions for Anti-Money Laundering, Fraud, Know Your Customer, and Trading and Broker Compliance applications. It surrounds these point solutions to provide an end-to-end solution that leverages a robust data model and comprehensive dashboard capabilities to deliver a single transparent, holistic view of all Financial Crime and Compliance related activities across the enterprise.Oracle Financial Services helps you to identify operational inefficiencies that increase noncompliance risks and overall compliance costs.The unified Oracle Financial Services Financial Crime and Compliance family of applications helps you tackle today's tactical risk and compliance problems while future-proofing compliance spending across regulatory mandates. By establishing a strategy to address risk and compliance initiatives, you can respond to changing business andregulatory conditions while leveraging existing business, functional, and technologycomponents thereby improving the consistency and effectiveness of your data,increasing your business performance, improving your time to production andstrengthening your competitive advantage: all while controlling your overall compliancecosts.About Oracle Financial Services Analytical ApplicationsOracle Financial Services Analytical Applications bring financial institutions best-of-breed capabilities to proactively manage Financial Crime, Compliance, Risk, Treasury,Finance and the Front Office. The applications are built upon a commonly availableanalytical infrastructure consisting of a unified financial services data model, analyticalcomputations, a Metadata driven “R” modeling platform, and the industry-leading OracleBusiness Intelligence platform.A single, unified data model and infrastructure provides one version of the analytical“truth" to business users throughout the entire enterprise. This enables financial servicesinstitutions to confidently manage performance, governance, risk and compliance.Shared data, metadata, computations and business rules enable institutions to meetemerging business and regulatory requirements with reduced expenses and the unifiedplatform helps financial institutions to leverage existing investments.C O N T A C T U SFor more information about Oracle Financial Services Trading Compliance, visit/financialservices or call +1.800.633.0738 to speak to an Oracle representative.C O N N E C T W I T H U S/financialservices/OracleFS/oraclefs/financialservicesCopyright © 2017, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and thecontents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any otherwarranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability orfitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations areformed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by anymeans, electronic or mechanical, for any purpose, without our prior written permission.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license andare trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo aretrademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. 0417。

M A N A G E M E N TR E L E A S E11.1.2.1C ONTENTS I N B RIEFExpanded Database and Platform Support (2)Flat File Load Options (2)Authorization for System-Automated Tasks (2)Integration Type Enhancements (2)Enhancements to Task Design and Execution (3)Report Binder Options (3)Large Schedule Enhancement (3)Support for Lifecycle Management (3)Smart View Outlook Task Integration (3)Integration with Oracle PeopleSoft Enterprise Financials (4)Integration with Oracle Governance, Risk and Compliance (4)Expanded Database and Platform SupportThis release adds support for Microsoft SQL Server database. In addition, it includes expanded operating system support for Microsoft Windows 64-bit versions, and Red Hat and Oracle Enterprise Linux versions. See the Oracle Hyperion Enterprise Performance Management System Certification Matrix, posted at /technology/products/bi/hyperion-supported-platforms.html.Flat File Load OptionsMultiple options are now available for loading tasks into a template or schedule. You can replace some existing tasks, replace all tasks, or update partial task information. In addition, task types have replace and update options. See the Oracle Hyperion Financial Close Management Administrator's Guide.Authorization for System-Automated TasksTo preserve security, you may require authorization for system-automated tasks if you change the runtime user, or if task parameters are modified by a user other than the task owner. An administrator who knows the credentials of the runtime user can perform the authorization, or issue a request to the user to obtain authorization. A user who receives a request for authorization can access the Authorization dialog either from a link in the email sent by the administrator, or by logging on to the application. See the Oracle Hyperion Financial Close Management Administrator's and User's Guides.Integration Type EnhancementsIntegration Type enhancements include:l Ability to specify application-level settings that are common across all Integration Types of the same applicationl Ability to edit application security settings and parametersl Ability to export Integration Type XML filesl Ability to test and validate the Integration Type definition in the UI without creating and executing tasksl Support for additional application security policiesl Additional fields for Synchronous and Asynchonous Web Service processesl New Task Information parameter typeSee the Oracle Hyperion Financial Close Management Administrator's Guide.2New FeaturesEnhancements to Task Design and ExecutionThese enhancements include:l Ability to reopen tasksl Support for number formats in custom attributes, including currencyl Ability to specify whether custom attributes display on Task Actions or Report Bindersl Ability to import tasks to schedules as well as templatesSee the Oracle Hyperion Financial Close Management Administrator's Guide.Report Binder OptionsThe Report Binders output format has been redesigned to be more printer-friendly. The reportpages are merged into a single HTML page, with page breaks for sections as required, so that theentire report can be printed with a single print command. See the Oracle Hyperion FinancialClose Management Administrator's Guide.Large Schedule EnhancementYou can now create schedules with a maximum of 2000 tasks. See the Oracle Hyperion FinancialClose Management Administrator's Guide.Support for Lifecycle ManagementUsing Oracle Hyperion Enterprise Performance Management System Lifecycle Management,you can migrate applications from one environment to another. For example, you can moveapplications through a staged development cycle of Development, Test, and Production. See theOracle Hyperion Lifecycle Management Guide.Smart View Outlook Task IntegrationYou can view and work with your Financial Close Management tasks as tasks in MicrosoftOutlook. Using Outlook tasks, you can answer questions, add comments and attachments, andsubmit, approve, and reject tasks. See the Oracle Hyperion Smart View User's Guide.New Features3Integration with Oracle PeopleSoft Enterprise FinancialsIntegration Types are now available as XML files for Oracle PeopleSoft Enterprise Financials 9.0 and 9.1. The Integration Type XML files and documentation are available for download from My Oracle Support.Integration with Oracle Governance, Risk and ComplianceIntegration Types are now available as XML files for Oracle Governance, Risk and Compliance (GRC). The Integration Type XML files and documentation are available for download from My Oracle Support.4New FeaturesNew Features5COPYRIGHT NOTICEFinancial Close Management New Features, 11.1.2.1Copyright © 2011, Oracle and/or its affiliates. All rights reserved.Authors: EPM Information Development TeamThis software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:U.S. GOVERNMENT RIGHTS:Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.。

Oracle® Hyperion Financial Close ManagementReadmeRelease 11.2.1.0.000F13980-02March 2020Oracle Hyperion Financial Close Management11.2.1.0.000 ReadmeRelated Topics•Purpose•Scope of this Release•New Features in This Release•Upcoming Changes•Installation Information•Supported Platforms•Supported Languages•Compatibility•Defects Fixed in This Release•Known Issues•Documentation UpdatesPurposeThis document includes important, late-breaking information about this release ofOracle Hyperion Financial Close Management. Review this Readme thoroughly beforeinstalling Financial Close Management.Scope of this ReleaseOracle Hyperion Financial Close Management Release 11.2.1.0.000 offers thesebenefits:•Delivers updated technology, including Fusion Middleware (FMW) 12g.•Includes updated platform certifications.•Streamlines and simplifies the architecture, updating the underlying technology stack without a major upgrade. Future enhancements are delivered through Patch Set Updates (PSUs), so you can easily get new features by simply adding a patch onto your installation rather than reinstalling from scratch. This more nimbledelivery mechanism enables smaller releases for easier adoption of new features.•Provides a simplified repository configuration to streamline infrastructure and architecture for the future.•Premier Support is provided through at least 2030.Financial Close Management Release 11.2.1.0.000 doesn't support the following features:•The ability to configure a content management system.•Oracle Hyperion Financial Management integrations.•Event monitoring, automated integrations, and end-user integrations requiring integrated parameters.New Features in This ReleaseRelated Topics•About the New Features in this ReleaseAbout the New Features in this ReleaseThis section includes new features in Release 11.2.x. To review the list of new features from earlier releases, use the Cumulative Feature Overview tool. This tool enables you to identify the products you own and your current implementation release. With a single click, the tool quickly produces a customized report of new feature descriptions. This tool is available here:https:///pls/apex/f?p=20620:1:0New Features in Release 11.2.1.0.000Release 11.2.1.0.000 adds support for Google Chrome web browser, Microsoft Edge web browser, and Windows Server 2016. Check the Oracle Enterprise Performance Management System Certification Matrix for all platform requirements.New Features in Release 11.2.0There are no new features for Financial Close Management in Release 11.2.0. Upcoming ChangesInternet Browser SupportFor Internet Explorer Browser users, Microsoft recommends using the new Microsoft Edge as your default browser. With this guidance in mind, Oracle Enterprise Performance Management System will no longer support Internet Explorer starting with release 11.2.2.0.000. If you have any questions regarding de-support, please create a Service Request. For additional guidance on Internet Explorer Lifecycle, please reach out to Microsoft..Installation InformationLate-breaking information about the installation of EPM System products is provided in the Oracle Enterprise Performance Management System Installation and Configuration Readme. Review this information thoroughly before installing EPM System products.Complete instructions for installing this release are in the Oracle Enterprise Performance Management System Installation and Configuration Guide. Supported PlatformsRelated Topics•About Supported Platforms•Browser SupportAbout Supported PlatformsInformation about system requirements and supported platforms for Oracle Enterprise Performance Management System products is available in spreadsheet format in the Oracle Enterprise Performance Management System Certification Matrix.This matrix is posted on the Supported System Configurations page on Oracle Technology Network (OTN):https:///middleware/technologies/bi-foundation/hyperion-supported-platforms.htmlBrowser SupportFinancial Close Management does not have a browser version dependency; however, it is possible that the products that Financial Close Management works with do have dependencies.Check the Oracle Enterprise Performance Management System Certification Matrix and specific product readmes for any additional browser support requirements.This matrix is posted on the Supported System Configurations page on Oracle Technology Network (OTN):https:///middleware/technologies/bi-foundation/hyperion-supported-platforms.htmlSupported LanguagesInformation about supported languages for Oracle Enterprise Performance Management System products is available in spreadsheet format on the Translation Support tab in the Oracle Enterprise Performance Management System Certification Matrix.This matrix is posted on the Supported System Configurations page on Oracle Technology Network (OTN):https:///middleware/technologies/bi-foundation/hyperion-supported-platforms.htmlCompatibilityFinancial Close Management supports the Oracle Enterprise Performance Management System product versions listed in the Release Compatibility tab in the Oracle Enterprise Performance Management System Certification Matrix.This matrix is posted on the Supported System Configurations page on Oracle Technology Network (OTN):https:///middleware/technologies/bi-foundation/hyperion-supported-platforms.htmlDefects Fixed in This ReleaseThis release includes all defects fixed from any PSE or PSU released after Release 11.1.2.4. See those readmes for the list of defects fixed in each PSE or PSU. The Financial Close Management Release 11.1.2.4.000 readme is inclusive of all defects fixed.Known IssuesThe topics in this section contain the noteworthy known issues of Release11.2.1.0.000 and 11.2.. To view known issues from Release 11.1.2.4 or later PSE or PSUs, see those Readmes.Known Issues in Release 11.2.1.0.000There are no new known issues in release 11.2.1.0.000.Known Issues in Release 11.2Issue with Deployment of Forms with Large Entity ListWhen deploying a form that contains a large number of entities to collect data for a big data set with a large number of attributes, the deployment process does not complete in a timely manner.Documentation UpdatesRelated Topics•Accessing EPM System Product DocumentationAccessing EPM System Product DocumentationFind the latest Oracle Enterprise Performance Management System product guides in the Oracle Help Center (https:///en/). To access documents to view or download, click the Applications icon. In the Applications Documentation window, select the Enterprise Performance Management tab, and then look for your release in the Enterprise Performance Management list.You can also find deployment-related documentation on the Oracle Technology Network (/technetwork/index.html) and on the Oracle Software Delivery Cloud website (/EPD/WelcomePage/get_form).If you are also using EPM Cloud, for Cloud documentation and videos, go to the Cloud Documentation, Software as a Service (SaaS) page in the Oracle Help Center (https:// /en/cloud/saas/index.htm), and then click the link for your service in the Enterprise Performance Management list.Oracle® Hyperion Financial Close Management ReadmeF13980-02Copyright © 2020, Oracle and/or its affiliates. All rights reserved.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software" or “commercial computer software documentation” pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at /pls/topic/lookup?ctx=acc&id=docacc.Access to Oracle SupportOracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit /pls/topic/ lookup?ctx=acc&id=info or visit /pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.Toprovidefeedbackonthisdocumentation,*******************************,or,inanOracleHelpCentertopic,clicktheFeedbackbuttonlocatedbeneaththeTableof Contents (you may need to scroll down to see the button).Follow EPM Information Development on these social media sites:LinkedIn - /groups?gid=3127051&goback=.gmp_3127051Twitter - /hyperionepminfoFacebook - /pages/Hyperion-EPM-Info/102682103112642YouTube - https:///oracleepminthecloud。

Business / Technical BriefSolution Brief: Enabling Finance LeadershipHow IT can empower finance teams with acomplete, self-service data analytics solutionCopyright © 2021, Oracle and/or its affiliatesPublicIntroductionNo longer is it enough for finance teams to report financial results and streamline processes; in fact, 85% of an ESG survey respondents believe it is imperative for the finance organization to transform from reporting on “what” is happening in the business to “why” things are happening. Finance leaders are expected to answer new questions from executives every day, and to guide business strategy. It is therefore not surprising that according to Gartner, the #1 priority of CFOs is advanced data analytics technologies.While Deloitte notes that “CFOs are in a unique position to become the chief analytics officers as finance gains a bigger influence in driving the company’s strategy”, CFOs do spend more time sifting through spreadsheets than doing anything else—an average of 2.24 hours per day. Finance teams face significant challenges combining ever growing data sets across different formats and sources into a single source of truth to provide actionable insights to other departments.For IT teams, those needs translate into an increasing number of complex, time consuming demands from financial analysts.In this brief, we shall review how IT can enable finance teams to get the deep, trustworthy, data-driven insights they need to make quick decisions—while ensuring data governance, security, and saving significant time and efforts. Real-time insights to drive innovation and growth while reducing costsLet’s consider the following customer stories outlining how, with Oracle’s solution, finance teams have been able to dramatically improve their data analytics processes, while significantly reducing costs.Dou Yue’s 30 restaurants across China are committed to serving traditional Chinese cuisine on premises and for takeout. Multiple isolated legacy data platforms prevented the company from gaining the comprehensive, real-time insights it needed. If Dou Yue executives wanted to get a view of the entire business, they had to export spreadsheets from various systems to then manually aggregate and calculate results, a process that was outdated and error prone.By deploying Oracle Autonomous Database for analytics and data warehousing and Oracle Analytics Cloud on Oracle Cloud Infrastructure, Dou Yue integrated the data from multiple business systems onto a single, cloud-based platform. The financial team can now pull revenue, inventory, and other data—by restaurant—for company executives to act on. For example, when a restaurant posts a revenue decline, Dou Yue executives can analyze the environmental conditions (traffic, weather), sales model (dine-in or takeout), as well as menu and pricing in the region where the restaurant is located to determine the root causes and adjust strategy. By analyzing historical trends, repeat-consumption, and other data, Dou Yue is now able to understand which dishes customers like and adjust them—or create new ones—in a timely manner. They can also determine which commercial buildings tend to order the most take-out to inform targeted marketing campaigns and where to locate future restaurants. In the past, the company required two or three full-time staffers to spend a few hours to manually produce reports. With Oracle’s solution, reports are generated with a simple click, dramatically improving business decision-making while reducing labor costs.At Data Intensity, the finance team was spending 60% of the time just getting the data out of the systems. With Autonomous Database for analytics and data warehousing, they can now run 200 reports in seconds. A testament to the value of the solution, 10X more users are now accessing the system, driving value. Additionally, the company reduced costs by 30%. “Our CFO is delighted, he could do what he could not do before, sit in a board meeting and get the data then and there at his fingertips.” said James Anthony, CTO.Lyft, the transportation network, was busy reimagining the future of transportation. Behind the scenes though, the company had gone from a high-growth start-up to a publicly traded enterprise processing billions of transactions a year—and its finance systems hadn’t kept up. Lyft turned to Oracle for its integrated Oracle Fusion applications and data analytics solution. Jay Weiland, Director of Financial Solutions at Lyft said “When I have a process running in the middle of the night, I can’t tell you the exact minute it’s going to stop. With the autoscaler in Autonomous Database, it scales the number of CPUs automatically, so I don’t have to pay for idle hours. That’s very attractive to my finance team.”Faced with regulatory changes, Arlington Orthopedic Specialists required deeper analysis of its operations to avoid losses. With Autonomous Database and Oracle Analytics Cloud, they can now visualize detailed financial scenarios instantly, helping them negotiate the right rates with insurance carriers, and then allocate those savings toward programs that improve patient care. The company increased collections by 62% and reduced days-of-sales-outstanding from 79 days to 22 days, boosting revenue by 18%. CFO Honey Ranario said “Without the Oracle system, I would probably need to hire five or six financial analysts to perform the same volume and quality of analytics.”See more customer case studies.A complete, self-service data analytics solutionOracle delivers a complete, self-service data analytics solution empowering finance teams to rapidly get the deep, trustworthy, data-driven insights they need to make quick decisions.Self-service, governed, secure solution to meet business and IT needsWith a self-service solution, finance team members independently load, transform data, build business models, and automatically discover insights powered by machine learning. IT reduces risks with a governed, secure solution. IT teams can additionally rely on a simple, reliable, and repeatable approach for all data analytics requests from finance teams.Automation uniquely simplifies operations and boosts productivityAutonomous Database intelligently automates provisioning, configuring, securing, patching, backing up, performance tuning, and repairing of a data warehouse. This reduces administration effort by up to 90%, enabling finance teams to operate independently while freeing up valuable resources for IT teams.All-in-one solution with comprehensive suite of built-in toolsFinance teams can quickly combine all necessary data across different sources and formats in a converged database to drive secure collaboration around a single source of truth. Analysts can use graph, spatial analytics, build machine learning models, and create new applications themselves with no/low code built-in tools. Nothing more to purchase, install, and integrate.Elastic auto-scaling for consistent high performance and cost savingsAny number of concurrent users can benefit from consistent, high query performance, even at peak times. Unlike other cloud services, Autonomous Database scales while the service continues to run and can do so automatically to maintain performance. Compute resources can conversely be reduced or shut down during more quiet periods to reduce customers’ costs. All with no or minimal intervention from IT.“It's like the iOS of the enterprise cloud data warehouse space.”Patrick MoorheadFounder, President, & Principal Analyst at Moor Insights & StrategyArchitecture and offeringsThe architecture of the solution is represented below:Data from all sources and formats can be combined in Autonomous Database for analytics and data warehousing. It is the only cloud data warehouse that is autonomous, self-service, and complete, providing finance teams with a comprehensive suite of built-in tools:•Data tools enable self-service drag-and-drop data loading, data transformation, and business modelling.Financial analysts can automatically discover insights with machine learning algorithms—no coding required—saving them significant time and efforts.•Built-in graph analytics enables financial analysts to visualize relationships and connections between data entities. They can for example instantly see all costs and headcount associated to a given project, or understand all dependencies associated to a given supplier to best manage supplier relationships.•With built-in spatial analytics, they can rapidly answer financial questions such as “where did bad weather impact revenue?”, or “where are our most profitable customers?”•Financial analysts can build machine learning models—with a no code interface for business users—to predict likely financial outcomes, e.g. customers likely to default on payment, transactions likely to be fraudulent, expected revenue based on forecast and historical patterns…etc•With the built-in Oracle APEX low-code development platform, finance teams can quickly develop applications for ad hoc needs and gaps/processes handled outside of their ERP—without having to join a queue of IT projects. Such applications can include ad hoc data rooms for acquisitions, tracking the progress of digital transformation initiatives, or COVID-19 related applications.Oracle Analytics Cloud is connected to Autonomous Database, empowering business users and executives with modern, AI-powered, self-service analytics capabilities for data preparation, visualization, enterprise reporting, augmented analysis, and natural language processing/generation. Alternatively, Autonomous Database is certified with all popular analytics tools inlcuding Tableau, Looker, and Microsoft Power BI, ensuring freedom of choice for customers.“Enabling data analysts, citizen data scientists, and business users to create and analyze their own data sets with self-service tools avoids IT bottlenecks and significantly improves their productivity.”Bradley ShimminChief Analyst, OmdiaConclusionBeyond their core financial responsibilities, finance leaders are in a unique position to guide business strategy and help other departments achieve their goals. Having the ability to rapidly and independently turn a growing mountain of data into insights is essential to achieve these objectives. With Oracle’s complete, self-service data analytics solution powered by Autonomous Database, IT can enable finance teams to efficiently take on the leadership role that is increasingly expected of them—while reducing risks and increasing both IT and analysts' productivity.Learn more and get started in a few minutes only.Connect with usCall +1.800.ORACLE1 or visit . Outside North America, find your local office at: /contact. /oracle /oracleCopyright © 2021, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.This device has not been authorized as required by the rules of the Federal Communications Commission. This device is not, and may not be, offered for sale or lease, or sold or leased, until authorization is obtained.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. 0120Disclaimer: If you are unsure whether your data sheet needs a disclaimer, read the revenue recognition policy. If you have further questions about your content and the disclaimer requirements, e-mail ********************.。

Oracle® Hyperion Financial Management管理員手冊11.2.13 版F26578-142023 年 6 月Oracle Hyperion Financial Management 管理員手冊, 11.2.13 版F26578-14版權所有© 2000, 2023, Oracle 和 (或) 其關係公司。

主要作者：EPM Information Development TeamThis software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this is software, software documentation, data (as defined in the Federal Acquisition Regulation), or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed, or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software," "commercial computer software documentation," or "limited rights data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed, or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.Oracle®, Java, and MySQL are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.目錄文件協助工具說明文件意見1 關於 Financial ManagementFinancial Management 功能1-1 EPM Workspace 1-1 Financial Management 維度1-1 Scenario 維度1-2Year 維度1-2Period 維度1-2Entity 維度1-2Value 維度1-2Account 維度1-3Intercompany 維度1-3View 維度1-3自訂維度1-3使用者定義的元素1-3 2 管理應用程式應用程式管理2-1建立應用程式2-2建立新應用程式2-2定義頻率2-4編輯期間2-5新增同層級期間或子期間2-5刪除期間2-6定義功能2-6指定應用程式設定值2-6iii啟用或停用應用程式模組2-7建立自訂維度2-8儲存應用程式設定檔2-10從設定檔建立應用程式2-10從應用程式複製2-10修改應用程式2-11登錄應用程式2-11開啟應用程式2-12關閉應用程式2-12變更應用程式伺服器叢集2-12檢視應用程式清單2-13刪除應用程式2-13載入應用程式元素2-13擷取應用程式元素2-14複製 Financial Management 應用程式2-15匯入應用程式2-15建立 Oracle 資料庫的資料庫連結2-16為 SQL Server 資料庫建立連結的伺服器2-17使用系統訊息2-19檢視系統訊息2-19刪除系統訊息2-19系統訊息詳細資料字串2-20管理應用程式存取權2-20登出使用者2-21停用和啓用連線2-21檢視應用程式連線狀態2-22管理系統使用者2-22檢視使用者2-22登出選取的使用者或所有使用者2-23管理伺服器和應用程式2-24啟用和停用管理模式2-24同步化伺服器2-24稽核任務2-24稽核資料2-27監控執行中的任務2-29檢視執行中的任務2-29停止執行中的任務2-30重新整理執行中的任務2-30掃描並清除無效記錄2-31iv使用 HFM 洞察監控系統狀態2-31存取 HFM 洞察2-32HFM 洞察主要儀表板2-32篩選 HFM 洞察中的應用程式2-33HFM 洞察中的應用程式詳細資料2-333 管理應用程式安全性應用程式安全性考量3-1從 Financial Management 啓動 Shared Services Console3-2選取指派安全性類別的使用者和群組3-2設定安全性類別3-2建立安全性類別3-3刪除安全性類別3-4選取安全性類別3-4為安全性類別指派使用者存取權限3-4設定電子郵件警示3-6執行安全性報表3-6載入應用程式安全性3-7清除並載入安全性資訊3-8清除安全性資訊之前3-9清除安全性資訊之後3-9擷取應用程式安全性3-10 4 管理中繼資料定義科目4-1科目類型行為4-4定義動態帳戶4-6定義自訂成員4-7定義實體成員4-8定義案例成員4-9定義應用程式設定值4-12按期間分的組織4-15定義整合方法4-15使用整合方法4-16手動指派整合方法4-17使用 POWN 或 POWNMIN 整合方法4-17定義幣別4-19v定義儲存格文字標籤4-20系統產生的帳戶4-23整合帳戶4-23所有權帳戶4-23編輯系統產生的帳戶4-24設定公司間夥伴4-25編輯系統產生的 ICP 成員4-25編輯系統產生的值成員4-26依據安全性的中繼資料篩選4-27建立 APP 格式的中繼資料檔案4-27檔案格式4-28版本4-29應用程式設定值4-29幣別4-31成員4-31科目4-32案例4-32Entity4-33自訂4-33Value4-34Intercompany Partner4-35整合方法4-36階層4-36科目階層4-37案例階層4-39實體階層4-39自訂階層4-39中繼資料檔案中不包含的維度4-40中繼資料參考完整性4-40中繼資料參考完整性檢查4-41中繼資料記錄檔案參考完整性錯誤4-41使用中繼資料合併公用程式4-41載入中繼資料4-42檢視中繼資料載入變更4-45擷取中繼資料4-46 5 管理成員清單建立成員清單檔案5-1viEnumMemberLists5-2EnumMembersInList5-3動態成員清單5-6動態 POV 成員清單5-7載入成員清單5-10擷取成員清單5-11按維度列出的系統清單5-11 6 管理日記帳建立日記帳檔案6-1檔案格式區段6-2版本區段6-2日記帳群組區段6-2標準區段6-3循環區段6-3標頭區段6-3載入日記帳6-5擷取日記帳6-7 7 管理資料表單在表單設計工具中建立資料表單7-1設定檢視點7-2指定表單詳細資料7-3指定資料表單的按需規則7-3指定表單列和欄選項7-3指定表單標頭7-4使用資料表單指令集7-4 AddMember7-7BackgroundPOV7-8Blank7-10Cn7-10Calc17-11CalcByRow7-11Cell_Link7-12CellText7-13CustomHeader7-13CustomHeaderStyle7-14DynamicPOV7-15viiFormInputBoxLength7-15 FormNumDecimals7-15 FormRowHeight7-16 FormScale7-16 HeaderOption7-17 HideInPov7-17 Instructions7-18 LineItemDetailSinglePeriod7-18 Link7-19 MaxCells7-19 MaxColsForSparseRetrievalMethod7-20 NoSuppress7-20 NumDecimals7-20 OnDemandRules7-21 Override7-21 POVOrder7-22 PrintNumDataColsPerPage7-23 PrintNumRowsPerPage7-23 PrintRepeatHeadersonAllPages7-24 Rn7-24 ReadOnly7-26 ReportDescription7-26 ReportLabel7-26 ReportSecurityClass7-27 ReportType7-27 RowHeaderPct7-28 SCalc7-28 Scale7-29 SelectablePOVList7-30 ShowDescriptions7-31 ShowLabels7-31 String7-31 Style7-32 SuppressColHeaderRepeats7-34 SuppressInvalidCols7-34 SuppressInvalidRows7-35 SuppressNoDataCols7-35 SuppressNoDataRows7-36 SuppressRowHeaderRepeats7-36 SuppressZeroCols7-36 SuppressZeroRows7-36viii使用相對期間7-37衝突屬性的優先順序7-38編輯資料表單7-38載入資料表單7-39擷取資料表單7-40刪除資料表單7-40 8 將資料擷取至資料庫設定資料來源名稱 (DSN)8-1星型結構描述8-2星型結構描述格式8-3前置字元表格8-4建立並將資料匯出到星型結構描述8-4更新星型結構描述8-6刪除星型結構描述8-7建立星型結構描述範本8-8刪除星型結構描述範本8-8 9 定義報表定義日記帳報表指令集9-1定義公司間比對報表指令集9-2為公司間比對報表選取成員清單9-3為公司間比對報表選取帳戶9-3指定公司間比對報表中的小數位9-3選取公司間比對報表的樣式表9-3指定公司間比對報表中的幣別9-3公司間比對報表的隱藏選項9-3公司間比對報表指令集關鍵字9-4 ReportType9-4ReportDescription9-5StyleSheet9-5POV9-5Entity9-6Partner9-6AccountEntity 和 AccountPartner9-6SuppressIfMatch9-9SuppressReversedTransactions9-9SuppressDetails9-10ixMatchingTolerance9-10SuppressCustoms9-11ScaleFactor9-11Decimal9-11DisplayLabels9-12DisplayDescriptions9-12DisplayPlugElimAccts9-12GroupByCustom9-13定義公司間交易報表指令集9-13 10 管理規則規則類型10-1規則考量10-3計算命令10-4強制計算10-4包含計算指令的計算規則10-4包含整合命令的計算規則10-5目前維度成員10-8科目表示式10-9函數自動清除資料10-10錯誤訊息10-10整合期間的規則執行10-10預設轉換10-11 Financial Management 物件10-12在規則中使用 VBScript10-13 VBScript 運算子10-13VBScript 陳述式10-14VBScript 關鍵字10-15VBScript 函數10-15日期與時間函數10-15格式函數10-15轉換函數10-16數學函數10-16陣列函數10-16字串函數10-16其他函數10-17 VBScript 物件10-17常用規則10-18重複使用資料10-18x透過計算金額設定帳戶10-19條件規則10-19測試維度成員10-20測試多個成員10-20對不同成員執行不同動作10-21設定所有帳戶的期初餘額10-22建立規則檔案10-22載入規則10-24擷取規則10-26規則分析10-26將分析資訊新增至規則檔案10-26啟動和停止規則分析10-27檢視規則分析結果10-27規則檢視10-28實體檢視10-28刪除規則分析10-29 11 規則函數函數概觀11-1 ABSExp11-8 AccountType11-8 AccountTypeID11-10 AddEntityToList11-11 AddEntityToListUsingIDs11-11 AddMemberToList11-12 AddMemberToListUsingIDs11-12 Alloc11-12 AllowAdjFromChildren11-14 AllowAdjs11-15 ApplicationName11-16 CalculateExchangeRate11-16 CalculateRate11-17 CalcStatus11-17 CellTextUnitItem11-19 Clear11-22 Con11-23 Consol1, Consol2, Consol311-24 ConsolidateYTD11-24 ContainsCellText11-25ContainsCellTextWithLabel11-26 Currency11-27 CustomTop11-28 DataUnitItem11-29 Decimal11-30 DefaultFreq11-31 DefaultParent11-32 DefaultTranslate11-33 DefaultView11-34 DefCurrency11-35 DOwn11-36 Dynamic11-37 Exp11-38維度交集考量11-39 Period 和 Year 關鍵字11-40數學計算11-41在 Exp 內放入其他函數11-41同時設定多個帳戶11-41 Exp 和維度交集考量11-42所有交集均有效11-42無效交集11-43右側有一個有效成員11-44 GetCell11-45 GetCellNoData11-45 GetCellRealData11-46 GetCellText11-47 GetCellTextWithLabel11-48 GetCellType11-49 GetCustomLabelArray11-50 GetItem11-50 GetItemIDs211-51 GetItemIDs2ExtDim11-52 GetNumItems11-53 GetNumLID11-54 GetRate11-55 GetSubmissionGroup11-55 GetSubmissionPhase11-56 Holding11-56 ICPTopMember11-57 ICPWeight11-58 IDFromMember11-59ImpactStatus11-60 Input11-61 IsAlmostEqual11-62 IsBase11-63 IsCalculated11-65 IsChild11-66 IsConsolidated11-68 IsDescendant11-69 IsFirst11-71 IsICP11-72 IsLast11-73 IsTransCur11-74 IsTransCurAdj11-74 IsValidDest11-75 IsZero11-76 List11-78 Member11-79 MemberFromID11-80 Method11-82 NoInput11-82 NoRound11-83 NumBase11-84 Number11-86 NumChild11-87 NumCustom11-88 NumDescendant11-89 NumPerInGen11-91 NumPeriods11-92 OpenCellTextUnit11-93 OpenDataUnit11-94 OpenDataUnitSorted11-94 Owned11-95 Owner11-95 PCon11-96 PEPU11-97 PeriodNumber11-97 PlugAcct11-98 POwn11-99 PVAForBalance11-100 PVAForFlow11-101 RateForBalance11-101RateForFlow11-102 ReviewStatus11-103 ReviewStatusUsingPhaseID11-104 Round11-105 Scale11-106 SecurityAsPartner11-107 SecurityClass11-108 SetCellTextWithLabel11-110 SetData11-110 SetDataWithPOV11-111 SubmissionGroup11-112 SupportsProcessManagement11-113 SupportsTran11-114 SwitchSign11-114 SwitchType11-115 Trans11-117 TransPeriodic11-118 UD1...311-118 ValidationAccount11-120 ValidationAccountEx11-121 XBRLTags11-12112 自訂函數管理報表函數12-2 Average12-2累計12-5差異12-8DSO - 銷售未結的天數12-11Opening12-14Rate12-17商業規則函數12-24 Custom_Alloc12-24Increase_Decrease12-28Pro_Rata_Ratio12-30Spread12-32Units_Rates12-3513 使用 Calculation Manager 建立規則Calculation Manager 安全性角色13-1使用 Calculation Manager 中的應用程式13-1將規則移轉至 Calculation Manager13-2函數選取器中的 VB 函數支援13-2特殊的 Financial Management VB 指令集函數13-3 14 管理公司間交易設定公司間交易14-1開啟公司間期間14-1設定符合容錯14-2設定在登入前進行比對/驗證選項14-2關閉公司間期間14-3管理原因代碼14-3新增原因代碼14-4編輯原因代碼14-4刪除原因代碼14-5監視公司間交易14-5鎖定和解除鎖定實體14-6檢視公司間交易摘要14-7 15 管理程序管理的提交階段定義提交階段15-1設定提交群組15-2提交群組和階段範例15-3將提交群組指派到階段15-4檢視未指派的提交群組15-5 16 管理電子郵件警示設定程序管理警示16-1設定公司間警示16-2 A 組態設定值可用的組態設定值A-1變更組態設定值A-6置換值A-7變更設定值表格顯示A-7搜尋設定值A-7檢視有效設定值A-8匯出設定值A-8刪除設定值A-8 B 最佳化效能效能概觀B-1常用 EPM 安裝目錄參照B-1 Financial Management 記錄與子立方體B-2 Financial Management 的調整建議B-3診斷效能問題B-3使用監視工具B-3使用遠端診斷代理程式 (RDA)B-5使用參照應用程式B-5調整作業系統參數B-6調整 Windows 參數B-6調整 Web 伺服器B-6調整 HFM Web B-7 HFM Web 逾時參數B-7 HFM Web 調整參數B-8調整 Financial Management 應用程式B-10常見調整的 Financial Management 設定值B-10 MaxNumDataRecordsinRAM B-10MinDataCacheSizeInMB B-10MaxDataCacheSizeInMB B-10MaxNumCubesInRAM B-11IcmSystemReportTranslationMode B-11NumConsolidationThreads B-11MaxNumConcurrentConsolidations B-12NumThreadsToUseWhenUpdatingCalcStatusSystemWasChanged B-13較大型應用程式的 Financial Management 記憶體設定值B-13應用程式特定的設定值B-13調整 Financial Management 應用程式伺服器B-14 Financial Management 調整範例B-15應用程式資料庫維護B-16基本設計注意事項B-16為 Financial Management 調整 Oracle 11g 資料庫B-17簡介B-17常見效能問題B-17 Oracle 11g 資料庫調整準則B-18 Oracle 初始化參數B-18 CURSOR_SHARING B-18 MEMORY_TARGET B-18 MEMORY_MAX_TARGET B-19 SGA_TARGET B-19 SGA_MAX_SIZE B-19 PGA_AGGREGATE_TARGET B-19 LOG_BUFFER B-19 OPTIMIZER_MODE B-20 OPTIMIZER_INDEX_COST_ADJ B-20 PROCESSES B-20 SESSIONS B-20 TRANSACTIONS B-20 OPEN_CURSORS B-20 SESSION_CACHED_CURSORS B-21 TRACE_ENABLED B-21 STATISTICS_LEVEL B-21 TIMED_STATISTICS B-21 TIMED_OS_STATISTICS B-21如何決定 Oracle 資料庫 11g 版的記憶體設定值B-21記憶體大小總計 (MEMORY_TARGET)B-22 SGA 調整大小 (SGA_TARGET)B-23 PGA 調整大小 (PGA_AGGREGATE_TARGET)B-23 LOG_BUFFER 調整大小B-24如何計算 Oracle 資料庫 11g 版的處理程序數目B-24其他注意事項B-25共用伺服器與專用伺服器B-25線上重做日誌檔大小B-25表格空間與區段片段化B-25索引片段化B-26停用 DEFERRED_SEGMENT_CREATION 功能B-26停用 DEFERRED_SEGMENT_CREATION 功能B-26定期維護與調整計畫B-26常見問題集B-27文件協助工具文件協助工具如需有關 Oracle 對於協助工具的承諾資訊，請瀏覽 Oracle Accessibility Program 網站，網址為/pls/topic/lookup?ctx=acc&id=docacc。

Oracle Hyperion® Strategic Finance, Fusion EditionRelease 11.1.1.4.00Readme FileThis file contains the following sections:Purpose (1)New Features (2)Supported Platforms (3)Supported Paths to this Release (3)Supported Languages (3)Installation, Configuration, and Migration (3)Using Oracle® Shared Services (3)Using Oracle® Crystal Ball EPM Fusion Edition (4)Using Oracle® Hyperion Financial Data Quality Management (4)Configuration Notes (4)Upgrade Notes (5)Defects Fixed in this Release (5)Known Issues (7)Documentation Update (8)PurposeThis document includes important, late-breaking information about Oracle Hyperion Strategic Finance Fusion Edition (HSF) Release 11.1.1.4. Review this document thoroughly before installing the product.To ensure that this release is appropriate for your installation, or if you have questions regarding supported platforms, installation steps, addressed issues, or any other issues, please contact Customer Support before installing this release.Top of DocumentNew FeaturesRelease 11.1.1.4This release addresses defects. There are no new features.Release 11.1.1.3Provides Strategic Finance 11.1.1 in non-English languages. The languages supported by all EPM System products is provided in the Oracle Hyperion Enterprise Performance Management System Certification Matrix.System requirements are no longer part of the Oracle Hyperion Enterprise PerformanceManagement System Installation Start Here. Information about system requirements for EPMSystem products is available in the Oracle Hyperion Enterprise Performance Management System Certification Matrix.Release 11.1.1.1Integration with Oracle Hyperion Financial Quality Management (FDM), enabling you to:● Use a central repository for all source financial data● Drill down on audit trails● Archive source files, error logs, and load files● Import source data from any supported data source● Map multiple dimensions and validate mappings● Identify errors and us e error notifications● Validation and reporting on target system● Load adjustments capability through Excel journals● Budget data loading for multiple periods● Perform advanced reporting and auditing● Perform “lights-out” batch loading● Support unlim ited concurrent users● Use SQL Server and Oracle databaseFDM Drill-Back AnalysisMonte Carlo Simulations with Crystal BallNew formula functionsWhere Used to understand the potential effects of forecast changes in models.Cell Text NotesScenario Manager improvements enabling you to change the order in which scenarios displayon the Accounts tabRun multiple scenario consolidations for multiple targetsAutomatic exports to Essbase and PlanningAutomatically export data whenever a Strategic Finance entity is checked inAutomatically purge entity archivesTop of DocumentSupported PlatformsStrategic Finance 11.1.1.4 supports these platforms:Microsoft Windows 2003, SP2, and R2Microsoft Windows 2008 SP2 and R2Microsoft Windows XP Pro SP3Microsoft Windows Vista SP1Microsoft Windows Office 2010Oracle database 11.1.0.7SQL Server 2008 R2Top of Document Supported Paths to this ReleaseThis is a maintenance release for 11.1.1.0, 11.1.1.1, 11.1.1.2, or 11.1.1.3. If you are starting from an earlier release, upgrade to an 11.1.1.x release. This may require upgrading to an interim release first, and then to 11.1.1.x. Once at 11.1.1.x, in EPM System Installer, select the “Apply Maintenance Release” option.This release also provides a complete installation if you are not already starting from 11.1.1.x. If you are starting from EPM System Release 9.3.3, Oracle recommends you upgrade to release 11.1.2.1+. Security Synchronization between Essbase and Shared Services was removed in Essbase 9.3, starting with 9.3.1.4.1. Essbase and Shared Services Release 11.1.1.3, however, still synchronize security information. Consequently, if you are using Essbase 9.3.1.4.1, 9.3.1.5, 9.3.1.6, or 9.3.1.7, you cannot upgrade to release 11.1.1.3. Instead, upgrade all products to 9.3.3, and then upgrade all products to 11.1.2.1+.Top of Document Supported LanguagesThis release supports non-English languages. The list of supported languages for all EPM System products is included in the Oracle Hyperion Enterprise Performance Management System Certification Matrix, posted at /technology/products/bi/hyperion-supported-platforms.html.Top of Document Installation, Configuration, and MigrationThe section includes important information about installing and configuring this release of Strategic Finance and integrated products such as Oracle® Hyperion Shared Services, Oracle® Crystal Ball Enterprise Performance Management Fusion Edition, and Oracle® Hyperion Financial Data Quality Management. For installation instructions, see the Oracle Hyperion EPM System Installation and Configuration Guide.Using Oracle® Shared ServicesDo not install this version of Strategic Finance Shared Services 9.3.1 on the same server. UseHyperion Shared Services Release 11.1.1.x.xx.If you are upgrading and will migrate users to Shared Services for the first time, migrate themmanually or using Active Directory before upgrading to this release of Strategic Finance.If you are upgrading and using an existing release of Shared Services, install the StrategicFinance Server on a different computer than that running Shared Services.Using Oracle® Crystal Ball EPM Fusion EditionTo use Strategic Finance with Crystal Ball, you must meet these requirements:Have release 11.1.1.1.00 or higher of Crystal BallHave a valid Enterprise Performance Management (EPM) license feature.Have a supported version, identified in the Crystal Ball documentation, of Microsoft Excel To install Strategic Finance for use with Crystal Ball, perform these steps:1.Install the Strategic Finance client. See the Oracle Hyperion Enterprise PerformanceManagement Installation and Configuration Guide.Note: To run Crystal Ball against server entity, install the Crystal Ball server.2.Install Microsoft Excel, Crystal Ball, and the Strategic Finance client on the same computer3.Register the CoHSF Component Object Model (COM) with Strategic Finance as follows:From a command prompt, access:Enter:Access:Enter:Using Oracle® Hyperion Financial Data Quality ManagementFinancial Data Quality Management (FDM) is an out-of-the-box data transformation tool providing source-level financial data to consolidation, reporting, planning, and analytical applications. For information on the feature, refer to Oracle Hyperion Strategic Finance Administrator’s Guide, and the Financial Data Quality Management documentation.To use this release of Strategic Finance with FDM, perform these tasks:1.Install:FDM 11.1.1.x.xxThe FDM EPM Adapter SuiteThe Strategic Finance client, server, and HSFWebServices component.2.Access the Internet Information Services Management console and configure WebExtensions/ to Allowed. See the Microsoft Internet Information Servicesdocumentation for details.Configuration NotesUse the Oracle Hyperion EPM Configuration Utility to specify the RPC Port and HSF Data directory location. Perform all other server configuration using the Strategic Finance Administrator.Upgrade NotesStop all services and reboot your computer after upgrading to this release of Strategic Finance.After upgrading, some maps on the server may not have defined currency units, which maycause maps-related batch operations to fail. Ensure that all maps have a valid value for “Scalecurrency/unit” before running batches.You can convert archive files from a release prior to 3.5.1. When prompted in theAdministrator, do not upgrade archive files until you are ready to upgrade to this release.For information, see the Oracle® Hyperion Enterprise Performance Management (EPM) SystemUpgrade Guide.Top of Document Defects Fixed in this ReleaseNote: If you are using release 11.1.1.0, 11.1.1.1, or 11.1.1.2 of Strategic Finance, use the Defects Fixed Finder tool to review the list of defects fixed between those releases and release 11.1.1.3. This tool is available at:https:///oip/faces/secure/km/DocumentDisplay.jspx?id=1292603.112573454 –Worksheet links for actual periods incorrectly display values in blue, not green.12545148 - Forecast formulas are not applied, if you use the “Apply to Children” option, tosubaccounts if the root account is associated with two or more custom dimensions.12545134 – When you add new members to dimensions, account subtotals are copied to all new account intersections.12409629 - When exporting data to Oracle Hyperion Planning (Planning), account names thatcontain special characters such as tildes export zero or #missing values.12338083 – If you use multiple deal periods in different time periods, consolidation mayoccasionally start after the deal period for some entities.12313749 - Although they fail, Oracle Hyperion Essbase batches display as successfullycompleted.12313557 – Although the Planning import process completes without errors, some account dataimports NA values when you import using maps.12313530 – The security assigned to Entity Change Management documents that you copy tocreate new ECM documents, may not be applied to the new documents.11935025 – Batch files with large number of entries may not execute.11925451, 9729830– The character limit for Essbase server names is too low, and prevents you from connecting to Essbase when creating import or export maps.11906548 – You receive errors or be unable to get input values when defining free style report cells with these characteristics:o References any entity on the servero Uses any input account, and has an attribute of “input”o Uses any input scenario or period11696592, 9906888– Deleting combined scenarios using the Scenario Manager causes Strategic Finance to close abnormally or become unresponsive.11060058 – You receive .OCX file-related errors after setting OPATCH_PLATFORM_ID as a temporary environment variable, and running register.bat as instructed in the readme installation instructions.10415926 – You cannot link entity files because the Import from HSF Link option does not display when you select “File”, then “Import From File”.10312666 – Large consolidations take a significant amount of time to run, and may cause out of memory errors if entity files on the HSF server are not closed.10240846 – You receive time period error when saving the sample.alc if no time periods exist, using the “Financial Data O nly” option.10235940 – When processing large consolidations, HSF may close abnormally during if entity files on the HSF server are not closed.10402858 – If you drill down to access Financial Data Management data from Strategic Finance applications, data containing Unicode characters is not URL encoded, and causes the query that fetches FDM data to fail.10042968 – Strategic Finance may shut down abnormally or become unresponsive if you renumber subaccounts or rename accounts.9858080 – When using Entity Change Manager, freeform forecast methods are copied only to child dimension members, and not dimension parents. Consequently, when new dimension members are added, they inherit the old forecast method or formula. It also means that new formulas are lost if dimensions are removed and then reapplied.9783073– Account group data does not consolidate correctly using the equity method.9535591 – You cannot check in entities during or after using Entity Change Management.Top of DocumentKnown IssuesThe following are the noteworthy known issues of this release:10042491 - Despite having the correct administrative access, and having correctly configuredStrategic Finance for use with Financial Management, the Create Map button for FinancialManagement import and export maps is disabled because the required .dll file is incorrectly named.To resolve this issue:1.Perform these steps on the computer hosting the Strategic Finance Client:Close all Strategic Finance applications.Navigate to .Rename as .Rename as .Start the applications.2.Perform these steps on the computer hosting the Strategic Finance Server:Stop the Strategic Finance server service.Navigate to .Rename as .Rename as .Start the Strategic Finance server service.3.Connect to the Strategic Finance Server from the computer hosting the Strategic Finance Client.4.Create the Hyperion Financial Management map.8499173 - If you use Shared Services and Essbase with the current or an upgraded release ofStrategic Finance, you may receive a "Cannot initialize Oracle Essbase Integration" error whenchecking out new Essbase maps that you imported or exported.8606578 - In Strategic Finance web services, EnumOpenedEntities may not display open entities.102482026 – The context sensitive help for some dialog boxes and tabs may not display.When using Shared Services and OpenLDAP, the Hyperion OpenLDAP service may sometimesdisappear after a reboot. To work around this issue, reinstall the service by opening a commandconsole and run the following:8499173 - If you use Shared Services and Essbase with the current or an upgraded release ofStrategic Finance, you may receive a "Cannot initialize Orale Essbase Integration" error whencheckng out new Essbase maps that you imported or exported.8606578 - In Strategic Finance web services, EnumOpenedEntities may not display open entities.8704738 - You cannot use PKZip as described in the Oracle Hyperion Enterprise PerformanceManagement System Strategic Finance Administrator’s Guide to backup your Strategic Financedatabase.8704824-Youcannotuse@********************************************************* be provided in the next release of the Oracle Hyperion Enterprise Performance ManagementSystem Strategic Finance User Guide.7407918 -The @LIKEPD function is not described in the Oracle Hyperion Enterprise Performance Management System Strategic Finance User Guide.Top of DocumentDocumentation UpdateAccessing DocumentationThe most recent version of each Hyperion product guide is available for download from theDocumentation area of the Oracle Technology Network (OTN) Web site(/technetwork/index.html). Deployment-related documentation is also available from the Oracle E-Delivery Web site (https:///). Individual product guides are available for download on the Oracle Technology Network (OTN) Web site only.Note: Not all of the documentation for this product has been updated from Release 11.1.1.1, 11.1.1.2, or 11.1.1.3. Similarly, the product UI may not have been updated since these releases.Access to Oracle SupportOracle customers have access to electronic support through My Oracle Support. For information, visit /pls/topic/lookup?ctx=acc&id=info or visit/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired. Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at /pls/topic/lookup?ctx=acc&id=docacc.Top of DocumentCopyright © 2011, Oracle and / or its affiliates. All rights reserved.。

Oracle’s Hyperion® Data Integration Management Adapter for Financial ManagementRelease 9.3.1.1ReadmeReadme FileThis file contains the following sections:Purpose (1)System Requirements (2)Hardware (2)Software (2)Installation Instructions (2)Compatible Software (2)Installing the Adapter (3)Installing the Adapter in Silent Mode (5)Installing the Adapter in Console Mode (5)Configuring the Adapter (5)Registering the Repository Plug-in (5)Configuring Application Connections (6)Uninstalling the Adapter (7)Known Issues (7)Tips and Troubleshooting (7)Accessing Hyperion Product Documentation (8)PurposeThis document includes important, late-breaking information about this release of Oracle’s Hyperion® Data Integration Management Adapter for Financial Management. Review thisinformation thoroughly before installing Data Integration Management Adapter for Financial Management.TopSystem RequirementsThe following tables list system requirements for this release of Data Integration Management Adapter for Financial Management. For more information about system requirements, see these documents:•Hyperion Data Integration Management Release 9.3.1.1 Readme•Hyperion Installation Start Here•The Hyperion Financial Management – System 9 Installation Guide•The Informatica PowerCenter 8.1.1 Installation and Configuration Guide•The Informatica PowerCenter 8.1.1 SP3 Service Pack Installation GuideHardwareProcessor PentiumII266MHz PentiumIII500MHz Memory 128MB 512MB Disk Space 200MB 500MBScreen Resolution 800x600 1024x768SoftwareOperating SystemNote: Multiple non-English locales are supported on all supported platforms. Windows (x86, 32-bit)•Windows XP Pro (Client)•Windows Server 2000 (SP4) •Windows Server 2003 (SP1)Data Integration Management Release 9.3.1.1Informatica PowerCenter Release 8.1.1 SP3Installation InstructionsCompatible SoftwareThis release of Data Integration Management Adapter for Financial Management is compatible with these releases:•Data Integration Management 9.3.1.1•Hyperion Financial Management - System 9 Release 9.3.1•Informatica PowerCenter 8.1.1 SP3Note: Financial Management Client must be installed on the computer where PowerCenter Client is installed and on the computer where PowerCenter Server is installed.Installing the AdapterNote: You must be a Data Integration Management or Informatica PowerCenter user with administrative privileges to install Data Integration Management Adapter for FinancialManagement.Adapter installation prerequisites:•Informatica 8.1.1 SP3 must be installed on the computer where you install the adapter.•You must be a Data Integration Management or Informatica PowerCenter user with administrative privileges.➣To install Data Integration Management Adapter for Financial Management:1.Unless you have an installation DVD, downloaddimafm_93110_infa811_windows_x86.zip from Oracle E-Delivery and extract the fileinto a temporary folder.2.From the installation DVD or the folder where you extracteddimafm_93110_infa811_windows_x86.zip in step 1, start setupWin32Platform.exe.3.Click Next on the welcome screen.4.Select a country, and click Next.5.On the license agreement screen, select I AGREE and click Next.6.Specify the Hyperion Home directory, and click Next.If both the Client and Server components of PowerCenter are installed on the computer,the adapter installer defaults to a Server installation, as shown in the following figure:Note: The preceding figure shows c:\Informatica\PowerCenter811 as the Informatica installation folder, but your Informatica installation folder could be different.7.On the destination screen, specify whether to install the Client Plug-in, the Server Plug-in, or both components:•To install only the Server Plug-in, click Next.•To install only the Client Plug-in, replace Server with Client in the installation destination, so that the specified destination folder isInformatica_Installation_Folder\Client, and click Next.•To install the Client Plug-in and the Server Plug-in, delete \Server from the installation path, so that the specified destination folder isInformatica_Installation_Folder.If you specify Informatica_Installation_Folder as the destination, this setupoptions screen is displayed:8.If the setup options screen is displayed, select a setup option.•Typical—Install all adapter components•Custom—Select which components to install:o Client Plug-ino Server Plug-inNote: When you install the client and server components on one computer, you mustinstall both components in the same location.9.Follow the prompts to complete the installation, noting the configuration information.Installing the Adapter in Silent ModeWhen you install the adapter in silent mode, the installer retrieves the installation properties that are saved in a response file instead of displaying screens where you enter these properties.Silent mode is often used for performing installations remotely.➣ To install an adapter in silent mode1.Create a response file if you do not have one:a.Run the adapter installer from the command line as follows:setupWin32Platform.exe–options-template ResponseFileNameb.Edit the response file manually, if necessary.2.Run this command:setupWin32Platform.exe-silent -options ResponseFileNameInstalling the Adapter in Console ModeWhen you run the installer for an adapter in console mode, you select input from a series of menus that are displayed.➣ To install an adapter in console mode, run this command:setupWin32Platform.exe-consoleConfiguring the AdapterAfter installing the adapter, you must configure it on the computers hosting the PowerCenter Client and Server components of Data Integration Management. Configuration tasks:•Registering the repository plug-in for the adapter•Creating and configuring connection propertiesRegistering the Repository Plug-inIf you install the Server plug-in component, you must register the Repository Plug-in.Note: This registration is not required for the Client Plug-in.➣ To register the Repository Plug-in:1.Access the PowerCenter Administration Console:a.Select Start > Programs > Informatica PowerCenter 8.1.1.b.Select Services -> Launch Admin Console.Note: The default user name for accessing the console is admin, and the defaultpassword is password. The user name and password are case-sensitive.2.In the Administration Console:a.In the left pane, double click the repository service for which you want to registerthe plug-in.b.Click the Properties tab in the right pane.c.In the General Properties section:1.Click the Edit button2.Change the OperatingMode setting to Exclusive.3.Click OK.4.Click OK to restart the repository.d.Click the Plug-ins tab.e.Under Register plug-ins and security modules in the right pane, clickRegister Repository Service plug-in.f.Under Register plug-in for Repository Service, select hfm.xml, which is in theInformatica_Installation\Server folder.g.Click OK.3.On the Properties tab:a.Click the Edit buttonb.Change the OperatingMode setting to Normal.Configuring Application ConnectionsYou must configure an application connection in the Workflow Manager for PowerCenter Server before you can load or extract metadata or data in a Financial Management application. When configuring application connections, specify attributes that PowerCenter Server uses to connect to a database during a PowerCenter session. The application connections that you define in the Workflow Manager are saved in the PowerCenter repository.➣ To configure an application connection:1.In the Workflow Manager, connect to a PowerCenter repository.2.Click Connections > Application.3.Select the connection for Hyperion Financial Management, and click OK.4.Enter this information in Connection Object Definition, and click OK:•Name—A name for the connection•User Name—Your user name for the Financial Management instance•Password—Your password for the Financial Management instance•ServerHost (in the Attributes box)—The name of the Financial Management server host computerApplication Connection Browser lists the new application connection.Tip: You can edit or delete an application connection by selecting it in the list in Application Connection Browser and clicking Edit or Delete.See “Managing Connection Objects” in the Informatica PowerCenter 8.1.1. WorkflowAdministration Guide for more informationUninstalling the Adapter➣ To uninstall Data Integration Management Adapter for Financial Management:1.Unregister the Financial Management Repository Plug-in.For instructions, see “Registering and Unregistering Repository Plug-ins” in theInformatica PowerCenter 8.1.1 Administration Guide.2.Select Add/Remove Programs from the Windows Control Panel.3.Select the adapter and click Change / Remove.Top Known Issues•Custom uninstallation in silent mode uninstalls all the components even if all components are not specified in the response file.•If you click the Previous button on the license agreement screen, the selected language is reset.Top Tips and Troubleshooting•In case of errors in a workflow that involves loading metadata, the Informatica Server Temp folder contains log and metadata files. You must remove these files manually: Log X.tmp and Data X.tmp, where X is a hexadecimal number.•When you start Informatica PowerCenter Designer, you might receive this error message:Failed to Load DLL: HFMClientPlugin.dll for Plug-in: HFM, Vendor:Informatica. The specified module could not be found.This error may occur if the Financial Management client is not installed on the clientcomputer.•If the Financial Management application servers are installed on a separate computer, then DCOM must be enabled. Otherwise, a connection to Financial Management may beunresponsive. The Enable DCOM option is on the Server/Cluster Registration tab of theFinancial Management configuration utility. For more information, see the “Enabling DCOM”section in the Hyperion Financial Management – System 9 Installation Guide.Top Accessing Hyperion Product DocumentationThe most recent version of each Hyperion product guide is available for download from the Documentation area of the Oracle Technical Network (OTN) Web site(/technology/index.html).Documentation is also available from the Oracle E-Delivery Web site(/EPD/WelcomePage/get_form). Please note that individual product guides are available for download on the Oracle Technical Network (OTN) Web site only.TopCopyright © 2006, 2007, Oracle and / or its affiliates. All rights reserved.。

Oracle Hyperion Financial Data Quality Management Enterprise EditionFinance organizations need to enhance the quality of internal controls and reporting processes. To meet these goals, you need a source-to-report view of financial data. Oracle Hyperion Financial Data Quality Management Enterprise Edition allows business analysts to develop standardized financial data management processes and validate data from any source system—all while reducing costs and complexity. Fully integrated with Oracle Enterprise Performance Management applications, Oracle Hyperion Financial Data Quality Management Enterprise Edition is the only enterprise-class system of its kind for managing the quality of financial data.K E Y B U S I N E S S B E N E F I T S• Increase your confidence in the numbers• Lower the cost of compliance• Simplify financial data collection and transformation• Standardize with repeatable financial processes• Deliver process transparency through audit trails• Achieve timeliness of data with a Web-guided workflow process• Improve the productivity of finance staff• Support multi-GAAP reportingK E Y F E A T U R E S• Guided workflow interface• Complete data validations and error checking• Automated data mapping and loading • Prepackaged system adapters• Detailed audit reviews and reconciliations• Support for standard file formats as well as direct connections to transaction systems Increase Your Confidence in the NumbersOracle Hyperion Financial Data Quality Management Enterprise Edition eliminates the data integrity risks associated with collecting, mapping, verifying, and moving critical financial data. With it, you can build standardized, repeatable processes and avoid the typical inefficiencies of collecting financial data. These transparent processes give you greater assurance of clean data and accurate results:•End-to-end automation of the collection, mapping, verification, and movement of financial data creates a standard process that eliminates variability.•Data validations and quality checks allow you to inspect data at each step to identify errors, generate notifications, and reconcile discrepancies.•Robust reporting in Oracle Hyperion Financial Data Quality Management Enterprise Edition provides prebuilt audit, log, system, and process management reports which can be easily amended to create user specific versions and additional reports. Lower the Cost of ComplianceAnnual audit fees can be reduced with Oracle Hyperion Financial Data Quality Management Enterprise Edition. This integrated solution for tracking the movement and preparation of financial data includes:•Instant error checking that enables you to identify errors and notify stakeholders in a timely fashion.•Audit reviewing that tracks evaluations, gap analysis, and action plans, and lets you trace consolidated financial results back to original sources.Simplify Financial Data Collection and TransformationOracle Hyperion Financial Data Quality Management Enterprise Edition eliminates databottlenecks and manual file manipulation by efficiently importing data from a range offinancial data sources. These features allow you to collect clean data from multiple sources.• A data preparation engine integrates, transforms, and validates data from any source system.•Unique “push” integration verifies mapping and intersection, retrieves data for verification, and helps meet quality requirements of Oracle Enterprise Performance Management target systems.•Oracle’s prepackaged source adapters allow financial managers to seamlessly link Oracle Enterprise Performance Management applications to transaction systems further reducing integration costs and data mapping complexities.•The process can be configured to import standard data files or connect to source transaction systems, validate data, and export it to its final target system.Administrators can set up predefined mappings and “wildcards” for any unmapped items in the data import file or underlying transaction system.•The creation of batch definitions automates as much or as little of the data loading process as you require.Figure 1: Oracle Hyperion Financial Data Quality Management Enterprise Edition delivers a Web-based user interface that helps business users develop standardized financial data management processesImprove the Productivity of Finance StaffOracle Hyperion Financial Data Quality Management Enterprise Edition streamlines the time-consuming task of manual data reconciliation by automating and verifying data submissions:•Complete audit trails from trial balance to report give users a transparent, intuitive view of data and processes.• A Web-based user interface enables business users to load, review, and verify data for any target system.•Guided workflow helps users create sophisticated data mappings and repeatable processes.•Support for multi-GAAP (IFRS) reporting and reconciliations.•Connect Source Data to Oracle Hyperion Enterprise Performance ManagementSystemConnect Source Data to Oracle Enterprise Performance Management SystemAlong with a data preparation engine, Oracle Hyperion Financial Data Quality Management Enterprise Edition delivers prepackaged adapters that make it easy to integrate and map data. These adapters connect directly to applications within the Oracle Enterprise Performance Management system, and can connect directly to many transaction systems as well, enabling you to save time and reduce IT costs while managing the integrity of your data. Oracle Hyperion Financial Data Quality Management Enterprise Edition, along with the adapters help to eliminate the risk and variability typically associated with data integration by providing the following features:•Business analyst “Guided Workflow” process•Available “Lights Out” batch processing.•Audit trail visibility to data and process.•Direct drill-through from Oracle Enterprise Performance Management applications to Oracle E-Business Suite, Oracle Fusion Financials, PeopleSoft, JD Edwards and SAP transaction systems and write-back of Oracle Hyperion Planning data to Oracle E-Business Suite and PeopleSoft Financials.•Live integration that delivers only valid input dimensions for mapping.•Immediate visibility to mapping and intersection validation errors.•Automatic execution of calculations, consolidations, and data retrieves.•Retrieval of data and provision of data quality checking against rules.•The ability to automatically change entity hierarchies or the chart of accounts based on changes sourced from ERP systems.•Specify an EPM application as a data source for integration. This effectively allows FDMEE to be a tool to synchronize data between EPM applications, in addition to loading data from external sourcesSource Adapters for Standard File Formats and Transaction SystemsThe Oracle Hyperion Financial Data Quality Management Enterprise Edition source adapters make it easy to load data from any data file, or connect directly to a variety of transaction systems. The core product includes connectivity from the following sources•ASCII/text•Open Interface Adapter and Interface TableA business user-friendly web interface, part of the Oracle Enterprise Performance Management Workspace, is available to connect the source adapters and to create and run metadata and data extraction rules. To load data to EPM Applications, or to directly connect to additional sources, additional adapters are provided as follows:Oracle Hyperion Financial Data Quality Management Adapter for Oracle Hyperion Financial Management for Oracle Enterprise Performance Management SystemThe Oracle Hyperion Financial Management Adapter provides a seamless way to load Financial Management from a file or the open interface table. If direct connectivity to a supported ERP is desired, then the adapter suite is also required.O R A C L E E N T E R P R I S E P E R F O R M A N C E M A N A G E M E N T A P P L I C A T I O N SOracle enterprise performance management applications are an integrated, modular suite that supports a broad range of strategic and financial performance management processes and helps unlock business potential.R E L A T E D P R O D U C T SOracle’s enterprise performance management applications provide the following capabilities:• Strategy Management• Financial Close and Reporting• Planning, Budgeting and Forecasting • Profitability and Cost Management • Enterprise Data Governance Oracle Hyperion Financial Data Quality Management Adapter Suite for Oracle Enterprise Performance Management SystemOracle Hyperion Financial Data Quality Management Adapter Suite for Oracle Hyperion Planning, Oracle Essbase, Oracle Hyperion Financial Close Manager provides the ability to load these application types, and also source data directly from the following sources:•Oracle E-Business Suite Financials.•Oracle Fusion Financials.•PeopleSoft Financials.•PeopleSoft Human Resources for Oracle Hyperion Public Sector Planning and Budgeting.•JD Edwards EnterpriseOne General LedgerOracle Hyperion Financial Data Quality Management ERP Source Adapter for SAPThe ERP source adapter for SAP provides connectivity to SAP R/3, ECC 6.0 and SAP BW sources. Data can be seamlessly integrated to the Oracle EPM applications from these SAP sources.Please note that a version of Financial Data Quality Management Enterprise Edition is included as the data management option in Oracle Planning and Budgeting Cloud Service, and provides an easy way to load and map source files to this cloud based application.C ON TAC TUS For more information about [insert product name], visit or call +1.800.ORACLE1 to speak to an Oracle representative. C O N N E C T W I T H U S/oracle /oracle /oracle Copyright © 2015, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.。

Product Release Note Oracle Financial Services Lending and Leasing Release 14.2.0.0.1 [Phase II] [October] [2015]Product Release NoteTable of ContentsRELEASE NOTES (1)1.1B ACKGROUND /E NVIRONMENT (1)1.2P URPOSE (1)1.3P RODUCT S UMMARY (1)1.4R ELEASE H IGHLIGHTS (1)ENHANCEMENTS (2)1.5D ATAMYX I NTEGRATION (2)1.5.1Description (2)1.5.2Datamyx Input Files creation for Customers and FTP Upload (2)1.5.3Datamyx Triggers File Download, Dialer Extract Creation and ‘Triggers’ display (2)1.5.4Dealer / Sales Agent Reports on Datamyx Triggers (3)1.6I NTEGRATION I TEMS (4)1.6.1360 degree report and Combined Statement/Report Generation (4)1.6.2CASA Integration (4)1.6.3CIF Integration (7)PATCHES AND BUGS (14)SECURITY FIXES (15)LIMITATIONS AND OPEN ISSUES (16)1.7L IMITATIONS AND OPEN ISSUES (16)Release Notes1.1 Background / EnvironmentOracle Financial Services Software Limited has developed Oracle Financial Services Lending and Leasing Release 14.2.0.0.1 [Phase II] integrated solution with FLEXCUBE Universal Banking System. This integration enables OFSLL to integrate with FCUBS giving capability to integrate with centralized CIF, ELCM and CASA.OFSLL supports direct lending as well as indirect lending activities. For the indirect lending model, the solution offers comprehensive channel management that allows a financial institution to support its dealer network, including various compensation and participation programs.Oracle FLEXCUBE Universal Banking (FCUBS) is the core transaction processing back office system which caters to retail, corporate and investment streams of banking. FCUBS supports both retail and corporate flavors of lending and leasing businesses.OFSLL would be enhanced to co-exist and operate with a core banking system. With a generalized integration approach in place, effort required to integrate with any other third party core banking system can be considerably reduced.FCUBS is an application mainly for the banks and OFSLL is conventionally focused on NBFC (Non- banking financial company) market.1.2 PurposeThe purpose of this Release Note is to highlight the enhancements included in the Oracle Financial Services Lending and Leasing Release 14.2.0.0.1 [Phase II] integrated solution with FLEXCUBE Universal Banking System1.3 Product SummaryOracle Financial Services Lending and Leasing Release 14.2.0.0.1 [Phase II] integrated solution with FLEXCUBE Universal Banking System is built to meet various challenges faced by financial institutions. It addresses each of the lending processes — from design through execution. Its unique value lies in its ability to provide the business with predefined processes and a world-class framework that takes care of business risk and compliance needs.1.4 Release HighlightsThe key highlight of this release is to fix the critical bugs and to enhance the industry specific requirements.Enhancements1.5 Datamyx Integration1.5.1 Description∙To receive ‘Monitoring triggers from Datamyx, OFSLL provide s ‘input file’, which contains existing customer details. Once input files are created, OFSLL automatically uploads the same to Datamyx FTP server.1.5.2 Datamyx Input Files creation for Customers and FTP Upload∙Generate ‘input file’ using the BI Publisher. Input file has OFSLL existing customer information [Customer First Name, Customer Last Name, Full Street Address (Current Address), ZIP Code (Current Address), OFSLL Customer ID, and Customer Account Number].∙Using the ‘BI Publisher’, user can configure the frequency of file generation and auto upload into Oracle FTP server. Since system cannot access an external FTP server like Datamyx FTP server;for development purpose, system uses internal Oracle FTP server.∙While generating the customer input file, system needs to i nclude all the ‘ACTIVE’ customers (where loan account is not closed) every time, meaning Datamyx requires a full replacement of last sent file.∙In case multiple loan accounts exist for a customer, system needs to pick up the latest account created, meaning only one account number needs to be included.∙While creating the input file OFSLL needs to consider only the ‘primary applicant’ of a loan account∙ A facility is provided to upload the generated customer input file directly to the FTP server without any manual intervention from the lender side1.5.3 Datamyx Triggers File Download, Dialer Extract Creation and ‘Triggers’ display∙Manually download the latest Datamyx ‘Monitoring Triggers’ file from Oracle FTP server and save the information into OFSLL DB. (Post processing OFSLL Customer input file, Datamyx creates the corresponding monitoring triggers file and uploads the same into the designated location of Oracle FTP server).∙Creates a new batch job for the creation of ‘Market Trigger Events’ received on the response file to an account.∙Marketing trigger based campaign call activities are handled from the new tab ‘Cross/Up Selling Activities’ of customer services screen.∙Generates ‘Dialer Extract’ file by including the customer information received through the ‘Monitoring Triggers’ file and include s phone number details by picking the same from ‘Telecom’ section of OFSLL customer service customer details.∙While doing ‘call activities’, facility to view the ‘Monitoring Triggers’ information on the new tab ‘Cross / Up Selling Activities’ as part of OFSLL Customer Service screen.∙Facility to mark the information as part of ‘call activity’o Marks whether follow up required or noto Updates the follow up date∙ A marketing trigger based campaign call activity has any of the following ‘condition’ i.e.‘Opportunity’ either ‘Open’ or ‘Close’ and has a ‘Follow-Up Date’ in case it is still an ‘Open Opportunity’. While generating the dialer extract f or a date, system needs to include those accounts for which follow up date is same as extract file date and condition as ‘Open Opportunity’∙In case customer agrees for an offer provided by the marketing call agent, facility to create ‘Simple Loan Application’ so that origination process can be startedCross / Up Selling Activities. Path: Servicing → Customer Service → Cross/Up Selling Activities1.5.4 Dealer / Sales Agent Reports on Datamyx Triggers∙OFSLL supports a facility to generate Datamyx monitoring triggers report on customers with customer contact details and trigger(s) information1.6 Integration Items∙When in an integrated environment (INT_FCUBS = ‘Y’), OFSLL is enhanced to addresses the following scenarios.1.6.1 360 degree report and Combined Statement/Report Generation∙In case of customers who are having transactions across FCUBS and OFSLL business products, following FCUBS reports include OFSLL assets (Loan/Line/Lease) details. OFSLL sends the required information to generate the following reportso Combined Statement Generation (CSRCSTAD)o360 Degree Customer Report (Retail /Corporate) (STRCUSRP)∙FCUBS combines the list of all accounting transaction linked to a given CIF and generate as one single report. When the user generates the ‘combined statements’ by providing the required details and/ or the customer report, it generates the report with all the account details linked to the CIF number.∙While generating the report if there is any OFSLL accounts linked to CIF Id, FCUBS gets those details from OFSLL over DB call. OFSLL needs to fetch the required details to generate the report from transaction history (online) and hand off the details to FCUBS (Online). Then combine both details and generate the report in FCUBS∙If a single customer has different types of loans transactions spread across product processors of FCUBS and OFSLL like Mortgage Loans in FCUBS Mortgages module, Personal Loans in OFSLL Loans and Car Loan in OFSLL Auto loans, then, in this case, account statements /common asset reports generated by FCUBS for this customer includes OFSLL loan accounts also.o Customer Combined statement (CSRCSTAD) generated for a CIF includes the Loan/Line/Lease account details of the customer.o In Combined Statement Maintenance (STDCDSTM) screen, a facility is provided to select OFSLL asset account details also along with FCUBS assets.o In 360 Degree Customer Report (Retail/Corporate) (STRCUSRP), if the customer is having active asset details maintained in OFSLL, same also get displayed along with the assetdetails maintained in FCUBS.1.6.2 CASA Integration1.6.2.1Recurring CASA debits – [Incoming Payments]∙Recurring CASA Debits Retry [INCOMING PAYMENTS] –The batch is enhanced and forwarded to FCUBS to process the CASA debit∙New system parameter (CASA_DEBIT_MAX_RETRY_COUNT - MAXIMUM # OF TIMES THE CASA DEBIT RETRY ALLOWED FOR UNSUCCESSFULL PAYMENT is created to configure number of times the CASA debit retry count should be triggered (a numeric value parameter) ∙ A new batch job set ‘SET-ICS2’ is created, existing ‘ICCPRC_BJ_100_01’ batch job for CASA debit retry is enhanced and placed under the new ‘SET-ICS2’ batch job set.∙This batch runs in BOD and picks all the accounts, where CASA debit is required [based on criteria-> System date=Payment Due date] and does a function call one by one.o If payment is successful, system posts record in ‘CASA Reconciliation’ screen as ‘Processed’.o If payment is not successful, system posts a record in ‘CASA Reconciliation’ screen under NSF with NSF sub status as ‘OPENED’.o After system attempts ‘N’ number of times (based on system parameter) ‘CASA Debit Retry’ batch, if payment is successful then in ‘CASA Reconciliation’ screen the existingrecord in NSF with sub status ‘OPENED’ gets changed to ‘CLOSED’ (So whole NSF statuswould be ‘NSF-CLOSED’).∙At EOD, system picks up only ‘NSF-OPENED’ status records for ‘CASA Debit Retry’ before Non-sufficient funds batch job.∙Once NSF is posted, the ‘NSF-OPENED’ status record in ‘CASA Reconciliation’ screen change s to ‘NSF-CLOSED’ status.1.6.2.2Advance Entry [Outgoing payments]Few changes are taken in ‘Advance Entry’ screen to enable CASA entries.∙‘CASA Payments’ batch type is provided in ‘Advance Entry > Batch section > Batch Type’ LOV field.∙By default ‘CASA’ mode will be selected for ‘CASA Payments’ batch type in ‘Advance Entry > Advances section > Mode’ LOV field as shown in figure below.On posting, OFSLL calls FCUBS function for crediting CASA and debiting OFSLL account.∙On posting, OFSLL calls FCUBS function for crediting CASA and debiting OFSLL account.∙CASA advance reversal is allowed; On reversal, OFSLL will call the reversal function.∙All the advance entry transactions are recorded in AP transactions. Currently ‘Currency’ field is text field; it is changed to LOV field and is configured to ‘CURRENCY_CD’ l ook up type.∙In ‘Advance Entry’ screen ‘Advance Allocations’ is made mandatory for posting advances, system validates before posting whether ‘Advance Allocations’ are provided or not.‘Advance Entry Screen’ for CASA Payments1.6.2.3Advance Maintenance [Outgoing payments]∙New fragment ‘Advance Allocations’ is introduced in ‘Advance Maintenance’ screen with ‘Edit, View and Audit’ buttons.‘Txn Amt’ field in ‘Advance Maintenance >Advances Section’ is made non-editable, which was earlier editable.∙Based on the total ‘Advance Allocations’ amount, system validate s and updates the ‘Txn Amt’ field in ‘Advance Maintenance >Advances Section’. When user updates any record in ‘Advances’ section of ‘Advance Maintenance’ screen, system reverse s the existing amount and reposts with the updated amount and other details.∙When user updates any record in ‘Advance Maintenance > Advance Allocation’ section, it is updated at following places.o For CASA payments both in OFSLL account and FCUBS account.o For non-CASA payments only in OFSLL account.o‘Txn Amt’ Amount in the ‘Advances’ section record.∙All the ‘Advance Entry and Advance Maintenance’ transactions are recorded in ‘AP Transactions’.∙All CASA related transactions in ‘Advance Entry and Advance Maintenance’ screens are recorded in ‘CASA Reconciliation’ screen also.∙In ‘AP Transactions’ screen only the ‘Open’ status transactions are allowed to reverse the transaction.‘Advance Maintenance Screen’ for CASA Payments1.6.3 CIF Integration1.Changes done in Origination >Business Tab and Servicing >Business tab.∙“Existing Business #” is added in Origination >Business> Business >Affiliate Tabs. (Read only). “Existing Business” check box is added in Origination >Business> Business>Affiliate Tabs. (This is checked automatically). When user searches and adds a businessfrom “Business Search”, system populates the “Corporate CIF” number in “ExistingBusiness number” field and “Existing Business” check box is checked.∙“Business #” is added in Servicing > Customer Details> Business> Business Tab (Read only). When user adds a “Corporate CIF” using non mon etary transaction, systempopulates the “Corporate CIF” number in “Business #” field.Origination:Servicing:2.Changes done in Origination >Business >Business Search tab∙“Customer Type” LOV (Values as ‘Business’ and ‘Affiliates’) field is added in “Search Result” header in Origination >Business > Business search. “Copy Details” button isadded in Origination> Business>Business Search tab.∙If user selects Customer type as “Business” and clicks on “Copy Details”, business details are populated in Business >Business Details table. When the Business recordalready exists with same “Business Number” in “Business” tab, system throws anerror saying “Record Already Exists” and doesn’t allow copy ing the details.∙When user selects Customer type as “Affiliates” and if clicks on “Copy Details”, business details are populated in Business >Affiliates tab. If user tries to map thesame ‘Business Number’ to Business/Affiliate (both), system gives error m essage –“Cannot copy Business details, Business is already mapped to the Application”3.New Business “Tracking Attributes” tab∙“Tracking Attributes” tab is added tab under Origination >Business> Business and Servicing >Customer Details > Business. These “Tracking Attributes” gets copied to“Servicing” after Funding the Application4.Search and add the “Partner CIF” fr om Origination >Customer Search∙“Copy Partner Details” button is added next to the “Copy Customer Details” button in Origination >Customer Search. If user selects a Customer from search result andclicks on “Copy Partner Details” button, system copies the Customer details toPartner details in Origination >Business >Partners Tab.∙Mapping is done between “Customer” tables and “Partner” tab. Bu tton is enabled only when business tab is enabled5.Map the “Deceased” fag in FCUBS with “Deceased Date” the OFSLL∙The “Customer Deceased Date” of FCUBS is mapped to “Customer Deceased Date”in Servicing >Customer Details >Customer tab of OFSLL∙Changes done in FCUBS: “Customer Deceased Date” field is added in “OFSLL Parameters” tab in “STDCIF”. If the “Deceased” flag set as “Yes”, system makes the“Customer Deceased Date” as mandatory field and if user tries to input ‘CustomerDeceased Date’ without checking the ‘Deceased’ check box (In STDCIF Screen);system throws an error. FCUBS sends this “Customer Deceased Date” as part of CIFdata propagation to OFSLL.∙Changes done in OFSLL: OFSLL consumes the “Customer Deceased Date” as part of CIF data propagation from FCUBS and populates in “Customer Deceased Date” fieldin Servicing >Customer DetailsFCUBS ScreenOFSLL Screen6.“OFSLL Loan” balances are shown in 360 Degree View of FCUBS under “Summary >BalanceSheet Asset and Liabilities” for both Retail and Corporate. Sum of “Pay Off Amt” field of OFSLL is displayed Under “Assets” side of “Summary >Balance Sheet Asset and Liabilities” block7.Invoke OFSLL “Servicing/ Collection” Screen from FCUBS 360 Degree View screen of “Retail andCorporate Custome rs”.If user clicks on an Account number in “OFSLL Loans” tab, FCUBS System invokes a popup of respective account “Servicing/Collection” Screen of OFSLL. If user clicks onmultiple accounts, FCUBS opens multiple popup screens with respective account“Servicing/Collection” Screen of OFSLLFCUBS ScreenOFSLL Screen8.Map the “Tenure” field of “Professional” in FCUBS to “Years” field of Employment details Statedand Actual in Employments tab of OFSLL.Employment details field “Months” Stated and Actual in OFSLL are hidden (This information is not editable in OFSLL; if its populated from FCUBS) FCUBS ScreenOFSLL9.Display the Business (Corporate CIF) CASA account details of FCUBS in OFSLL Business>Financials TabWhen the existing Corporate customer is added as a Business, system pulls the CASA account details of Existing Corporate CIF and displays in Business > Financials tab.(Information in this tab is queried on FCUBS database). “Savings” and “TermDeposits” of FCUBS will be displayed under “Financial” tab of OFSLLPatches and BugsSecurity FixesLimitations and Open issues1.7 Limitations and open issuesSome of the limitations as well as known open issues within the application areProduct Release Note[October] [2015]Oracle Financial Services Lending and Leasing Release 14.2.0.0.1 [Phase II]Oracle Financial Services Software LimitedOracle ParkOff Western Express HighwayGoregaon (East)Mumbai, Maharashtra 400 063IndiaWorldwide Inquiries:Phone: +91 22 6718 3000Fax:+91 22 6718 3001/financial_services/Copyright © 1998, 2015, Oracle and/or its affiliates. All rights reserved .Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are “commercial computer software” pursuant to the applicable Federal Acquisition Regulation and agenc y-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate failsafe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish or display any part, in any form, or by any means. Reverse engineering, disassembly, or recompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing. This software or hardware and documentation may provide access to or information on content, products and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.。