How to migrate Business Events and their Subscriptions

Oracle has provided a WFXLoad utility to download Business Event definitions from a database in to a flat XML file.

WFXLoad utility works with adjava (Automatic Distribution of Java Applications).

Syntax for downloading Business Events

adjava oracle.apps.fnd.wf.WFXLoad -d apps **** ServerName:PortNumber:SID thin US ./FileNameTowhichEventShouldGetDownloaded.wfx EVENTS EventName

Syntax for downloading Business Event Subscriptions

adjava oracle.apps.fnd.wf.WFXLoad -d apps **** ServerName:PortNumber:SID thin US ./FileNameTowhichSubscriptionsShouldGetDownloaded.wfx SUBSCRIPTIONS EventName

-d – For Download
-u – For Upload
apps – Schema name
ServerName:PortNumber:SID – Host with port number
EventName – Name of the Business Event

Example to Download Business Event

adjava oracle.apps.fnd.wf.WFXLoad -d apps password devserver01.oracleappsdna.com:1521:dev1 thin US 
./PO_RCPT_Event.wfx EVENTS oracle.apps.po.rcv.rcvtxn

Example to Upload Business Event

adjava oracle.apps.fnd.wf.WFXLoad -u apps password devserver01.oracleappsdna.com:1521:dev1 thin US  
PO_RCPT_Event.wfx

Example to Download Business Event Subscriptions

adjava oracle.apps.fnd.wf.WFXLoad -d apps password devserver01.oracleappsdna.com:1521:dev1 thin US 
./PO_RCPT_Subscriptions.wfx SUBSCRIPTIONS oracle.apps.po.rcv.rcvtxn

Example to Upload Business Event Subscriptions

adjava oracle.apps.fnd.wf.WFXLoad -u apps password devserver01.oracleappsdna.com:1521:dev1 thin US  
PO_RCPT_Subscriptions.wfx