Results for “invoice_group_table_name”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_INVOICE_GROUP_TABLES is a system-defined reference table in the Oracle Projects (PA) module. Its documented purpose is to hold the tables that are used to derive invoice group columns. In Oracle EBS 12.1.1 and 12.2.2, this object functions as a metadata dictionary that drives the dynamic construction of invoice group structures used in Project Billing, allowing Oracle Projects to resolve the source table for each invoice grouping attribute without hard-coding it into the application.
Under a heuristic Data Vault classification mined from the foreign-key structure, PA_INVOICE_GROUP_TABLES leans toward a satellite. It is dependent on PA_INVOICE_GROUP_COLUMNS through a foreign key rather than acting as a standalone hub or a transactional link, making it an attribute-bearing descriptor rather than an independent business entity. This classification is a modeling suggestion only; the authoritative definition remains the EBS schema in the APPS/PA environment.
Key Information Stored
The physical schema is documented with nine columns in 12.2.2, owned by the PA schema:
- INVOICE_GROUP_TABLE_NAME — the name of the system table from which an invoice group column is derived; part of the composite primary key.
- INVOICE_GROUP_COLUMN_ID — foreign key to PA_INVOICE_GROUP_COLUMNS; identifies the invoice group column being resolved and is also part of the primary key.
- TEXT — descriptive text associated with the table/column mapping; the third component of the composite primary key.
- LAST_UPDATE_DATE — audit column recording the most recent modification timestamp.
- LAST_UPDATED_BY — the user who performed the last update.
- CREATION_DATE — timestamp of initial row creation.
- CREATED_BY — the user who created the row.
- LAST_UPDATE_LOGIN — login identifier associated with the last update, for audit trail purposes.
- ZD_EDITION_NAME — editioning column supporting Oracle EBS 12.2 online patching and edition-based redefinition.
The surrogate primary key is PA_INVOICE_GROUP_TABLES_PK, defined over the composite of INVOICE_GROUP_TABLE_NAME, INVOICE_GROUP_COLUMN_ID, and TEXT. The only documented foreign-key reference is INVOICE_GROUP_COLUMN_ID to PA_INVOICE_GROUP_COLUMNS, indicating that the table qualifies each invoice group column with the source table and qualifying text.
Common Use Cases and Queries
Typical use cases include generating invoice group layouts in Project Billing, resolving the source table for a given grouping attribute during draft invoice generation, and auditing the configuration of invoice group columns. The following pattern joins the table to its parent column definition:
- SELECT t.INVOICE_GROUP_TABLE_NAME, t.TEXT, c.INVOICE_GROUP_COLUMN_ID FROM PA.PA_INVOICE_GROUP_TABLES t, PA.PA_INVOICE_GROUP_COLUMNS c WHERE t.INVOICE_GROUP_COLUMN_ID = c.INVOICE_GROUP_COLUMN_ID;
- Reporting the tables available for deriving a specific invoice group column by filtering on INVOICE_GROUP_COLUMN_ID.
- Auditing recently changed mappings using LAST_UPDATE_DATE and LAST_UPDATED_BY.
Because the content is system-defined, direct DML should be avoided; configuration changes should go through the supported Project Billing setup or concurrent program that maintains these mappings.
Related Objects
The following objects are most significant to PA_INVOICE_GROUP_TABLES:
- PA_INVOICE_GROUP_COLUMNS — parent table; joined on INVOICE_GROUP_COLUMN_ID, defining each invoice group column.
- PA_INVOICE_GROUPS and PA_INVOICE_GROUP_LINES — invoice group headers and lines that consume the resolved grouping attributes.
- PA_DRAFT_INVOICES_ALL — draft invoice records whose presentation depends on invoice group derivation.
- PA_PROJECTS_ALL — projects providing key grouping attributes used during invoice generation.
- PA_CUSTOMERS / HZ_CUST_ACCOUNTS — customer-level grouping attributes commonly referenced by invoice group definitions.
- Project Billing concurrent programs and the PA invoice group setup forms, which read these mappings at runtime.
Together these objects form the Project Billing invoice grouping framework, with PA_INVOICE_GROUP_TABLES serving as the system-defined source-table dictionary that supports it.
-
System-defined tables used to derive invoice group columns
-
System-defined tables used to derive invoice group columns
-
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