Search Results pa_proj_period_profiles




Overview
Explore in AI Chat

Overview

The PA_PROJ_PERIOD_PROFILES table is a core data structure within the Oracle E-Business Suite Projects (PA) module, specifically in versions 12.1.1 and 12.2.2. It functions as the repository for period profile information, which is a critical configuration for financial and performance reporting on projects. The table's primary role is to define the accounting calendar and period structure used for reporting against a specific project. This linkage ensures that project transactions, costs, and revenues are aligned with the appropriate accounting periods, enabling accurate period-end closing, revenue recognition, and management reporting. It serves as the bridge between project-specific data and the general ledger's fiscal calendar.

Key Information Stored

The table stores the relationship between a project and the General Ledger's accounting calendar. While the full column list is not detailed in the provided metadata, the documented foreign keys reveal the most critical columns. The PROJECT_ID column links to PA_PROJECTS_ALL, identifying the specific project. The PERIOD_SET_NAME column references GL_PERIOD_SETS, defining which accounting calendar (e.g., "Accounting") is assigned to the project. The GL_PERIOD_TYPE column references GL_PERIOD_TYPES, specifying the period frequency (e.g., Month, Quarter) for that calendar. Collectively, these columns establish the temporal framework for all period-based project reporting and accounting.

Common Use Cases and Queries

The primary use case is to determine the reporting calendar for any given project, which is essential for building accurate financial reports. This is frequently queried in custom reports for project cost accruals, revenue recognition schedules, and budget versus actual analyses segmented by period. A common SQL pattern involves joining this table to project and General Ledger period tables to translate transaction dates into the correct accounting periods. For example, to list all projects with their assigned accounting calendars, a query would join PA_PROJ_PERIOD_PROFILES (PP) to PA_PROJECTS_ALL (P) and GL_PERIOD_SETS (PS): SELECT P.SEGMENT1 PROJECT_NUMBER, P.NAME, PP.PERIOD_SET_NAME FROM PA_PROJECTS_ALL P, PA_PROJ_PERIOD_PROFILES PP WHERE P.PROJECT_ID = PP.PROJECT_ID;. This profile is also critical for the proper functioning of standard Oracle Projects reports and the integration of project accounting with the General Ledger.

Related Objects

As indicated by the foreign keys, PA_PROJ_PERIOD_PROFILES has direct dependencies on several fundamental tables. Its primary relationship is with PA_PROJECTS_ALL, the master table for all projects. For calendar definition, it depends on the General Ledger tables GL_PERIOD_SETS and GL_PERIOD_TYPES. In practice, this table is also closely related to transaction tables like PA_EXPENDITURE_ITEMS_ALL and PA_CUST_REV_DIST_LINES_ALL, whose dates are validated against the assigned period profile. Key reporting views, such as PA_PROJECTS, may also incorporate data from this table to present a complete project definition.

  • Table: PA_PROJ_PERIOD_PROFILES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJ_PERIOD_PROFILES,  object_name:PA_PROJ_PERIOD_PROFILES,  status:VALID,  product: PA - Projects ,  description: This table stores the period profile information that is used for reporting purposes. ,  implementation_dba_data: PA.PA_PROJ_PERIOD_PROFILES , 

  • Table: PA_PROJ_PERIOD_PROFILES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJ_PERIOD_PROFILES,  object_name:PA_PROJ_PERIOD_PROFILES,  status:VALID,  product: PA - Projects ,  description: This table stores the period profile information that is used for reporting purposes. ,  implementation_dba_data: PA.PA_PROJ_PERIOD_PROFILES , 

  • View: PA_ORGFCST_PERIODS_TMP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_ORGFCST_PERIODS_TMP_V,  object_name:PA_ORGFCST_PERIODS_TMP_V,  status:VALID,  product: PA - Projects ,  description: The PA_ORGFCST_PERIODS_TMP_V view displays information about period types such as the name of the period and the start and end dates. ,  implementation_dba_data: APPS.PA_ORGFCST_PERIODS_TMP_V , 

  • View: PA_ORGFCST_PERIODS_TMP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_ORGFCST_PERIODS_TMP_V,  object_name:PA_ORGFCST_PERIODS_TMP_V,  status:VALID,  product: PA - Projects ,  description: The PA_ORGFCST_PERIODS_TMP_V view displays information about period types such as the name of the period and the start and end dates. ,  implementation_dba_data: APPS.PA_ORGFCST_PERIODS_TMP_V , 

  • View: PA_FP_PERIOD_INFO_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_PERIOD_INFO_V,  object_name:PA_FP_PERIOD_INFO_V,  status:VALID,  product: PA - Projects ,  description: The pa_fp_period_info_v view store the period information plan versions. ,  implementation_dba_data: APPS.PA_FP_PERIOD_INFO_V , 

  • Table: PA_PROJ_PERIODS_DENORM 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJ_PERIODS_DENORM,  object_name:PA_PROJ_PERIODS_DENORM,  status:VALID,  product: PA - Projects ,  description: This table stores denormalized amounts for various amount types for the set of periods defined in the PA_PROJ_PERIOD_PROFILES entity. ,  implementation_dba_data: PA.PA_PROJ_PERIODS_DENORM , 

  • View: PA_FP_PERIOD_INFO_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_PERIOD_INFO_V,  object_name:PA_FP_PERIOD_INFO_V,  status:VALID,  product: PA - Projects ,  description: The pa_fp_period_info_v view store the period information plan versions. ,  implementation_dba_data: APPS.PA_FP_PERIOD_INFO_V , 

  • Table: PA_PROJ_PERIODS_DENORM 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJ_PERIODS_DENORM,  object_name:PA_PROJ_PERIODS_DENORM,  status:VALID,  product: PA - Projects ,  description: This table stores denormalized amounts for various amount types for the set of periods defined in the PA_PROJ_PERIOD_PROFILES entity. ,  implementation_dba_data: PA.PA_PROJ_PERIODS_DENORM , 

  • View: PA_FP_PERIODS_TMP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_PERIODS_TMP_V,  object_name:PA_FP_PERIODS_TMP_V,  status:VALID,  product: PA - Projects ,  description: The PA_FP_PERIODS_TMP_V view displays information about period types such as the name of the period and the start and end dates. ,  implementation_dba_data: APPS.PA_FP_PERIODS_TMP_V , 

  • Table: PA_PROJECTS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL , 

  • Table: PA_PROJECTS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL ,