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