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:

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.