Fusion Blog

EBS Blog


Contact Us

Oracle Workflows - All Articles
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
This article explains how you can move the workflow events and their subscriptions from one environment to another. In any implementation, it is a good practice to script as much of your setup when preparing for UAT or go-Live.
Whilst we have Oracle FNDLOAD for moving most of the Sysadmin setups, it however does not cover Oracle Workflow events.

For basics of Oracle Workflow events, use the links below
Oracle Workflows Business Events - How to create and raise Event with XML Payload
Oracle Workflows Business Events - How to parse XML Payload, via Workflow Events Subscription
Testing Oracle Workflow Business Event with XML Payload

Lets undertake some Q&A for transferring workflow events?

What is the name of the utility for downloading and uploading workflows events?
wmximport, its a java class available in package oracle.apps.fnd.wf

Can wmximport be run in both upload and download mode?
Indeed, just like FNDLOAD, but syntax differs
In this case you have -u for upload, whereas you use -d to download

What other parameters are required by this utility?
1. Name of the event
2. Database Machine name :- used for jdbc connection
3. Database port number
4. Event file name [into which you download or upload from]
5. Flag to indicate EVENT or SUBSCRIPTION

What if the event already exists on production environment, and hence I am only interested in moving the subscription?
You can either download just the workflow event definition or all its subscriptions too. In the sample below, I am listing the commands for transferring events and also transferring subscriptions.

What is the syntax of this command ?

The components of this syntax for WFXLoad are listed below. These need to be on one single line, but for clarity I have broken the parameters into individual lines
adjava WFXLoad -d[to indicate download or upload :-u]
appsusername apps-password
Database Machine name
Database Port Number
Oracle Instance Name[from two task]
thin [for jdbc thin driver connectivity]
Language [US in this case]

Event/Subsctiption File Name [into which event definition is downloaded or uploaded from]
Name of the event

How do I generalize the script without hardcoding machine name and db port number?
Use the sample script below, which gets the machine name and port numbers from Profile options[as below]

On command prompt set the apps password
Export $APPS_PWD

Include this in your script
####Start of the script

MACHINE_NAME=`sqlplus -s apps/$APPS_PWD <<EOF
set pages 0
set lines 1023
select fnd_profile.value('CSF_EMAP_DS_HOST') from dual ;

PORT_NUMBER=`sqlplus -s apps/$APPS_PWD <<EOF
set pages 0
set feed off
select fnd_profile.value('CSF_MAP_DB_PORT') from dual ;

adjava oracle.apps.fnd.wf.WFXLoad -d apps $APPS_PWD $MACHINE_NAME:$PORT_NUMBER:$TWO_TASK thin US ./XX_IRCSIGNFAIL_EVENT.wfx EVENTS xxirc.oracle.apps.fnd.signon.failure

adjava oracle.apps.fnd.wf.WFXLoad -d apps $APPS_PWD $MACHINE_NAME:$PORT_NUMBER:$TWO_TASK thin US ./XX_IRCSIGNFAIL_SUBSCRIPTION.wfx SUBSCRIPTIONS xxirc.oracle.apps.fnd.signon.failure
#end of script

How does the downloaded file look like?
The event file looks like below
<?xml version = '1.0' encoding = 'UTF-8'?>
<!-- $Header: WFXLoad.java 115.39 2006/04/18 05:19:59 vshanmug ship $ -->
<!-- dbdrv: exec java oracle/apps/fnd/wf WFXLoad.class java &phase=daa+38 \ -->
<!-- dbdrv: checkfile:~PROD:~PATH:~FILE \ -->
<!-- dbdrv: -u &un_apps &pw_apps &jdbc_db_addr &jdbc_protocol US \ -->
<!-- dbdrv: &fullpath_~PROD_~PATH_~FILE -->
<!-- Source Database ITUPDV2 -->

<XlatElement Name="WF_EVENTS">
<XlatElement Name="DISPLAY_NAME" MaxLen="80"
<XlatElement Name="DESCRIPTION" MaxLen="2000"

