Search Results pa_page_layouts

Overview

The PA_PAGE_LAYOUTS table is a core repository within Oracle E-Business Suite (EBS) Projects (PA) module, specifically for the storage of user-defined page layout definitions. It serves as the central metadata table governing the structure and presentation of key project-centric pages in the application's user interface. Its primary role is to enable the configuration and personalization of page types, such as the seeded Project Home and Project Status Report pages, allowing organizations to tailor the information displayed to different user roles or project types. This table acts as the parent definition, which is then populated with specific content regions through related child tables.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships indicate the critical data elements. The central column is PAGE_ID, which serves as the unique primary key identifier for each layout record. Another significant column is PERS_FUNCTION_NAME, which stores the name of a function from FND_FORM_FUNCTIONS, linking the page layout to a specific navigable menu function within the EBS framework. This connection is essential for launching the configured page. The table also stores descriptive attributes for each layout, such as the page type, name, and other configuration flags that determine the layout's behavior and applicability.

Common Use Cases and Queries

A primary use case involves querying the system to audit or report on all custom page layouts created for a specific page type, such as Project Status Reports. Administrators may need to identify which layouts are assigned to specific task types for progress entry. A common diagnostic query is to join with FND_FORM_FUNCTIONS to verify the navigational integrity of a page layout.

• Sample Query to List All Page Layouts:
  SELECT page_id, name, page_type, pers_function_name FROM pa.pa_page_layouts ORDER BY page_type, name;
• Use Case: Identifying the page layout used for task progress entry by a specific task type, by joining PA_TASK_TYPES to PA_PAGE_LAYOUTS on TASK_PROGRESS_ENTRY_PAGE_ID.

Related Objects

The PA_PAGE_LAYOUTS table maintains integral relationships with several other EBS objects, primarily through foreign key constraints as documented.

• PA_PAGE_LAYOUT_REGIONS: This is the direct child table. It stores the individual content regions (like summaries, charts, or lists) that compose a page layout. It joins to PA_PAGE_LAYOUTS via PA_PAGE_LAYOUT_REGIONS.PAGE_ID.
• FND_FORM_FUNCTIONS: Provides the menu function definition. Joined via PA_PAGE_LAYOUTS.PERS_FUNCTION_NAME to the function name in FND_FORM_FUNCTIONS.
• PA_TASK_TYPES: References a page layout for task progress entry. Joined via PA_TASK_TYPES.TASK_PROGRESS_ENTRY_PAGE_ID to PAGE_ID.
• PA_PROJ_ELEMENTS: Similarly references a page layout for task progress entry at the project element level via PA_PROJ_ELEMENTS.TASK_PROGRESS_ENTRY_PAGE_ID.