EBS Object Types - Workflow XMLs

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

Name	Description
.wfx	Workflow XML loader files.

Object Type

Name	Code

Name	Code
Workflow XMLs	WORKFLOW_XML

Object Type Attributes

Name	Code	Description	Default Value	Supported Values

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

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