Search Results invoice_group_column_id




Overview
Explore in AI Chat

Overview

The PA_INVOICE_GROUP_COLUMNS table is a core system-defined reference table within the Oracle E-Business Suite Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. It serves as a master repository for the columns that are available for use in defining invoice grouping rules. Invoice grouping is a critical functionality that determines how project-related transactions are aggregated and summarized for customer invoicing. This table does not store transactional data; instead, it defines the permissible attributes—such as Project Number, Task, or Expenditure Type—that can be used as criteria to group invoice lines. Its role is to provide a controlled set of column definitions that ensure consistency and validity in the configuration of invoice formats and grouping rules.

Key Information Stored

While the provided ETRM metadata does not list specific column details beyond the primary key, the table's structure is inferred from its purpose and relationships. The central identifier is the INVOICE_GROUP_COLUMN_ID, which is the primary key (PA_INVOICE_GROUP_COLUMNS_PK). This unique ID references each system-defined grouping attribute. Another critical column is INVOICE_GROUP_ID, a foreign key linking the column definition to a specific invoice group header in the PA_INVOICE_GROUPS table. Other columns likely include metadata such as the column name (e.g., PROJECT_ID, TASK_ID), a display sequence, and flags indicating whether the column is enabled or mandatory for grouping purposes. The data in this table is typically seeded by Oracle and is not modified by end-users during normal operations.

Common Use Cases and Queries

This table is primarily referenced during the setup and generation of project invoices. A common administrative use case is auditing the available grouping criteria for a specific invoice group. For instance, a consultant might run a query to list all columns associated with a particular invoice group name to verify setup. A typical SQL pattern joins PA_INVOICE_GROUP_COLUMNS with PA_INVOICE_GROUPS:

  • SELECT ig.NAME, igc.* FROM PA_INVOICE_GROUP_COLUMNS igc, PA_INVOICE_GROUPS ig WHERE igc.INVOICE_GROUP_ID = ig.INVOICE_GROUP_ID ORDER BY ig.NAME, igc.DISPLAY_SEQUENCE;

From a reporting perspective, this table is key to understanding how invoice lines are aggregated. Troubleshooting invoices that are grouping unexpectedly often involves tracing the active grouping rules back to the column definitions stored here.

Related Objects

The PA_INVOICE_GROUP_COLUMNS table is central to the invoice grouping schema, with defined relationships to several other key tables. As per the provided metadata, the foreign key relationships are as follows:

  • References (Parent): PA_INVOICE_GROUPS via the column INVOICE_GROUP_ID. This defines the header for the grouping rule.
  • Referenced By (Child Tables):
    • PA_INVOICE_FORMAT_DETAILS via INVOICE_GROUP_COLUMN_ID. This links the column definition to specific invoice format layouts.
    • PA_INVOICE_GROUP_TABLES via INVOICE_GROUP_COLUMN_ID. This associates the column with the underlying database tables that hold the transactional data.
    • PA_INV_GRP_COL_WHR_CLAUSES via INVOICE_GROUP_COLUMN_ID. This stores additional conditional (WHERE clause) logic that can be applied to the column for refined grouping.

These relationships illustrate that PA_INVOICE_GROUP_COLUMNS acts as a hub, connecting the logical grouping rule (PA_INVOICE_GROUPS) to the implementation details of format, data source, and filtering.