1. Tables and Views for Financials
  2. FUN_WF_HISTORY

FUN_WF_HISTORY

FUN_WF_HISTORY contains the approval and rejection history of each submission that passes through the Approval Workflow process. This table is for capturing the high level transaction history and submission details.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

FUN_WF_HISTORY_PK

HISTORY_ID

Columns

Name Datatype Length Precision Not-null Comments
HISTORY_ID NUMBER 18 Yes Identifier that correlates the table FUN_WF_HISTORY with the table FUN_WF_HISTORY_LINES.
TRANSACTION_ID NUMBER 18 Yes Transaction undergoing the approval cycle.
WORKFLOW_ID NUMBER 18 Foreign key reference identifier to the FUN_WORKFLOWS_B table.
APPLICATION_ID NUMBER 18 Unique application identification number.
TRANSACTION_NAME VARCHAR2 200 Name of the approval workflow transaction.
INITIATION_DATE TIMESTAMP Date and time of transaction initiation.
SUBMITTED_BY VARCHAR2 64 Name of the transaction submitter.
STATUS_CODE VARCHAR2 30 Current status of the transaction. Once approval is completed,This field will indicate final status of the transaction.Values are derived from the lookup type ORA_FUN_APPROVAL_STATUS.
WORKFLOW_OUTCOME_CODE VARCHAR2 30 Current workflow outcome of the transaction. Once approval is completed, this field will indicate final workflow outcome of the transaction.This field will indicate final status of the transaction.Values are derived from the lookup type ORA_FUN_APPROVAL_WF_OUTCOME.
SOURCE_CODE VARCHAR2 30 Transaction creation source. Possible values are manually, batch, and so on.Values are derived from the lookup type ORA_FUN_APPROVAL_TXN_SOURCE.
SOURCE_ID NUMBER 18 Process ID which submitted the transaction. When transaction is submitted through automated process like an ESS job, this field stores the request ID.
LAST_ACTED_BY VARCHAR2 1000 User who last acted on the transaction.
FLOW_ID NUMBER 38 Flow identifier of the submission.
TAC_TRANSACTION_ID VARCHAR2 18 Identifier for Transaction Console.
ROOT_TASK_ID VARCHAR2 64 Root task identifier of the submission.
ADDITIONAL_CONTEXT BLOB Additional detailed meta data for transaction.
COMPLETION_DATE TIMESTAMP Date and time of the transaction approval completion.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table Foreign Table Foreign Key Column
FUN_WF_HISTORY fun_workflows_b WORKFLOW_ID
fun_wf_history_lines fun_wf_history HISTORY_ID

Indexes

Index Uniqueness Tablespace Columns
FUN_WF_HISTORY_N1 Non Unique Default TRANSACTION_ID, WORKFLOW_ID, APPLICATION_ID
FUN_WF_HISTORY_PK Unique Default HISTORY_ID