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

    • Select Firm Planned Order to display scheduled firm planned orders.

    • Select Batch to display scheduled batches.

    Status

    • Select Pending to display pending batches.

    • Select WIP to display work in process.

    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:

    • Start Date of the Firm Planned Order or Batch.

    • End Date of the Firm Planned Order or Batch.

    • Document number.

    • Recipe code.

    • Recipe Version.

    • Product code. Required.

    • Formula code.

    • Version number.

    • Routing code.

    • Routing Version.

    • Routing Class.

  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:

    • Type displays whether the line entry is for a Firm Planned Order or a Batch.

    • Document is the batch or firm planned order number.

    • Product is the code for the primary product in the batch or firm planned order.

    • Description is a brief description of the product.

    • Revision is the revision of the primary product in the batch or firm planned order.

    • Planned Start Date is the planned start date and time for the batch or firm planned order.

    • Planned Completion Date is the planned end date and time for the batch or firm planned order.

    • Status is the status of the batch or firm planned order, and can be Pending or WIP.

    • Formula is the code for the formula in the batch or firm planned order.

    • Formula Version is the formula version number in the batch or firm planned order.

    • Routing is the routing code for the recipe in the batch or firm planned order.

    • Routing Version is the routing version number in the batch or firm planned order.

    • Routing Class is the routing class in the batch or firm planned order.

    • Recipe is the code for the recipe in the batch or firm planned order.

    • Recipe Version is the recipe version number in the batch or firm planned order.

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:

    • Batch document number.

    • Start Date of the batches.

    • Formula code.

    • Formula Version number.

    • Routing code.

    • Routing Version number.

    • Recipe code.

    • Recipe Version number

  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:

    • Batch is the batch document number.

    • Planned Completion Date is the planned date and time of completion for the batches listed.

    • Routing is the code for the routing used for each batch.

    • Version is the version of the routing for each batch.

    • Total Steps is the total number of batch steps in each routing.

    • Completed Steps is the number of batch steps completed in the batch.

    • Active Steps is the number of batch steps in process.

    • Recipe is the code for the recipe for each batch.

    • Version is the version of the recipe for each batch.

  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 is the batch document number.

    • Product is the code for the primary product of the batch.

    • Revision is the revision of the primary product of the batch.

    • Recipe is the code for the recipe for the batch.

    • Recipe version is the version of the recipe for the batch.

    • Routing is the code for the routing for the batch.

    • Routing Version is the routing version number for the batch.

    • Routing Quantity is the planned product quantity made by the combination of the batch, routing, and version.

    • UOM is the unit of measure for the product quantity.

Batch Steps

  1. The following fields are display only:

    • Step is the operation step number.

    • Operation is the name of the step operation.

    • Version is the step operation version.

    • Planned Start Date is the step planned start date and time.

    • Planned Completion Date is the planned completion date and time for the step.

    • Actual Start Date is the step actual start date and time.

    • Actual Completion Date is the step actual completion date and time.

    • Required Completion Date is the batch due date and time.

    • Step Closed Date is the step close date and time.

    • Planned Step Quantity is the planned step quantity.

    • Actual Step Quantity is the actual step quantity.

    • Status is the step status. Status can be Pending, WIP, Canceled, Completed, or Closed.

    • Operation Description is the description of the operation used in the step.

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:

    • Batch document number.

    • Start Date of the batches.

    • Formula code.

    • Formula Version number.

    • Routing code.

    • Routing Version number.

    • Item code.

    • Recipe code.

    • Recipe Version number.

  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:

    • Batch is the batch document number.

    • Actual Start Date is the batch start date and time.

    • Product is the code for the primary product of the batch.

    • Revision is the revision of the primary product.

    • Total Planned is the expected amount of material to be generated by the batch.

    • Total Actual is the actual amount of material generated by the batch.

    • Variance [%] is material variance expressed as a percent, as calculated by:

      (Actual Quantity - Planned Quantity)/Planned Quantity * 100%

      For example, a material variance of 25% occurs when the Actual Quantity is 250 and the Planned Quantity is 200, as calculated by:

      (250 - 200)/200 * 100%

    • Formula is the code of the formula used in the batch.

    • Formula Version is the version of the formula used in the batch.

    • Routing is the code of the routing used in the batch.

    • Routing Version is the version of the routing used in the batch.

  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:

    • Batch is the batch document number.

    • Product is the code for the primary product produced by the batch.

    • Revision is the revision of the primary product produced by the batch.

    • Routing is the code for the routing used in the batch.

    • Routing Version is the routing version number for the selected batch.

    • Planned Start is the planned start date for the batch.

    • Formula is the code for the formula used in the batch.

    • Formula Version is the formula version number for the selected batch.

    • Planned Completion is the planned completion date and time for the batch.

    • Recipe is the code of the recipe used in the batch.

    • Recipe Version is the version of the recipe used in the batch.

    • Actual Start is the actual start date for the batch.

    • Total Planned Qty is the planned quantity of material to be produced by the batch.

    • Total Actual Qty is the actual amount of material produced by the batch.

    • Actual Completion is the actual finish date for the batch.

