Search Results gme_eres_utils

Overview

GME_ERES_UTILS is a utility package owned by the APPS schema in Oracle E-Business Suite, classified under the OTHER API category within the ETRM repository. Its documented purpose, drawn from the package header commentary, is to hold the collection of routines that support ERES output during XML mapping as consumed by the gateway product. ERES, the Electronic Records and Electronic Signatures subsystem, is the 21 CFR Part 11 compliance layer used to capture attributable, tamper-evident electronic signatures on regulated manufacturing transactions. In the process manufacturing (OPM/GME) footprint, batch and material records must be exported to downstream gateway consumers as structured XML, and the values that populate that XML often require resolution rather than direct column reads.

The package therefore functions as a thin, read-only resolution layer between stored manufacturing identifiers and the human-readable or decision-bearing attributes required by the mapping layer. It does not create, update, or delete business data; it exposes lookups that convert surrogate keys into descriptive values suitable for presentation in the ERES output stream.

Key Procedures and Functions

• GET_BATCH_NUMBER — Accepts a batch identifier and returns the corresponding batch number as an output parameter. This procedure allows the XML mapping layer to translate the internal batch key held on material and batch records into the externally meaningful batch number expected by the gateway consumer, without requiring the caller to join directly against the batch master.
• GET_PHANTOM_OR_NOT — Accepts a batch identifier and returns an output value indicating whether the batch is a phantom batch. Phantom batches represent intermediate or non-stocked process steps that are not physically produced or inventoried. The XML mapping layer uses this indicator to determine whether a given batch should be rendered, flagged, or suppressed in the ERES output.

Only these two procedures are documented in the ETRM metadata for this package. Both follow a consistent signature convention in which the input is a batch identifier and the result is returned through a NOCOPY output parameter, reflecting the package's role as a passive value provider rather than a business process driver.

Tables Accessed

The package accesses the GME_MATERIAL_DETAILS table through an APPS synonym. GME_MATERIAL_DETAILS stores the material detail lines associated with process manufacturing batches, including batch and material identifiers at the detail level. It is the documented source from which the batch identifier passed into these procedures is resolved and from which the phantom status attribute is derived. Because both procedures take a batch identifier as input and return descriptive attributes, the reads are expected to be keyed lookups against this table rather than set-based queries. No other base tables are documented as referenced.

Usage Notes

GME_ERES_UTILS is an internal support package. ETRM records no other packages referencing it, which indicates it is invoked directly by the ERES XML mapping and gateway components rather than by the broader OPM API stack. It is not exposed through a concurrent program or a standard Oracle Forms interface in its own right.

Typical invocation occurs when the ERES output generation process assembles the XML payload for batch-related regulated transactions and must enrich each record with the batch number and phantom indicator. Custom extensions that emit ERES-compatible XML for process manufacturing transactions may call these procedures under the same pattern, passing the batch identifier carried on the source record.

Because the package performs read-only lookups, callers should treat the returned values as point-in-time snapshots. No commit or rollback handling is required. Any caller relying on the output should account for the possibility of a null return when the supplied batch identifier does not resolve to a row in GME_MATERIAL_DETAILS, and should validate the identifier before use.