Skip Headers

Oracle Process Manufacturing Process Execution User's Guide
Release 12.1
Part Number E13652-05
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Inquiries

This topic shows you how to run and interpret inquiries for a production schedule, work in process, material variances, batch step variances, resource variances, and resource usage.

This chapter covers the following topics:

Requirements

Following are some requirements that customers have for inquiries in Process Execution:

Can a production schedule differentiate between pending and WIP batches?

Yes. The Production Schedule Selection Criteria window lets you select batches by pending or WIP status.

Production Schedule Inquiry Differentiates Pending and WIP Batches

The Production Schedule Selection Criteria dialog box enables the selection of the type and status of a production schedule. Production Supervisors can display firm planned orders and batches scheduled for production. The inquiry allows differentiation by status.

Is it possible to display all current work in process for the plant?

Yes. The Work in Process Inquiry searches for batches with a status of work in process.

Work in Process Inquiry Displays Specified Batches in Production

The Work in Process Inquiry Selection Criteria dialog box enables the search of batches by plant, document number, start date, and formula or routing used. The Work In Process Inquiry Details window displays relevant information about planned and actual dates for each batch step as well as required completion dates, so that the Production Supervisor can gain an overview of all work in process.

Is there an application tool to monitor variances in material production and consumption?

Yes. The Material Variance Inquiry enables the Production Supervisor to monitor processes outside expected production tolerances.

Material Variance Inquiry Shows Discrepancies Between Actual and Planned Batch Quantities

Production Supervisors use the Material Variance Inquiry to monitor material consumption. When a process is outside expected production tolerances, the inquiry assists in the troubleshooting of specific problems in batch production.

Can variances be viewed at the step level?

Yes. The Batch Step Variance Inquiry enables the display of variances at the step level.

Batch Step Variance Inquiry Displays Step Variances

Step Variances are a valuable diagnostic tool used to troubleshoot process flow issues. Failure to close batch steps or the inability to complete them in an allowable time helps Production Supervisors optimize work processes at the batch step level.

Is it possible to view bottlenecks in the production process?

Yes. The Resource Variance Inquiry enables the Production Supervisor to display variances in actual versus planned hours for each resource utilized in the batch.

Resource Variance Inquiry Identifies Resource Consumption Problems

The Production Supervisor runs the Resource Variance Inquiry to identify variations in resource consumption during batch production. By investigating planned versus actual hours used for each resource, it is possible to troubleshoot production bottlenecks and remove contentions for resources in a production run. The Resource Usage window enables management to examine relative efficiencies for a process.

Running a Production Schedule Inquiry

The Production Schedule Selection Criteria dialog box lets you limit the list of production schedules displayed. When you accept the selected criteria entered, the Production Schedule window lists the scheduled batches and firm planned orders that meet those criteria.

Prerequisites

To run a production schedule inquiry:

  1. Navigate to the Production Schedule Selection Criteria dialog box.

  2. Enter one or more of the following parameters to specify the Type and Status of the Production Schedule to display:

    Type

    Status

    Required.

  3. Make no entries in the From and To fields to search all data, or enter a starting From and ending To value to narrow the range in each of the following:

  4. Click OK.

Interpreting a Production Schedule Inquiry

The Production Schedule Inquiry window displays all firm planned orders and batches that meet the criteria entered on the Production Schedule Selection Criteria window.

You can use folders with this window.

See: Oracle E-Business Suite User's Guide

Prerequisites

To interpret a production schedule inquiry:

  1. Navigate to the Production Schedule Inquiry window.

  2. The following fields are display only:

Running a Work in Process Inquiry

The Work in Process Inquiry Selection Criteria dialog box lets you generate a Work in Process Inquiry to view detailed information about batches in process. Narrow the inquiry by using selection criteria that limit the data to display.

Prerequisites

To run a work in process inquiry:

  1. Navigate to the Work in Process Inquiry Selection Criteria dialog box.

  2. Make no entries in the From and To fields to search all data, or enter a starting From and ending To value to narrow the range in each of the following:

  3. Click OK.

Interpreting a Work in Process Inquiry

The Work in Process Inquiry window displays batches that meet the criteria entered for WIP Inquiry Selection Criteria. The Work in Process inquiry provides important information about batches in process including their scheduled completion, number of steps completed, and total steps that remain active. The inquiry is a good indicator of percent batch completion.

You can use folders with this window.

See: Oracle E-Business Suite User's Guide

Prerequisites

To interpret a work in process inquiry:

  1. Navigate to the Work in Process Inquiry window.

  2. The following fields are display only:

  3. Drill down to the Work in Process Inquiry Details window to display additional process details for a specific batch.

