Oracle Integration Cloud Service

https://cloud.oracle.com/integration?tabname=LearnMoreInfo&lmResID=1431004357101 https://apexapps.oracle.com/pls/apex/f?p=44785:141:17492019332184::NO:141:P141_PAGE_ID,P141_SECTION_ID:308,2411 What is Integration Cloud Service? Oracle Integration Cloud Service (ICS) is a simple and powerful integration platform in the cloud to maximize the value of your investments in SaaS and on-premises applications. Oracle Integration Cloud Service is Oracle's integration platform as a service (iPaas) and includes an intuitive web based integration designer for point and click integration between applications, a rich monitoring dashboard that provides real-time insight into the transactions, all of it running on a mature runtime platform on Oracle Cloud. ICS will help customers accelerate their integration projects by pre-integrating with several SaaS Applications and will significantly shorten their time-to-market through a highly intuitive user interface and a large library of SaaS Adapters. What cloud services are pre-requisites for Integration Cloud Service? There are no pre-requisites for subscribing to any cloud services while subscribing to Integration Cloud Service. What is the best way to get started with Integration Cloud Service? Integration Cloud Service public trials are coming soon. Please contact your Sales Representative to enroll in a private trial. You can get up-to-speed by viewing the Overview video. Refer to the below links to read more: eBook http://cloud.oracle.com/_downloads/eBook_Integration_File/oracle-integration-cloud-service-ebook.pdf Blogs http://blogs.oracle.com/soa How much does Integration Cloud Service cost? See Pricing section for more details http://cloud.oracle.com/integration?tabID=1431004107723. What defines a Connection in Integration Cloud Service, and how does it tie into the pricing for the service? A Connection identifies a unique Application endpoint that is accessed using Integration Cloud Service. For instance, a sandbox instance of Salesforce.com or your production instance of Oracle Sales Cloud are each considered individual connections. There is a minimum of 6 connections for non-metered ICS and a minimum of 2 connections per month for metered ICS. There is no maximum limit on the # of connections you can place in an order. After you place an order for a specific number of connections, you will be led to a UI wherein you can decide on the allocation of connections to one or more ICS instances. Each ICS instance can accommodate up to 10 connections. For example, if you place an order for 20 connections, you would be able to allocate 10 to one instance and 10 to another instance. If you place an order for 7 connections, you could allocate 5 to one instance and 2 to another. You can process upto a a maximum of one hundred thousand (100,000) messages per connection per day, across all connections. If your ICS instance had 8 connections, you could process upto 800,000 messages per day across all connections. Since once ICS instance can be configured with a max of 10 connections, you can process upto 1 million messages across all connections per day on that instance. Note that the size of the message may not exceed 512 KB. What use-cases are supported by Integration Cloud Service? Integration Cloud Service addresses literally all SaaS to SaaS and SaaS to On-premises integration use-cases including ranging from simple Customer data synchronization across applications, to more advanced integration flows for processing opportunities, quotes, orders etc. The integration patterns range from real-time synchronous message exchanges between 2 applications to publish/subscribe message exchanges between multiple applications. Depending on the application, ICS also enables submission of a batch of requests to process a set of data objects (such as Incidents, Accounts etc) in one single interaction. When operating in a hybrid model, the set of possibilities expand to even larger number of business use-cases. What applications can I integrate with Integration Cloud Service? Integration Cloud Service provides rich and native connectivity to a wide variety of applications including but not limited to Salesforce.com, Oracle Sales Cloud, Oracle HCM Cloud, RightNow, Eloqua, CPQ. This list will grow to a broad portfolio of Oracle and third party SaaS applications over the next few releases. However, you do not need an adapter to get your integrations off the ground. The product does support native Web Services – so any one of the 2300+ SaaS applications in the market today can be integrated with ICS. The same applies to on-premises Applications as well. Native rich adapters for on-premises applications such as E-Business Suite, S.P, Siebel, JD Edwards, Peoplesoft etc will also be available on ICS in future releases. Integration Cloud Service is a brand new product that just released. Is it ready for production use? Though Integration Cloud Service offers a brand new exciting new user experience, under it's skin, it's built on the proven and popular Oracle Fusion Middleware platform that 1000s of customers are already running in production running millions of transactions, across all verticals. The adapters that are available on the service are exactly the same adapters that run on our on-premises middleware platform. Moreover, Integration Cloud Service is already hardened by our own internal SaaS Product teams who are delivering integrations on the ICS platform. What is the availability SLA for Integration Cloud Service? Please refer to the Service Level Objective Policy section of the Oracle Cloud Hosting and Delivery Policy available here. Can I also integrate with On-premises applications with Integration Cloud Service? Yes. As long as they are reachable via a SOAP/HTTP endpoint, on-premises applications can be seamlessly and securely integrated using Integration Cloud Service. We will soon release an on-premises Agent component that will enable richer native integration with on-premises applications such as E-Business Suite, SAP, Peoplesoft, JDE, Databases, FTP servers etc. You can also invoke an existing SOA Suite or Service Bus service that runs on your premises to initiate a Business Process or invoke an existing Service in your enterprise. Does Integration Cloud Service run only on Oracle Cloud? Yes. However we are working on a plan to deliver the same capability on-premises and in the private cloud. Can I search for transactions processed in Integration Cloud Service and track and act on errors? Yes – you can define tracking identifiers for each integration flow and use them to search and find executed transactions from the monitoring dashboard. The dashboard allows drill-down capabilities and insight into errors. Users can act on these errors by resubmitting or aborting those errors. All my applications are on-premises. Does it make sense for me to use Integration Cloud Service at all? If you are looking at a choice of operational simplification, faster time-to-market, and if you have SaaS applications on your near horizon, then Integration Cloud Service, together with an on-premises integration platform operating as a hybrid platform would be a great option. Does Integration Cloud Service integrate with Salesforce.com? Yes. The same high-productivity and easy-to-use adapter for Salesforce.com is available with Integration Cloud Service as well. How much IT involvement is required in setting up Integration Cloud Service? Very little, compared to an on-premises middleware offering. You no longer have to manage a large IT ecosystem for hosting your dev-test-prod environments. However you will still need to mediate with IT, though to a lesser extent. Can Oracle provide consultants who can help design and deliver Integrations on Integration Cloud Service? Yes. Oracle and its partner SIs can further accelerate your time to market by designing and providing pre-built solutions on the Integration Cloud Service Platform. Does Integration Cloud Service require downtime during patching? During initial product releases it would require a planned down-time once every month for a short duration. The patching window would be announced in advance for your information. We are looking to alleviate this in a future release. Do I need to undergo any training to use Integration Cloud Service? In general, you do not need to undergo training to design integrations using Integration Cloud Service. This is by virtue of the highly simplified user interface that ICS provides. As long as you understand the data models of the applications you are trying to integrate, and understand the basic concepts of integration, that should suffice. The product user interface also embeds various simple instructional videos that can help you figure out how to perform a specific action using ICS console. Is there additional training available for Integration Cloud Service? For someone who is looking to master the service and offering in a greater detail, or for someone who is very new to the integration space, we are planning to offer a full-service training from Oracle University. Is Integration Cloud Service transactional similar to on-premises Middleware? No. Transactions are not as relevant in the cloud as they are on-premises. More often than not, SaaS applications are geared up to handle idempotency issues so that complexity is alleviated from the integration middleware. However, ICS does provide guaranteed message delivery. Can I use Integration Cloud Service for Bulk Data Load use-cases involving large data sets? Probably not. We have other PaaS offerings coming soon for Data Integration that can help with these use-cases. Please reach out to your Oracle Sales contact for more information. Can I build Integrations or Adapters to applications and make them available on the Marketplace? Yes. You can sign up as a partner and work with us to release pre-built integrations and adapters that you can make available to the broader community. Building adapters and delivering on marketplace enables partner community to be able to design, deliver and monetize on quality integration with SaaS and on-premises applications. For customers, this means they get access to deep and wide integration to a large portfolio of applications. Can I model process orchestrations using ICS? Yes. This is on our roadmap. We have upcoming capabilities to build long running processes in the cloud. However, the use-cases will be tailored to ensure they do not bring in elements of complexity into the design experience. You can also integrate with an existing SOA BPEL based Web service built using SOA Suite on-premises or SOA Suite Cloud Service instead. Can I integrate with my trading partners using ICS? We are working on a highly simplified user experience for partner community integration. In the interim, you can always leverage the B2B capabilities of Oracle SOA Suite in your own hybrid platform. Does Integration Cloud Service integrate with other PaaS services from oracle? Integration Cloud Service will natively integrate with a wide variety of PaaS Services including Mobile, Process, Developer, Big Data and so on, providing a highly integrated user experience across the entire Cloud platform. How do I do dev-test-production using Integration Cloud Service? When we release, you can move your integrations between your environments using a very simple Import/Export capability. An upcoming release wherein ICS will be pre-integrated with Developer Cloud Service will allow you to source control, version and move your integration artifacts between your environments seamlessly, following the principles of Continuous Integration. What are the security capabilities in Integration Cloud Service? There are several dimensions of security that Integration Cloud Service supports. Physical/Data center security  - provided by Oracle Cloud Data Centers. ICS Product Security – ensuring that your ICS environment is secured from from external threats and also ensure security of any customer's data and metadata within ICS ecosystem. ICS capabilities to securely integrate with Oracle's own SaaS apps on OPC seamlessly. ICS capabilities to securely integrate with any third party Application (generic SOAP/REST API based interface) ICS capabilities to securely integrate with on-premises applications   Together, ICS provides a highly secure environment for your enterprise in the Cloud. Can I import my Oracle SOA Suite projects into Integration Cloud Service? No. For SOA Suite projects/services that you wish to run in the Cloud, Oracle SOA Cloud Service is a better option. How do I benefit from a Marketplace for Adapters? A marketplace for adapters enables customers to benefit from a broad partner community that is building and delivering adapters for several of the 2300+ SaaS applications and on-premises applications out there today. These partner built adapters are audited by Oracle prior to delivery to ensure high quality of integration. How does ICS enable reduction of costs of building and managing integration? Usage of pre-built integrations, the highly simplified designer interface, the rich and broad connectivity to applications are just a few ways you will accelerate delivery of integrations, reducing time and cost of designing integrations. Also, the service provisioning is fully automated, it runs on Oracle Cloud, and all of patching, backup, recovery, etc. are all managed by Oracle. All of this means that you do not incur the substantial costs of managing and maintain all of this infrastructure on-premises. What defines an iPaaS? As per Gartner, Integration Platform as a Service (iPaaS) is a suite of cloud services enabling development, execution and governance of integration flows connecting any combination of on premises and cloud-based processes, services, applications and data within individual or across multiple organizations.