Ingredient Details

  1. The following fields are display only:

    • Line is the formula line number for the ingredient.

    • Ingredient is the code for the ingredient.

    • Revision is the revision of the ingredient.

    • Planned Quantity is the planned quantity of the ingredient in the primary unit of measure.

    • Actual Quantity is the actual quantity of ingredient in the primary unit of measure.

    • UOM is the unit of measure used to express the ingredient quantities.

    • Variance [%] is the ingredient variance expressed as a percent, as calculated by:

      (Actual Quantity - Planned Quantity)/Planned Quantity * 100%

      For example, an ingredient variance of 25% occurs when the Actual Quantity is 125 and the Planned Quantity is 100, as calculated by:

      (125 - 100)/100 * 100%

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:

    • Batch is the batch document number.

    • Product is the code for the primary product produced by the batch.

    • Product Revision is the revision of the primary product produced by the batch.

    • Recipe is the code for the recipe used in the batch.

    • Recipe Version is the recipe version number for the batch.

    • Formula is the code for formula used in the batch.

    • Formula Version is the formula version number for the batch.

    • Routing is the code for the routing used in the batch.

    • Routing Version is the routing version number for the selected batch.

    • Ingredient is the ingredient code used in the batch.

    • Ingredient Revision is the revision of the ingredient used in the batch.

    • Total Planned Qty is the routing planned quantity of ingredient consumed by the batch.

    • Total Actual Qty is the actual quantity of ingredient consumed by the batch in the primary unit of measure.

    • UOM is the unit of measure used to express the ingredient quantities.

Step Details

  1. The following fields are display only:

    • Step is the batch step number.

    • Operation is the name of the operation for the listed step.

    • Version is the operation version used for the listed step.

    • Status is the status of the batch step and can be Pending, WIP, Completed, or Closed.

    • Total Planned Quantity is the planned quantity of material consumed by the step.

    • Total Actual Quantity is the actual quantity of material consumed by the step.

    • UOM is the unit of measured used to express ingredient quantities.

    • Variance [%] is the batch step variance expressed as a percent, as calculated by:

      (Actual Quantity - Planned Quantity)/Planned Quantity * 100%

      For example, a step variance of 25% occurs when the Actual Quantity is 125 and the Planned Quantity is 100, as calculated by:

      (125 - 100)/100 * 100%

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:

    • Batch document number.

    • Start Date of the batches.

    • Formula code.

    • Version number.

    • Routing code.

    • Routing Version number.

    • Item code.

    • Operation code.

    • Operation Version number.

    • Recipe code.

    • Recipe Version number.

  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:

    • Batch is the batch document number.

    • Actual Completion Date is the actual finish date for the batch.

    • Routing is the code for the routing used in the batch.

    • Version is the routing version number for the selected batch.

    • Num of Routing Steps is the total number of steps in the routing.

    • Num of Batch Steps is the total number of steps in the batch.

    • Planned Hours is the planned number of hours required to complete the batch step.

    • Actual Hours is the actual number of hours required to complete the batch step.

    • Variance [%] is the batch step variance expressed as a percent, as calculated by:

      (Actual Hours - Planned Hours)/Planned Hours * 100%

      For example, a step variance of 25% occurs when the Actual Hours are 2.50 and the Planned Hours are 2.00, as calculated by:

      (2.50 - 2.00)/2.00 * 100%

  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:

    • Batch is the batch document number.

    • Product is the primary product produced by the batch.

    • Revision is the revision of the primary product produced by the batch.

    • Recipe is the code for the recipe used in the batch.

    • Recipe Version is the recipe version number for the selected batch.

    • Routing is the code for the routing used in the batch.

    • Routing Version is the routing version number for the selected batch.

    • Planned Start is the planned start date and time for the batch.

    • Planned Completion is the planned completion date and time for the batch.

    • Actual Start is the date the batch was actually started.

    • Actual Completion is the date the batch was actually completed.

