Results for “grade_update_id”
42 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_GRADE_STATUS_ERES_GTMP is an Inventory (INV) schema table in Oracle E-Business Suite 12.1.1 and 12.2.2. The suffix "GTMP" follows Oracle's longstanding convention for a global temporary table, and the "ERES" segment reflects the e-records and electronic signature framework used by Oracle Quality and Inventory for regulated or auditable status transitions. In the context of EBS, this object functions as a transient staging area that holds pending material grade and status update identifiers during a status-change transaction before that transaction is committed to the permanent status history tables.
The documented physical schema for ETRM 12.2.2 shows the object owned by INV with only two columns: STATUS_UPDATE_ID and GRADE_UPDATE_ID. The heuristic Data Vault classification mined from the foreign-key structure is standalone. In Data Vault modeling terms, this suggests the object is best treated as neither a durable hub nor a full satellite, but rather as a session-scoped staging or link construct that carries the two business identifiers required to reconcile a grade change with a material status change. Because the table is temporary, its contents are private to the session that populates it and are purged at transaction or session end.
Key Information Stored
The documented column list is deliberately narrow, consistent with a temporary workspace whose purpose is to correlate two identifiers rather than to store descriptive attributes.
- STATUS_UPDATE_ID — The identifier of the material status update being processed. The documented foreign key maps this column to MTL_MATERIAL_STATUS_HISTORY, indicating that the value ultimately resolves to a row in the permanent status history table. This is the principal business-key candidate and the column most likely to appear in join predicates.
- GRADE_UPDATE_ID — The identifier of the associated grade update. This column ties the row to the grade-change side of the transaction, allowing the e-records signature process to capture both the status and grade components of a single user action.
No surrogate primary key or unique index is documented beyond the two columns, which is expected for a global temporary table used as an intra-session work area. Applications should not rely on row ordering or on the persistence of rows across sessions.
Common Use Cases and Queries
The primary use case is diagnostic and audit-related. Because the table is transient, direct reporting against it is uncommon; however, DBAs and developers may query it during debugging to confirm that grade and status identifiers are being staged correctly prior to commit.
- Reconciliation debugging: correlate staged rows with committed history using
SELECT t.STATUS_UPDATE_ID, t.GRADE_UPDATE_ID FROM MTL_GRADE_STATUS_ERES_GTMP tand then joining STATUS_UPDATE_ID to MTL_MATERIAL_STATUS_HISTORY to verify that each staged status update was written. - E-records signature evidence: confirm which grade/status pair was presented for electronic signature during a regulated inventory transaction.
- Orphan analysis: identify staged identifiers with no matching history row, which can indicate a rolled-back or failed status update.
Queries should be executed within the originating session, since temporary-table visibility is session-scoped.
Related Objects
- MTL_MATERIAL_STATUS_HISTORY — the documented foreign-key target for STATUS_UPDATE_ID and the permanent audit trail of material status changes.
- MTL_MATERIAL_STATUSES — defines the valid material status codes referenced by the history records.
- MTL_ITEM_GRADES / MTL_GRADES — grade definitions associated with GRADE_UPDATE_ID.
- MTL_SYSTEM_ITEMS_B — item master rows whose grade and status attributes are affected by the transaction.
- MTL_MATERIAL_TRANSACTIONS — inventory transaction records that frequently accompany a status or grade change.
- INV_MATERIAL_STATUS_PUB / INV_ITEM_GRADE_PUB — public APIs that initiate grade and status updates and that indirectly drive population of this temporary table.
-
New Table, stores the grade update history lot grade updates.
-
New Table, stores the grade update history lot grade updates.
-
View: MTL_GRADE_CHANGE_ERV 12.1.1
APPS.MTL_GRADE_CHANGE_ERV·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_LOT_GRADE_HISTORY·↳ MTL_PARAMETERS·Explore INV module →
-
View: MTL_GRADE_CHANGE_ERV 12.2.2
APPS.MTL_GRADE_CHANGE_ERV·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_LOT_GRADE_HISTORY·↳ MTL_PARAMETERS·Explore INV module →
-
PACKAGE: APPS.INV_GRADE_PKG 12.2.2
-
PACKAGE: APPS.INV_GRADE_PKG 12.1.1
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2