Learning Oracle Integration Cloud Services SOA | BPM

Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.

Product/Company Name Month Year Oblix March 2005 Context Media July 2005 OctetString November 2005 Thor Technologies November 2005 Sigma Dynamics August 2006 Sunopsis October 2006 Stellent November 2006 Tangosol March 2007 Bharosa July 2007 Bridgestream September 2007 BEA January 2008 Captovation January 2008 ClearApp September 2008 Tacit Software November 2008 Java April 2009 GoldenGate July 2009 HyperRoll September 2009 Passlogix October 2010 AmberPoint February 2010

Recently, I have successfully prepared Oracle SOA clustered environment on Oracle Enterprise Linux 6.4 in production mode. This clustered environment includes Admin Server which is running on port 7001 and two SOA Managed Servers. Both SOA clustered Managed Servers are running on same port i.e. 8001. Node Managers are also configured for all domains. Summary of Servers in Weblogic console

Solution:-   In Jdeveloper open the source tab of BEPL process, search binding.jca entry in the composite.xml and remove the "ns1:" qualification on the operation and redeploying. For example: From: <binding.jca config="BAPI_COMPANYCODE_GETDETAIL_invoke_3P.jca" operation="ns1:BAPI_COMPANYCODE_GETDETAIL"/> To: <binding.jca config="BAPI_COMPANYCODE_GETDETAIL_invoke_3P.jca" operation="BAPI_COMPANYCODE_GETDETAIL"/> For further detail see my OTN forum post:- https://forums.oracle.com/thread/2546166

Solution:-  Change the Object Manager name to 'SCCObjMgr_enu' in Advanced tab in Oracle Application Explorer. Further details see my OTN forum post:- My Post on OTN Forum  

Adapter for Oracle Applications uses interface tables to insert and update data in Oracle Applications.  Interface Tables act as staging tables between client application and Apps Base tables. Data is never loaded directly into Oracle Applications base tables. Instead, data is first loaded into interface tables, and then Oracle-supplied concurrent programs move data from interface tables to base tables. This ensures that all business logic and processing is handled using Oracle components. Today I successfully loaded Sample Order Data from SOA Server to the following Oracle EBS Interface Tables:- 1) OE_HEADERS_IFACE_ALL 2) OE_LINES_IFACE_ALL BPEL Process of Insert Order into EBS

I successfully create SOA Composie Application that interact with Oracle Database by using DB Adapter. The Oracle Database Adapter enables a BPEL process to communicate with Oracle databases or third party databases through JDBC. The Oracle Database Adapter service is defined within a BPEL process partner link by using the Adapter Configuration Wizard of Oracle BPEL Process Manager. BPEL Process of my DB Adapter

Recently I prepared Oracle Fusion Middleware 11g environment for SOA Server Suite on Oracle Solaris11.1 (x86-64bit). This includes the installation and configuration of following Oracle products:- 1) Oracle Database 11gR2. 2) Repository creation for SOA Suite. 3) Oracle Weblogic Server 11g. 4) Oracle SOA Suite 11g. 5) Domain creation and configuration for Admin Server and SOA Server.

In this post we are going to configure and install MVDEMO Sample Data Set for Oracle MapViewer in Oracle Databse XE 11g on windows 7.   Pre-requisite for MVDEMO Sample Data Set   1) Oracle Java Development Kit (JDK 7). 2) Oracle Database Express Edition (XE 11g). 3) Oracle MapViewer QuickStart Kit 11g ps5. 4) Oracle SQL Developer 11g Installation Download MVDEMO Sample Data Set for MapViewer Demo from OTN. This Demo contains MapViewer sample data and instructions for use with Oracle Fusion Middleware Mapviewer 11g.

