Search Results gmd_recipe_val




Overview
Explore in AI Chat

Overview

GMD_RECIPE_VAL is the recipe validation package body in the Oracle Process Manufacturing (OPM) product family of Oracle E-Business Suite. In EBS 12.1.1 and 12.2.2, it resides in the APPS schema and holds a status of VALID. Its primary business function is to centralize the validation logic applied to production recipes before and during their maintenance. Recipes define the formula, routing, process loss, and customer associations required to manufacture a product. Because these records drive costing, batch execution, and regulatory compliance, the application must ensure that every recipe created or modified satisfies referential, date, quantity, and routing rules.

The package exposes a set of reusable validation and query utilities that are consumed by the recipe maintenance forms, the OPM public APIs, and other dependent PL/SQL packages. It relies on the OPM common validation layer (GMD_COMMON_VAL) and the Oracle Application Object Library error handling framework (FND_MESSAGE, FND_MSG_PUB, FND_API, FND_PROFILE), which indicates it participates in the standard OPM API error-stack convention. The metadata confirms that at least six other database objects reference this package, underscoring its role as a shared validation service rather than an isolated utility.

Key Procedures and Functions

The documented interface comprises sixteen procedures and functions. Their purposes are as follows:

  • RECIPE_EXISTS — Determines whether a recipe already exists for a given key, supporting duplicate prevention.
  • RECIPE_NAME — Retrieves the descriptive name of a recipe for display or validation messaging.
  • RECIPE_FOR_UPDATE — Validates that a recipe is eligible for update, typically enforcing status and locking rules.
  • RECIPE_DESCRIPTION — Returns the recipe description associated with a recipe identifier.
  • RECIPE_ORGN_CODE — Resolves the organization code owning a recipe, respecting organization access controls.
  • PROCESS_LOSS_FOR_UPDATE — Confirms process loss records are in a state that permits modification.
  • RECIPE_CUST_EXISTS — Checks for existing recipe-to-customer associations.
  • CHECK_ROUTING_VALIDITY — Verifies that the routing attached to a recipe is valid and usable.
  • VALIDATE_START_DATE / VALIDATE_END_DATE — Validate the effective date boundaries of a recipe.
  • EFFECTIVE_DATES — Returns or evaluates the effective date range for a recipe.
  • STD_QTY and MAX_QTY — Retrieve the standard and maximum quantity values defined for a recipe.
  • CALC_INV_QTYS — Calculates inventory quantities, using INV_CONVERT for unit-of-measure conversion.
  • CALCULATE_PROCESS_LOSS — Derives process loss amounts from the recipe's loss definitions.
  • CHECK_FOR_DUPLICATE — Detects duplicate recipe definitions across the relevant uniqueness criteria.

Tables Accessed

The package reads and writes the core OPM recipe tables. GMD_RECIPES and GMD_RECIPES_B hold the base and translated recipe headers. GMD_RECIPE_CUSTOMERS stores customer-specific recipe associations. GMD_RECIPE_PROCESS_LOSS and GMD_PROCESS_LOSS define process loss percentages and quantities. GMD_RECIPE_VALIDITY_RULES holds the date and status validity rules evaluated by the date validation routines. GMD_PARAMETERS_HDR supplies OPM parameter definitions, GMD_ROUTINGS_B provides routing headers for validity checks, GMD_STATUS supplies status code meanings, and GMD_RECIPE_ID_S generates recipe identifiers. DUAL is used for single-row lookups, and ORG_ACCESS_VIEW enforces organization-level security.

Usage Notes

GMD_RECIPE_VAL executed primarily from the OPM Recipe Maintenance forms and from public recipe APIs, where it is called before inserts and updates to enforce business rules. It is also invoked by the six documented dependent packages, and its FND_MSG_PUB integration allows validation errors to be surfaced through the standard OPM error stack. Custom code should call these routines rather than duplicating validation logic, preserving consistency with standard recipe behavior.