Search Results mass_replace_operation

Overview

GMD_CONC_REPLACE_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and classified as an "OTHER" API within the ETRM repository. It belongs to the Process Manufacturing (GMD) product family and supports the bulk substitution of components and resources across process manufacturing definitions. In release 12.1.1 and 12.2.2, this package is the engine behind the concurrent mass-replace utility that allows a planner or process engineer to replace one item, formula material, or operation resource with another across many formulas, recipes, and routings in a single controlled operation instead of editing each definition individually.

The package records each substitution against the substitution header tables and writes the outcome of the run into a results table, giving the business an auditable trail of what was changed, what was skipped, and why. Status in the data dictionary is VALID, and it references the standard FND_PROFILE API for session context such as organization and user identification.

Key Procedures and Functions

Three procedures are documented for this package.

• POPULATE_SEARCH_TABLE — Builds the working set of rows that satisfy the user-entered selection criteria (for example a source item, formula, or resource). This staging step identifies candidate records across the formula, recipe, and routing tables before any update is applied.
• VALIDATE_ALL_REPLACE_ROWS — Evaluates each staged row for eligibility according to process manufacturing business rules and the parameters passed to the concurrent request. Rows that fail validation are flagged so they can be reported and excluded from the actual replacement.
• MASS_REPLACE_OPERATION — Performs the confirmed replacement against the targeted formula, recipe, and routing entities and writes execution results to the results table. This procedure constitutes the transactional core of the mass-replace process.

No parameter lists are documented in the ETRM metadata; the procedures should be invoked through the standard concurrent program driver rather than called directly with assumed signatures.

Tables Accessed

The package reads and writes process manufacturing definition and substitution tables through APPS synonyms, including:

• FM_FORM_MST, FM_FORM_MST_B, FM_MATL_DTL, FM_ROUT_DTL — formula headers, material detail lines, and routing detail lines where component or resource references are replaced.
• GMD_RECIPES_B, GMD_RECIPE_ORGN_ACTIVITIES, GMD_RECIPE_ORGN_RESOURCES, GMD_RECIPE_PROCESS_LOSS — recipe headers, organization-level activities, resources, and process loss definitions affected by the substitution.
• GMD_OPERATIONS_B, GMD_OPERATION_ACTIVITIES, GMD_OPERATION_RESOURCES — operation definitions and their associated activities and resources.
• GMD_FORMULA_SUBSTITUTION, GMD_ITEM_SUBSTITUTION_HDR_B — substitution header and formula substitution records that capture the intent and scope of the replacement.
• GMD_MSNR_RESULTS — mass-replace results, holding the row-by-row outcome of the concurrent run.
• FND_USER — user attribution for the request; profile values are obtained via FND_PROFILE.

Usage Notes

This package is normally invoked from the Process Manufacturing mass-replace concurrent program rather than from a form directly; the concurrent manager supplies the selection criteria, and the package executes POPULATE_SEARCH_TABLE, then VALIDATE_ALL_REPLACE_ROWS, then MASS_REPLACE_OPERATION in sequence. Because a single run can touch many formula, recipe, and routing rows, the process should be executed during a low-activity window and the GMD_MSNR_RESULTS output reviewed before dependent planning or costing activities proceed. The ETRM metadata records zero packages referencing this one, so it is a terminal utility rather than a shared library; custom code should call it only through the supported concurrent program interface and should not depend on internal procedure signatures, which are not published in the repository documentation.