Search Results okc_action_att_lookups




Overview
Explore in AI Chat

Overview

The table OKC_ACTION_ATT_LOOKUPS is a core reference table within the Oracle E-Business Suite Contracts Core (OKC) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to define and store metadata for table and column lookups associated with Action Attributes. In the context of the Contracts module, Action Attributes are configurable elements that define specific properties or data points for contract actions and workflows. This table acts as a central repository that links these attributes to the underlying database tables and columns from which valid values can be sourced, thereby enforcing data integrity and enabling dynamic list-of-values (LOV) functionality within the application's user interface.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the table's description and its primary key structure indicate the core data it holds. The primary key column is ID (OKC_ACTION_ATT_LOOKUPS_PK). Based on its purpose, the table typically stores information such as the lookup code or name, the target database table name, the key column within that table used for the value, and the display column used for the description shown to the user. It may also include columns for application context, enabling logic, and effective date ranges to control the availability of the lookup values. This configuration allows administrators to define precisely which valid set of records from a master table (e.g., a list of approvers, contract types, or terms) is available for a given Action Attribute.

Common Use Cases and Queries

The primary use case is the backend support for dynamic lists of values in Contracts Core forms and workflows. When a user interacts with an Action Attribute configured with a lookup, the application queries this table to determine the source of the LOV data. A common reporting need is to audit all configured lookups for Action Attributes. A sample query pattern would join this table to its related attributes table to list all lookups:

  • SELECT aal.lookup_code, aal.table_name, aal.value_column, aal.display_column, aab.attribute_name FROM okc_action_att_lookups aal, okc_action_attributes_b aab WHERE aab.aal_id = aal.id;

Another critical scenario is during customization or data fixes, where a developer might need to trace the source of values for a specific attribute or update a lookup definition to point to a new table or column.

Related Objects

The table has a direct and documented foreign key relationship, making it a parent table in the data model. The key related object is:

  • OKC_ACTION_ATTRIBUTES_B: This table holds the definition of Action Attributes themselves. It references OKC_ACTION_ATT_LOOKUPS via its foreign key column AAL_ID, which joins to the primary key (ID) of OKC_ACTION_ATT_LOOKUPS. This relationship means that an attribute record in OKC_ACTION_ATTRIBUTES_B can be associated with a single, predefined lookup configuration. No other tables are documented as having foreign keys referencing OKC_ACTION_ATT_LOOKUPS in the provided metadata.