Results for “doc_type_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGI_EXP_WKF_ASSIGN is a table in the IGI schema, belonging to the Oracle E-Business Suite product IGI — Public Sector Financials International. Its documented purpose is to record which document type is assigned to a given workflow. In practice, the table functions as an assignment or mapping register: it binds a workflow definition (identified by WKF_ID) to one or more document types (identified by DOC_TYPE_ID), allowing the IGI expenditure and public-sector financials processes to determine the correct approval or processing workflow for each category of document.

The object is documented as VALID in Oracle EBS 12.1.1 and 12.2.2. The physical schema exposes seven columns, with a composite primary key defined by the IGI_EXP_WKF_ASSIGN_PK constraint. From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is standalone. This suggests that IGI_EXP_WKF_ASSIGN is best modeled as an independent structure rather than as a hub, link, or satellite in a conventional Data Vault sense. Where it is incorporated into a warehouse model, its composite key of WKF_ID and DOC_TYPE_ID makes it a natural candidate for a link-style association between a workflow hub and a document type hub, but the documented heuristic treats it as standalone.

Key Information Stored

The table is intentionally narrow. The most significant columns are the two key components and the standard Oracle EBS audit columns:

• WKF_ID — Identifier of the workflow definition. This is the column most frequently searched by users (the search term "wkf_id" maps directly to it) and forms the leading column of the primary key.
• DOC_TYPE_ID — Identifier of the document type assigned to the workflow. It is the second component of the composite primary key.
• LAST_UPDATE_DATE — Timestamp of the most recent modification to the row.
• LAST_UPDATED_BY — User identifier responsible for the most recent update.
• CREATION_DATE — Timestamp when the assignment row was created.
• CREATED_BY — User identifier that created the row.
• LAST_UPDATE_LOGIN — Login session identifier associated with the last update, used for audit traceability.

The surrogate primary key is the composite IGI_EXP_WKF_ASSIGN_PK, defined on (WKF_ID, DOC_TYPE_ID). There is no separate single-column surrogate key documented. The same composite index serves as the unique business-key candidate, meaning that a given workflow may be assigned to a document type only once. No additional unique indexes are documented beyond this constraint.

Common Use Cases and Queries

The primary practical use of IGI_EXP_WKF_ASSIGN is to resolve which workflow applies to a document type, or conversely, which document types a workflow governs. A common query pattern retrieves all assignments for a workflow:

• SELECT wkf_id, doc_type_id, creation_date, last_update_date FROM igi.igi_exp_wkf_assign WHERE wkf_id = :p_wkf_id;
• SELECT doc_type_id, wkf_id FROM igi.igi_exp_wkf_assign WHERE doc_type_id = :p_doc_type_id;
• Join to workflow configuration tables to validate that every active workflow has at least one document type assignment.
• Audit reporting on creation and last-update metadata to identify recently changed workflow assignments.
• Data migration or setup validation scripts that verify the WKF_ID values referenced exist in the workflow definition source.
• Extracts feeding a data warehouse, where WKF_ID and DOC_TYPE_ID are used as a composite business key.

Because the table is small and key-driven, queries are inexpensive and typically index-driven through the primary key.

Related Objects

The ETRM metadata classifies IGI_EXP_WKF_ASSIGN as standalone and does not document outbound foreign keys to other tables. Consequently, related objects are inferred from the key columns and the IGI product context:

• Workflow definition tables — referenced through WKF_ID, which identifies the workflow assigned to the document type.
• Document type tables — referenced through DOC_TYPE_ID, identifying the document category being mapped.
• IGI expenditure and public-sector financials setup tables — the broader configuration context in which these assignments are consumed.
• Oracle Workflow (WF_) dictionary objects — the runtime engine that resolves and executes the workflow selected via WKF_ID.
• IGI_EXP_WKF_ASSIGN_PK — the composite primary key constraint that enforces uniqueness of the workflow-to-document-type mapping.

No dependent views, APIs, or child tables are documented in the supplied metadata. Practitioners should confirm current relationships against the live data dictionary, since the IGI schema is proprietary and its object relationships may be extended by patches or localizations.