Usage

  1. The following fields are display only:

    • Step is the step number for the displayed batch step.

    • Operation is the operation performed in the displayed batch step.

    • Version is the version number of the operation performed in the displayed batch step.

    • Planned Step Qty is the quantity of the product planned to be produced in the step.

    • Actual Step Qty is the quantity of the product produced in the step.

    • UOM is the unit of measure to express the quantity of product produced.

    • Planned Hours is the planned number of hours to perform the batch step.

    • Actual Hours is the actual number of hours to perform the batch step.

    • Variance [%] is the variance of planned versus actual hours.

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

Dates

  1. The following fields are display only:

    • Step is the step number for the displayed batch.

    • Operation is the operation performed in the displayed batch step.

    • Version is the version number of the operation performed in the displayed batch step.

    • Planned Start is the planned start date and time for the batch step.

    • Planned Completion is the planned completion date and time for the batch step.

    • Actual Start is the actual start date and time for the batch step.

    • Actual Completion is the actual completion date and time for the batch step.

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:

    • Batch is the batch document number.

    • Product is the primary product produced by the batch.

    • Revision is the revision of the primary product produced by the batch.

    • Total Output Qty is the planned quantity of product produced by the batch.

    • UOM is the primary unit of measure used to express quantity per batch.

    • Step is the batch step number selected.

    • Operation is the operation performed in the displayed batch step.

    • Version is the operation version.

    • Planned Start is the planned start date and time for the batch.

    • Planned Completion is the planned completion date and time for the batch.

    • Actual Start is the actual start date and time for the batch.

    • Actual Completion is actual completion date and time for the batch.

Activities

  1. The following fields are display only:

    • Activity is the activity in the operation.

    • Planned Start Date is the planned start date and time for the activity.

    • Planned Completion Date is the planned completion date and time for the activity.

    • Actual Start Date is the actual start date and time for the activity.

    • Actual Completion Date is the actual completion date and time for the activity.

    • Planned Factor is the planned number of times the activity is performed.

    • Actual Factor is the actual number of times the activity is performed.

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:

    • Batch is the batch document number.

    • Product is the primary product produced by the batch.

    • Revision is the revision of the product produced by the batch.

    • Total Output Qty is the planned quantity of product produced by the batch.

    • UOM is the primary unit of measure used to express quantity per batch.

    • Batch Step is the batch step number selected.

    • Operation is the operation performed in the displayed batch step.

    • Version is the operation version.

    • Activity is the activity performed by each listed resource.

    • Planned Start Date is the planned start date and time for the batch.

    • Planned Completion Date is the planned completion date and time for the batch.

    • Actual Start Date is the actual start date and time for the batch.

    • Actual Completion Date is the actual completion date and time for the batch.

Usage Details

  1. The following fields are display only:

    • Resource is each resource used in the batch step.

    • Planned Start Date is the planned start date and time for the resource to begin the batch step.

    • Planned Completion Date is the planned completion date and time for the resource to complete the batch step.

    • Actual Start Date is the actual date and time the listed resource started the batch step.

    • Actual Completion Date is the actual date and time the listed resource finished the batch step.

    • Planned Count is the planned number of resources scheduled to perform the batch step.

    • Actual Count is the actual number of resources required to perform the batch step.

    • Planned Hours is the planned number of hours scheduled for each resource to perform the batch step.

    • Actual Hours is the actual number of hours required to perform the batch step.

    • Variance [%] is the usage variance between the planned hours and the actual hours as a percentage:

      (Actual Hours - Planned Hours)/Planned Hours * 100%

      For example, a usage variance of 25% occurs when the Actual Hours are 2.5 and the Planned Hours are 2.0, as calculated by:

      (2.5 - 2.0)/2.0 * 100%

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:

    • Resource code.

    • Batch document number.

    • Start Date of the batches.

    • Formula code.

    • Formula Version number.

    • Routing code.

    • Routing Version number.

    • Operation code.

    • Operation Version number.

    • Recipe code.

    • Recipe Version number.

  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:

    • Resource is the code or name of the resource selected in the inquiry.

    • Last Usage is the date when the resource was used.

    • Total Batches is the total number of batches where the resource was used.

    • Planned Hours is the planned number of usage hours scheduled for the resource.

    • Actual Hours is the actual number of usage hours used by the resource.

    • Variance is the variance between the planned hours and the actual hours as a percentage:

      (Actual Hours - Planned Hours)/Planned Hours * 100%

      For example, a resource variance of 25% occurs when the Actual Hours are 2.5 and the Planned Hours are 2.0, as calculated by:

      (2.5 - 2.0)/2.0 * 100%

