Search Results gmf_transaction_valuation

Overview

GMF_TRANSACTION_VALUATION is a Process Manufacturing Financials (GMF) table that stores transaction valuation records for process organizations in Oracle E-Business Suite 12.1.1 and 12.2.2. It captures the cost valuation of inventory and manufacturing transactions executed within process-enabled organizations, providing the financial representation of material movements, resource consumption, and production events. The table resides in the GMF schema and is classified as VALID in the ETRM repository.

From a heuristic Data Vault modeling perspective, the mined foreign-key structure characterizes this object as a standalone entity. It does not participate in a classic hub-and-satellite topology in the metadata as documented, though its columns (EVENT_ID, TRANSACTION_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID) suggest it could be modeled as a link or transaction-grained satellite in a downstream warehouse. This classification is a modeling suggestion only; the authoritative definition remains the GMF schema table with 46 columns.

Key Information Stored

The table is keyed on the surrogate primary key VALUATION_ID, which is enforced by unique index GMF_TRANSACTION_VALUATION_U1. Business-meaningful columns include:

HEADER_ID / EVENT_ID — Links the valuation record to the originating transaction header and costing event.
LEDGER_ID / LEGAL_ENTITY_ID / LEDGER_CURRENCY — Identifies the accounting ledger, legal entity (FK to FV_LEGAL_ENTITIES), and ledger currency for the valuation.
TRANSACTION_SOURCE_TYPE_ID / TRANSACTION_SOURCE_TYPE — Foreign key to MTL_TXN_SOURCE_TYPES, defining the source of the transaction.
TRANSACTION_ID / DOC_ID / LINE_ID — References the specific transaction, document, and line being valued.
ORG_ID / ORGANIZATION_ID — The inventory organization and operating unit context.
INVENTORY_ITEM_ID / ITEM_NUMBER / LOT_NUMBER / SUBINVENTORY_CODE — Item identity and storage detail.
TXN_BASE_VALUE_RAW / TXN_BASE_VALUE — The raw and final transaction base values used in costing.
VALUATION_COST_TYPE / VALUATION_COST_TYPE_ID / COST_LEVEL — Costing methodology and level applied.
TRANSACTION_DATE / FINAL_POSTING_DATE / ACCOUNTED_FLAG — Timing and posting status of the valuation.
JOURNAL_LINE_TYPE / ENTITY_CODE / EVENT_CLASS_CODE / EVENT_TYPE_CODE — Accounting classification attributes.

Common Use Cases and Queries

Typical reporting scenarios include reconciliation of inventory valuation to the general ledger, cost variance analysis, and tracing transaction valuations to costing events. A representative query pattern:

Join GMF_TRANSACTION_VALUATION to MTL_TXN_SOURCE_TYPES on TRANSACTION_SOURCE_TYPE_ID = TRANSACTION_SOURCE_TYPE_ID to categorize transaction origins.
Join to FV_LEGAL_ENTITIES on LEGAL_ENTITY_ID to attribute valuation to the correct legal entity.
Filter by ORGANIZATION_ID, TRANSACTION_DATE, and ACCOUNTED_FLAG to isolate posted versus unposted valuations.
Aggregate TXN_BASE_VALUE by INVENTORY_ITEM_ID, LOT_NUMBER, or SUBINVENTORY_CODE for inventory balance reporting.

Related Objects

MTL_TXN_SOURCE_TYPES — referenced via TRANSACTION_SOURCE_TYPE_ID.
FV_LEGAL_ENTITIES — referenced via LEGAL_ENTITY_ID.
GMF_COSTING_EVENTS and related GMF costing tables — linked through EVENT_ID.
MTL_MATERIAL_TRANSACTIONS — source of TRANSACTION_ID references.
GL_JE_LINES / GL_IMPORT_REFERENCES — downstream accounting impact of valued transactions.

