Results for “column_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_INVOICE_GROUP_COLUMNS is a Projects (PA) module table that stores the system-defined columns associated with invoice groups. In Oracle EBS 12.1.1 and 12.2.2, invoice groups provide the logical grouping mechanism used by the Project Billing and Project Invoicing features to determine how billing detail lines are aggregated, formatted, and presented on customer-facing invoices and intercompany invoices. Each row in this table defines a single column that participates in an invoice group's layout, including its formatting behavior, selection logic, and grouping attributes.

From a Data Vault modeling perspective, the heuristic classification of this object is hub-leaning. The primary key INVOICE_GROUP_COLUMN_ID functions as a durable business key surrogate, while descriptive attributes such as SELECT_TEXT, GROUP_BY_TEXT, and the various flag columns behave as satellite-type payload. Modelers should treat the surrogate identifier as the hub key and the mutable descriptive columns as satellite attributes when designing downstream integration or warehouse structures.

Key Information Stored

• INVOICE_GROUP_COLUMN_ID — Surrogate primary key (PA_INVOICE_GROUP_COLUMNS_PK) uniquely identifying each column definition.
• INVOICE_GROUP_ID — Foreign key to PA_INVOICE_GROUPS, tying the column to its parent invoice group.
• NAME — Business-facing name of the column; combined with INVOICE_GROUP_ID and ZD_EDITION_NAME it forms unique index U2.
• COLUMN_CODE — Internal code identifying the underlying project billing attribute the column represents.
• SELECT_TEXT — SQL selection expression used to populate the column when the invoice group is processed.
• GROUP_BY_TEXT — SQL grouping clause applied to aggregate detail lines for this column.
• DEFAULT_RIGHT_JUSTIFY_FLAG — Indicates whether numeric or amount values default to right justification in the invoice layout.
• INTERCOMPANY_INVOICE_FLAG — Controls whether the column is available on intercompany invoices.
• CUSTOMER_INVOICE_FLAG — Controls whether the column is available on customer invoices.
• ZD_EDITION_NAME — Editioning column supporting Oracle EBS 12.2 online patching and edition-based redefinition.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide standard EBS WHO column tracking.

The surrogate key (INVOICE_GROUP_COLUMN_ID) is distinct from the documented business-key candidates captured by unique indexes U1 and U2, both of which include ZD_EDITION_NAME to preserve uniqueness across editions.

Common Use Cases and Queries

The most frequent scenario is reviewing which columns belong to a given invoice group and how each is configured for customer versus intercompany output.

• Listing columns for an invoice group:
  SELECT name, column_code, customer_invoice_flag, intercompany_invoice_flag FROM pa_invoice_group_columns WHERE invoice_group_id = :group_id;
• Identifying columns available for customer invoices by joining to PA_INVOICE_GROUPS to resolve group names for reporting.
• Auditing SELECT_TEXT and GROUP_BY_TEXT to troubleshoot invoice aggregation discrepancies, since these expressions drive how billing lines roll up.
• Analyzing formatting behavior through DEFAULT_RIGHT_JUSTIFY_FLAG when diagnosing invoice layout issues.
• BI reporting on invoice group configurations, filtering by edition via ZD_EDITION_NAME in a 12.2 multi-edition environment.

Related Objects

• PA_INVOICE_GROUPS — Parent table; joined via PA_INVOICE_GROUP_COLUMNS.INVOICE_GROUP_ID.
• PA_INVOICE_GROUP_TABLES — References this table by INVOICE_GROUP_COLUMN_ID; defines source tables for columns.
• PA_INVOICE_FORMAT_DETAILS — References INVOICE_GROUP_COLUMN_ID; governs invoice presentation formatting.
• PA_INV_GRP_COL_WHR_CLAUSES — References INVOICE_GROUP_COLUMN_ID; stores WHERE clause fragments applied to column selection.
• PA_INVOICE_GROUP_COLUMNS_PK / _U1 / _U2 — Primary and unique indexes enforcing identity and business-key uniqueness.

Together these objects form the configuration backbone for Project Billing invoice generation in Oracle EBS.