Results for “invoice_group_column_id”
28 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The table PA.PA_INV_GRP_COL_WHR_CLAUSES is a Projects (PA) module reference object within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the association between system-defined invoice group WHERE clauses and the invoice group columns to which those clauses apply. In practical terms, this table functions as a bridge that determines which predicate (filter condition) constrains which selectable column when an invoice group is assembled for billing or reporting against Oracle Projects.
From a modeling perspective, the Data Vault classification mined from the foreign key structure is a link table. This classification is a heuristic suggestion rather than a physical declaration: the table's role is to resolve a many-to-many relationship between invoice group columns and invoice group WHERE clauses rather than to carry a standalone business entity. Each row binds one column definition to one WHERE clause definition within the invoice grouping framework.
Key Information Stored
The documented physical schema contains eight columns, of which the identity and audit columns are the most significant:
- INVOICE_GROUP_COLUMN_ID — The foreign key to
PA_INVOICE_GROUP_COLUMNS. It identifies the invoice group column to which a WHERE clause is assigned. This column also composes part of the primary key. - INVOICE_GROUP_WHERE_CLAUSE_ID — The foreign key to
PA_INV_GRP_WHR_CLAUSES. It identifies the system-defined WHERE clause being bound to the column. This column also composes part of the primary key. - ZD_EDITION_NAME — The editioning identifier, present as part of the unique index and reflecting the edition-based redefinition architecture used in 12.2.x.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns that record who created and last modified each association row and when.
The surrogate primary key is PA_INV_GRP_COL_WHR_CLAUSES_PK, defined over (INVOICE_GROUP_COLUMN_ID, INVOICE_GROUP_WHERE_CLAUSE_ID). A separate unique index, PA_INV_GRP_COL_WHR_CLAUSES_U1, is defined over (INVOICE_GROUP_COLUMN_ID, INVOICE_GROUP_WHERE_CLAUSE_ID, ZD_EDITION_NAME), functioning as a business-key candidate that enforces uniqueness per edition.
Common Use Cases and Queries
Typical usage centers on reconstructing the effective filter logic of invoice groups, validating configuration integrity, and generating configuration reports for billing administrators.
- Retrieve all WHERE clauses assigned to a given invoice group column:
SELECT INVOICE_GROUP_WHERE_CLAUSE_ID FROM PA.PA_INV_GRP_COL_WHR_CLAUSES WHERE INVOICE_GROUP_COLUMN_ID = :column_id; - Join to the parent clause definition to display clause text and behavior alongside the column definition.
- Audit configuration drift by comparing creation and update metadata across editions, using ZD_EDITION_NAME to isolate the active edition.
- Reconcile orphaned associations where a referenced column or clause has been removed from its parent table.
Related Objects
The following objects are most significant to this table, based on the documented foreign key and key relationships:
- PA_INVOICE_GROUP_COLUMNS — Referenced via
INVOICE_GROUP_COLUMN_ID; defines the columns available within an invoice group. - PA_INV_GRP_WHR_CLAUSES — Referenced via
INVOICE_GROUP_WHERE_CLAUSE_ID; defines the system WHERE clauses available for assignment. - PA_INV_GRP_COL_WHR_CLAUSES_PK — The composite primary key constraint enforcing row identity.
- PA_INV_GRP_COL_WHR_CLAUSES_U1 — The unique index supporting business-key enforcement per edition.
Because the table sits between column and clause definitions, any reporting or integration that expands invoice group behavior must traverse both parent tables, typically joining on the two foreign key columns documented above.
-
System-defined invoice group WHERE clauses assigned to invoice group columns
-
System-defined tables used to derive invoice group columns
-
System-defined tables used to derive invoice group columns
-
System-defined columns associated with invoice groups
-
System-defined invoice group WHERE clauses assigned to invoice group columns
-
Implementation-defined details of the invoice format configurations
-
Implementation-defined details of the invoice format configurations
-
System-defined columns associated with invoice groups
-
eTRM - PA Tables and Views 12.1.1
-
eTRM - PA Tables and Views 12.2.2
-
eTRM - PA Tables and Views 12.1.1
-
eTRM - PA Tables and Views 12.2.2