Table: GMF_TRANSACTION_VALUATION 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GMF_TRANSACTION_VALUATION, object_name:GMF_TRANSACTION_VALUATION, status:VALID, product: GMF - Process Manufacturing Financials , description: Transaction Valuation table for process organizations , implementation_dba_data: GMF.GMF_TRANSACTION_VALUATION ,
Table: GMF_TRANSACTION_VALUATION 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GMF_TRANSACTION_VALUATION, object_name:GMF_TRANSACTION_VALUATION, status:VALID, product: GMF - Process Manufacturing Financials , description: Transaction Valuation table for process organizations , implementation_dba_data: GMF.GMF_TRANSACTION_VALUATION ,
SYNONYM: APPS.GMF_TRANSACTION_VALUATION 12.2.2
owner:APPS, object_type:SYNONYM, object_name:GMF_TRANSACTION_VALUATION, status:VALID,
SYNONYM: APPS.GMF_TRANSACTION_VALUATION 12.1.1
owner:APPS, object_type:SYNONYM, object_name:GMF_TRANSACTION_VALUATION, status:VALID,
VIEW: GMF.GMF_TRANSACTION_VALUATION# 12.2.2
owner:GMF, object_type:VIEW, object_name:GMF_TRANSACTION_VALUATION#, status:VALID,
VIEW: GMF.GMF_TRANSACTION_VALUATION# 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.GMF_XLA_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMF_XLA_PKG, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.OPI_DBI_MTL_VARIANCE_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OPI_DBI_MTL_VARIANCE_PKG, status:VALID,
PACKAGE BODY: APPS.OPI_DBI_INV_VALUE_INCR_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OPI_DBI_INV_VALUE_INCR_PKG, status:VALID,
PACKAGE BODY: APPS.OPI_DBI_INV_CCA_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OPI_DBI_INV_CCA_PKG, status:VALID,
PACKAGE BODY: APPS.OPI_DBI_COGS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OPI_DBI_COGS_PKG, status:VALID,
PACKAGE BODY: APPS.OPI_DBI_RES_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OPI_DBI_RES_PKG, status:VALID,
PACKAGE BODY: APPS.OPI_DBI_JOB_TXN_STG_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OPI_DBI_JOB_TXN_STG_PKG, status:VALID,
APPS.OPI_DBI_COGS_PKG SQL Statements 12.1.1
PACKAGE BODY: APPS.GMF_XLA_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMF_XLA_PKG, status:VALID,
12.1.1 FND Design Data 12.1.1
12.2.2 FND Design Data 12.2.2
TABLE: GMF.GMF_TRANSACTION_VALUATION 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GMF_TRANSACTION_VALUATION, object_name:GMF_TRANSACTION_VALUATION, status:VALID,
TABLE: GMF.GMF_TRANSACTION_VALUATION 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GMF_TRANSACTION_VALUATION, object_name:GMF_TRANSACTION_VALUATION, status:VALID,
PACKAGE BODY: APPS.OPI_DBI_INV_VALUE_INIT_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OPI_DBI_INV_VALUE_INIT_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
APPS.GMF_XLA_PKG SQL Statements 12.1.1
APPS.GMF_XLA_PKG SQL Statements 12.2.2
APPS.OPI_DBI_INV_VALUE_INCR_PKG SQL Statements 12.1.1
PACKAGE BODY: APPS.GMF_XLA_PKG 12.1.1
PACKAGE BODY: APPS.GMF_XLA_PKG 12.2.2
PACKAGE BODY: APPS.OPI_DBI_COGS_PKG 12.1.1
APPS.OPI_DBI_MTL_VARIANCE_PKG SQL Statements 12.1.1
PACKAGE BODY: APPS.OPI_DBI_INV_VALUE_INCR_PKG 12.1.1
APPS.OPI_DBI_MTL_VARIANCE_PKG dependencies on GMF_TRANSACTION_VALUATION 12.1.1
APPS.OPI_DBI_RES_PKG dependencies on GMF_TRANSACTION_VALUATION 12.1.1
APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on GMF_TRANSACTION_VALUATION 12.1.1
APPS.GMF_XLA_PKG dependencies on GMF_TRANSACTION_VALUATION 12.1.1
APPS.OPI_DBI_COGS_PKG dependencies on GMF_TRANSACTION_VALUATION 12.1.1
APPS.OPI_DBI_INV_CCA_PKG dependencies on GMF_TRANSACTION_VALUATION 12.1.1
APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on GMF_TRANSACTION_VALUATION 12.1.1
APPS.OPI_DBI_INV_VALUE_INIT_PKG dependencies on GMF_TRANSACTION_VALUATION 12.1.1
APPS.GMF_XLA_PKG dependencies on GMF_TRANSACTION_VALUATION 12.2.2
APPS.OPI_DBI_RES_PKG SQL Statements 12.1.1
APPS.OPI_DBI_INV_VALUE_INIT_PKG SQL Statements 12.1.1
APPS.OPI_DBI_JOB_TXN_STG_PKG SQL Statements 12.1.1
APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on OPI_DBI_ORG_LE_TEMP 12.1.1
APPS.OPI_DBI_COGS_PKG dependencies on OPI_DBI_ORG_LE_TEMP 12.1.1