Oracle Workflow Error – ORA-20002 : 3124 Process for item not Active

I was calling WF_ENGINE.ABORTPROCESS to cancel the Workflow Process in some business scenarios.

I have received the above error few times then realized that if the given Workflow process in completed already and you were trying to cancel the same.

So the workaround could be , call the WF_ENGINE.ITEMSTATUS standard workflow API and get the given workflow status, and if it is in ACTIVE state then CANCEL else do not. Possible values returned for the status are: ACTIVE, COMPLETE, ERROR, or SUSPENDED.

PL/SQL Syntax

procedure ItemStatus

 (itemtype in varchar2, itemkey in varchar2, status out varchar2, result out varchar2);

——————————————————————————————-

Sample Call would be:

wf_engine.ItemStatus (    itemtype => itemtype
, itemkey  => itemkey
, status =>  status
, result => result

);

dbms_output.put_line(stat);
if status = ‘ACTIVE’ then
..

elsif status <> ‘ACTIVE’ then
..
end if;

——————————————————————————————-

Thanks,

Senthil

Oracle Workflow Errors – Sending notification to SYSADMIN using Oracle Business Events

Oracle Workflow Errors – Sending notification to SYSADMIN using Oracle Business Events

Add the following error subscription to the event group ‘oracle.apps.wf.notification.receive’ and reproduce the issue.  This subscription is harmless and doesn’t hamper anything.

a) Log in to Applications.

b) Select the Workflow Administrator Web Applications role.
c) Select Business Events.
d) Query on the oracle.apps.wf.notification.receive event.
e) Click on GO.
f) The event will be listed below.
g) Now click on the subscription icon to the right.
h) To the right, click on create subscription.
i) Please input the following details for the subscription and save:
Source Type: Error
Phase : 50
Action Type: Custom
On Error : Stop and Rollback
PL/SQL Rule Function: WF_RULE.ERROR_RULE
Workflow Type : WFERROR
Workflow Process: DEFAULT_EVENT_ERROR
Owner Name : Oracle Workflow
Owner Tag : FND

Now when the issue occurs, check for any Error notification sent to System Administrator and obtain the notification contents for review.

 

Comparison of SOA Suites

I found this useful note for comparision of SOA suites. Thanks..

Reference:  http://myarch.com/comparison-of-soa-suites

Several SOA vendors are trying to put together comprehensive suites of SOA products that in theory should be capable of addressing all aspects of SOA, including governance, integration, business process management and others.

Formation of SOA suites is having a tremendous impacts on how SOA products are selected as many organizations are being tempted to settle for “one stop shop” approach as opposed to doing proper product evaluation within each SOA product category. (Interesting discussion about SOA suites is available at ZDNet).

So what is a SOA suite and how offerings from different vendors support different aspects of SOA? The table below attempts to answer this question.

One thing to keep in mind is that SOA products within the same category can differ substantially in terms of their feature sets. Definitions of ESB, registry and other SOA product categories are not standardized and so vendors are free to categorize their products as they wish. Detailed analysis and evaluation is still a requirement when selecting SOA products.

IBM, BEA and Oracle are emerging as leaders in terms of completeness of their SOA suites. Microsoft’s products are not as comprehensive, nevertheless Microsoft’s marketshare makes it a signifcant player – Micorsoft’s shops tend to be very loyal to the vendor even if Microsoft’s SOA story is not as compelling.

Other vendors, including Software AG/webMethods and HP have interesting offerings too, however, they still have some gaps in their capabilities and so they are not covered here (perhaps I’ll add more vendors in the future).

 

	IBM	BEA	Oracle	Microsoft
Web Services Container (applicaiton server)	WebSphere Application Serer	WebLogic Application Server	Oracle Application Server	.NET/Windows
ESB	WebSphere ESB Message Broker	AquaLogic Service Bus	Enterprise Service Bus (part of Oracle SOA suite)	BizTalk Server (some ESB capabilities)
Registry/Repository	WebSphere Registry and Repository	AquaLogic Service Registry (re-braned Systinet product) AqualLogic Enterprise Repository (FlashLine aquisition)	Oracle Service Registry (re-braned Systinet product?)
Business Process Management	WebSphere Process Server (also includes ESB)	AquaLogic BPM Suite (Fuego acquisition)	BPEL Process Manager	BizTalk Server
Business Activity Monitoring	WebSphere Business Monitor	AquaLogic BPM Suite	Business Activity Monitoring	BizTalk Server
SOA Security	Tivoli Access Manager Tivoli Federated Identity Manager WebSphere DataPower SOA Appliances	AquaLogic Enterprise Security	Oracle Web Services Manager (formerly Oblix COREsv)	Windows?
SOA Management	Tivoli Composite Application Manager for SOA (part of Tivoli suite)	BEA AquaLogic SOA Management	Oracle Web Services Manager