Search Results pa_invoice_group_tables




Overview
Explore in AI Chat

Overview

The PA_INVOICE_GROUP_TABLES table is a system-defined reference table within the Oracle E-Business Suite Projects (PA) module. Its primary role is to support the invoice grouping functionality, a core feature for generating consolidated customer invoices from multiple project transactions. The table acts as a metadata repository, defining the specific application tables that serve as data sources for deriving the values of invoice group columns. These columns are used to logically organize and aggregate revenue, cost, and other billable items into discrete invoice lines or headers, ensuring accurate and efficient billing. The table's configuration is integral to the setup of the Oracle Projects invoicing engine in both releases 12.1.1 and 12.2.2.

Key Information Stored

The table stores a mapping between invoice grouping logic and the underlying transactional tables. Each record identifies a source table and a specific column within it that contributes to an invoice group's definition. The primary columns, which collectively form the table's unique constraint (PA_INVOICE_GROUP_TABLES_PK), are INVOICE_GROUP_TABLE_NAME, INVOICE_GROUP_COLUMN_ID, and TEXT. The INVOICE_GROUP_TABLE_NAME holds the name of the application table (e.g., PA_EXPENDITURE_ITEMS_ALL) containing the source data. The INVOICE_GROUP_COLUMN_ID is a foreign key that links to the PA_INVOICE_GROUP_COLUMNS table, identifying the specific grouping attribute. The TEXT column likely stores a literal value or a code used as a filter or default within the grouping context for that specific table-column combination.

Common Use Cases and Queries

This table is primarily referenced during the invoice generation process. The invoicing engine queries PA_INVOICE_GROUP_TABLES to determine which transactional tables to scan and which columns to evaluate when building invoice groups according to the customer's invoicing rules. A common administrative use case is auditing or verifying the setup of invoice grouping sources. For example, a consultant might run a query to list all source tables defined for a particular invoice group column to troubleshoot missing data in invoices. A sample diagnostic SQL pattern would join this table with its parent column definition table:

  • SELECT igt.invoice_group_table_name, igc.column_name, igt.text
  • FROM pa_invoice_group_tables igt,
  • pa_invoice_group_columns igc
  • WHERE igt.invoice_group_column_id = igc.invoice_group_column_id
  • ORDER BY igc.column_name, igt.invoice_group_table_name;

Related Objects

The PA_INVOICE_GROUP_TABLES table maintains a direct foreign key relationship with the PA_INVOICE_GROUP_COLUMNS table, which defines the available attributes for grouping (e.g., Project, Task, Expenditure Type). The relationship is enforced through the column PA_INVOICE_GROUP_TABLES.INVOICE_GROUP_COLUMN_ID, which references PA_INVOICE_GROUP_COLUMNS. This structure creates a hierarchy: group columns are defined in PA_INVOICE_GROUP_COLUMNS, and then specific source tables for each column are enumerated in PA_INVOICE_GROUP_TABLES. This table is a foundational component for the invoicing workflow and is referenced by various internal APIs and programs within the Oracle Projects invoicing subsystem.