Results for “region_defaulting_api_proc”

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

Overview

AK_REGION_ITEMS is a metadata repository table owned by the AK (Common Modules-AK) schema in Oracle EBS 12.1.1 and 12.2.2. It links a single attribute (item) to a region within the Oracle Application Framework (OAF) / AK region-based declarative UI framework. Each row defines how an item — a field, LOV, button, nested region reference, or menu element — is presented, validated, defaulted, ordered, and secured inside a region. It is therefore the primary configuration store for region-level item behavior used by AK-based self-service pages and the framework's runtime rendering engine.

The heuristic Data Vault classification for this object is satellite-leaning. This is a modeling suggestion rather than a physical designation: the table's composite primary key combines region and attribute identifiers, and the presence of edition/version columns (ZD_EDITION_NAME) and extensive descriptive attributes suggests it behaves largely as a dependent descriptive structure keyed by two upstream business entities rather than a classic hub or pure link. The two unique indexes (AK_REGION_ITEMS_U1 and AK_REGION_ITEMS_U2) confirm the business key.

Key Information Stored

The table holds 93 documented columns. The most significant are listed below.

• REGION_CODE / REGION_APPLICATION_ID — composite foreign key to AK_REGIONS, identifying the owning region.
• ATTRIBUTE_CODE / ATTRIBUTE_APPLICATION_ID — composite foreign key to AK_ATTRIBUTES, identifying the item placed in the region.
• DISPLAY_SEQUENCE / ORDER_SEQUENCE / ORDER_DIRECTION — presentation ordering of the item within the region.
• DISPLAY_VALUE_LENGTH / ATTRIBUTE_LABEL_LENGTH — sizing controls for the displayed value and label.
• REQUIRED_FLAG / UPDATE_FLAG / DISPLAY_FLAG / SUBMIT / ENCRYPT / USER_CUSTOMIZABLE / ADMIN_CUSTOMIZABLE — behavioral flags governing editability, submission, security, and personalization.
• LOV_REGION_CODE, LOV_ATTRIBUTE_CODE, LOV_FOREIGN_KEY_NAME, LOV_DEFAULT_FLAG — List of Values configuration for the item.
• DEFAULT_VALUE_VARCHAR2 / DEFAULT_VALUE_NUMBER / DEFAULT_VALUE_DATE — typed default values.
• REGION_DEFAULTING_API_PKG / REGION_DEFAULTING_API_PROC / REGION_VALIDATION_API_PKG / REGION_VALIDATION_API_PROC — server-side packages/procedures for defaulting and validation.
• NESTED_REGION_CODE / NESTED_REGION_APPLICATION_ID — parent/child region nesting.
• MENU_ID / MENU_NAME — foreign key to FND_MENUS for menu items.
• ZD_EDITION_NAME — edition/version marker participating in both unique indexes.

The surrogate/natural composite key is AK_REGION_ITEMS_PK (REGION_CODE, REGION_APPLICATION_ID, ATTRIBUTE_CODE, ATTRIBUTE_APPLICATION_ID). The business-key candidates are AK_REGION_ITEMS_U1 (the same four columns plus ZD_EDITION_NAME) and AK_REGION_ITEMS_U2 (REGION_CODE, REGION_APPLICATION_ID, DISPLAY_SEQUENCE, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical use cases include auditing region item configuration, tracing defaulting/validation package assignments, and locating menu-linked items.

• List all items in a region, ordered as displayed:
  SELECT attribute_code, display_sequence, required_flag, update_flag FROM ak.ak_region_items WHERE region_code = :p_region AND region_application_id = :p_app ORDER BY display_sequence;
• Find items using a specific defaulting procedure:
  SELECT region_code, attribute_code FROM ak.ak_region_items WHERE region_defaulting_api_proc = :p_proc;
• Join to AK_REGIONS to resolve region descriptive text via AK_REGION_ITEMS_TL.
• Report LOV configuration across regions.

Related Objects

• AK_REGIONS — parent of REGION_CODE / REGION_APPLICATION_ID.
• AK_ATTRIBUTES — parent of ATTRIBUTE_CODE / ATTRIBUTE_APPLICATION_ID.
• FND_MENUS — referenced via MENU_NAME and MENU_ID.
• AK_REGION_ITEMS_TL — translated descriptions; child on the same four key columns.
• AK_CATEGORY_USAGES — child referencing the composite key.
• AK_FLOW_PAGE_REGION_ITEMS — child referencing the composite key.