Search Results okc_action_attributes_b




Overview
Explore in AI Chat

Overview

The OKC_ACTION_ATTRIBUTES_B table is a core data structure within the Oracle E-Business Suite Contracts Core (OKC) module. It functions as the master repository for attributes that define and describe Actions within the contract management system. In the context of Oracle Contracts, an Action is a business process or task that can be triggered by contract events, such as generating a renewal notice or creating a purchase order. This table stores the metadata for the configurable parameters, or attributes, associated with these Actions, enabling flexible and detailed control over contract automation and workflow execution. Its role is foundational to the rule-based engine that governs contract lifecycle management in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to define the characteristics of an Action's attributes. While the full column list is not detailed in the provided metadata, the foreign key relationships and standard Oracle Contracts design patterns indicate critical columns. The primary key is the ID column. The ACN_ID column is a foreign key to OKC_ACTIONS_B, linking the attribute to its parent Action. The AAL_ID column references OKC_ACTION_ATT_LOOKUPS, which typically stores the type or definition of the attribute (e.g., a data type, display prompt, or validation rule). Other columns would store the attribute's sequence number, whether it is mandatory, and its default value logic. Essentially, each row defines one parameter that must or can be supplied when the associated Action is executed.

Common Use Cases and Queries

This table is primarily accessed for configuration, troubleshooting, and reporting on contract automation rules. Common scenarios include identifying all configurable parameters for a specific Action or validating attribute setup. A typical query would join to OKC_ACTIONS_B to list attributes for a named action.

  • Listing Attributes for an Action: SELECT aae.* FROM okc_action_attributes_b aae, okc_actions_b acn WHERE aae.acn_id = acn.id AND acn.name = 'RENEW_CONTRACT';
  • Auditing Attribute Definitions: Reports can be built to cross-reference attributes with their lookup definitions and the values stored in child tables like OKC_ACTION_ATT_VALS to ensure data integrity and completeness.
  • Support & Diagnostics: When an Action fails or behaves unexpectedly, support personnel may query this table and its related values to verify the attribute configuration passed to the business logic.

Related Objects

As shown in the metadata, OKC_ACTION_ATTRIBUTES_B is a central hub with multiple dependencies. OKC_ACTIONS_B is the parent table defining the Action itself. OKC_ACTION_ATT_LOOKUPS provides the type or template for the attribute. Crucially, OKC_ACTION_ATT_VALS is a key child table that stores the actual values assigned to these attributes for specific contract records. Furthermore, it is referenced by OKC_CONDITION_LINES_B, OKC_FUNCTION_EXPR_PARAMS, and OKC_OUTCOME_ARGUMENTS, highlighting its integral role in the expression, condition, and outcome evaluation logic of the Contracts Core engine. Development or customization involving contract rules will invariably interact with this table's relationships.