XML definitions for Business Event System objects between a database and a flat file.
Object Type Identification
- Files with the extension .wfx are included regardless of location
File Extensions
| Name | Description |
|---|---|
| .wfx | Workflow XML loader files. |
Object Type
| Name | Code |
|---|---|
| Workflow XMLs | WORKFLOW_XML |
Object Type Attributes
| Name | Code | Description | Default Value | Supported Values |
|---|---|---|---|---|
| Source | SOURCE | Object Source Location Type | SCM (**populating from SCM) EBS (**manual creation) | SCM | EBS |
| Target Location | TARGET_LOCATION | Path to where the file should be deployed. | $<PROD_TOP>/patch/115/xml/ | |
| Force | FORCE | Overwrites any existing definitions. | true | true | false |
| JDBC Protocol | JDBC_PROTOCOL | DB connection protocol for JDBC | thin | thin|oci8 |
| Language | LANG | Specifies the current language of the session. | 2 character value is defaulted based on value of Workflows Root Source Directory. For example, Workflows Root Source Directory is set to workflows then
| |
| Classpath for Workflow | CLASSPATH | Classpath to add dependent jars files used in workflows. | ||
| Exact Download Mode | EXACT_DOWNLOAD_MODE | To download exactly as they are specified in the database. In this mode, the Workflow XML Loader does not convert any data to tokens; instead, all values, including system-specific values, are copied to the XML file. | false | true | false |
| Object Type | OBJECT_TYPE | Workflow type | EVENTS | AGENTS | EVENTS | EVENT_GROUPS | SUBSCRIPTIONS |
| Object Key | OBJECT_KEY | Workflow Key | ||
| Target File Permissions | FILE_PERMISSIONS | Permissions to apply to the file after it is deployed | Defaults to the project property FDEBS_FILE_PERMISSIONS |
Related Project Properties
| Name | Code | Description | Default Value |
|---|---|---|---|
| Workflows Root Source Directory | FDEBS_WORKFLOWS_ROOT_SOURCE_DIR | Source folder for workflow files.(e.g. wf). | workflows |
| Workflows Root Destination Directory | FDEBS_WORKFLOWS_ROOT_DESTINATION_DIR | Target directory for Workflow files (e.g. $XXHR_TOP/workflow). | $<PROD_TOP>/patch/115/import or xml |
| Workflow Classpath | FDEBS_WORKFLOW_CLASSPATH | Set the classpath if needed for Workflow Load (WFXLoad). | |
| File Permissions | FDEBS_FILE_PERMISSIONS | Target File Permission. Will be set to target file after deployment using chmod. eg: 755 |
Sample Build Commands
java oracle.apps.fnd.wf.WFXLoad -d $FDEBS_DB_USER "$FDEBS_DB_PASSWORD" "$AD_APPS_JDBC_URL" thin US "$SOURCE_FILE" wfx EVENTS
Sample Deploy Commands
cp "$SOURCE_FILE" "$XXHR_TOP/patch/115/xml/"; java oracle.apps.fnd.wf.WFXLoad -uf $FDEBS_DB_USER "$FDEBS_DB_PASSWORD" "$AD_APPS_JDBC_URL" thin US $XXHR_TOP/patch/115/xml/asn_event.wfx