Search Results set_default_lot_for_batch




Overview
Explore in AI Chat

Overview

GME_TRANS_ENGINE_UTIL is a public utility package owned by APPS within the Oracle E-Business Suite Process Manufacturing (GME) schema. It provides the private and public helper routines that support the GME Material and Resource Transaction Load routines, forming part of the transaction engine that translates process manufacturing batch activity into inventory transactions. The package is declared with AUTHID CURRENT_USER, meaning its execution privileges are resolved against the invoking user rather than the package owner, which is significant in the Oracle EBS 12.1.1 and 12.2.2 environments where APPS synonyms act as the interface layer.

The header records the package as originating from Oracle's TVP development group in Reading, England, with an initial version dated February 2001. The primary functional role is to load material and resource transactions associated with a batch header row and to construct the underlying inventory transaction records consumed by the GMI transaction engine. The 2004 revision (BUG#3528006) introduced the SET_DEFAULT_LOT_FOR_NEW_BATCH procedure explicitly as a performance enhancement, reflecting the volume sensitivity of lot defaulting during high-throughput batch processing.

Key Procedures and Functions

  • LOAD_MAT_AND_RSC_TRANS — Loads both material and resource transactions for a given batch. It accepts a batch header row and returns the count of material rows and resource rows processed, along with a return status.
  • BUILD_TRANS_REC — A function that constructs a transaction record from a pending transaction row, returning a BOOLEAN success indicator. It populates the internal transaction engine record structure.
  • LOAD_RSRC_TRANS — Loads resource transactions only for a batch header row, returning the resource row count and a return status. It is the resource-specific counterpart to the combined material and resource loader.
  • SET_DEFAULT_LOT_FOR_BATCH — Assigns default lot information for an existing batch, returning a status indicator.
  • SET_DEFAULT_LOT_FOR_NEW_BATCH — Assigns default lot information for a newly created batch. Added for performance enhancement in 2004.
  • DEDUCE_TRANSACTION_WAREHOUSE — Determines the warehouse code applicable to a transaction based on the pending transaction record, the item master record, and effective warehouse data.
  • GET_DEFAULT_LOT — The routine relevant to the user's search, resolving default lot information used during transaction load. It is one of the seven documented procedures/functions in the 12.2.2 metadata.

Tables Accessed

The package operates against the following tables through APPS synonyms: GME_BATCH_HEADER (the driving batch definition), GME_MATERIAL_DETAILS and GME_RESOURCE_TXNS (source material and resource transaction detail), GME_INVENTORY_TXNS_GTMP and GME_RESOURCE_TXNS_GTMP (global temporary staging tables for transaction load), IC_TRAN_PND (pending inventory transactions), IC_ITEM_MST (item master attributes), IC_WHSE_MST and PS_WHSE_EFF (warehouse master and effective warehouse validation). These tables supply the batch, item, warehouse, and pending transaction data needed to build valid inventory transaction records.

Usage Notes

This package is invoked internally by the GME transaction engine rather than directly by end users. It is referenced by 18 other packages, indicating a broad dependency footprint across the process manufacturing transaction load and validation flow. Typical invocation paths include batch close and transaction processing concurrent programs, process execution forms that trigger transaction generation, and custom extensions that must build or stage inventory transactions from batch data. Because GET_DEFAULT_LOT and the SET_DEFAULT_LOT procedures influence lot assignment, customizations calling them should respect the same item, lot, and warehouse validation rules applied by the standard engine. Direct calls should supply the correct batch header row type and anticipate NOCOPY OUT parameters for row counts and return status.