Oracle BAM 12.2.x is Out

If you are used to 11G version of Oracle BAM, release 12.2 is full of pleasant surprises. Oracle says the 12 version was rebuilt from the ground up. BAM composer looks clean and much more simplified. Capabilities are clearly pinned to roles and made available under a pretty ADF Alta UI.

Login Screen: Home Page:

Here are the most impressive features that caught my attention:

1. Refreshed ADF based data Visualization Tools – graphs & charts with drill through, actions.

2. Extended browser compatibility support – IE, Firefox, Chrome. This one should really come above everything else listed here :).

3. KPI based email alerts

4. Pre-defined SQL Queries - Not the same thing as External Data Objects.

5. Automatic data purges - Configure the retention period as a configuration for Data Objects

6. Export data to a CSV file. All list, table views has this feature out of the box

7. Ready-to-use dashboards for BPM and SOA. A lot of the most important assignment, task, workload statistics are built into BAM

8. CQL for real-time pattern matching & trend analysis. Continuous Query Language(CQL) can be used to define queries on business objects that monitor patterns

8. BAMCommand, LoadGen - Tools provided for export, import operations. LoadGen can be used to load test data into BAM in specified intervals and order.

9. Multiple ways for data IO - BAMAdapter, Web Services or EMS

10. Role based security - 'Administrator' defines data objects and manage viewlets. 'Designer' builds queries, views and dashboards. BAM content user has access to the Home tab of BAM composer where they can view all dashboards they have access to.

BAM development cycle is as defined below:

1. BAM Administrator user defines the Data Object. DO can be Simple, Derived, Logical or External

2. BAM Designer creates a project and adds the created DO to the project.

3. Create a business query from DO attributes. Query can be Flat, Group, Tree Model or Continuous

4. Create a business view from business query.

5. Create dashboard(s) from business views.

6. Optionally, build KPIs and Params if needed.

Rendering a drop down list dynamically on Oracle PCS Web form

Been wanting to blog a little experiment I did with Oracle Process Cloud's Web form. Current version of PCS is limited to Web forms; no ADF. I'll post the other shortcomings of current PCS release in another blog. The only way to build dynamic field/value behavior (for now at least)is by using Javascript, JSON and REST.

Here is how you to build a 'drop down' that loads country names at run time.

Login to PCS account > composer> application.

Create a new form. I am calling it CountryList.

Drag and add a 'drop down' component on to the form. I am also adding a message component to show the selected country.

Click on the 'Create Rule' icon on top right of the form and add a new rule.

Type the rule below to load country list from a public JSON service on form load.

The code above reads country names from the JSON service and constructs a temporary array - v_Countries - from the 'name' elements of the JSON array. This temp array is then assigned to drop down Options.

Add an additional line to display the selected drop down value on message component. Web forms are smart enough to rerun the rules every time an event occurs in the component - which is value change in our case.

Test the form using the 'preview' button on top right.