Search Results get_recipe_data

Overview

GMD_RECIPE_DATA_PUB is a public PL/SQL API package in the APPS schema that exposes recipe data retrieval services for Oracle Process Manufacturing (OPM) in Oracle E-Business Suite 12.1.1 and 12.2.2. The package belongs to the OPM product family (GMD prefix) and is classified as a PUB API, indicating that it is an officially supported integration point intended for public invocation rather than internal use. Its principal business function is to return the definition of a process manufacturing recipe — the master document that specifies the formula, routing, and operational sequence required to manufacture a product — to calling programs that need recipe data for batch creation, rerouting, or other downstream processing.

The package relies on the FND_API standard error-handling infrastructure and validates recipe-related data through GMDFMVAL_PUB. It also delegates portions of its retrieval logic to GMD_RECIPE_FETCH_PUB, forming a layered access path over the OPM recipe tables. Package body metadata confirms the package currently has a VALID status in the data dictionary.

Key Procedures and Functions

The documented interface consists of a single public procedure, GET_RECIPE_DATA. Its purpose is to retrieve recipe information for a given recipe identifier and return the resulting data to the caller. It acts as the single entry point into the recipe data API, shielding callers from the underlying fetch and validation logic implemented in GMD_RECIPE_FETCH_PUB and GMDFMVAL_PUB. The ETRM metadata documents the procedure name and classification but does not publish the formal parameter list; integrators should therefore obtain the signature from the installed package specification (for example, by querying ALL_ARGUMENTS or describing the package in SQL*Plus) before coding against it.

Tables Accessed

The documented tables referenced through APPS synonyms are FM_FORM_MST, FM_ROUT_HDR, and GMD_RECIPES.

• FM_FORM_MST — the OPM formula master table. It stores formula headers, providing the ingredient and quantity structure associated with the recipe.
• FM_ROUT_HDR — the OPM routing header table. It holds routing definitions describing the sequence of operations and resources required by the recipe.
• GMD_RECIPES — the recipe header table itself, which links formula, routing, and recipe-level attributes such as validity and version.

Read access to these tables allows GET_RECIPE_DATA to assemble a complete recipe view, combining recipe header information with its formula and routing components. Dependency metadata additionally shows references to FM_FORM_MST at the object level, consistent with the documented table list.

h4>Usage Notes

GMD_RECIPE_DATA_PUB is invoked by other OPM PL/SQL packages rather than directly by end users. Documented reverse dependencies show that GME_CREATE_BATCH_PVT and GME_REROUTE_BATCH_PVT call into this package; both are involved in batch creation and batch rerouting, where the recipe definition must be resolved before production data can be generated. The package is also self-referencing, indicating internal calls within the package body. Custom code may call GET_RECIPE_DATA directly when recipe data is required for integration, reporting, or validation purposes, provided the caller follows standard FND_API conventions and handles the returned status and error messages. Because the package is a published API, it should be preferred over direct SQL against FM_FORM_MST, FM_ROUT_HDR, or GMD_RECIPES in order to preserve upgrade compatibility across Oracle EBS 12.1.1 and 12.2.2 releases.