HPYERION LOGS

http://epmcult.blogspot.qa/2014/08/default-log-location-of-hyperion-epm.html Default Log Location of Hyperion EPM Components Author:-Sanjay Purohit Audience:-Hyperion Solution Architect, Technical Lead and Hyperion Administrator Planning application is giving an error message and I am unable to refresh an application. My HFR reports are not working. I just found one article taking about the MIDDLEWARE_HOME and log locations. I don’t understand this language. Why it is happening with my application. Where do I go and see the details message about the error. I get these kind of questions from our clients and I always try to help them over the phone. All of those questions made me to write this blog. This blog can be very useful for starter. I will also try to provide you Oracle doc URLs for details on each log. I am going to describe the Hyperion terminology and default log location of commonly used Hyperion family products. We will start with Hyperion terminology. · MIDDLEWARE_HOME:- is defined during the installation of components and refers the location of middleware components such as WebLogic, HTTP Server, used Java environments. One server can have more than one EPM_ORACLE_HOME its really depends on server configuration. The default location is MIDDLEWARE_HOME. The default location Oracle\Middleware. · EPM_ORACLE_HOME:- contains the support files of EPM system. This resides under the MIDDLEWARE_HOME. The default location is Oracle\Middleware\EPMsystem11R1 · EPM_ORACLE_INSTANCE:- This location is defined during the Hyperion configuration. Most of the EPM/Hyperion components requires deployment location. The default location is Oracle\Middleware\user_projects\epmsystem1. Users can modify this location during the configuration. · WEBLOGIC_DOMAIN_HOME:- most of the EPM components runs on WebLogic. This directory contains server domain for each deployed components. The default name is EPMSystem. Now we will discusses about the default log location of Hyperion (11.1.2.x) related components. We can differentiates EPM logs in four categories:- · EPM Installation Logs · EPM Configuration Logs · WebLogic Managed Services Logs · Application Logs Node Manager Start Location /Oracle/Middleware/wlserver_10.3/server/bin Opmn Start Location Oracle/Middleware/EPMSystem11R1/opmn/bin EPM Install/Uninstall logs: - This location contains the EPM installation logs. Any error during installation may be seen here. The default locating is Oracle/Middleware/EPMSystem11R1/diagnostics/logs/install Running Uninstaller Location (In case you need to re-install components) /u02/Oracle/Middleware/EPMSystem11R1/uninstall EPM Configuration Logs: - The default log location Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/config Running Configurator:- Oracle/Middleware/EPMSystem11R1/common/config/11.1.2.0 Shared Services Config Schema:- Oracle/Middleware/user_projects/config/foundation/11.1.2.0 RMI Port Oracle/Middleware/EPMSystem11R1/common/RMI/11.1.2.0 Oracle/Middleware/user_projects/epmsystem1/RMI Outline Export from Workspace Location:- Oracle/Middleware/user_projects/epmsystem1/tmp LCM Log Location:- Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs Patch log location:- Oracle/Middleware/EPMSystem11R1/cfgtoollogs/opatch/ Diagnostic Logs Essbase Server Related Logs:-Essbase maintain two logs types of logs to record the server and application related activities. The Location is Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/essbase/essbase Essbase Application Related Logs:-This log keeps the application specific activity logs. Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/essbase/essbase/app/(name of application) Essbase OPMN logs:- Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/OPMN/opmn Oracle HTTP Server (OHS):-This location contain OHS access and console logs. Oracle/Middleware/user_projects/epmsystem1/httpConfig/ohs/diagnostics/logs/OHS/ohs_component · access_log and access_log.number:- WebLogic-generated log files for a managed server · console~OHS~1.log:- Oracle HTTP Server-generated log file, console output · ohs_component.log:- Oracle HTTP Server-generated log file Common Location for All Diagnostic Logs:-This location contains all the installed components start and stop related logs. The default location on UNIX Server is:- Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/starter The default log location on Windows Server is:- Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\services Domain Log Location for Each Deployed Components Planning Logs:- C: /MIDDLEWARE_HOME/user_projects/domains/EPMSystem/servers/Planning0/logs Planning0.log:-Records Planning Web Application activity Planning_ADF.log:-Oracle Application Development Framework information Planning_WebApp.log:-Logs generated for Planning Server interactions Planning_ADF.log–AD:- (Oracle Application Development Framework) information Foundation Services Logs:- Oracle/Middleware/user_projects/domains/EPMSystem/servers/FoundationServices0/logs FoundationServices0.log–Server and security activity Framework.log:- EPM System common user interface framework error and informational messages. SharedServices_Admin.log:-Applications Groups management activity. SharedServices_Audit.log:-Audit server errors while reading/writing audit information to the database. SharedServices_Audit_Client.log:-information about the audit client. SharedServices_CMSClient.log:-Metadata Service client activity. SharedServices_Hub.log:-Shared Services listener and initialization activity. SharedServices_LCM.log:-Lifecycle Management activity when it is run from Workspace. SharedServices_Registry.log:-Shared Services Registry activity. SharedServices_Security.log:-User management, authentication, and provisioning. SharedServices_TaskFlow.log:-Information about Taskflows. Workspace.log:-EPM Workspace error and informational messages. Financial Data Quality of Management Enterprise Edition (FDMEE) log:- Oracle/Middleware/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs MIDDLEWARE_HOME/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs ErpIntegrator0.log:- FDMEE application server log aif-CalcManager.log:- Logs for Calculation Manager. aif-HfmAdmDriver.log:- Logs for Financial Management ADM Driver. aif-Planning_WebApp.log:- Logs for Planning Server interactions. FDMEE Folder Creation Location:- Oracle/Middleware/user_projects/domains/EPMSystem ODI Generated FDMEE logs:- Oracle/Middleware/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs/oracledi Calculation Manger Logs:- Oracle/Middleware/user_projects/domains/EPMSystem/servers/CalcMgr0/logs access.log:-What site was accessed inside the Web application (if access logging is enabled) apsserver.log:-Communications between Calculation Manager. CalcManager.log:-Calculation Manager Web-tier activities. CalcMgr0.log:-All Calculation Manager Activities. apsserver.log:-communications between Calculation Manager and Essbase. Registry.log:-CM registry activity. SharedServices_SecurityClient.log:-Logon activities and errors I spend some time to collect most useful Oracle URLs. Below given URL should be enough to provide you details what you looking for. Foundation Services Logs URL http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_1112200/frameset.htm?ch03s12.html FDMEE Related Logs URL http://docs.oracle.com/cd/E40248_01/epm.1112/epm_troubleshooting/frameset.htm?ch03s16s02.html EPM System Product Logging Matrix URL http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_1112200/frameset.htm?ch03s01.html Using EPM System Configurator URL http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install/frameset.htm?ch05s10.html EPM System Configurator and System logs URL http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_11121/frameset.htm?ch03s02s05.html Essbase Diagnostic logs URL http://docs.oracle.com/cd/E12825_01/epm.111/eashelp/frameset.htm?logsabot.htm EPM System Product Logging Matrix URL http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_1112200/frameset.htm?ch03s01.html Planning logs URL http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_1112200/frameset.htm?ch03s16s01.html FDMEE logs URL http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_1112200/frameset.htm?ch03s16s01.html Application Server, Webserver and EPM system process logs http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting/frameset.htm?ch03s10.html Using the Log Analysis Utility to Identify Problems http://docs.oracle.com/cd/E40248_01/epm.1112/epm_troubleshooting/frameset.htm?ch03s01.html LCM logs URL https://docs.oracle.com/cd/E17236_01/epm.1112/epm_lifecycle_management/frameset.htm?ch07s05s05.html Node Manager http://docs.oracle.com/cd/E23943_01/web.1111/e13740/starting_nodemgr.htm#NODEM214 http://www.oratraining.com/blog/2012/11/startup-shutdown-sequence-for-oracle-fusion-apps-components/ Oracle Support Article FDMEE: Where Are The Logs For FDMEE (Doc ID 1640612.1)

