Search Results mst_audit_rep_excp




Overview
Explore in AI Chat

Overview

MST_AUDIT_REP_EXCP is an Oracle EBS Applications (APPS) PL/SQL package belonging to the Oracle Transportation Management / E-Business Suite Logistics family, specifically associated with the MST (transportation) schema objects. It is classified as an OTHER API, meaning it is not a public, supported open interface but rather an internal utility package that supports the ETRM Audit Report and exception-detection functionality. The package is declared with AUTHID CURRENT_USER, so it executes with the privileges of the calling session rather than the definer, a characteristic typical of internal report-support code. Version metadata ($Header: MSTEARES.pls 115.10 2004/05/05) indicates the source was last updated in 2004 and is flagged "noship," confirming it is an internal, non-shipped component.

Functionally, the package evaluates transportation plans and snapshots for data-quality and business-rule violations, producing the set of exceptions surfaced in the Audit Report. It also provides shared UOM conversion and transit-time utilities used by that audit logic.

Key Procedures and Functions

The package exposes 19 documented procedures and functions. The exception-detection procedures each accept a plan identifier and user identifier and populate the MST exception tables with identified anomalies:

  • MissingLatLongCoordExcptn — flags plan locations lacking latitude/longitude coordinates.
  • MissingDistanceDataExcptn — flags lanes or legs with no distance data.
  • DL_with_zero_values — detects delivery legs with zero-valued attributes.
  • DimensionViolForPieceExcptn — reports dimensional violations for piece-level freight.
  • WgtVolViolForPieceExcptn, WgtVolViolForDLExcptn, and WgtVolViolForFirmDelivExcptn — report weight/volume violations for piece, delivery-leg, and firm-delivery contexts respectively.
  • InsufficientIntransitTimeExptn — flags shipments whose in-transit time is below the required minimum.
  • PastDueOrdersExptn — identifies past-due order lines.
  • FacCalViolForPickUpExptn and FacCalViolForDeliveryExptn — report facility-calendar violations for pickup and delivery.

Supporting utilities include runAuditReport, the driver that orchestrates the audit and returns status via errbuf and retcode; getExceptionThreshold, which retrieves the configured tolerance for a given exception type; initializeGlobalVariables, which seeds package-level state from the plan and user; and debug_output, a diagnostic trace helper. Conversion facilities include testConv, GET_UOM_CONVERSION_RATES (returning whether a conversion exists and its rate), and CONV_TO_UOM, which converts a value between units of measure with an optional inventory item context. GET_MINIMUM_TRANSIT_TIME returns the minimum allowable transit time between two locations for a plan.

Tables Accessed

The package reads and writes transportation reference and transactional data through APPS synonyms. Exception output is written to MST_EXCEPTIONS, MST_EXCEPTIONS_S, MST_EXCEPTION_DETAILS, and MST_EXCEPTION_DETAILS_S. Preferences and tolerances are read from MST_EXCEP_PREFERENCES and MST_PARAMETERS. Plan and shipment data are read from MST_DELIVERIES, MST_DELIVERY_ASSIGNMENTS, and MST_DELIVERY_DETAILS. Distance and calendar logic relies on FTE_LOCATION_MILEAGES, FTE_LOCATION_PARAMETERS, FTE_VEHICLE_TYPES, BOM_CALENDAR_DATES, BOM_SHIFT_DATES, and BOM_SHIFT_TIMES.

Usage Notes

MST_AUDIT_REP_EXCP is typically invoked from the ETRM Audit Report concurrent program or associated forms, which call runAuditReport to execute the suite of exception checks and populate the MST exception tables for review. Because it carries AUTHID CURRENT_USER and an internal "noship" designation, it is not a supported public API for external integration; custom code that requires UOM conversion or minimum transit-time calculation should generally use the corresponding public conversion APIs rather than this package. Users searching for get_uom_conversion_rates are most likely tracing how ETRM resolves UOM conversions within audit reporting; the procedure returns a boolean indicating whether a conversion was found together with the numeric rate. The package is referenced by no other packages, confirming its role as a terminal reporting utility rather than a shared library dependency.