Search Results pa_summary_project_retn




Overview
Explore in AI Chat

Overview

The PA_SUMMARY_PROJECT_RETN table is a core data structure within the Oracle E-Business Suite Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. It serves a critical function in the project billing and revenue management process by storing aggregated, or summary, retention amounts. Retention refers to a portion of the contract revenue that is withheld by the customer until project milestones or conditions are met. This table calculates and holds these summary amounts based on retention rules and billing setups defined at either the project level or the top task level. The data stored here represents rolled-up totals from more granular, detailed retention transaction records, providing a consolidated view essential for financial reporting, revenue recognition, and customer billing processes.

Key Information Stored

The table's primary purpose is to track summarized retention figures across multiple dimensions. While the full column list is not provided in the metadata, the documented foreign key relationships reveal its critical data points. It stores summary amounts linked to a specific PROJECT_ID and potentially a TASK_ID. It associates these amounts with the relevant customer (CUSTOMER_ID) and funding agreement (AGREEMENT_ID). A key aspect of its design is the storage of monetary amounts in multiple currencies, as indicated by foreign keys to FND_CURRENCIES for project currency, project functional currency, funding currency, and invoice processing currency. This multi-currency support is vital for global enterprises managing projects across different geographical and reporting standards.

Common Use Cases and Queries

This table is central to generating retention-related reports and inquiries. Common use cases include analyzing total retention held per project or customer, reconciling retention amounts during the project close process, and supporting audit trails for revenue deferrals. A typical reporting query would join this summary table to its related master tables to produce a comprehensible report. For example:

  • Retention Summary by Project: A query joining PA_SUMMARY_PROJECT_RETN to PA_PROJECTS_ALL and HZ_CUST_ACCOUNTS to list total retention amounts per active project, grouped by customer and currency.
  • Agreement-Level Retention Analysis: A query linking the table to PA_AGREEMENTS_ALL to analyze retention exposure against specific funding contracts or purchase orders.
  • Data Validation: SQL scripts to compare the summarized amounts in this table against the sum of detailed retention line items (likely in a table such as PA_RETENTIONS) to ensure data integrity.

Related Objects

As evidenced by its foreign key constraints, PA_SUMMARY_PROJECT_RETN is a nexus table that integrates data from several fundamental EBS modules. Its primary relationships are:

  • PA_PROJECTS_ALL: The master table for all projects.
  • PA_TASKS: The work breakdown structure tasks within a project.
  • PA_AGREEMENTS_ALL: Stores funding agreements, contracts, and purchase orders.
  • HZ_CUST_ACCOUNTS: The Trading Community Architecture (TCA) table for customer accounts.
  • FND_CURRENCIES: The application foundation table defining valid currencies.

This table is likely populated and maintained by the project billing engine and is a key source for retention reporting within the Projects module and integrated financial statements.

  • Table: PA_SUMMARY_PROJECT_RETN 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_SUMMARY_PROJECT_RETN,  object_name:PA_SUMMARY_PROJECT_RETN,  status:VALID,  product: PA - Projects ,  description: PA_SUMMARY_PROJECT_RETN stores summary retention amounts calculated based on retention and retention billing setup at the project or top task level. These amounts are the summary amounts of the detailed retention records. These amounts are ,  implementation_dba_data: PA.PA_SUMMARY_PROJECT_RETN , 

  • Table: PA_SUMMARY_PROJECT_RETN 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_SUMMARY_PROJECT_RETN,  object_name:PA_SUMMARY_PROJECT_RETN,  status:VALID,  product: PA - Projects ,  description: PA_SUMMARY_PROJECT_RETN stores summary retention amounts calculated based on retention and retention billing setup at the project or top task level. These amounts are the summary amounts of the detailed retention records. These amounts are ,  implementation_dba_data: PA.PA_SUMMARY_PROJECT_RETN , 

  • Table: PA_AGREEMENTS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_AGREEMENTS_ALL,  object_name:PA_AGREEMENTS_ALL,  status:VALID,  product: PA - Projects ,  description: Customer contracts that serve as the basis for work authorization ,  implementation_dba_data: PA.PA_AGREEMENTS_ALL , 

  • Table: PA_AGREEMENTS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_AGREEMENTS_ALL,  object_name:PA_AGREEMENTS_ALL,  status:VALID,  product: PA - Projects ,  description: Customer contracts that serve as the basis for work authorization ,  implementation_dba_data: PA.PA_AGREEMENTS_ALL , 

  • View: PA_PROJECT_RETENTION_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJECT_RETENTION_V,  object_name:PA_PROJECT_RETENTION_V,  status:VALID,  product: PA - Projects ,  description: Stores retention summary balances ,  implementation_dba_data: APPS.PA_PROJECT_RETENTION_V , 

  • View: PA_PROJECT_RETENTION_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJECT_RETENTION_V,  object_name:PA_PROJECT_RETENTION_V,  status:VALID,  product: PA - Projects ,  description: Stores retention summary balances ,  implementation_dba_data: APPS.PA_PROJECT_RETENTION_V , 

  • View: PA_SUMMARY_PROJECT_RETNS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_SUMMARY_PROJECT_RETNS_V,  object_name:PA_SUMMARY_PROJECT_RETNS_V,  status:VALID,  product: PA - Projects ,  description: Stores retention summary amounts ,  implementation_dba_data: APPS.PA_SUMMARY_PROJECT_RETNS_V , 

  • View: PA_SUMMARY_PROJECT_RETNS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_SUMMARY_PROJECT_RETNS_V,  object_name:PA_SUMMARY_PROJECT_RETNS_V,  status:VALID,  product: PA - Projects ,  description: Stores retention summary amounts ,  implementation_dba_data: APPS.PA_SUMMARY_PROJECT_RETNS_V , 

  • Table: PA_TASKS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TASKS,  object_name:PA_TASKS,  status:VALID,  product: PA - Projects ,  description: User-defined subdivisions of project work ,  implementation_dba_data: PA.PA_TASKS , 

  • Table: PA_TASKS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TASKS,  object_name:PA_TASKS,  status:VALID,  product: PA - Projects ,  description: User-defined subdivisions of project work ,  implementation_dba_data: PA.PA_TASKS , 

  • 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 , 

  • 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 ,