Search Results ak_flow_page_region_items




Overview
Explore in AI Chat

Overview

The AK_FLOW_PAGE_REGION_ITEMS table is a core metadata repository within the Oracle E-Business Suite (EBS) Application Object Library (AK) module. It functions as a junction table that establishes the relationship between a specific UI region item and the region to which it belongs. This table is fundamental to the declarative, metadata-driven architecture of the EBS framework, enabling the dynamic rendering of application pages. It stores configuration data that defines which attributes (items) appear within a given region on a specific page of an application flow. The integrity of this data is critical for the correct display and behavior of the user interface across both EBS 12.1.1 and 12.2.2 versions.

Key Information Stored

The table's primary key is a composite of eight columns, ensuring a unique definition for each region item placement. These columns collectively identify the precise context of the item within the application hierarchy. The key columns are FLOW_CODE, FLOW_APPLICATION_ID, PAGE_CODE, PAGE_APPLICATION_ID, REGION_CODE, REGION_APPLICATION_ID, ATTRIBUTE_CODE, and ATTRIBUTE_APPLICATION_ID. The FLOW, PAGE, and REGION columns define the navigational and structural context, while the ATTRIBUTE_CODE and ATTRIBUTE_APPLICATION_ID columns specifically identify the UI item (e.g., a text field, button, or display-only value) being placed. The consistent use of *_APPLICATION_ID columns ties each component to its owning application, a standard pattern in EBS metadata tables.

Common Use Cases and Queries

This table is primarily queried by the EBS framework during page rendering to determine the list of items to display. Common administrative and development use cases include auditing UI customizations, troubleshooting missing page elements, and generating documentation. A typical query to list all items for a specific region would join to the related metadata tables. For example:

  • SELECT attribute_code FROM ak_flow_page_region_items WHERE flow_application_id = :1 AND flow_code = :2 AND page_application_id = :3 AND page_code = :4 AND region_application_id = :5 AND region_code = :6 ORDER BY display_sequence;
  • Identifying all pages where a specific attribute is used across the system by querying on ATTRIBUTE_CODE and ATTRIBUTE_APPLICATION_ID.
  • Comparing items between environments by extracting metadata sets based on the composite key columns.

Related Objects

AK_FLOW_PAGE_REGION_ITEMS maintains documented foreign key relationships with two primary metadata tables, as per the provided ETRM data. These relationships enforce referential integrity and define its place in the metadata schema.

  • AK_FLOW_PAGE_REGIONS: The relationship links a region item to its parent region. The join is performed on the columns FLOW_APPLICATION_ID, FLOW_CODE, PAGE_APPLICATION_ID, PAGE_CODE, REGION_APPLICATION_ID, and REGION_CODE. This ensures an item cannot exist without a defined region.
  • AK_REGION_ITEMS: This relationship links the instance of an item on a region to the master definition of the item itself. The join is performed on the columns REGION_APPLICATION_ID, REGION_CODE, ATTRIBUTE_APPLICATION_ID, and ATTRIBUTE_CODE. This ensures all used items have a valid template definition.