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



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
The following macros are not currently supported in the footer:
  • style