OPM Item Process and Recipe Attributes – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Process Manufacturing · all Process Manufacturing reports

Overview

Oracle Process Manufacturing (OPM) item attributes: for every process-manufacturing-enabled item, its recipe, process-execution, quality and costing enabled flags, grade control and default grade, lot / child-lot control, lot divisibility, and shelf-life control and days. Lets formulation and QA teams see which items are recipe and process enabled.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Organization Code, Item, Item Status

Oracle EBS Tables Used

mtl_system_items_vl, org_organization_definitions, org_access_view

Report Categories

Enginatics, R12 only

CAC Missing WIP Accounting Transactions, INV Cycle count hit/miss analysis, INV Cycle count entries and adjustments, INV Cycle counts pending approval, INV Cycle count listing, CAC Item Cost Summary, INV Cycle count unscheduled items, INV Cycle count schedule requests, CAC Last Standard Item Cost

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output OPM Item Process and Recipe Attributes 05-Jun-2026 120010.xlsx
Blitz Report™ XML Import OPM_Item_Process_and_Recipe_Attributes.xml
SQL Source OPM Item Process and Recipe Attributes.sql
Full Report on Enginatics www.enginatics.com/reports/opm-item-process-and-recipe-attributes/

Case Study & Technical Analysis: OPM Item Process and Recipe Attributes

Executive Summary

The OPM Item Process and Recipe Attributes report lists the items of Oracle Process Manufacturing that are enabled for recipes, process execution, process quality or process costing, with the attributes that govern how each item is produced and controlled. For each item it shows the enabled flags, grade control and default grade, lot and child lot control, lot divisibility and shelf life control. Formulation chemists, quality assurance teams and process engineers use it to confirm that an item is set up correctly before it is used in a recipe or batch, and to find items whose lot or shelf life settings differ from the standard for their organization. The report runs in Excel through Blitz Report.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. MTL_SYSTEM_ITEMS_VL joins to ORG_ORGANIZATION_DEFINITIONS on the organization ID.
  2. The item rows are restricted to organizations in ORG_ACCESS_VIEW for the current responsibility.
  3. The process-enabled condition is applied as an OR of the recipe, process execution, process quality and process costing flags.
  4. Output is ordered by organization code and item concatenated segments.

Parameters & Filtering

Performance & Optimization

FAQ

Q: Which items appear in this report? A: Items that are enabled for recipes, process execution, process quality or process costing in the accessible organizations.

Q: What does Grade Controlled show? A: It shows whether grade control is enabled for the item, together with the default grade of the item.

Q: How is shelf life control displayed? A: The shelf life control column shows No shelf life control, Shelf life days, or User-defined expiration, depending on the shelf life code, with the shelf life days alongside.

© Enginatics GmbH