Search Results list_element_id

Overview

PA_CONFIG_LIST_ELEMENTS_V is a Projects (PA) module view in Oracle E-Business Suite 12.1.1 and 12.2.2 that exposes the individual member rows of configuration lists used throughout the Projects application. Its documented purpose is straightforward: "Displays all list elements." In the Projects architecture, list elements are the discrete entries that populate a configuration list — a list header identified by LIST_ID acting as a parent, and each list element representing one selectable or configurable value beneath it. Because the view presents these elements in a clean, denormalized form, it serves as the principal read-only interface for reporting, integration, and validation logic that must expand a list into its constituent members.

The view is significant to the user who searched for list_element_id, since that column is the unique identifier for each element row and is the join key most consumers will use when correlating a list element to downstream Projects data. The ETRM metadata explicitly notes that the view is "not implemented in this database," meaning the object exists as documented metadata but was not deployed in the environment where the extraction ran. This is common for Projects views whose deployment depends on specific product configurations or patch levels.

Underlying Base Objects

The view text is documented directly: it selects all columns from a single underlying table, PA_CONFIG_LIST_ELEMENTS. No joins, unions, or aggregation are present. The view is therefore a thin projection — a one-to-one column-for-column exposure of the base table. It introduces no filtering predicates, so every row in PA_CONFIG_LIST_ELEMENTS appears in the view. The ETRM "Referenced base objects" metadata lists none documented, which is a metadata gap rather than an indication of a complex definition; the embedded SELECT text conclusively identifies PA_CONFIG_LIST_ELEMENTS as the source. Related list header information (the list name and description associated with LIST_ID) resides in a companion header object, not in this view, so reporting that requires human-readable list names must join to the header.

Key Columns

• LIST_ELEMENT_ID — Surrogate primary key uniquely identifying each list element. This is the column most frequently searched and used in joins.
• LIST_ID — Foreign key back to the parent configuration list header; groups all elements belonging to a single list.
• DISPLAY_ORDER — Sequence number controlling the element's presentation order within the list.
• RECORD_VERSION_NUMBER — Optimistic locking counter used to detect concurrent updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking insert/update provenance.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The Oracle DFF/descriptive flexfield segment columns, carrying customer-defined extensibility data.

Common Use Cases and Queries

Typical uses include generating reports of all configuration list members, validating that a configured selection maps to a valid element, and extracting list contents for data conversion. Because the view carries no list name, a join to the header is typically required. A representative query:

SELECT v.LIST_ID, v.LIST_ELEMENT_ID, v.DISPLAY_ORDER, v.LAST_UPDATE_DATE FROM PA_CONFIG_LIST_ELEMENTS_V v WHERE v.LIST_ID = :p_list_id ORDER BY v.DISPLAY_ORDER;

To resolve a single element by its identifier: SELECT * FROM PA_CONFIG_LIST_ELEMENTS_V WHERE LIST_ELEMENT_ID = :p_list_element_id;

Confirming deployment before relying on the object is advisable given the documented "not implemented" status; query ALL_VIEWS for VIEW_NAME = 'PA_CONFIG_LIST_ELEMENTS_V' prior to use.