To display detailed resource usage detailed information:

  1. Run a Resource Variance inquiry.

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

    • Click Resource Usage.

    • Choose Resource Usage from the Actions menu.

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

    • Resource is the code used to identify equipment or labor used in the manufacturing process.

    • Routing is the code for the routing used in the batch.

    • Version is the version of the routing used in the batch.

    • Batch is the batch document number.

    • Actual Start Date is the actual date and time the resource was utilized.

    • Status is the status of the batch.

    • Planned Hours is the number of hours scheduled for the resource in the displayed routing.

    • Actual Hours is the number of hours actually used for the resource displayed in the routing.

    • Variance % is the difference between the planned hours and actual hours expressed as a percent using the following calculation:

      (Actual Hours - Planned Hours)/Planned Hours * 100%

      For example, a resource variance of 25% occurs when the Actual Hours are 2.5 and the Planned Hours are 2.0, as calculated by:

      (2.5 - 2.0)/2.0 * 100%

    • Product is the primary product the batch produces.

    • Revision is the revision of the product the batch produces.

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.

    • Batch is the batch document number.

    • Product is the primary product produced by the batch.

    • Revision is the revision of the product produced by the batch.

    • Recipe is the code for the recipe used in the batch.

    • Version is the recipe version used in the batch.

    • Formula is the code for the formula used in the batch.

    • Version is the formula version used in the batch.

    • Routing is the code for the routing used in the batch.

    • Version is the routing version.

    • Resource is the code used to identify equipment or labor used in the manufacturing process.

Usage Details

  1. The following fields are display only:

    • Operation is the name of the operation for the listed routing.

    • Version is the operation version.

    • Activity is the action where the operation is performed.

    • Planned Start Date is the planned start date and time for the resource usage.

    • Planned Completion Date is the planned completion date for the resource usage.

    • Actual Start Date is the actual start date for the resource usage.

    • Actual Completion Date is the actual completion date for the resource usage

    • Planned Count is the planned number of resources scheduled to perform the operation.

    • Actual Count is the actual number of resources used to perform the operation.

    • Planned Hours is the planned number of usage hours scheduled for the resource.

    • Actual Hours is the actual number of usage hours used by the resource.

    • Variance % is the difference between the planned usage and the actual usage of the resource during the operation step as a percent, as calculated by:

      (Actual Usages - Planned Usages)/Planned Usages * 100%

      For example, a usage variance of 25% occurs when the Actual Usage is 250 and the Planned Usage is 200, as calculated by:

      (250 - 200)/200 * 100%

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:

    • Plant is the code name of the manufacturing or laboratory organization. This defaults to your current plant.

    • Document is the document number for the batch.

    • Status displays the status of the batch as:

      • Pending if a batch is created, but not yet released.

      • WIP if a batch is released to work in process.

      • Completed if a batch is completed, but not yet closed.

      • Closed if a batch is closed.

      • Canceled if a batch is canceled.

      • Terminated if the batch was terminated.

    • Step is the step number entered for a batch query. Only those materials associated with that step are retrieved. This field is blank if you did not query a specific step, or if you navigated to this window from the Batch window.

    • Operation is the name of the operation for the listed step.

    • Step Status is the status of the displayed step.

    • Recipe is the recipe used in the batch.

    • Recipe Version is the version of the recipe used in the batch.

    • Formula is the formula used in the batch.

    • Formula Version is the version of the formula used in the batch.

    • Routing is the routing used in the batch.

    • Routing Version is the routing version number.

