Results for “old_vat_id”
7 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The table IGI.IGI_RPI_LINE_AUDIT_DET_ALL is a transaction and audit table within the Oracle E-Business Suite product family IGI - Public Sector Financials International. It records standing charge line price updates, each of which represents a price update to a specific standing charge line charge item. The table is owned by the IGI schema and holds a status of VALID in the ETRM 12.2.2 documentation set. In practice, the object functions as an audit trail that captures the before-and-after state of a price revision applied to a standing charge line, so that price changes introduced through a batch or request-driven process can be reconstructed and reconciled.
From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. That classification is a modeling suggestion rather than a physical constraint: the table is self-contained, and although it carries a foreign key to IGI_RPI_STANDING_CHARGES_ALL, the ETRM heuristic does not treat it as a link to multiple hubs. A reasonable Data Vault interpretation would treat it as a satellite-like audit entity attached to the standing charge hub, since it stores descriptive and historical change attributes keyed to a parent standing charge line.
Key Information Stored
The documented physical schema contains twenty columns. The most significant of these for functional and reporting purposes include:
- STANDING_CHARGE_ID — identifies the parent standing charge header or line this audit row updates. This is the documented foreign key to IGI_RPI_STANDING_CHARGES_ALL.
- LINE_ITEM_ID and CHARGE_ITEM_NUMBER — identify the specific standing charge line charge item being revised.
- ITEM_ID — the inventory or product item affected by the price update.
- PRICE, EFFECTIVE_DATE, REVISED_PRICE, REVISED_EFFECTIVE_DATE — the primary value pair capturing the prior and new price along with their effective dates.
- PREVIOUS_PRICE and PREVIOUS_EFFECTIVE_DATE — retain the prior values for audit comparison.
- OLD_VAT_ID and NEW_VAT_ID — track changes to the associated VAT/tax identifier alongside the price revision.
- RUN_ID and REQUEST_ID — tie each row to the concurrent program run and request that produced the update.
- ORG_ID — the operating unit under which the update applies, enabling multi-org reporting.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
The metadata does not document a surrogate primary key or unique index for this table; the closest identifier candidates are STANDING_CHARGE_ID combined with LINE_ITEM_ID or REQUEST_ID, which function as business-key candidates in query design.
Common Use Cases and Queries
Typical scenarios include auditing mass price revisions, reconciling price-change batches, and reporting on VAT reclassification of standing charges. A representative query comparing current and revised values is:
SELECT STANDING_CHARGE_ID, LINE_ITEM_ID, PREVIOUS_PRICE, REVISED_PRICE, PREVIOUS_EFFECTIVE_DATE, REVISED_EFFECTIVE_DATE FROM IGI.IGI_RPI_LINE_AUDIT_DET_ALL WHERE REQUEST_ID = :request_id;SELECT * FROM IGI.IGI_RPI_LINE_AUDIT_DET_ALL WHERE ORG_ID = :org_id AND TRUNC(CREATION_DATE) BETWEEN :start_date AND :end_date;SELECT RUN_ID, COUNT(*) FROM IGI.IGI_RPI_LINE_AUDIT_DET_ALL GROUP BY RUN_ID ORDER BY RUN_ID DESC;
Reports that trace a single charge item across revisions should join to the parent standing charge table to obtain descriptive context.
Related Objects
- IGI_RPI_STANDING_CHARGES_ALL — the primary parent object; joined on
IGI_RPI_LINE_AUDIT_DET_ALL.STANDING_CHARGE_ID = IGI_RPI_STANDING_CHARGES_ALL.STANDING_CHARGE_ID. - IGI_RPI_STANDING_CHARGE_LINES — typically holds the line items whose charge values are audited here.
- IGI_RPI_LINE_AUDIT_ALL — companion audit header object at the standing charge level.
- FND_CONCURRENT_REQUESTS — joins on
REQUEST_ID/RUN_IDto identify the concurrent program that generated each update. - FND_CONCURRENT_PROGRAMS — resolves the program definition associated with the run.
- INV_ITEMS / MTL_SYSTEM_ITEMS — resolve the
ITEM_IDto descriptive item attributes. - ZX_TAX_RATES or equivalent tax reference tables — resolve
OLD_VAT_IDandNEW_VAT_IDwhere those values map to tax identifiers.
-
Records standing charge line price updates, each of which represents a price update to a specific standing charge line charge item
-
eTRM - IGI Tables and Views 12.2.2
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.