Search Results get_step_qty

Overview

The APPS.GMF_ROUTING_STEP_CALC package is a discrete process manufacturing calculation utility within Oracle E-Business Suite. It forms part of the Oracle Process Manufacturing (OPM) costing infrastructure, providing the arithmetic that converts recipe and routing definitions into the per-step quantities consumed by cost rollup and variance calculations. Its principal role is to act as a wrapper and caching layer over the procedure GMD_AUTO_STEP_CALC.calc_step_qty, which resides in the GMD schema. The package performs the underlying step quantity computation once, stores the resulting step table in a package-level variable, and then exposes that cached result through a retrieval routine so that multiple downstream consumers can obtain individual step quantities without recomputing the full routing.

As documented in its header comment, the package was introduced to support the cost_calc_rout function of cost rollup and the compute_variances routine of the subledger. This dual-consumption pattern explains the two-procedure design: one procedure computes, the other retrieves.

Key Procedures and Functions

The package exposes two public procedures, as documented in the ETRM metadata and source header:

• CALC_STEP_QTY — A wrapper for GMD_AUTO_STEP_CALC.calc_step_qty. It accepts a recipe identifier, an effective-date/FMEFF identifier, a scale factor, and an optional process loss value (defaulted to 0), returning an error code and error message. The procedure invokes the GMD routine and caches the complete step table output in a package variable for subsequent retrieval. Process loss is forwarded to the ASQC routine, per the documented bug history (Bug 2468924).
• GET_STEP_QTY — Retrieves the individual step's quantity from the cached step table. It is keyed by recipe identifier, step identifier, and step number, returning the step quantity and an error code. It is explicitly documented as being called from cost_calc_rout of cost rollup and compute_variances of the subledger.

Tables Accessed

The documented reference identifies PLITBLM as the only table accessed via APPS synonyms. PLITBLM is the standard OPM routing/step table that holds the computed quantity for each routing step. The package reads this table (or its cached projection) to satisfy step-quantity retrievals. No additional tables are documented in the supplied metadata.

Usage Notes

Invocation follows a two-phase pattern. The caller first executes CALC_STEP_QTY to compute and cache the full step table, then issues one or more GET_STEP_QTY calls to obtain individual step quantities for each routing step of interest. This design is efficient for cost rollup and variance processing, where a single recipe's routing is queried repeatedly.

The package is invoked from cost rollup (cost_calc_rout) and subledger variance computation (compute_variances), both of which are typically driven from concurrent programs. It is classified as an OTHER API, meaning it is not a supported public interface for custom callers; customization that depends on it should account for the fact that the package header carries no shared-pool ship designation. ETRM metadata records that no other packages reference this package, so it exists as a leaf utility called directly by cost and subledger routines rather than by other PL/SQL packages. Error handling is caller-driven: both procedures return an error code and message, and callers must inspect the code before using the returned step quantity. The defaulted process-loss parameter ensures backward compatibility with pre-2003 callers, per Bug 2700453.