How does the SUBSCRIPTION file look like?
It looks like below, keeping in mind this specific subscription is a PL/SQL
<?xml version = '1.0' encoding = 'UTF-8'?>
<!-- $Header: WFXLoad.java 115.39 2006/04/18 05:19:59 vshanmug ship $ -->
<!-- dbdrv: exec java oracle/apps/fnd/wf WFXLoad.class java &phase=daa+39 \ -->
<!-- dbdrv: checkfile:~PROD:~PATH:~FILE \ -->
<!-- dbdrv: -u &un_apps &pw_apps &jdbc_db_addr &jdbc_protocol US \ -->
<!-- dbdrv: &fullpath_~PROD_~PATH_~FILE -->
<!-- Source Database ITUPDV2 -->

Anil Passi


0 #1 Ambati 2007-02-03 00:00
Than ks for the article,

Can you explain the WFXImport Syntax More Elaborately?
0 #2 Anil Passi 2007-02-04 00:00
Hi Ambati

Pleas e let me know which bit do you want me to elaborate upon?

Thanks ,
Anil Passi
0 #3 Ambati 2007-02-04 00:00

Th anks for the article, Can you Please Elaborate the wmximport command
0 #4 Ambati 2007-02-05 00:00

Th anks for early response. Now I under stand every thing
0 #5 Rathan 2007-02-19 00:00
Great website for Oracle Apps and efforts to write many topics.
I wanted to know if you have created any or have any standards documents for creating/custom zing WF in Oracle Apps environment.
T hanks
0 #6 Disha1 2007-09-06 07:35
Hi Anil,

When I am creating an event attribute with event action as receive, how do i pass the correlation_id? Does the system automatically passes this id or do i need to create a sequence and then pass it as correlation_id?

Please advice...

Than ks...
0 #7 Ajitha 2007-10-10 15:06
I have a work flow event that will be raised when ever a purchase order is placed. I have to subscribe to this event and call a web service whenever I receive the notification. Can I achieve this using XML Gateway. I am a newbie to workflow and XMLGateway so please suggest me any alternatives as well.
0 #8 Anil Passi 2007-10-10 15:32
Hi Ajitha

Not sure which version of 11i/12i are you using
For 11i you can subscribe a pl/sql to the business event and from that pl/sql[metalink note 221854.1 ] you can invoke the web service [...R12 has out of the box integration though between WSDL and WF Events]

Thank s,
Anil Passi
0 #9 Ajitha 2007-10-15 09:20
Hi Anil,

Thanks a lot for the information. I could invoke my web service succesfully from the java rule function.
Also I came across a new feature in R12. Thought I will post it here for future reference. Inorder to invoke a BPEL process or any other web service we have to specify
"oracle .apps.fnd.wf.be s.WebServiceInv okerSubscriptio n" in the Java Rule function.
Also the following 5 parameters have to be specified in the Event parameters section
SERVICE _WSDL_URL http://xyz.com:7777/orabpel/default/WorkFlowIntegration/1.1?WSDL
SERVICE_NAME Workflowintegra tion
SERVICE_PO RTTYPE Workflowintegra tion
SERVIC E_PORT WorkFlowIntegra tionPort
This will be helpful in invoking a simple web service without any parameters. If we have any parameter passing or any custom validations we can do it by extending the class
WebServic eInvokerSubscri ption and by specifying in the Java Rule function.

Than ks
0 #10 Anil Passi 2007-10-16 09:04
Thanks for these details Ajitha.

Regard s,
Anil Passi
0 #11 Shiv Saroj 2007-10-16 18:21
Nice discussion Anil. There are some pre built point of invocations with respect to BPEL or generic web service in EBIZ. Let me dig it out and will update the same later on.
0 #12 Lalit 2007-12-11 08:48
I am new to Oracle apps I want to know how to do we create Business events and subscribe when a sales order in Oracle APPS.
0 #13 krishna440 2013-05-07 09:35
Hi, Can some one tell me how to migrate the business event using putty,also can you tell me how to find machine_name,po rt,sid...all the details..plz i am in a very critical need

Add comment

Security code

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Jun 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
   1  2  3  4  5  6
  7  8  910111213

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner