Search Results gmd_spread_errors_gtmp

Overview

GMD_SPREAD_ERRORS_GTMP is a global temporary table (GTMP) in the GMD schema, belonging to the Process Manufacturing Product Development module of Oracle E-Business Suite. In both release 12.1.1 and 12.2.2 the object is documented as VALID with a physical schema of fourteen columns. Its name indicates its function: it is a transient staging area used by the Process Manufacturing product development routines to capture errors encountered while "spreading" technical parameter or specification values across items, lots, or expression-driven records.

Unlike permanent GMD entities such as recipes, formulas, or technical parameters, a GTMP holds session-scoped rows only for the duration of the calling process. Rows are populated by the spread/conversion program when a value cannot be resolved, an expression fails, or a referenced item, lot, or technical parameter is invalid. The table therefore acts as a diagnostic buffer that the concurrent program or PL/SQL API reads back to present a summary of rejected rows to the user, rather than persisting invalid data in the transactional specification tables.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone, meaning it is not treated as a hub, link, or satellite. This is consistent with its role as a temporary error log rather than a durable business entity. Where the table is retained for analysis, it is best modeled as a transient staging or error satellite whose grain is one failed spread attempt.

Key Information Stored

The fourteen documented columns describe the failed row and the reason for failure. The most significant are:

• ENTITY_ID — identifier of the parent business entity (for example, the specification or technical parameter record) that was being processed.
• LINE_ID and LINE_TYPE — identify the individual line within that entity and its type, allowing the error to be tied back to a specific row of the source structure.
• ITEM_ID, ITEM_NO, and INVENTORY_ITEM_ID — the item involved, presented both by internal identifier and by user-facing number and inventory key.
• LOT_ID, LOT_NO, and LOT_NUMBER — the lot against which the spread was attempted, with alternate lot identifiers.
• TECH_PARM_ID and TECH_PARM_NAME — the technical parameter being spread, the primary foreign key relationship documented for this table.
• ERROR_MESSAGE — the human-readable failure text presented to the user.
• EXPRESSION_TYPE — the category of expression that was evaluated when the error occurred.
• CONCATENATED_SEGMENTS — the concatenated flexfield representation of the item or account involved, useful for report output.

The metadata documents no surrogate primary key for this table, which is expected for a temporary error buffer; neither are unique business-key indexes documented. TECH_PARM_ID is the sole documented foreign key, referencing GMD_TECH_PARAMETERS_B.

Common Use Cases and Queries

The primary use case is diagnosing and reporting failures from the technical parameter spread process. A typical reporting query lists failures for a batch run:

• SELECT item_no, lot_no, tech_parm_name, error_message FROM gmd_spread_errors_gtmp ORDER BY item_no, lot_no;
• Joining to the technical parameter base table to enrich the message: SELECT e.item_no, e.error_message, t.tech_parm_name FROM gmd_spread_errors_gtmp e, gmd_tech_parameters_b t WHERE e.tech_parm_id = t.tech_parameter_id;
• Grouping errors by cause to identify systemic issues: SELECT expression_type, COUNT(*) FROM gmd_spread_errors_gtmp GROUP BY expression_type;

Because the table is temporary, queries are only meaningful within the originating session or immediately after the concurrent program completes before the rows are cleared. Administrators should treat any retained content as run-specific evidence.

Related Objects

The following objects are the most significant dependencies and companions:

• GMD_TECH_PARAMETERS_B — referenced through TECH_PARM_ID; the technical parameter definition against which the spread was attempted.
• GMD_SPEC_TMPLT_HEADERS_B / GMD_SPEC_TMPLT_VRS_B — specification template entities commonly processed by the spread routine.
• GMD_SPEC_VRS_VL — specification version view used to resolve item and specification context for error reporting.
• MTL_SYSTEM_ITEMS_B — source of ITEM_NO, INVENTORY_ITEM_ID, and CONCATENATED_SEGMENTS values.
• GMD_LOTS / LOT_NUMBER sources — used to validate LOT_ID and LOT_NO entries.
• FND_MESSAGES — provides the message text convention reflected in ERROR_MESSAGE.

These relationships confirm the table's narrow purpose: it exists solely to capture and surface failures from the technical parameter spread process within the Process Manufacturing Product Development module.