Saturday, October 16, 2010

How to report laptop demos in ADS- DSS

As part of our target of report our  demos in ADS – DSS, we mustto define all of them in ADS – DSS as laptop – Not Network demo. As shown below.



Wednesday, October 6, 2010

Oracle has posted a BPM Tutorial


SOA Suite logo Pre-built Virtual Machine for SOA Suite and BPM Suite 11g


Please note that this appliance is for testing purposes only, as such it is unsupported and should not to be used in a production environment.

This VirtualBox appliance contains a fully configured, ready-to-use SOA/BPM 11g R1 installation.

All you need is to install Oracle VirtualBox on your desktop/laptop and import the SOA/BPM appliance and you are ready to try out SOA 11g including the recently released BPM 11g -- no installation and configuration required!

The following software is installed in this VritualBox image:

  • Oracle Enterprise Linux 5 Update 4
  • Oracle XE Universal database
  • Oracle WebLogic Server
  • SOA Suite 11gR1 PS2
  • BPM Suite 11gR1 PS2 (with bundle patch #1)
  • BAM 11gR1 PS2
  • B2B 11gR1 PS2
  • JDeveloper

Please follow the instructions below for downloading and importing the VirtualBox image.

  • At least 3GB of RAM
  • At least 30GB of free disk space. (Note: virtualization works best with contiguous space so it is a good idea if on Windows to run a defrag program, and make sure you are using NTFS for your file system to handle large files on Windows
  • 2GHz processor


Learn More

Getting Started With Oracle BPM Suite 11g R1: A Hands-On Tutorial book cover
Getting Started With Oracle BPM Suite 11g R1: A Hands-On Tutorial
Learn from the experts – teach yourself Oracle BPM Suite 11g with an accelerated & hands-on learning path brought to you by Oracle BPM Suite Product Management team members.
by Heidi Buelow, Manoj Das, Manas Deb, Prasen Palvankar, Meera Srinivasan

Complete information can be reached here:

Note: Information taken from Oracle Websites

Definitions for understand SOA


Note: Information taken from many places specially from:


  • Cohesion (Acoplamiento in spanish)- Software cohesion is the level of association between two or more elements.  Traditional design principles focus in High Cohesion.  SOA promotes loose coupling at all levels but SOA, in light of the levels defined above, actually requires low cohesion to be successful.


  • Enterprise Canonical Data Model - The data we all agree on.  This is not ALL the data.  This is the data that we all need to agree on in order to do our business.  This is the entire model, as though the enterprise had one and only one relational database.  Of course, it is impossible for the enterprise to function with a single database.  So, in some respect, creating this model is an academic exercise.  It's usefulness doesn't become apparent until you add in the following concepts, so read on.


  • Canonical Message Schema - When we pass a message from one application to another, over a Service Oriented Architecture or in EDI or in a batch file, we pass a set of data between applications.  Both the sender and the reciever have a shared understanding of what these fields (a) data type, (b) range of values, and (c) semantic meaning.  The first two we can handle with the service tools we have.  The third one is far and away the hardest to do, and this is where most of the cost of point-to-point integration comes from: creating a consistent agreement between two applications for what the data MEANS and how it will be used.


  • Event Driven Architecture -  Architecture pattern promoting the production, detection, consumption of, and reaction to events.  A style of  architecture characterized by the development of a set of relatively independent actors who communicate events amongst themselves in order to achieve a coordinated goal.  This can be done at the application level, the distributed system level, the enterprise level, and the inter-enterprise level (B2B and EDI).



  • Business Event Ontology -- A reasonably complete list of business events, usually in a hierarchy, that represents the points in the overall business process where two "things" need to communicate or share.  I'm not referring to a single event, but rather to the entire list.  Note that a business event is not the same as a process step.  An event may trigger a process step, but the event itself is a "notification of something that has occurred," not the name of the process we follow next.

I guess what escaped me, until recently, was how closely related these concepts really are.
The way I'm approaching this starts from the business goal: use data to drive decisions.  Therefore, we need good data.  In order to have good data, we need to either integrate our applications or bring the data together at the end.   Either way, if the data is used consistently along the way, we will have a good data set to report from at the end.
To create that consistency, we need the Enterprise Canonical Data Model.  Creating this bird is not easy.  It requires a lot of work and executive buy-in.  Note that the process of creating this model can generate a lot of heated discussions, mostly about variations in business process.  Usually the only way to mitigate these discussions is to create a data model that contains either none of the variations between processes, or contains them all.  Neither direction is "more correct" than the other.

However, in order to integrate the applications, either along the way or at the end of the data-generation processes, we need to use a particularly constrained definition of Canonical Schema: the Enterprise Canonical Message Schema is a subset of the Enterprise Canonical Data Model that represents the data we will pass between systems that many people feel would be useful. Note that we added a constraint over the definition above.  Not only are we sharing the data, but we are sharing the data from the Enterprise CDM.

By constraining our message schema to the elements in the Enterprise Canonical Data Model, we radically reduce the cost of producing good data "at the end" because we will not generate bad data along the way.  The key word is "subset."  In order to create a canonical schema without a canonical data model, you are building a house on sand.  The CDM provides the foundation for the schema, and creating the schema first is likely to cause problems later.
Therefore, for my friends still debating if we should do SOA as a "code first" or "schema first" approach, I will say this: if you want to actually share the service, you have no choice but to create the service "schema first" and even then, only AFTER a sufficiently well understood part of the canonical data model is described and understood.

And for my friends creating schemas that are not a subset of the overall model, time to resync with the overall model.  Let's get a single model that we all agree on as a necessary foundation for data integration.
The next relationship is between the Canonical Message Schema and the Event Driven Architecture approach.  If you build your application so that you are sending messages, and you want to create autonomy between the components (goodness), you need to send data that has a well understood interpretation and as little 'business rule baggage" as you can get away with.  What better place than the Canonical Data Model to get that understanding?  Now, this is no longer an academic exercise. 

Creating the enterprise level data model provides common understanding, so that these messages can have clear and consistent meaning.  That is imperative to the notion of Event Driven Architecture, where you are trying to keep the logic of one component from bleeding over into another.

The business event ontology defines the list of events that will occur that require you to send data.  Creating an ontology requires that you understand the process well enough to generalize the process steps into common-held sharable events.  To get this, the data shared at the point of an event should be in the form of an Enterprise Canonical Message Schema.

Therefore, to summarize the relationship:
  Business Events occur in a business, causing an application to send a Canonical Message to another application.  The Canonical Message Schema is a subset of the Canonical Data Model.  Event Driven Architecture is most efficient when you send a Canonical Message Schema message between components.  This provides you with more consistent data, which is better for creating a business intelligence data warehouse at the end.

Some agility notes:
The list of business events in a prospect ontology may include things like "receive prospect base information", "receive prospect extended information", "prospect questionnaire response received", "prospect (re)assigned", "prospect archived", "prospect matched to existing customer", "prospect assigned to marketing program," etc. It is not a list of process steps.  Just the events that occur as inputs or outputs.

Clearly, this list can be created in iterations, but if it is, you need to make sure that you capture all of the events that surround a particular high level process and not just focus from technology.  In other words, the business processes of "qualify prospect" or "validate order" may have many business events associated with them, and those events may need to touch many applications and people.  If you decide to focus on "qualify prospect" first, then understand all of the events surrounding "qualify prospect" before moving on to "validate order," but if both processes hit your Customer Relationship Management system, focus on the process, not the system.

Tuesday, October 5, 2010

001 - Understanding the Architecture behind Technologies

One of the first step to understand any technology architecture is to have some background knowledge and understand terminology.  To do so, I will be here sharing information that you can get browsing the internet.


Soon Very Soon

Tuesday, August 17, 2010

Viewlet about APEX.

Oracle has published a beautiful viewlet about what is and what can you do with Oracle APEX.

Click here to watch it.

Wednesday, July 7, 2010

INTERNATIONAL - Oracle Technology Network Developer Day -Updated


Welcome to the Oracle Technology Network Developer Day - Hands-on Database Application Development hands-on lab (HOL) installation instructions. This is a bring-your-own-laptop workshop; this document describes how to install a virtual guest appliance that provides pre-configured Oracle software for your use while working on the HOLs.

This Database Development Appliance is necessary for completing the Hands on Labs in the Java, Apex and Database Development tracks - you will not need it for the .Net Track.

Please note that this appliance is for testing purposes only, as such it is unsupported and should not to be used in production environment. This virtual machine contains:

Oracle Enterprise Linux 5,  Oracle Database 11g Release 2 Enterprise Edition, Oracle TimesTen In-Memory Database cache, Oracle XML DB, Oracle SQL Developer, Oracle SQL Developer Data Modeler, Oracle Application Express 4.0, Oracle JDeveloper, Hands-On-Labs (accessed via the Toolbar Menu in Firefox)


-At least 2GB RAM

-At least 15GB of free space (Note: virtualization works best with contiguous space so it is a good idea if on Windows to run a defrag program, and make sure you are using NTFS for your file system to handle large files on Windows. )

-2GHz Processor (a lesser processor will be acceptable but slower)

-Mozilla Firefox 2.0 or higher, Internet Explorer 7 or higher, Safari 3.0 and higher or Google Chrome 1.0 or higher

-Adobe Acrobat reader

Step 1. Download and install Oracle VM VirtualBox on your host system.


Step 2. Download the files:

Download Oracle Developer Days.ovf (93,494 bytes, md5sum: 84ccbd711972e3907fd85bd665aae762)

Download (1,261,391,872 bytes, md5sum: e332cb5c23e3d70ffc09c8386aa9fca5)

Step 3. Download and re-assemble the files:

Download (2,097,152,000 bytes, md5sum: 06012abd8b3ba7620a271825aa85d0d9)

Download (840,474,624 bytes, md5sum: 406491621b62e7fc419bad398f463d7f)


- Download all files, preserving filenames

- Download the .sh file and execute OR run command:

cat OTN_DD_ORACLE.vmdk.001 OTN_DD_ORACLE.vmdk.002 > OTN_DD_ORACLE.vmdk


- Download all files, preserving filenames

- Download the .bat file and execute OR from command line, run:

copy /B OTN_DD_ORACLE.vmdk.001 + OTN_DD_ORACLE.vmdk.002 OTN_DD_ORACLE.vmdk

Step 4. Import your VM: File > Import Appliance to launch Appliance Import Wizard. Click Choose... to browse to the directory you re-assembled all the files in and select the OTN Developer Days.ovf then click Next> to begin importing the virtual machine. It will prompt you to agree to the appropriate developer licenses while importing. You will see 'Oracle Developer Days (Powered Off)' when it is finished importing.

Step 5. Test your VM: Once the import has completed, double-click the OTN Developer Days VM. Click OK to close the Virtualbox Information dialogs. When you get to the Enterprise Linux 5 screen you can now login. (Username and password is oracle.) Allow the process to complete; it is ready when you see a terminal window, which you can close. Once you are finished working in the guest VM you can shut it down via System > Shut Down; this will return the guest VM to the Powered Off state.

Thursday, May 27, 2010

The Oracle's Social Services Solution





Watch this incredible video. Will help you to understand what and how social services should work

Monday, May 24, 2010

APEX DEVELOPER DAY – Table of Contents


Here are the steps to follow the Apex Developer Day.  It can take a day to follow all the 21 Labs

Downloading the VM
























Step 21 – Apex Developer Day - Calling BI Publisher reports from APEX

Note: For this LAB you need Microsoft Office installed on your Local PC/Laptop

There are many way to integrate BI Publisher and APEX let try one a simple way.

  1. Start BI Publisher in case it is down.


You will see BI publisher up and running when it display the initialized in the last row.


  1. Click BI publisher Enterprise Login


  1. You can login as Administrator/Administrator. Notice letter “A”in upper-case.


Let’s setup the connection to the database

  1. Click on Admin Tab


  1. Click on Jdbc Connection


  1. Add a new data source. Click over the button “Add Data Source”


  1. Complete the information

Data Source Name: LocalConnection

Connection String: jdbc:oracle:thin@localhost:1521:orcl

Enter the Username used in Step 5 from Section 1

Username: <YourName>

Password: <Your Password>

Database Driver Class: oracle.jdbc.driver.OracleDriver

Click Test Connection, a confirmation message “Connection established successfully” will be displayed above of the parameters.


  1. Click “Apply”


  1. Because we don’t want to complicate the lab with the users validation (Just for this lab)

Under Security Center Click on Security Configuration


  1. Under Guest Access Section Select the Check Mark Allow Guest Access and enter Guest on the Guest Folder Name field. Click Apply


  1. Click on Reports TAB


  1. Go to Reports > Shared Folders click Create a new folder and create a new Folder "Guest"


  1. Enter Guest in the Folder Name Field and click Create


  1. Open the new Guest Folder


  1. Click on Create a New Report


  1. Enter ExampleReport and Click Create


  1. A new report is created click edit link.


  1. Enter Example Report for be displayed in APEX in the description Field

Select LocalConnection as Default Data Source


  1. Click Data Model in the left frame, and Click in New Tab

clip_image040 clip_image042

  1. Enter ApexEmployeeDataSet in the Name Field, select SQL Query as a Type and select LocalConnection as Data Source. Click Query Builder Button.


  1. Select APEX_EMPLOYEES and APEX_TASKS. These tables must be displayed in the right frame.


  1. Click over EMPLOYEE_ID in APEX_EMPLOYEES table, keep the click pressed and drag and drop it over ASSIGNED_TO column in APEX_TASK Table


It must be created a link(“Foreign Key”) between those two tables

  1. Select First_Name, Last_Name, Email, Hire_Date on APEX_EMPLOYEES table and Task_Name, Status on APEX_TASK table. Click Save


  1. Convert the date format to char as: to_char(APEX_EMPLOYEES.HIRE_DATE, ‘DD-MON-YY’) as HIRE_DATE,

Click Save on left side of the page to save the changes made.



  1. Click View and View again in the output example shown.



  1. Because we have not defined any template to the report. It is displayed in XML Format.


Creating Report Template

  1. Because the next step must be done in the HOST operating system (Your PC/Laptop) not inside the Guest Operating System, we need to know the IP Guest.


  1. In the terminal windows change to the root user, enter ” su – oracle as password. If you are connected as root the symbol # must be the prompt. Now write ifconfig and press enter. An IP will be displayed an it will use on your personal PC/Laptop . (In my case


  1. In you pc Open a browser (iExplorer, Firefox, Chrome) .



  1. Now we are getting access to our BI Publisher externally from our laptop.

Login as Administrator/Administrator Click Sign in and click on Guest Folder


  1. Click on Template Builder


  1. Download the file BIPublisherDesktop.exe and run it. Microsoft tools(Word, excel, etc) must be closed. Install the tool selecting the default parameters


  1. Now you can Open Microsoft Word. A new menu must be in the right top of MS Word with name And-Ins. Click On it, you will see the Oracle BI Publisher menu. Click on Oracle BI publisher menu and


  1. A window with show up, click on Shared Folders -> Guest and select ExampleReport, Click Open Report


  1. Click on Insert -> Table Wizard menu


  1. Select Table and click Next


  1. Click Next


  1. Click on clip_image084 to select all fields and click Next


  1. Group by Status and Click Next


  1. Select Hire Date as sort By and click Next


  1. Click Finish


  1. The template should be displayed as the picture below.


  1. Save the template click on Oracle BI Publisher -> Upload Template As.


Before to Upload the file it will require to Save as a .rft File


  1. We can test the report Click on Preview -> HTML


  1. A Browser session will appear and show us an example of the report.


  1. We have the new template Saved in the BI Publisher repository. Now we can Swith Back to the Oracle Enterprise Linux Guest Operating System. And try to run the report. Click View


  1. Notice now the template EmployeeTask is displayed as a template and multiples Formats to display the report are available. You can try some of them if you want. At the end Select HTML and click VIEW


  1. Now in the right side of the page click on link this report and click Document Only.


  1. A URL will be displayed. Copy it


  1. Now go back to APEX, Create a new TAB, and Clcik on APEX 3.2 Button and login as <YourName> user


  1. In application Builder Click on View Applications, and Select Project tasks Application - <N>


  1. Click on Home Image


  1. Click on Create Buttons




Enter BIPUBLISHER REPORT in Button Name Field and Label. Select Redirect to URL without submitting page. Click Next


Click Next


Click next