Technical‎ > ‎Misc‎ > ‎

Migrating Oracle e-business Business Events


To download Business Event System object definitions from a database in Oracle e-ebusiness to a flat XML file, you can either run the Workflow XML Loader manually, or, if you are using the standalone version of Oracle Workflow, you an use a script to run the loader.


To run the Workflow XML Loader manually, run java / jre against oracle.apps.fnd.wf.WFXLoad. 


You must specify your CLASSPATH pointing to the Java Runtime Environment, the directory containing the Workflow JAR files, the Oracle JDBC implementation, and the following Workflow JAR files:

• wfjava.jar - Workflow Java utilities

• wfapi.jar - Workflow Java APIs


java -classpath "$/rt.jar:$:$/wfjava.jar:$/wfapi.jar:$/jdbc/lib/classes111.zip:" oracle.apps.fnd.wf.WFXLoad [-d|-u]   <apps_username> <apps_pwd> <server:server_port:sid> thin US <filename> [EVENTS|SUBSCRIPTIONS] <event_name>


  • Specify whether you want to upload(-u) or download(-d)
  • Specify the apps user name and password
  • Provide the server details i.e the servername/port/sid
  • Provide the name of the file to which you want to download or from which you want to upload
  • Specify whether you want to download subscriptions/events
  • Specify the name of the event for download

Sample for downloading events:

adjava oracle.apps.fnd.wf.WFXLoad -d aapps **** myserver:1541:sid thin US ./xx_oracle_apps_po_rfq_event_RFQActiveEvent.wfx EVENTS xx.oracle.apps.po.rfq.event.RFQActiveEvent

Sample for downloading subscriptions:

adjava oracle.apps.fnd.wf.WFXLoad -d apps **** myserver:1541:sid thin US ./xx_oracle_apps_po_rfq_event_RFQActiveEventSubscription.wfx SUBSCRIPTIONS xx.oracle.apps.po.rfq.event.RFQActiveEvent

Sample for uploading events

adjava oracle.apps.fnd.wf.WFXLoad -u apps **** myserver:1554:sid thin US  xx_oracle_apps_po_rfq_event_RFQActiveEvent.wfx

Sample for uploading subscriptions

adjava oracle.apps.fnd.wf.WFXLoad -u apps **** myserver:1554: sid thin US  xx_oracle_apps_po_rfq_event_RFQActiveEventSubscription.wfx



Free Hit Counters
Comments