Results for “report_application_id”

28 results




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

Overview

EGO_REPORT_LISTS_VL is a multi-lingual (VL) view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the EGO - Advanced Product Catalog product family. It exposes the report list definitions maintained by the Advanced Product Catalog reporting framework, presenting user-defined groupings of reports that control which reports appear on a given region for a given user and responsibility. As a translated view, it resolves the language-specific name and description columns (LIST_NAME and LIST_DESCRIPTION) against the session language, so applications and reports automatically display list metadata in the language indicated by USERENV('LANG'). The view is documented as VALID in both ETRM 12.1.1 and 12.2.2 metadata sets. Because reporting and personalization features in Advanced Product Catalog frequently need to present a list identifier together with its user-facing description, the view is the primary access point for queries that search on list_description.

Underlying Base Objects

The view is defined over two base objects, exposed through synonyms in the APPS schema:

The join is performed on LIST_ID, with the translation table filtered by ERLTL.LANGUAGE = USERENV('LANG'), which restricts the result to exactly one row per list for the caller's session language. This is the classic EBS _VL pattern: a _B table for language-independent data joined to a _TL table for translated text.

Key Columns

  • LIST_ID – Primary key of the report list; the join key between _B and _TL tables.
  • LIST_NAME – Language-specific name of the list, sourced from EGO_REPORT_LISTS_TL.
  • LIST_DESCRIPTION – Language-specific description of the list, the column most commonly searched by end users.
  • USER_ID – Owner of the list when it is a personal (user-defined) list; may be null for seeded or shared lists.
  • REPORT_APPLICATION_ID / REPORT_REGION_CODE – Identify the application and region against which the list applies.
  • DEFAULT_FLAG – Indicates whether the list is the default for its region/user context.
  • CUSTOMIZATION_LEVEL_ID – The customization level governing who may modify the list (e.g., user, responsibility, site).
  • CLASSIFICATION1, CLASSIFICATION2, CLASSIFICATION3, ORGANIZATION_ID – Flexible classification and organization-scoping attributes.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns.

Common Use Cases and Queries

The view is typically queried to look up a list by its description, to retrieve the description for a known LIST_ID, or to drive LOVs and reports that must respect session language. A representative search on description is:

  • SELECT list_id, list_name, list_description, user_id, default_flag
    FROM apps.ego_report_lists_vl
    WHERE UPPER(list_description) LIKE UPPER('%&search_text%');
  • Retrieve the active default list for a region:
    SELECT list_id, list_name, list_description
    FROM apps.ego_report_lists_vl
    WHERE report_region_code = :region
    AND NVL(default_flag,'N') = 'Y';
  • List all personal lists for a user:
    SELECT list_id, list_name, list_description
    FROM apps.ego_report_lists_vl
    WHERE user_id = :user_id;

Because the translation filter uses USERENV('LANG'), query results depend on the session's NLS language setting; concurrent programs and integrations should initialize the session language explicitly when a deterministic description is required.