Search Results pa_page_layouts




Overview
Explore in AI Chat

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.
  • Table: PA_PAGE_LAYOUTS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PAGE_LAYOUTS,  object_name:PA_PAGE_LAYOUTS,  status:VALID,  product: PA - Projects ,  description: PA_PAGE_LAYOUTS contains the page layouts created for each page type. The seeded page types are Project Home and Project Status Report. ,  implementation_dba_data: PA.PA_PAGE_LAYOUTS , 

  • Table: PA_PAGE_LAYOUTS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PAGE_LAYOUTS,  object_name:PA_PAGE_LAYOUTS,  status:VALID,  product: PA - Projects ,  description: PA_PAGE_LAYOUTS contains the page layouts created for each page type. The seeded page types are Project Home and Project Status Report. ,  implementation_dba_data: PA.PA_PAGE_LAYOUTS , 

  • View: PA_TM_PAGE_LAYOUTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_TM_PAGE_LAYOUTS_V,  object_name:PA_TM_PAGE_LAYOUTS_V,  status:VALID,  product: PA - Projects ,  description: This view is created as this will be used as the database_object_name in fnd_objects table for seeding an object of type TEAM_MEMBER_HOME. The view is a select of all the columns of pa_page_layouts table, selecting page layouts correspondin ,  implementation_dba_data: APPS.PA_TM_PAGE_LAYOUTS_V , 

  • View: PA_TM_PAGE_LAYOUTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_TM_PAGE_LAYOUTS_V,  object_name:PA_TM_PAGE_LAYOUTS_V,  status:VALID,  product: PA - Projects ,  description: This view is created as this will be used as the database_object_name in fnd_objects table for seeding an object of type TEAM_MEMBER_HOME. The view is a select of all the columns of pa_page_layouts table, selecting page layouts correspondin ,  implementation_dba_data: APPS.PA_TM_PAGE_LAYOUTS_V , 

  • Table: PA_TASK_TYPES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TASK_TYPES,  object_name:PA_TASK_TYPES,  status:VALID,  product: PA - Projects ,  description: PA_TASK_TYPES stores implementation-defined classifications of task. ,  implementation_dba_data: PA.PA_TASK_TYPES , 

  • Table: PA_PAGE_LAYOUT_REGIONS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PAGE_LAYOUT_REGIONS,  object_name:PA_PAGE_LAYOUT_REGIONS,  status:VALID,  product: PA - Projects ,  description: This table contains all the regions included in a page layout. ,  implementation_dba_data: PA.PA_PAGE_LAYOUT_REGIONS , 

  • Table: PA_PAGE_LAYOUT_REGIONS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PAGE_LAYOUT_REGIONS,  object_name:PA_PAGE_LAYOUT_REGIONS,  status:VALID,  product: PA - Projects ,  description: This table contains all the regions included in a page layout. ,  implementation_dba_data: PA.PA_PAGE_LAYOUT_REGIONS , 

  • Table: PA_TASK_TYPES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TASK_TYPES,  object_name:PA_TASK_TYPES,  status:VALID,  product: PA - Projects ,  description: PA_TASK_TYPES stores implementation-defined classifications of task. ,  implementation_dba_data: PA.PA_TASK_TYPES , 

  • View: PA_PROGRESS_REPORT_SETUP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROGRESS_REPORT_SETUP_V,  object_name:PA_PROGRESS_REPORT_SETUP_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROGRESS_REPORT_SETUP_V , 

  • View: PA_PROGRESS_REPORT_SETUP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROGRESS_REPORT_SETUP_V,  object_name:PA_PROGRESS_REPORT_SETUP_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROGRESS_REPORT_SETUP_V , 

  • Table: PA_PROJ_ELEMENTS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJ_ELEMENTS,  object_name:PA_PROJ_ELEMENTS,  status:VALID,  product: PA - Projects ,  description: PA_PROJ_ELEMENTS stores the common non-versioned information related to tasks and structures. - For future use ,  implementation_dba_data: PA.PA_PROJ_ELEMENTS , 

  • Table: PA_PROJ_ELEMENTS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJ_ELEMENTS,  object_name:PA_PROJ_ELEMENTS,  status:VALID,  product: PA - Projects ,  description: PA_PROJ_ELEMENTS stores the common non-versioned information related to tasks and structures. - For future use ,  implementation_dba_data: PA.PA_PROJ_ELEMENTS , 

  • View: PA_STRUCTURES_TASKS_V 12.2.2

    product: PA - Projects ,  description: PA_STRUCTURES_TASKS_V selects all the attributes of a structure version and a task version. - For future use ,  implementation_dba_data: Not implemented in this database , 

  • View: PA_STRUCTURES_TASKS_V 12.1.1

    product: PA - Projects ,  description: PA_STRUCTURES_TASKS_V selects all the attributes of a structure version and a task version. - For future use ,  implementation_dba_data: Not implemented in this database ,