Interpreting Work in Process Inquiry Details

The Work In Process Inquiry Details window displays work in process details for a specific batch. Individual steps in each operation display planned start and completion dates, planned step quantities, the actual start and completion dates, and status of each step. The date and time for required completion and closing date for each step give a summary of batch step information.

You can use folders with this window.

See: Oracle E-Business Suite User's Guide

Prerequisites

To interpret work in process inquiry details:

  1. Navigate to the Work In Process Inquiry Details window.

  2. The following fields are display only:

Batch Steps

  1. The following fields are display only:

To redisplay the Work in Process Inquiry window:

Choose Work in Process from the Actions menu.

Running a Material Variance Inquiry

The Material Variance Inquiry Selection Criteria dialog box lets you generate a Material Variance Inquiry to view detailed information about variances in batch material production and consumption. Narrow the inquiry by using selection criteria that limit the data displayed.

Prerequisites

To run a material variance inquiry:

  1. Navigate to the Material Variance Inquiry Selection Criteria dialog box.

  2. Make no entries in the From and To fields to search all data, or enter a starting From and ending To value to narrow the range in each of the following:

  3. Click OK.

Interpreting a Material Variance Inquiry

The Material Variance Inquiry window lets you display the variances observed between actual and planned batch quantities. The material variance is expressed as a percentage. Optimize and troubleshoot the production run by monitoring the actual amounts of material produced in batches. Variances also help monitor production costs by signaling a process outside an expected production tolerance.

You can use folders with this window.

See: Oracle E-Business Suite User's Guide

Prerequisites

To interpret a material variance inquiry:

  1. Navigate to the Material Variance Inquiry window.

  2. The following fields are display only:

  3. Drill down to the Material Variance - Ingredient Inquiry window.

To display the Material Variance - Ingredient Inquiry window:

  1. Navigate to the Material Variance Inquiry window.

  2. Select the Batch to examine for ingredient material variances.

  3. Choose Ingredients from the Actions menu.

Interpreting a Material Variance - Ingredient Inquiry

The Material Variance - Ingredient Inquiry window lets you view ingredient details for each line in a batch, including both planned and actual quantities and percent variances for each ingredient. This inquiry lists ingredient consumption detail information.

You can use folders with this window.

See: Oracle E-Business Suite User's Guide

Prerequisites

To interpret a material variance ingredient Inquiry:

  1. Navigate to the Material Variance - Ingredient Inquiry window.

  2. The following fields are display only:

Ingredient Details

  1. The following fields are display only:

To display the Material Variance - Step Details Inquiry window:

  1. Navigate to the Material Variance - Ingredient Inquiry window.

  2. Select the Batch to examine for variances at the step detail level.

  3. Choose Step Details from the Actions menu.

To redisplay the Material Variance Inquiry from the Material Variance - Ingredient Inquiry window:

  1. Navigate to the Material Variance - Step Details Inquiry window.

  2. Choose Material Variance from the Actions menu.

To display the Material Variance - Step Details window:

  1. Navigate to the Material Variance - Ingredient Inquiry window.

  2. Choose Step Details from the Actions menu.

Interpreting a Material Variance - Step Details Inquiry

The Material Variance - Step Details window lets you view variances on each step in the production batch.

You can use folders with this window.

See: Oracle E-Business Suite User's Guide

Prerequisites

To interpret a material variance steps details inquiry:

  1. Navigate to the Material Variance - Step Details window.

  2. The following fields are display only:

Step Details

  1. The following fields are display only:

To display the Material Variance - Ingredient Inquiry window:

  1. Navigate to the Material Variance - Step Details window.

  2. Choose Ingredients from the Actions menu.

Running a Batch Step Variance Inquiry

The Batch Step Variance Inquiry Selection Criteria dialog box lets you generate a Batch Step Variance Inquiry to view detailed information about variances in batch step material consumption. Narrow the inquiry by using selection criteria that limit the data displayed.

Prerequisites

To run a batch step variance inquiry:

  1. Navigate to the Batch Step Variance Inquiry Selection Criteria dialog box.

  2. Make no entries in the From and To fields to search all data, or enter a starting From and ending To value to narrow the range in each of the following:

  3. Click OK.

Interpreting a Batch Step Variance Inquiry - Summary

The Batch Step Variance Inquiry - Summary window provides detailed information about batch variances. Determine the actual and planned hours for each batch.

You can use folders with this window.

See: Oracle E-Business Suite User's Guide

Prerequisites

