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 

NameDescription
.wfxWorkflow XML loader files.

Object Type

NameCode
Workflow XMLsWORKFLOW_XML

Object Type Attributes

NameCodeDescriptionDefault ValueSupported Values
SourceSOURCEObject Source Location Type

SCM (**populating from SCM)

EBS (**manual creation)

SCM | EBS
Target LocationTARGET_LOCATIONPath to where the file should be deployed.$<PROD_TOP>/patch/115/xml/
ForceFORCEOverwrites any existing definitions.truetrue | false
JDBC ProtocolJDBC_PROTOCOLDB connection protocol for JDBCthinthin|oci8
LanguageLANG

Specifies the current language of the session.

US
Classpath for WorkflowCLASSPATH

Classpath to add dependent jars files used in workflows.



Exact Download ModeEXACT_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.

falsetrue | false
Object TypeOBJECT_TYPEWorkflow typeEVENTSAGENTS | EVENTS | EVENT_GROUPS | SUBSCRIPTIONS
Object KeyOBJECT_KEYWorkflow Key

Target File PermissionsFILE_PERMISSIONSPermissions to apply to the file after it is deployedDefaults to the project property FDEBS_FILE_PERMISSIONS

Related Project Properties

NameCodeDescriptionDefault Value
Workflows Root Source DirectoryFDEBS_WORKFLOWS_ROOT_SOURCE_DIRSource folder for workflow files.(e.g. wf).workflows
Workflows Root Destination DirectoryFDEBS_WORKFLOWS_ROOT_DESTINATION_DIRTarget directory for Workflow files (e.g. $XXHR_TOP/workflow).$<PROD_TOP>/patch/115/import or xml
Workflow ClasspathFDEBS_WORKFLOW_CLASSPATHSet the classpath if needed for Workflow Load (WFXLoad).
File PermissionsFDEBS_FILE_PERMISSIONSTarget 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