Results for “pa_config_list_elements”

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

Overview

PA_CONFIG_LIST_ELEMENTS is a configuration table within the Oracle E-Business Suite Projects (PA) module. It stores the defined elements and behaviors of a configuration list, capturing attributes such as the element identifier and the display order in which elements appear within a given list. In practical terms, this table functions as the detail-level companion to PA_CONFIG_LISTS, allowing administrators and the application to define which discrete elements belong to a named list and how those elements behave when presented to users, whether in setup screens, lookups, or configurable list regions within the Projects application.

From a dimensional modeling perspective, the supplied metadata classifies this object heuristically as satellite-leaning. The composite primary key of LIST_ID and LIST_ELEMENT_ID ties each row to a parent list while retaining a distinct element identity, which is characteristic of a satellite table dependent on an upstream hub or link. This classification is a modeling suggestion rather than a functional constraint, but it accurately reflects the table's role as descriptive detail hanging off the PA_CONFIG_LISTS parent.

The object is documented as not implemented in the reference database, which indicates that in some environments or releases the corresponding database object may not be physically present, or that it was catalogued from the repository definition rather than an installed schema. Implementers should verify physical existence via the data dictionary before building dependencies.

Key Information Stored

The columns documented in the metadata are limited but precise, and they establish the table's identity and parentage:

• LIST_ID — Identifies the parent configuration list. This is the first component of the composite primary key PA_CONFIG_LIST_ELEMENTS_PK and the sole documented foreign key column referencing PA_CONFIG_LISTS.LIST_ID.
• LIST_ELEMENT_ID — Identifies the individual element within the list. This is the second component of the composite primary key and serves as the surrogate/business identifier for the element row.

Beyond these documented key columns, the table is described as storing elements and behaviors of a list, including display order. The display-order attribute governs presentation sequencing of elements, and additional behavior flags determine how each element responds in the list context. The composite primary key (LIST_ID, LIST_ELEMENT_ID) guarantees uniqueness of each element within its list, while LIST_ID alone acts as the business-key linkage back to the parent list rather than a unique key on this table.

Common Use Cases and Queries

File-based and setup validation routines frequently join this table to PA_CONFIG_LISTS to resolve the ordered set of elements belonging to a named list. A representative query retrieves elements in presentation order:

• SELECT cle.list_id, cle.list_element_id FROM pa_config_list_elements cle WHERE cle.list_id = :p_list_id ORDER BY cle.display_order;
• Join pattern: SELECT cl.list_name, cle.list_element_id FROM pa_config_lists cl, pa_config_list_elements cle WHERE cl.list_id = cle.list_id;

Typical scenarios include diagnosing why a configurable list renders elements in an unexpected sequence, auditing which elements are attached to a list after an upgrade or patch, and extracting list membership for reporting on Projects configuration. Because the object is not implemented in every database, queries should be preceded by a check against ALL_TABLES or USER_TABLES.

Related Objects

The documented foreign key defines a direct dependency on the parent list table, and the surrounding configuration tables form the practical reference set:

• PA_CONFIG_LISTS — Parent table; joined on PA_CONFIG_LIST_ELEMENTS.LIST_ID = PA_CONFIG_LISTS.LIST_ID.
• PA_CONFIG_LIST_ELEMENTS_PK — The primary key constraint (LIST_ID, LIST_ELEMENT_ID) enforcing element uniqueness.
• PA_CONFIG_LIST_HEADERS — Header-level configuration metadata for the list family, when installed.
• PA_CONFIG_LOOKUPS — Lookup-driven configuration referenced by list elements where element values resolve to lookup codes.
• PA_CONFIGURATION_RELATIONS — Repository metadata describing configuration list membership and dependencies.
• FND_LOOKUP_VALUES / FND_FLEX_VALUES_VL — Common value sources for elements whose behavior is code or flexfield driven.
• PA_CONFIG_LIST_ELEMENTS_TL — Translation table, where present, carrying language-specific element display text.