Ingredients

  1. The following fields are display only:

    • Line is the batch line number for the ingredient.

    • Item is the item code for the ingredient.

    • Description is a brief description of the ingredient as it appears on the Item Master.

    • Original Qty is the initial quantity of each ingredient when the batch was first created. This field is a baseline from the initial creation of the batch, and cannot be changed.

    • Planned Qty is the quantity of ingredients planned.

    • WIP Plan Qty is the work in process planned quantity of ingredients. This field displays for batches with a status of WIP, Completed, or Closed.

    • UOM is the unit of measure for the original and planned quantities.

  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:

    • Automatic when ingredients are consumed automatically when the batch is released.

    • Manual when ingredients are consumed manually.

    • Incremental when ingredients quantities are backflushed by incremental backflushing.

    • Automatic by Step when ingredients are consumed automatically as the step is released.

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

  6. The following fields are display only:

    • Scale Type displays as:

      • Fixed if the ingredient is not scalable.

      • Proportional if the ingredient is scalable.

      • Integer if the ingredient is scalable by multiples.

    • Scale Multiple is the scaling increment for the ingredient.

    • Scale Rounding Variance is the percent variance allowable for rounding when the Scale Type is Integer. If the Rounding Variance field is left blank, then rounding occurs without regard to variance.

    • Rounding Direction displays as:

      • Down if the acceptable rounding direction is down to the nearest multiple.

      • Either if the acceptable rounding direction is up or down to the nearest multiple.

      • Up if the acceptable rounding direction is up to the nearest multiple.

    • Scrap Factor is the anticipated amount of ingredient lost in the manufacturing process as a percentage. For example, if the Scrap Factor is 10 percent, then an additional 10 percent of material is added to accommodate for this loss.

    • Required Qty is the sum of the planned quantity and the scrap.

    • Phantom Type displays as:

      • Not a Phantom indicates the ingredient is not a phantom item.

      • Automatic indicates that the ingredient is a phantom item exploded automatically.

      • Manual indicates that the ingredient is a phantom item that requires manual explosion from the Actions menu.

    • Phantom displays as Exploded if the phantom ingredient is exploded previously.

    • Contribute to Step Qty displays as Yes if the ingredient contributes to the step quantity.

    • Step is the step associated to the ingredient.

Products

  1. The following fields are display only:

    • Line is the batch line number for the product.

    • Item is the item code for the product.

    • Description is a brief description of the product as it appears on the Item Master.

    • Original Qty is the initial amount of each product when the batch was created. This field is a baseline for the initial creation of the batch.

    • Planned Qty is the amount of products planned. The Planned Qty changes when the batch is scaled, and is editable in a batch with a status of Pending.

    • WIP Plan Qty is the work in process planned quantity of products.

    • UOM is the unit of measure for the original and planned quantities.

    • Actual Qty is the actual quantity of products yielded.

  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:

    • Automatic when products are yielded automatically when the batch is completed.

    • Manual when products are yielded manually.

    • Incremental when product yield is calculated by incremental backflushing.

    • Automatic by step when products are yielded automatically as the step is completed.

  4. The following fields are display only:

    • Scale Type displays as:

      • Fixed if the product is not scalable.

      • Proportional if the product is scalable.

    • Scale Multiple is the scale multiple for the product.

    • Scale Rounding Variance % is the percent variance allowable for rounding when the Scale Type is Integer.

    • Rounding Direction displays:

      • Down if the acceptable rounding direction is down to the nearest multiple.

      • Up if the acceptable rounding direction is down to the nearest multiple.

      • Either if the acceptable rounding direction is up or down to the nearest multiple.

    • Cost Allocation is the percent cost allocation for the product.

    • Contribute to Step Qty displays as Yes if the product contributes to the step quantity.

    • Step is the step associated to the product.

By-Products

  1. The following fields are display only:

    • Line is the batch line number for the byproduct.

    • Item is the item code for the byproduct.

    • Description is a brief description of the byproduct as it appears on the Item Master.

    • Original Qty is the initial amount of each byproduct when the batch was created. This field is a baseline for the initial creation of the batch.

    • Planned Qty is the amount of byppoducts planned. The Planned Qty changes when the batch is scaled, and is editable in a batch with a status of Pending.

    • WIP Plan Qty is the work in process planned quantity of byproducts. This field displays for batches with a status of WIP, Completed, or Closed.

    • Actual Qty is the actual quantity of byproducts yielded. This field displays for batches with a status of WIP or Completed.

    • UOM is the unit of measure for the original and planned quantities.

    • By-Product Type displays as Rework, Sample, Waste, or Yield depending on the byproduct.

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

  3. The following fields are display only:

    • Yield Type displays the type of product yield as:

      • Automatic when products are yielded automatically when the batch is completed.

      • Manual when products are yielded manually.

      • Incremental when product yield is calculated by incremental backflushing.

      • Automatic by step when products are yielded automatically as the step is completed.

    • Scale Type displays as:

      • Fixed if the product is not scalable.

      • Proportional if the product is scalable.

    • Scale Multiple is the scaling increment for the ingredient.

    • Scale Rounding Variance % is the percent variance allowable for rounding when the Scale Type is Integer.

    • Rounding Direction displays as:

      • Down if the acceptable rounding direction is down to the nearest multiple.

      • Up if the acceptable rounding direction is up to the nearest multiple.

      • Either if the acceptable rounding direction is up or down to the nearest multiple.

    • Contribute to step Qty displays Yes if the byproduct contributes to step quantity.

    • Step is the step associated to the product.