To interpret a batch step variance inquiry summary:

  1. Navigate to the Batch Step Variance Inquiry - Summary window.

  2. The following fields are display only:

  3. Drill down to the Batch Step Variance Inquiry window.

Interpreting Batch Step Variance Inquiry - Details

The Batch Step Variance Inquiry - Details window provides detailed information about batch steps in a production run. Navigate to the Batch Step Inquiry - Operation Details window from this window.

You can use folders with this window.

See: Oracle E-Business Suite User's Guide

Prerequisites

To display batch step variance details:

  1. Navigate to the Batch Step Variance Inquiry - Details window.

  2. The following fields are display only:

Usage

  1. The following fields are display only:

  2. Drill down to display the Batch Variance Inquiry - Operation Activities window.

Dates

  1. The following fields are display only:

Interpreting Batch Step Variance Inquiry - Activities

The Batch Step Variance Inquiry - Activities window displays the step activities associated with the batch. Each activity is listed with information about its planned start and completion date and time and actual start and completion date and time. Planned factors and actual factors are also provided.

You can use folders with this window.

See: Oracle E-Business Suite User's Guide

Prerequisites

To display batch step variance inquiry operation activities:

  1. Navigate to the Batch Step Variance Inquiry - Activities window.

  2. The following fields are display only:

Activities

  1. The following fields are display only:

Interpreting Batch Step Variance Inquiry - Activity Resources

The Batch Step Variance Inquiry - Activity Resources window displays the batch step activity resources associated with the batch and usage details for each resource.

You can use folders with this window.

See: Oracle E-Business Suite User's Guide

Prerequisites

To display batch step variance activity resource usage details:

  1. Navigate to the Batch Step Variance Inquiry - Activity Resources window.

  2. The following fields are display only:

Usage Details

  1. The following fields are display only:

Running a Resource Variance Inquiry

The Resource Variance Inquiry Selection Criteria dialog box lets you generate a Resource Variance Inquiry to view detailed information about variances in resource consumption during production. Narrow the inquiry by using selection criteria that limit the data to display.

Prerequisites

To run a resource variance inquiry:

  1. Navigate to the Resource Variance Inquiry Selection Criteria dialog box.

  2. Make no entries in the From and To fields to search all data, or enter a starting From and ending To value to narrow the range in each of the following:

  3. Click OK.

Interpreting Resource Variance Details

The Resource Variance Details window lets you view information about variances in resource consumption. Resources are the assets such as equipment and labor used to manufacture products. Resources are set up in the Oracle Process Manufacturing process planning applications. View details about the non-material resources used, the date and time specific resources are used, the planned and actual time they are used, and the variances between the planned and actual use.

Prerequisites

To interpret resource variance details:

  1. Navigate to the Resource Variance Details window.

  2. The following fields are display only:

To display detailed resource usage detailed information:

  1. Run a Resource Variance inquiry.

  2. The methods to display resource usage are as follows:

Interpreting Resource Usage

The Resource Usage window lets you view actual usage and variances between planned and actual hours for each resource. By reviewing this information, you determine the relative efficiencies of the process and troubleshoot bottlenecks and other production utilization problems.

Prerequisites

To interpret resource usage:

  1. Navigate to the Resource Usage window.

  2. The following fields are display only:

    Usages

To redisplay the Resource Variance Details window:

Choose Resource Variance Details from the Actions menu.

To display the Resource Usage Details window:

Choose Resource Variance Details from the Actions menu.

Interpreting Resource Usage Details

The Resource Usage Details window lets you view additional details about resource usage not displayed on the Resource Usage window.

Prerequisites

To view resource usage details:

  1. Navigate to the Resource Usage Details window.

Usage Details

  1. The following fields are display only:

Viewing Material Details

The Batch Material Details window lets you display all ingredients, products, and byproducts required for a batch.

Prerequisites

To view material details

  1. Navigate to the Batch Material Details widow.

  2. The following fields are display only:

Ingredients

  1. The following fields are display only:

  2. Actual Qty is the actual quantity of ingredients used. This field displays on batches with a status of WIP or Completed. You can edit this field for plain controlled items.

  3. Allocated is selected if the material displayed on the ingredient line is fully allocated.

  4. Consumption Type displays the type of ingredient consumption as:

  5. Contribute to Yield displays as Yes if the ingredient contributes to yield.

  6. The following fields are display only:

Products

  1. The following fields are display only:

  2. Allocated is selected if the material displayed on the product line is fully allocated.

  3. Yield Type displays the type of product yield as:

  4. The following fields are display only:

By-Products

  1. The following fields are display only:

  2. Allocated is selected if the material displayed on the product line is fully allocated.

  3. The following fields are display only: