Results for “list_yn”

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

Overview

OKC_ACTION_ATTRIBUTES_B is a Contracts Core (OKC) base table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the descriptive attributes belonging to an Action. Within the Oracle Contracts architecture, an Action represents a discrete executable step in a contract's lifecycle — for example, a term generation rule, a deliverable trigger, or a workflow-driven activity. Each Action may be parameterized by one or more attributes, and OKC_ACTION_ATTRIBUTES_B is the repository that defines those parameters, their data types, presentation properties, validation ranges, and list-of-values bindings.

The table's Data Vault classification, derived heuristically from its foreign key topology, is hub-leaning. In modeling terms, this suggests treating OKC_ACTION_ATTRIBUTES_B as a durable business entity keyed on a surrogate identifier, with the surrounding tables (values, condition lines, function expression parameters) acting as dependent satellites or links that carry transactional and contextual state.

Key Information Stored

The table is physically defined in the OKC schema with 42 columns. The most significant columns are:

• ID — Surrogate primary key, enforced by OKC_ACTION_ATTRIBUTES_B_PK. This is the internal identifier referenced by all dependent child tables.
• ACN_ID — Foreign key to OKC_ACTIONS_B, identifying the parent Action to which the attribute belongs.
• AAL_ID — Foreign key to OKC_ACTION_ATT_LOOKUPS, binding the attribute to a lookup definition and its associated list-of-values behavior.
• ELEMENT_NAME — The programmatic name used to address the attribute in generated expressions and rule logic. It participates in the unique index OKC_ACTION_ATTRIBUTES_B_U3 (ACN_ID, ELEMENT_NAME, ZD_EDITION_NAME), making it a business-key candidate.
• DATA_TYPE — The declared data type of the attribute (character, number, date, and similar), which governs downstream validation and rendering.
• NAME — The user-facing display label for the attribute.
• LIST_YN and VISIBLE_YN — Flags indicating whether the attribute is driven by a list of values and whether it is presented in the user interface.
• FORMAT_MASK, MINIMUM_VALUE, MAXIMUM_VALUE — Formatting and range constraints applied during attribute entry.
• DATE_OF_INTEREST_YN and SOURCE_DOC_NUMBER_YN — Behavioral flags controlling how the attribute participates in date tracking and document numbering.
• SEEDED_FLAG and ZD_EDITION_NAME — Standard Oracle metadata columns denoting Oracle-supplied seed data and the edition in which the row is visible. The composite unique index OKC_ACTION_ATTRIBUTES_B_U1 (ID, ZD_EDITION_NAME) reinforces edition-aware identity.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard concurrency control and audit columns.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enabling multi-tenant or operating-unit-level data segregation.

Common Use Cases and Queries

Typical usage centers on interrogating the attribute configuration for a given Action, driving dynamic UI rendering, and auditing rule parameters. A representative query joins the attribute definition to its parent Action:

• Listing all attributes for a specific Action: SELECT a.ID, a.ELEMENT_NAME, a.NAME, a.DATA_TYPE FROM OKC_ACTION_ATTRIBUTES_B a WHERE a.ACN_ID = :acn_id;
• Identifying list-driven attributes: filter on LIST_YN = 'Y' and join to OKC_ACTION_ATT_LOOKUPS via AAL_ID.
• Auditing recently modified configurations using LAST_UPDATE_DATE and LAST_UPDATED_BY.
• Reconciling seeded versus customer-defined attributes via SEEDED_FLAG.
• Reporting on attributes referenced by contract condition lines and function expressions for rule traceability.

Because the table is edition-enabled, queries against 12.2.2 should account for ZD_EDITION_NAME when comparing across editions.

Related Objects

• OKC_ACTIONS_B — Parent table; joined on OKC_ACTION_ATTRIBUTES_B.ACN_ID = OKC_ACTIONS_B.ID.
• OKC_ACTION_ATT_LOOKUPS — Lookup definition; joined on AAL_ID.
• FND_SECURITY_GROUPS — Security grouping; joined on SECURITY_GROUP_ID.
• OKC_ACTION_ATT_VALS — Stores permitted attribute values; references this table via AAE_ID.
• OKC_CONDITION_LINES_B — Contract condition definitions; references this table via AAE_ID.
• OKC_FUNCTION_EXPR_PARAMS — Function expression parameters; references this table via AAE_ID.
• OKC_OUTCOME_ARGUMENTS — Outcome argument definitions; references this table via AAE_ID.