Page Comparison

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

to

.	$<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 /workflows/US/a.wfx path would have US as default. /payment/US/b.wfx path would have pa as default.
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

EBS

Workflows Root Source Directory

FDEBS_WORKFLOWS_ROOT_SOURCE_DIR

Source folder for workflow files.(e.g. wf).

workflows

EBS

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

EBS Workflows Upload ModeEBS

Upload Mode for WFLOAD (e.g. FORCE).UPLOAD

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

Code Block

language	bash
theme	RDark

java  oracle.apps.fnd.wf.WFXLoad -ded $FDEBS_DB_USER "$FDEBS_DB_PASSWORD" "$AD_APPS_JDBC_URL" thin US  "$SOURCE_FILE" wfx EVENTS

...

Sample Deploy Commands