Following are the configuration to run Oracle Fusion Middleware MapViewer QuickStart kit 11g ps5 (11.1.1.6) successfully on windows 7. MapViewer is a component of Oracle Application Server.It provides powerful geospatial data visualization services. Software Requirements 1) Download Oracle Java Development Kit (JDK 7) 2) Download the MapViewer QuickStart Kit Installation and Configurations  1) Install JDK in your desire location. I am installing it on under D:\OPT\ 2) Unzip MapViewer (mv11ps5_quickstart). In my case i am unziping it under D:\OPT\ (this will create a new directory called mapviewer11p5_quickstart).

Asset An asset is an object created by a user populating the fields of a content entry form, similar to the one at the given below picture. In this example, the asset is an article, defined by field values entered by the user

In this post we will create new user for the WebCenter Sites application and assign ACLs to the user in the WEM Admin interface. 1) Login to the WEM Admin interface as the fwadmin user.

1) Start Weblogic Server 2) Open browser and enter the following URL http://localhost:7001/servlet Log in as the fwadmin user.

WebCenter Sites roles determine which interface functions are enabled or disabled for a particular user. A disabled function is hidden to the user if his or her role does not match that of the interface function. Following are the list of roles in WebCenter Sites 11g. Role Name Description AdvancedUsers Advance User Analytics Supports analytics Approver Approver ArtworkAuthor Junior Graphic Artist ArtworkEditor Senior Graphic Artist ContentAuthor Content Author ContentEditor Site Editor Designer Site Designer DocumentAuthor Document Author DocumentEditor Document Editor GeneralAdmin General Administration MarketingAuthor MarketingAuthor MarketingEditor Brand Manager ProductAuthor Product Specialist ProductEditor Product Editor SiteAdmin Site Administration SitesUser Sites User WorkflowAdmin Workflow Administration  

There are three type of security layers exists for managing users in WebCenter Sites and these layers are 1) Access Control List (ACL) 2) Roles 3) Authorize Access Control List The first layer controls the user’s ability to read and write information to the WebCenter Sites database tables. This set of permissions is known as access control lists (ACLs). Roles The next layer of security exists at the WebCenter Sites application layer. This layer of security controls how the user works in the interface. This layer is known as roles. Authorize There is then a layer of security which affects specific types of content they can work with. These are known as Authorize.

Following are the components of CM site Asset Types Users Roles Start Menu Items Tree Tabs Workflows A CM site in WebCenter Sites is made up of a set of asset types and a group of users. Roles are applied to asset types and assigned to users in order to grant permissions to users and determine who can access and manage specific types of assets within a CM site. Roles can be applied to asset types, tree tabs, start menu items, and workflows. Unless otherwise configured, all users can access all assets within the CM site.

Content Management Site (CM) CM site in WebCenter Sites usually represents your website. It is where your content contributors create and manage data to be displayed on the website, and development team designs and develops templates to display that data properly. It is also possible to have multiple contribution sites that together, make up a single website.

After the successfull installation of Oracle WebCenter Sites on Windows 7 with Weblogic Server now in this post we will verify the installation. To access the WebCenter Sites interfaces Open browser and enter the following URL http://localhost:7001/servlet The WebCenter Sites login form is displayed.

After completing prerequsities steps for WebCenter Sites installation on windows 7, we are in the position to start the install of WebCenter Sites using the provided installer. Extract the WebCenter Sites installer archive into a directory. Go to the following path and run csInstall.bat file <directory>\sites\WebCenterSites\WCS_Sites_11.1.1.6.0\ContentServer run csInstall.bat file WebCenter Sites installer screen will appear from that click next.

In this post we will craete and configure a Data Source in Weblogic Server for Oracle WebCenter installation. I assumes that the admin server has already start. Create the Data Source Log in to the WebLogic Server Administration Console. 1) In the tree at the left expand Services. 2) Click Data Sources. 3) Click New and select Generic Data Source 4. In the “Create a New JDBC Data Source” screen, enter the following values:     a. A name for the data source.     b. csDataSource for the JNDI name.