IFS Enterprise Upstream Event Management

Back to IFS Enterprise Upstream Workflows

1 Staging Table Reference

IFS Workflow includes product-specific triggers that can be used as a template to create new triggers. These triggers insert data into the staging table for custom workflows.

Once a new workflow is identified, the workflow.properties file will need to be updated with the following parameters for the desired workflow:

userUid
taskUid
processUid

The prefix for these properties can be any 6 character string, but the prefix needs to match exactly what is stored as the workflow type in the staging table.

In the trigger, the parameter being passed to the EB_WORKFLOW_STG_PKG.insert_row is the value that must match the prefixes in the workflow.properties file.

Staging Table Reference

The staging table consists of the following columns:

COLUMN	TYPE	DESCRIPTION	COMMENTS

COLUMN	TYPE	DESCRIPTION	COMMENTS
STAGE_UID	NUMBER	Unique identifier for each record	This field is the primary key for the table and identifies a unique record in EU. It is populated by a new sequence: eb_workflow_staging_seq.
WORKFLOW_TYPE	VARCHAR2(6)	Identifies the workflow type of the record	This needs to have matching values in the workflow.properties file. Example: A record with PRDISP as the workflow_type in the staging table needs to have the following three lines in the application.properties file: PRDISP.userUid= PRDISP.taskUid= PRDISP.processUid=
STATUS	VARCHAR2(1)	Tells the user the status of the record	The different Statuses are: Transfer - This record is ready to be picked up Waiting for transfer confirmation - The record has been picked up by the web services, but has not completed Error - The record was not successfully created in IFS Workflow. See the status_message column for additional information Successfully transferred - The record was created successfully in IFS Workflow.
STATUS_MESSAGE	VARCHAR2(4000)	Error messages will display here
WORKFLOW_VALUES	VARCHAR2(4000)	Any necessary values that need to be passed to IFS Workflow. This could differ for each different workflow type.	This is a JSON string that is built by the workflow PL/SQL package.
CREATION_DATE	DATE	Captures when the record was created
CREATED_BY	NUMBER(15)	Captures which user created the record
LAST_UPDATE_DATE	DATE	Captures the date the record was last updated
LAST_UPDATED_BY	NUMBER(15)	Captures the user that last updated the record
LAST_UPDATE_LOGIN	NUMBER(15)	Captures the ID of the session that last updated the record
ORG_ID	NUMBER(15)	Used for ODP