EPM 11.1.2.4 Installation Hangs at 80% After Adding or Reinstall Additional Components on Linux Doc ID 2031630.1

EPM 11.1.2.4 Installation Hangs at 80% After Adding or Reinstall Additional Components on Linux (Doc ID 2031630.1) APPLIES TO: Hyperion Planning - Version 11.1.2.4.000 and later Hyperion BI+ - Version 11.1.2.4.000 and later Hyperion Financial Management - Version 11.1.2.4.100 and later Hyperion Essbase - Version 11.1.2.4.000 and later Linux x86-64 SYMPTOMS User is trying to add a new product to an existing EPM 11.1.2.4 environment running on Linux and the install hangs at 80% with the message "creating oracle inventory, the process will take few minutes" The same issue will also happen if the user attempts to re-install any existing EPM product in same environment. CAUSE This is a result of an undocumented Bug 21437460. Every product attempts to reinstall oracle common components and this hangs. If you execute a Unix PS command during this time, you will see that we are hung up trying to unzip some packages that are already present in the Oracle/Middleware/oracle_common/OPatch/Patches directory. Patch directories 16964825 17178347 18514458 2032677 SOLUTION Both new product installations and re-installs will work fine if you first rename or remove the 4 extracted Patch directores in the Oracle/Middleware/oracle_common/OPatch/Patches folder. Patch directories 16964825 17178347 18514458 20326778 REFERENCES

