Friday, September 27, 2013

Lexmark Perceptive Software -BPM Workflow management suite.

Perceptive Software owned by of Lexmark Inc (as of 2004) has a web based Workflow Designer and easy to use components to route the right information to the right place at the right time.

 

On Premise and SaaS based product.

Can integrate with almost all MS stack , JD Edwards, SAP , Oracle ERPs.

Has Hardware integration with touch screen based Multifunction Printers (MFP) and scanners and is a reason bought by Lexmark.

Lexmark, Dell, Xerox etc use this.

 

 

 

 

 

Business process management automates your daily workflows through a thoughtful combination of software and expertise that

tightly integrates with and extends your enterprise applications without compromising their integrity.

And far from being a one-time exercise, it simply becomes a part of how you do business—a continuous cycle of improvement for any process in your organization.


Process Discovery illuminates the reality of your processes, exposing bottlenecks in both people and technology that disrupt the flow of productivity. 

Process Design uses the insight you’ve gained to model your processes for better results. 

Perceptive process modeling gives you everything you need to rethink your processes. 

Perceptive process documentation provides the tools needed to publish the processes you've designed, to make everyone understand the impact of their work on the work of others and how they add value to organizational goals.

Process Execution delivers the processes you’ve modeled to a desktop or a mobile device as user-ready applications.

Perceptive’s content-based workflow supports your organization in structuring your processes,

maximizing the number of transactions your team is able to process, direct, approve and complete.

With its more flexible and agilecase management approach, Perceptive provides the optimized process support knowledge workers need to get their work done in the most efficient way—while keeping an overview of everything their customers need.

Process Monitoring and Improvement allows you to make quick adjustments and adapt to changes the future may throw your way. Perceptive process analytics provides immediate insight into your current operations with the ability to immediately act on unbalanced workloads or operational disturbances, and to identify and analyze operational problems to find their root cause

 

 

See more at:

 

http://www.perceptivesoftware.com/products/perceptive-process/business-process-management

 

Rayudu Addagarla

BPM Workflow specialist

Wednesday, September 4, 2013

How to use Java Objects of Oracle similar to Oracle Procedure/Function

Keywords: TOAD, PL/SQL , SQLPLUS, Oracle Java Object, Convert Oracle code to use as Oracle Functions.

 

 

You might have seen Java in Oracle TOAD, But wonder how to use Java there?

 

Yes you can write simple java code in Toad or sqlplus.

Please refer to the below steps and you can write some nice java code to use in PL/SQL.

 

Examples why you might have to use Java:

Some complex String manipulations or might have to make decision on reading some data from files. You probably could call web services and get some data and return inside pl/sql

I did not try calling WS, but since you can write java code, I don’t think you will be limited to any java extensibility.

 

 

Below is a sample Hello World and imagination is only your limit to extend your java skills when using oracle.

 

 

-- Step 1 DROP Java Source

DROP JAVA SOURCE "HelloRayudu";

 

-- Step 2 Create Java Source and Class and a static method

 

CREATE JAVA SOURCE NAMED "HelloRayudu" AS

   public class HelloRayudu {

      public static String hello() {

         return "Hello Rayudu";   } };

        

 

-- Step 3 Create equivalent Oracle Package and function

 

CREATE OR REPLACE PACKAGE APPIAN_TMS.JAVATEST AS

FUNCTION hello

   return VARCHAR2

 AS

LANGUAGE java

    NAME 'HelloRayudu.hello() return java.lang.String';

 

end;

 

 

-- Step 4 Execute the function created above

 

SELECT  JAVATEST.hello FROM DUAL;

 

 

 

        

Once this steps are done, you will be able to see the class in Schema browser as above and details like below.

 

 

 

Rayudu Addagarla