Search Results okc_action_att_vals




Overview
Explore in AI Chat

Overview

The table OKC_ACTION_ATT_VALS is a core transactional data store within the Oracle E-Business Suite Contracts Core (OKC) module. Its primary function is to persist the specific values assigned to action attributes for each unique occurrence of a contract action. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is essential for managing the detailed, instance-level data that defines how a particular contract action or condition is executed. It serves as a child table, linking the definition of an action attribute (from OKC_ACTION_ATTRIBUTES_B) to a specific instance of a condition occurrence (from OKC_CONDITION_OCCURS). This relationship allows for highly configurable and data-rich contract action management within the application.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two foreign key columns. This design enforces a one-to-many relationship from a condition occurrence to its multiple action attribute values. The key columns are:

  • AAE_ID: The foreign key identifier linking to the OKC_ACTION_ATTRIBUTES_B table. This column specifies which defined attribute (e.g., notification recipient, escalation level, due date offset) is being populated.
  • COE_ID: The foreign key identifier linking to the OKC_CONDITION_OCCURS table. This column identifies the specific instance or occurrence of a contract condition or action for which the attribute value is being stored.

While the provided metadata does not list the value column(s) explicitly, the table's description indicates it stores the "value of an instance of Action Attribute." Therefore, in addition to the key columns, the table would contain at least one column (e.g., ATTRIBUTE_VALUE, NUMBER_VALUE, DATE_VALUE) to hold the actual data for the specified attribute for that specific occurrence.

Common Use Cases and Queries

This table is central to reporting and auditing the execution parameters of contract actions. A common use case involves generating a detailed report of all attribute values set for actions related to a specific contract or contract template. Technical consultants and support personnel may query this table to diagnose issues with action execution or to validate data integrity. A typical SQL pattern involves joining to the parent tables to retrieve descriptive information.

Sample Query Pattern:
SELECT occ.condition_id, aab.attribute_name, aav.attribute_value
FROM okc_action_att_vals aav,
okc_action_attributes_b aab,
okc_condition_occurs occ
WHERE aav.aae_id = aab.id
AND aav.coe_id = occ.id
AND occ.condition_id = :p_condition_id;
This query fetches all action attribute values for a given condition, showing the attribute name and its stored value for each occurrence.

Related Objects

OKC_ACTION_ATT_VALS is a dependent table with defined foreign key relationships to two primary master tables in the Contracts Core schema. These relationships are critical for data integrity and application logic.

  • OKC_ACTION_ATTRIBUTES_B: This is the definition table for action attributes. The relationship is defined as OKC_ACTION_ATT_VALS.AAE_ID → OKC_ACTION_ATTRIBUTES_B. It ensures every stored value corresponds to a valid, predefined attribute.
  • OKC_CONDITION_OCCURS: This table tracks individual instances or occurrences of contract conditions and actions. The relationship is defined as OKC_ACTION_ATT_VALS.COE_ID → OKC_CONDITION_OCCURS. It ties the attribute value to a specific runtime occurrence of an action within the contract lifecycle.

The table's primary key constraint, OKC_ACTION_ATT_VALS_PK, on columns (AAE_ID, COE_ID) ensures uniqueness of an attribute value per action occurrence.