How to migrate Business Events and their Subscriptions

By | November 16, 2014

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
WOW! Did you like this post? We'll send more interesting posts like How to migrate Business Events and their Subscriptions to you!
Enter your Email Address: