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>
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 |