Search Results process_transactions

Overview

MTH_PROCESS_TXN_PKG is a public PL/SQL package in the APPS schema that supports the Oracle E-Business Suite Enterprise Asset Management (EAM) / Enterprise Telecommunications Resource Management (ETRM) domain. Its central responsibility is the processing of equipment transaction data — specifically time-zone-aware equipment activity records and equipment status records staged from external or internal sources — and the reconciliation of that data into the ETRM fact structures. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the defining user, and it exposes two named exceptions, RAISE_ERROR and VALIDATION_ERR, indicating that validation failures and processing errors are surfaced to the caller rather than silently handled.

The header of the package body identifies the implementation file as MTHPTXNS.PLS (version 120.1.12020000.1, dated 2012), confirming that this is a shipped EBS artifact rather than a customer extension. It is referenced by two other packages and is classified as an "OTHER" API, meaning it is not a formally published open interface but is nonetheless callable from the EBS execution layer.

Key Procedures and Functions

The package exposes a single documented program unit, PROCESS_TRANSACTIONS. It is a public procedure whose purpose is to drive the ingestion, incremental update, or recalculation of equipment transaction data.

• PROCESS_TRANSACTIONS — The main entry point for transaction processing. Its signature defines an OUT error buffer and OUT return code for standard concurrent-program style error reporting, a processing mode parameter that distinguishes INIT, INCR, and RECAL (initial load, incremental load, and recalculation), a source parameter that identifies the originating data stream (TAG, CSVS, CSVO, CSVSO), time-zone range parameters used for TAG-sourced data, and optional plant, equipment, and recalculation date parameters that scope a recalculation run to a specific plant, equipment item, and date range.

No other procedures or functions are documented for this package.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• MTH_EQUIP_OUTPUT_STG — Staging table for equipment output transactions; the primary inbound data set for processing.
• MTH_EQUIP_STATUSES_STG — Staging table for equipment status records; processed alongside output transactions.
• MTH_EQUIPMENTS_D — Equipment master/denormalized table used to resolve and validate the equipment referenced by incoming transactions.
• MTH_PLANTS_D — Plant master table used to resolve plant context and support plant-scoped recalculation.
• MTH_RUN_LOG — Run log table used to record execution metadata, request identifiers, and processing outcomes for each invocation.

Usage Notes

Because PROCESS_TRANSACTIONS uses the OUT error buffer and return code convention, it is most commonly invoked from a concurrent program or from a host PL/SQL wrapper that passes the standard retcode/errbuf pair. Typical invocations include:

• Scheduled incremental loads (mode INCR) that pick up newly staged equipment output and status rows from MTH_EQUIP_OUTPUT_STG and MTH_EQUIP_STATUSES_STG.
• One-time or corrective full loads (mode INIT) after staging tables have been populated from an upstream source.
• Targeted recalculations (mode RECAL) scoped by plant, equipment, or date range when historical results must be regenerated.
• Source-specific runs (TAG, CSVS, CSVO, CSVSO), where TAG-sourced runs additionally supply from/to time-zone parameters.

Custom code should treat this package as an EBS-internal API and avoid direct modification. Callers should always inspect the return code and error buffer, since validation and processing failures are reported through the declared exceptions and the OUT parameters rather than by raising unhandled errors.