Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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

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 

Code Block
languagebashthemeRDark
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 

Code Block
languagebashthemeRDark
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

...