Results for “insert_ser_trx”
46 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
EAM_ENTER_LOT_SERIAL is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the EAM (Enterprise Asset Management) module. It is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user rather than the package owner, a common pattern for APIs that must respect the caller's security context and organization-level access. The header comment indicates the source file EAMPELSS.pls (version 115.1, dated 2003/06/25), reflecting an early EAM eTechnical Reference Manual lineage that remains valid through EBS 12.1.1 and 12.2.2.
The package's business purpose is to support the capture of lot and serial number information during asset-related material transactions. In EAM, maintenance work orders frequently consume or return serialized and lot-controlled inventory items. This package provides the programmatic entry points that stage that lot/serial data into temporary structures and then persist the serialized transaction records. It effectively bridges the gap between the temporary staging of lot/serial input collected from a user interface or feeder process and the authoritative serial transaction tables.
Key Procedures and Functions
- INSERT_SER_TRX — Inserts a serial transaction record. Based on the documented signature, it accepts a transaction temporary identifier, a serial transaction temporary identifier, a transaction header identifier, the user identifier, a "from" serial number, a "to" serial number, an item identifier, and an organization identifier, returning an error code and error message as OUT parameters. The from/to serial number pair indicates the procedure supports both single serial numbers and serial number ranges, which is typical for high-volume asset transactions. The OUT error code and message parameters follow the standard EBS API error-handling convention, allowing callers to detect and report failures without raising exceptions.
- CREATE_SERIAL_TEMP_ID — Creates a temporary serial identifier associated with a given transaction temporary identifier and lot number. This procedure generates the staging key used later by INSERT_SER_TRX, enabling the caller to associate a batch of serialized entries with a specific lot within a transaction before the permanent serial records are written.
No public functions are documented; the package exposes two procedures. Parameter lists are not reproduced here beyond what the metadata documents, and callers should obtain exact signatures from the ETRM or the package specification in the database.
Tables Accessed
- MTL_MATERIAL_TRANSACTIONS_S — The serial transaction table in Oracle Inventory. INSERT_SER_TRX writes serialized transaction detail here, linking each serial number to its parent material transaction and header. This is the authoritative record for serial-tracked movements.
- MTL_TRANSACTION_LOTS_TEMP — The temporary lot transaction table. CREATE_SERIAL_TEMP_ID and the staging logic use this table to hold lot/serial entries before they are validated and committed to the permanent transaction tables.
Both tables are referenced through APPS synonyms, consistent with standard EBS API design where the APPS layer owns the synonyms and grants.
Usage Notes
EAM_ENTER_LOT_SERIAL is typically invoked from EAM maintenance transaction forms or from Oracle Inventory transaction entry screens where lot and serial control applies. It may also be called by concurrent programs that bulk-load serialized asset movements, or by custom PL/SQL extensions performing work order material issues and returns. Because it is an OTHER-classified API rather than a formally certified public interface, Oracle does not guarantee its signature across releases; implementers should validate behavior in each target environment (12.1.1 versus 12.2.2) and avoid direct dependencies where a supported public API exists. The package is referenced by zero other packages per the ETRM metadata, indicating it is an entry-point module rather than a shared utility. The absence of any relationship to "EaseUS activation key crack" confirms the search term is unrelated to this database object; the object belongs exclusively to Oracle EBS Enterprise Asset Management.