Unable To Install EPM 11.1.2.4 (Doc ID 2020646.1)

Unable To Install EPM 11.1.2.4 (Doc ID 2020646.1) APPLIES TO: Hyperion Financial Management - Version 11.1.2.4.000 and later Information in this document applies to any platform. SYMPTOMS 11.1.2.4 Uninstallation on Windows 2012 - EPMINS-01098 User has to be a member of Administrators group Clean Uninstall of 11.1.2.4 onto Windows 2012 R2 server. The full "Administrator" ID works, but an ID that has been created for the uninstall of 11.1.2.4 does not work. The User ID is in the server's Administrators group and has been provisioned with the rights listed in the documentation for this version. The user ID's password also meets the requirements mentioned in the document (8 characters, capitals, lowercase and numbers - no special characters). CAUSE As per EPM 11.1.2.x pre-requisites customer must have UAC disabled at all times. Disabled UAC and Secpol.msc / Local Policies / Security Options / User Account Control: Run all administrators in Admin Approval Mode - DISABLED are required SOLUTION Disable UAC and Secpol.msc / Local Policies / Security Options / User Account Control: Run all administrators in Admin Approval Mode.

Unable to run the Hyperion 11.1.1.3 installtool.cmd (Doc ID 986203.1)

Hyperion BI+ - Version 11.1.1.3.00 and later Information in this document applies to any platform. ***Checked for relevance on 09-Apr-2013*** SYMPTOMS Unable to run the installtool.cmd to start a new installation. CAUSE Environment variable TEMP is not pointing to an existing folder or the user does not have permissions to write to that folder. SOLUTION Create folders for storing the temporary files and assign them to TEMP and TMP environment variables. Ensure the installing owner has permissions to write to these folders. For Example: TEMP=C:\Temp TMP=C:\Temp

Backing Up Financial Management 11.1.2.4 Application

http://www.oracle.com/webfolder/technetwork/tutorials/obe/hyp/hfm11.1.2_Backup_2016/fm_1112_backup.html

what is FRA in ASM

FRA (flash or fast recovery area) is a storage area (directory on disk or ASM diskgroup) that contains redo logs, control file, archived logs, backup pieces and copies, flashback logs and, in 11g, foreign archived logs. The flash recovery area was first introduced in Oracle 10g