Search Results pa_expenditures_all




Overview
Explore in AI Chat

Overview

The PA_EXPENDITURES_ALL table is a core transactional entity within Oracle E-Business Suite's Projects module (PA). It serves as the primary header-level repository for recording and grouping expenditure items. An expenditure, in this context, represents a logical batch or grouping of cost transactions—such as labor hours, expense reports, or supplier invoices—incurred by an employee or an organization for a specific period. Its fundamental role is to act as a parent record, consolidating high-level attributes for a set of related cost details, which are stored in the child table PA_EXPENDITURE_ITEMS_ALL. The table supports multi-organization access control through its ORG_ID column, as indicated by the "_ALL" suffix in its name.

Key Information Stored

The table's primary key is EXPENDITURE_ID, a unique system-generated identifier for each expenditure grouping. Critical columns include EXPENDITURE_GROUP, which links to the PA_EXPENDITURE_GROUPS_ALL table for batch processing control, and INCURRED_BY_ORGANIZATION_ID, which identifies the organizational unit responsible for the cost. For financial processing, the table holds currency information: DENOM_CURRENCY_CODE (transaction currency), ACCT_CURRENCY_CODE (accounting currency), and ACCT_RATE_TYPE for conversion. Other significant attributes track the source (e.g., VENDOR_ID for supplier costs), dates, statuses, and descriptive information about the expenditure batch. The ORG_ID column partitions the data by operating unit.

Common Use Cases and Queries

This table is central to expenditure inquiry, audit, and reconciliation processes. A common use case involves tracing the summary details and status of costs before drilling into item-level details. For reporting, it is frequently joined to its child items and project accounting tables. Sample SQL to list expenditures for a specific organization and period would be:

  • SELECT expenditure_id, expenditure_group, incurred_by_organization_id, denom_currency_code FROM pa_expenditures_all WHERE org_id = &org_id AND expenditure_ending_date BETWEEN &start_date AND &end_date;

Another critical scenario is validating the integrity of expenditure batches during month-end close or before transferring costs to General Ledger, often involving joins to PA_EXPENDITURE_ITEMS_ALL and PA_PROJECTS_ALL.

Related Objects

PA_EXPENDITURES_ALL has integral relationships with numerous other objects. Its primary child table is PA_EXPENDITURE_ITEMS_ALL, which holds the detailed line items for each expenditure header, linked via EXPENDITURE_ID. It references master data tables via foreign keys: PO_VENDORS for suppliers, HR_ALL_ORGANIZATION_UNITS for organizations, FND_CURRENCIES for currency definitions, and GL_DAILY_CONVERSION_TYPES for rate types. It is also referenced by PA_EXPENDITURE_GROUPS_ALL for batch grouping and by PA_ROUTINGS for approval workflows. This network of relationships underscores its position as a pivotal hub in the Projects transactional data model.