Search Results pa_agreement_types




Overview
Explore in AI Chat

Overview

The PA_AGREEMENT_TYPES table is a core reference table within the Oracle E-Business Suite Projects module (PA). It serves as a master repository for implementation-defined classifications used to categorize customer agreements. These classifications are critical for organizing and managing the contractual framework under which projects are executed. The table's role is to provide a controlled, validated list of agreement type codes that can be consistently applied across the system, ensuring data integrity and standardization in project setup, billing, and revenue recognition processes.

Key Information Stored

The primary data stored in this table is the agreement type classification itself. While the full column list is not detailed in the provided metadata, the structure is defined by its primary and foreign key relationships. The central column is AGREEMENT_TYPE, which serves as the primary key. This column holds the unique, user-defined code that identifies each agreement classification (e.g., 'FIXED_PRICE', 'TIME_MATERIALS', 'RETAINER'). The table also contains a column named TERM_ID, which establishes a foreign key relationship to the Receivables module (RA_TERMS_B), linking an agreement type to specific payment terms. Other typical columns in such reference tables would include descriptive fields like NAME or DESCRIPTION, enabled flags, and creation/update audit columns.

Common Use Cases and Queries

The primary use case is to validate and report on the types of agreements governing projects. It is essential during the creation of a project agreement in the PA_AGREEMENTS_ALL table, where the AGREEMENT_TYPE value must exist in PA_AGREEMENT_TYPES. Common reporting requirements include listing all configured agreement types and their associated payment terms, or analyzing the distribution of projects by agreement type. A typical query would join to the main agreements table:

  • Listing Active Agreement Types: SELECT agreement_type, name FROM pa_agreement_types WHERE enabled_flag = 'Y' ORDER BY 1;
  • Joining to Project Agreements: SELECT pat.agreement_type, pat.name, paa.agreement_num FROM pa_agreement_types pat, pa_agreements_all paa WHERE pat.agreement_type = paa.agreement_type;

Related Objects

PA_AGREEMENT_TYPES is centrally linked to other key objects in the Projects and Receivables modules, as documented by its foreign key constraints.

  • PA_AGREEMENTS_ALL: This is the primary transactional table. Each record in PA_AGREEMENTS_ALL references an agreement type via its AGREEMENT_TYPE column, which is a foreign key to PA_AGREEMENT_TYPES.AGREEMENT_TYPE.
  • RA_TERMS_B: A table from Oracle Receivables (AR). The PA_AGREEMENT_TYPES.TERM_ID column is a foreign key to RA_TERMS_B.TERM_ID, linking the agreement classification to standard invoicing payment terms.