Search Results oke_k_user_attributes_h




Overview
Explore in AI Chat

Overview

The OKE_K_USER_ATTRIBUTES_H table is a core data object within the Oracle E-Business Suite (EBS) Project Contracts (OKE) module. It functions as a historical repository for user-defined attributes associated with contract headers and lines. This table is essential for maintaining a complete audit trail of changes made to custom attribute values throughout the lifecycle of a project contract. Its role is to capture and preserve the state of these extensible data points each time a major version of the contract is created, ensuring compliance and enabling historical reporting and analysis.

Key Information Stored

The table stores the historical instances of user attribute definitions linked to specific contract versions. Key columns include the composite primary key, consisting of K_USER_ATTRIBUTE_ID and MAJOR_VERSION, which uniquely identifies each historical record. The K_HEADER_ID and K_LINE_ID columns reference the specific contract header and line to which the attributes belong. The USER_ATTRIBUTE_CONTEXT column defines the classification or category of the user attribute, which is critical for organizing and retrieving custom data. The MAJOR_VERSION column is pivotal, as it ties the attribute data to a specific version of the contract, enabling the reconstruction of a contract's state at any point in its revision history.

Common Use Cases and Queries

Primary use cases involve auditing, reporting, and data validation for project contracts. Analysts query this table to track how custom attribute values have changed between contract amendments or to verify the data that was in effect at the time of a specific transaction. A common reporting pattern is to join this table with the contract headers and lines history tables to produce a comprehensive historical view of a contract, including all its custom fields. A sample query to retrieve the historical user attributes for a specific contract header would be:

  • SELECT attr.* FROM oke_k_user_attributes_h attr, oke_k_headers_h hdr WHERE attr.k_header_id = hdr.k_header_id AND attr.major_version = hdr.major_version AND hdr.contract_number = '&CONTRACT_NUM';

Data migration and integration processes also frequently reference this table to extract or validate historical custom data for interfacing with external systems.

Related Objects

The OKE_K_USER_ATTRIBUTES_H table has defined foreign key relationships with two primary history tables in the OKE module, ensuring referential integrity for its key references.

  • OKE_K_HEADERS_H: The table is linked via the K_HEADER_ID and MAJOR_VERSION columns. This relationship ensures every user attribute history record is associated with a valid historical version of a contract header.
  • OKE_K_LINES_H: The table is linked via the K_LINE_ID and MAJOR_VERSION columns. This relationship ties attribute history records to specific historical versions of contract lines, allowing for granular tracking of line-level custom data.

These relationships are fundamental, as they anchor the user attribute history to the core contract versioning framework, making the data meaningful for temporal analysis.