Search Results pa_expenditure_types

Overview

The PA_EXPENDITURE_TYPES table is a core master data table within the Oracle E-Business Suite Projects (PA) module. It stores implementation-defined classifications for all expenditures charged to projects and tasks, serving as a critical control point for financial and operational tracking. Each expenditure type represents a distinct category of cost, such as labor, travel, or materials, and is fundamental to the processing of project transactions. Its role extends beyond the Projects module, as it is referenced by key transactional tables in Payables (AP), Grants Accounting (GMS), and other integrated products, ensuring consistent expenditure classification across the enterprise.

Key Information Stored

The table's primary key is the EXPENDITURE_TYPE column, which holds the unique, user-defined code for the cost classification. Other critical columns include EXPENDITURE_CATEGORY, which links to the PA_EXPENDITURE_CATEGORIES table for higher-level grouping (e.g., Labor, Supplies), and SYSTEM_LINKAGE_FUNCTION, which links to PA_SYSTEM_LINKAGES to define how this expenditure type integrates with external systems like Payables or Payroll. While the full column list is not detailed in the provided metadata, typical attributes include a description, unit of measure, revenue category, and various flags controlling costing, billing, and capitalizable status.

Common Use Cases and Queries

This table is central to reporting, validation, and setup. Common use cases include validating expenditure types on imported transactions, defining allocation rules, and generating cost distribution reports. A fundamental query retrieves all active expenditure types within a specific category for a lookup list:

• SELECT expenditure_type, name FROM pa_expenditure_types WHERE expenditure_category = 'LABOR' AND sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate);

Another critical pattern involves joining to transactional tables like PA_EXPENDITURES to analyze costs. For troubleshooting integration issues, a query joining PA_EXPENDITURE_TYPES to PA_SYSTEM_LINKAGES via SYSTEM_LINKAGE_FUNCTION is essential to verify the setup for automated transaction processing.

Related Objects

As indicated by the extensive foreign key relationships, PA_EXPENDITURE_TYPES is a heavily referenced parent table. Key dependent objects include:

• PA_EXPENDITURE_CATEGORIES: Parent table for the EXPENDITURE_CATEGORY column.
• PA_SYSTEM_LINKAGES: Parent table for the SYSTEM_LINKAGE_FUNCTION column.
• Transactional Tables: AP_INVOICE_DISTRIBUTIONS_ALL, AP_EXPENSE_REPORT_LINES_ALL, PA_BC_PACKETS, and PA_EXPENDITURES_ALL (implied) store the EXPENDITURE_TYPE as a foreign key.
• Control Tables: PA_ALLOC_RULES_ALL references it for both target and offset expenditure types, and PA_BILL_RATES_ALL uses it to define billing rates.
• Other Modules: Tables in GMS (GMS_AWARD_EXP_TYPE_ACT_COST), IGC, IGW, and PSP also reference it, highlighting its cross-module importance.