Friday, February 10, 2012

Business Event - download/upload

Using FNDLOAD is possible to transfer a lot of objects between instances. It's also possible to transfer Business Events but not with FNDLOAD, to accomplish this we need to use a java program called WFXLoad.

Download - Event
java oracle.apps.fnd.wf.WFXLoad -d apps appspwd host:port:sid thin US download_file.wfx EVENTS event_name

Example
java oracle.apps.fnd.wf.WFXLoad -d apps password bigboy:1521:demo thin US xx_demo_EVENT.wfx EVENTS xx.oracle.apps.demo

Download - Subscription
java oracle.apps.fnd.wf.WFXLoad -d apps appspwd host:port:sid thin US download_file.wfx SUBSCRIPTIONS event_name

Example
java oracle.apps.fnd.wf.WFXLoad -d apps password bigboy:1521:demo thin US xx_demo_SUBSR.wfx SUBSCRIPTIONS xx.oracle.apps.demo

Upload - Event
java oracle.apps.fnd.wf.WFXLoad -u apps appspwd host:port:sid thin US upload_file.wfx

Example
java oracle.apps.fnd.wf.WFXLoad -u apps password bigboy:1521:demo thin US xx_demo_EVENT.wfx

Upload - Subscription
java oracle.apps.fnd.wf.WFXLoad -u apps appspwd host:port:sid thin US upload_file.wfx

Example
java oracle.apps.fnd.wf.WFXLoad -u apps password bigboy:1521:demo thin US xx_demo_SUBSR.wfx

Note
  • If you want to down- or upload different languages you can control this by changing language in the command (the value after thin...)
  • Use -uf instead of -u if you want to force upload
  • 1 comment:

    1. Can we upload/download only a single subscription for an event ?

      ReplyDelete

    javascript:void(0)