Step 1: Load the Interface Tables

Using SQL*Loader, your favorite tool, or direct Oracle database-to-database communication, load your data into the required input columns in the following table:

• KWFL_TRANSACTIONS_INT

See Table 6-1. KWFL_TRANSACTIONS_INT interface table

Table 6-1. KWFL_TRANSACTIONS_INT interface table

Column	Usage	Data Type	Description
TRANSACTION_ID	Required	NUMBER	Uniquely identifies each transaction.
CREATION_DATE	Optional	DATE	The date/time for the step transaction cannot be set via this interface table. Instead, the value is taken from the LAST_UPDATE_DATE.
CREATED_USERNAME	Required	VARCHAR2	Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. Supply this or CREATED_BY.
CREATED_BY	Required	NUMBER	Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction. Supply this or CREATED_USERNAME.
LAST_UPDATE_DATE	Optional	DATE	This value is taken from the report execution date/time, which is transferred to the date/time for the step transaction. If left blank, the current date is used.
LAST_UPDATED_USERNAME	Required	VARCHAR2	Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. Supply this or LAST_UPDATED_BY.
LAST_UPDATED_BY	Optional	NUMBER	Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction. Supply this or LAST_UPDATED_USERNAME. If both are left blank, the value is derived from CREATED_USERNAME.
EVENT	Required	VARCHAR2	Specifies the type of workflow transaction.
DATA_LANG	I	VARCHAR2	Specifies the language of the data being imported, so it can be properly validated in the respective language. If no value is provided, then the language context is the same as the system language of the PPM instance into which the data is being imported.
GROUP_ID	Required	NUMBER	Groups all the records that should be processed at the same time. Use only one GROUP_ID each time you run a report. Derived from the KNTA_INTERFACE_GROUPS_S sequence.
WORKFLOW_ENGINE_BATCH_ID	Optional	NUMBER	Specifies the batch in which the workflow engine carried out this transaction.
PROCESS_PHASE	Optional	NUMBER	Indicates the current stage of the record as it is being processed. See Process State Information for details.
PROCESS_STATUS	Optional	NUMBER	Indicates the current disposition of the record. See Process State Information for details.
SOURCE_TYPE_CODE	Required	VARCHAR2	Specifies the type of external update. This should be a left blank or have a value of INTERFACE_WF.
SOURCE	Required	VARCHAR2	Specifies the source of the information. This information is not validated during an import. For example, the name of the third-party application or a value of CONVERSION.
INSTANCE_SOURCE_TYPE_CODE	Required	VARCHAR2	Indicates whether or not the transaction is for a package line (CR) or a request (IR).
INSTANCE_SOURCE_SET_NUMBER	Required	VARCHAR2	Specifies the package number (PACKAGE_NUMBER from KDLV_PACKAGES) or request number (REQUEST_NUMBER from KCRT_REQUESTS). Supply this or INSTANCE_SOURCE_SET_ID.
INSTANCE_SOURCE_SET_ID	Required	NUMBER	Specifies the package ID (PACKAGE_ID from KDLV_PACKAGES) or request ID (REQUEST_ID from KCRT_REQUESTS). Supply this or INSTANCE_SOURCE_SET_NUMBER.
INSTANCE_SOURCE_LINE_SEQ	Required	NUMBER	Specifies the package line sequence number (SEQ from KDLV_PACKAGE_LINES). Supply this or INSTANCE_SOURCE_ID.
INSTANCE_SOURCE_ID	Required	NUMBER	Specifies the package line ID (PACKAGE_LINE_ID from KDLV_PACKAGE_LINES) or request ID (REQUEST_ID from KCRT_REQUESTS). Supply this or INSTANCE_SOURCE_LINE_SEQ (for package lines) or INSTANCE_SOURCE_SET_NUMBER (for requests).
WORKFLOW_STEP_NAME	Required	VARCHAR2	Specifies the name of the workflow step (STEP_NAME from KWFL_WORKFLOW_STEPS). Supply this or WORKFLOW_STEP_ID.
WORKFLOW_STEP_SEQ	Required	VARCHAR2	Specifies the sequence number of the workflow step. Supply this or WORKFLOW_STEP_ID. For subworkflows, the sequence numbers of the workflow steps could be in the form of 2.4.5 and so forth.
RESULT_VALUE	Required	VARCHAR2	Indicates the result of the step. This is normally not displayed to the user; therefore it may be an ID or internal code.
VISIBLE_RESULT_VALUE	Required	VARCHAR2	Indicates the result of the step. This is the result value that a user normally sees.
USER_COMMENTS	Required	VARCHAR2	Specifies comments for the transaction. Any comments are appended to the notes for the package or request.
DELEGATED_TO_USERNAME	Required	VARCHAR2	Specifies the USERNAME (from KNTA_USERS) for the user that the decision is being delegated to. Supply this or DELEGATED_TO_USER_ID.
DELEGATED_TO_USER_ID	Required	NUMBER	Specifies the USER_ID (from KNTA_USERS) for the user that the decision is being delegated to. Supply this or DELEGATED_TO_USERNAME.
SCHEDULE_DATE	Required	DATE	Indicates the date that the execution step is scheduled to run.
WORKFLOW_ID	Optional	NUMBER	Specifies the workflow that the package should follow.
WORKFLOW_INSTANCE_ID	Optional	NUMBER	Specifies the instance ID.
WORKFLOW_STEP_ID	Required	NUMBER	Specifies the workflow step ID (WORKFLOW_STEP_ID from KWFL_WORKFLOW_STEPS). Supply this, WORKFLOW_STEP_NAME, or WORKFLOW_STEP_SEQ.
WORKFLOW_INSTANCE_STEP_ID	Optional	NUMBER	Specifies the instance step ID.
CURRENT_STEP_TRANSACTION_ID	Optional	NUMBER	Specifies the current step transaction ID.
APPROVALS_REQUIRED_CODE	Optional	NUMBER	Specifies the code for the required approvals.
EVENT_GROUP_ID	Optional	NUMBER	Specifies the group ID for the event.
CMD_EXECUTION_SCHD_TASK_ID	Optional	NUMBER	Specifies the execution step and the command that has been scheduled. This will specify the identified for the scheduled task.
TO_WORKFLOW_STEP_SEQ	Required	VARCHAR2	Specifies the sequence number of the workflow step for the step that the package line or request should transition to. Supply this, TO_WORKFLOW_STEP_ID, or TO_WORKFLOW_STEP_NAME.
TO_WORKFLOW_STEP_NAME	Required	VARCHAR2	Specifies the name of the workflow step (STEP_NAME from KWFL_WORKFLOW_STEPS) for the step that the package line or request should transition to. Supply this, TO_WORKFLOW_STEP_SEQ, or TO_WORKFLOW_STEP_ID.
TO_WORKFLOW_STEP_ID	Required	NUMBER	Specifies the workflow step ID (WORKFLOW_STEP_ID from KWFL_WORKFLOW_STEPS) for the step that the package line or request should transition to. Supply this, TO_WORKFLOW_STEP_NAME, or TO_WORKFLOW_STEP_SEQ.