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:
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
Enter and save a production schedule.
To run a production schedule inquiry
Navigate to the Production Schedule Selection Criteria dialog box.
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.
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:
Enter Start Date of the Firm Planned Order or Batch.
Enter End Date of the Firm Planned Order or Batch.
Enter Document number.
Enter Recipe code.
Enter recipe Version.
Enter Product code. Required.
Enter Formula code.
Enter Version number.
Enter Routing code.
Enter Routing Version.
Enter Routing Class.
Click OK.
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
Run a production schedule inquiry.
To interpret a production schedule inquiry
Navigate to the Production Schedule Inquiry window.
The following table lists and describes various fields in the Production Schedule Inquiry window.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Type | Displays whether the line entry is for a Firm Planned Order or a Batch. |
| Document | Displays the batch or firm planned order number. |
| Product | Displays the code for the primary product in the batch or firm planned order. |
| Description | Displays a brief description of the product. |
| Revision | Displays the revision of the primary product in the batch or firm planned order. |
| Planned Start Date | Displays the planned start date and time for the batch or firm planned order. |
| Planned Completion Date | Displays the planned end date and time for the batch or firm planned order. |
| Status | Displays the status of the batch or firm planned order, and can be Pending or WIP. |
| Hold Type | Displays the hold status of the batch and can be No Hold, Pause, or Stop. |
| Formula | Displays the code for the formula in the batch or firm planned order. |
| Formula Version | Displays the formula version number in the batch or firm planned order. |
| Routing | Displays the routing code for the recipe in the batch or firm planned order. |
| Routing Version | Displays the routing version number in the batch or firm planned order. |
| Routing Class | Displays the routing class in the batch or firm planned order. |
| Recipe | Displays the code for the recipe in the batch or firm planned order. |
| Recipe Version | Displays the recipe version number in the batch or firm planned order. |
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.
Note: The batches that are on hold are not displayed in the search results.
Prerequisites
Create batches.
To run a work in process inquiry
Navigate to the Work in Process Inquiry Selection Criteria dialog box.
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
Click OK.
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
Run a work in process inquiry.
To interpret a work in process inquiry
Navigate to the Work in Process Inquiry window.
The following table lists and describes various fields in the Work in Process Inquiry window.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Batch | Displays the batch document number. |
| Planned Completion Date | Displays the planned date and time of completion for the batches listed. |
| Routing | Displays the code for the routing used for each batch. |
| Version | Displays the version of the routing for each batch. |
| Total Steps | Displays the total number of batch steps in each routing. |
| Completed Steps | Displays the number of batch steps completed in the batch. |
| Active Steps | Displays the number of batch steps in process. |
| Recipe | Displays the code for the recipe for each batch. |
| Version | Displays the version of the recipe for each batch. |
Drill down to the Work in Process Inquiry Details window to display additional process details for a specific batch.
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
Run a work in process inquiry.
To interpret work in process inquiry details
Navigate to the Work In Process Inquiry Details window.
The following table lists and describes various fields in the Work In Process Inquiry Details window.
Note: The following fields display only.
| Field Name | Description |
|---|---|
| Batch | Displays the batch document number. |
| Product | Displays the code for the primary product of the batch. |
| Revision | Displays the revision of the primary product of the batch. |
| Recipe | Displays the code for the recipe for the batch. |
| Recipe version | Displays the version of the recipe for the batch. |
| Routing | Displays the code for the routing for the batch. |
| Routing Version | Displays the routing version number for the batch. |
| Routing Quantity | Displays the planned product quantity made by the combination of the batch, routing, and version. |
| UOM | Displays the unit of measure for the product quantity. |
Batch Steps:
The following table lists and describes various fields.
Note: The following fields are display only:
| Field Name | Description |
|---|---|
| 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
Select Work in Process from the Actions menu.
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
Create batches.
Consume batch materials.
To run a material variance inquiry
Navigate to the Material Variance Inquiry Selection Criteria dialog box.
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.
Click OK.
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
Run a material variance inquiry.
To interpret a material variance inquiry
Navigate to the Material Variance Inquiry window.
The following table lists and describes various fields in the Material Variance Inquiry window.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| 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. |
Drill down to the Material Variance - Ingredient Inquiry window.
To display the Material Variance - Ingredient Inquiry window
Navigate to the Material Variance Inquiry window.
Select the Batch to examine for ingredient material variances.
Select Ingredients from the Actions menu.
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
Perform a material variance inquiry.
To interpret a material variance ingredient Inquiry
Navigate to the Material Variance - Ingredient Inquiry window.
The following table lists and describes various fields in the Material Variance - Ingredient Inquiry window
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Batch | Displays the batch document number. |
| Product | Displays the code for the primary product produced by the batch. |
| Revision | Displays the revision of the primary product produced by the batch. |
| Routing | Displays the code for the routing used in the batch. |
| Routing Version | Displays the routing version number for the selected batch. |
| Planned Start | Displays the planned start date for the batch. |
| Formula | Displays the code for the formula used in the batch. |
| Formula Version | Displays the formula version number for the selected batch. |
| Planned Completion | Displays the planned completion date and time for the batch. |
| Recipe | Displays the code of the recipe used in the batch. |
| Recipe Version | Displays the version of the recipe used in the batch. |
| Actual Start | Displays the actual start date for the batch. |
| Total Planned Qty | Displays the planned quantity of material to be produced by the batch. |
| Total Actual Qty | Displays the actual amount of material produced by the batch. |
| Actual Completion | Displays the actual finish date for the batch. |
Ingredient Details:
The following table lists and describes various fields in the Ingredient Details section
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| 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
Navigate to the Material Variance - Ingredient Inquiry window.
Select the Batch to examine for variances at the step detail level.
Select Step Details from the Actions menu.
To redisplay the Material Variance Inquiry from the Material Variance - Ingredient Inquiry window
Navigate to the Material Variance - Step Details Inquiry window.
Select Material Variance from the Actions menu.
To display the Material Variance - Step Details window
Navigate to the Material Variance - Ingredient Inquiry window.
Select Step Details from the Actions menu.
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
Perform a material variance inquiry on ingredients.
To interpret a material variance steps details inquiry
Navigate to the Material Variance - Step Details window.
The following table lists and describes various fields in the Material Variance - Step Details window.
Note: The following fields are display only:
| Field Name | Description |
|---|---|
| Batch | Displays the batch document number. |
| Product | Displays the code for the primary product produced by the batch. |
| Product Revision | Displays the revision of the primary product produced by the batch. |
| Recipe | Displays the code for the recipe used in the batch. |
| Recipe Version | Displays the recipe version number for the batch. |
| Formula | Displays the code for formula used in the batch. |
| Formula Version | Displays the formula version number for the batch. |
| Routing | Displays the code for the routing used in the batch. |
| Routing Version | Displays the routing version number for the selected batch. |
| Ingredient | Displays the ingredient code used in the batch. |
| Ingredient Revision | Displays the revision of the ingredient used in the batch. |
| Total Planned Qty | Displays the routing planned quantity of ingredient consumed by the batch. |
| Total Actual Qty | Displays the actual quantity of ingredient consumed by the batch in the primary unit of measure. |
| UOM | Displays the unit of measure used to express the ingredient quantities. |
Step Details:
The following table lists and describes various fields in the Step Details section
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Step | Displays the batch step number. |
| Operation | Displays the name of the operation for the listed step. |
| Version | Displays the operation version used for the listed step. |
| Status | Displays the status of the batch step and can be Pending, WIP, Completed, or Closed. |
| Total Planned Quantity | Displays the planned quantity of material consumed by the step. |
| Total Actual Quantity | Displays the actual quantity of material consumed by the step. |
| UOM | Displays the unit of measured used to express ingredient quantities. |
| Variance [%] | Displays 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
Navigate to the Material Variance - Step Details window.
Select Ingredients from the Actions menu.
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
Create batches.
Consume batch materials.
To run a batch step variance inquiry
Navigate to the Batch Step Variance Inquiry Selection Criteria dialog box.
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.
Click OK.
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
Run a batch step variance inquiry.
To interpret a batch step variance inquiry summary
Navigate to the Batch Step Variance Inquiry - Summary window.
The following table lists and describes various fields in the Batch Step Variance Inquiry - Summary window
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Batch | Displays the batch document number. |
| Actual Completion Date | Displays the actual finish date for the batch. |
| Routing | Displays the code for the routing used in the batch. |
| Version | Displays the routing version number for the selected batch. |
| Num of Routing Steps | Displays the total number of steps in the routing. |
| Num of Batch Steps | Displays the total number of steps in the batch. |
| Planned Hours | Displays the planned number of hours required to complete the batch step. |
| Actual Hours | Displays the actual number of hours required to complete the batch step. |
| Variance [%] | Displays 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% |
Drill down to the Batch Step Variance Inquiry window.
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
Run a batch variance inquiry.
To display batch step variance details
Navigate to the Batch Step Variance Inquiry - Details window.
The following table lists and describes various fields in the Batch Step Variance Inquiry - Details window.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Batch | Displays the batch document number. |
| Product | Displays the primary product produced by the batch. |
| Revision | Displays the revision of the primary product produced by the batch. |
| Recipe | Displays the code for the recipe used in the batch. |
| Recipe Version | Displays the recipe version number for the selected batch. |
| Routing | Displays the code for the routing used in the batch. |
| Routing Version | Displays the routing version number for the selected batch. |
| Planned Start | Displays the planned start date and time for the batch. |
| Planned Completion | Displays the planned completion date and time for the batch. |
| Actual Start | is the date the batch was actually started. |
| Actual Completion | Displays the date the batch was actually completed. |
Usage:
The following table lists and describes various fields in the Usage section.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Step | Displays the step number for the displayed batch step. |
| Operation | Displays the operation performed in the displayed batch step. |
| Version | Displays the version number of the operation performed in the displayed batch step. |
| Planned Step Qty | Displays the quantity of the product planned to be produced in the step. |
| Actual Step Qty | Displays the quantity of the product produced in the step. |
| UOM | Displays the unit of measure to express the quantity of product produced. |
| Planned Hours | Displays the planned number of hours to perform the batch step. |
| Actual Hours | Displays the actual number of hours to perform the batch step. |
| Variance [%] | Displays the variance of planned versus actual hours. |
Drill down to display the Batch Variance Inquiry - Operation Activities window.
Dates:
The following table lists and describes various fields in the Dates section.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Step | Displays the step number for the displayed batch. |
| Operation | Displays the operation performed in the displayed batch step. |
| Version | Displays the version number of the operation performed in the displayed batch step. |
| Planned Start | Displays the planned start date and time for the batch step. |
| Planned Completion | Displays the planned completion date and time for the batch step. |
| Actual Start | Displays the actual start date and time for the batch step. |
| Actual Completion | Displays the actual completion date and time for the batch step. |
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
Run a batch step variance inquiry.
To display batch step variance inquiry operation activities
Navigate to the Batch Step Variance Inquiry - Activities window.
The following table lists and describes various fields in the Batch Step Variance Inquiry - Activities window.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Batch | Displays the batch document number. |
| Product | Displays the primary product produced by the batch. |
| Revision | Displays the revision of the primary product produced by the batch. |
| Total Output Qty | Displays the planned quantity of product produced by the batch. |
| UOM | Displays the primary unit of measure used to express quantity per batch. |
| Step | Displays the batch step number selected. |
| Operation | Displays the operation performed in the displayed batch step. |
| Version | Displays the operation version. |
| Planned Start | Displays the planned start date and time for the batch. |
| Planned Completion | Displays the planned completion date and time for the batch. |
| Actual Start | Displays the actual start date and time for the batch. |
| Actual Completion | Displays actual completion date and time for the batch. |
Activities:
The following table lists and describes various fields in the Activities section.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| 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. |
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
Run a batch step variance inquiry.
To display batch step variance activity resource usage details
Navigate to the Batch Step Variance Inquiry - Activity Resources window.
The following table lists and describes various fields in the Batch Step Variance Inquiry - Activity Resources window
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Batch | Displays the batch document number. |
| Product | Displays the primary product produced by the batch. |
| Revision | Displays the revision of the product produced by the batch. |
| Total Output Qty | Displays the planned quantity of product produced by the batch. |
| UOM | Displays the primary unit of measure used to express quantity per batch. |
| Batch Step | Displays the batch step number selected. |
| Operation | Displays the operation performed in the displayed batch step. |
| Version | Displays the operation version. |
| Activity | Displays the activity performed by each listed resource. |
| Planned Start Date | Displays the planned start date and time for the batch. |
| Planned Completion Date | Displays the planned completion date and time for the batch. |
| Actual Start Date | Displays the actual start date and time for the batch. |
| Actual Completion Date | Displays the actual completion date and time for the batch. |
Usage Details:
The following table lists and describes various fields in the Usage Details section.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Resource | Displays each resource used in the batch step. |
| Planned Start Date | Displays the planned start date and time for the resource to begin the batch step. |
| Planned Completion Date | Displays the planned completion date and time for the resource to complete the batch step. |
| Actual Start Date | Displays the actual date and time the listed resource started the batch step. |
| Actual Completion Date | Displays the actual date and time the listed resource finished the batch step. |
| Planned Count | Displays the planned number of resources scheduled to perform the batch step. |
| Actual Count | Displays the actual number of resources required to perform the batch step. |
| Planned Hours | Displays the planned number of hours scheduled for each resource to perform the batch step. |
| Actual Hours | Displays the actual number of hours required to perform the batch step. |
| Variance [%] | Displays 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% |
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
Create batches.
Use resources.
To run a resource variance inquiry
Navigate to the Resource Variance Inquiry Selection Criteria dialog box.
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.
Click OK.
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
Run a resource variance inquiry.
To interpret resource variance details
Navigate to the Resource Variance Details window.
The following table lists and describes various fields in the Resource Variance Details window.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Resource | Displays the code or name of the resource selected in the inquiry. |
| Last Usage | Displays the date when the resource was used. |
| Total Batches | Displays the total number of batches where the resource was used. |
| Planned Hours | Displays the planned number of usage hours scheduled for the resource. |
| Actual Hours | Displays the actual number of usage hours used by the resource. |
| Variance | Displays 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
Run a Resource Variance inquiry.
The methods to display resource usage are as follows:
Click Resource Usage.
Select Resource Usage from the Actions menu.
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
Run a resource variance inquiry.
To interpret resource usage:
Navigate to the Resource Usage window.
Usages
The following table lists and describes various field in the Usages section.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Resource | Displays the code used to identify equipment or labor used in the manufacturing process. |
| Routing | Displays the code for the routing used in the batch. |
| Version | Displays the version of the routing used in the batch. |
| Batch | Displays the batch document number. |
| Actual Start Date | Displays the actual date and time the resource was utilized. |
| Status | Displays the status of the batch. |
| Planned Hours | Displays the number of hours scheduled for the resource in the displayed routing. |
| Actual Hours | Displays the number of hours actually used for the resource displayed in the routing. |
| Variance% | Displays 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 | Displays the primary product the batch produces. |
| Revision | Displays the revision of the product the batch produces. |
To redisplay the Resource Variance Details window
Select Resource Variance Details from the Actions menu.
To display the Resource Usage Details window
Select Resource Variance Details from the Actions menu.
The Resource Usage Details window lets you view additional details about resource usage not displayed on the Resource Usage window.
Prerequisites
Run a resource variance inquiry.
To view resource usage details
Navigate to the Resource Usage Details window.
The following table lists and describes various fields in the Resource Usage Details window.
| Field Name | Description |
|---|---|
| Batch | Displays the batch document number. |
| Product | Displays the primary product produced by the batch. |
| Revision | Displays the revision of the product produced by the batch. |
| Recipe | Displays the code for the recipe used in the batch. |
| Version | Displays the recipe version used in the batch. |
| Formula | Displays the code for the formula used in the batch. |
| Version | Displays the formula version used in the batch. |
| Routing | Displays the code for the routing used in the batch. |
| Version | Displays the routing version. |
| Resource | Displays the code used to identify equipment or labor used in the manufacturing process. |
Usage Details:
The following table lists and describes various fields in the Usage Details section.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Operation | Displays the name of the operation for the listed routing. |
| Version | Displays the operation version. |
| Activity | Displays the action where the operation is performed. |
| Planned Start Date | Displays the planned start date and time for the resource usage. |
| Planned Completion Date | Displays the planned completion date for the resource usage. |
| Actual Start Date | Displays the actual start date for the resource usage. |
| Actual Completion Date | Displays the actual completion date for the resource usage |
| Planned Count | Displays the planned number of resources scheduled to perform the operation. |
| Actual Count | Displays the actual number of resources used to perform the operation. |
| Planned Hours | Displays the planned number of usage hours scheduled for the resource. |
| Actual Hours | Displays the actual number of usage hours used by the resource. |
| Variance % | Displays 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% |
The Batch Material Details window lets you display all ingredients, products, and byproducts required for a batch.
Prerequisites
To view material details
Navigate to the Batch Material Details widow.
The following table lists and describes various fields in the Batch Material Details window.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Plant | Displays the code name of the manufacturing or laboratory organization. This defaults to your current plant. |
| Document | Displays the document number for the batch. |
| Status | Displays the status of the batch as:
|
| Hold Type | Displays current hold status of the batch as:
|
| Step | Displays 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 | Displays the name of the operation for the listed step. |
| Step Status | Displays the status of the displayed step. |
| Recipe | Displays the recipe used in the batch. |
| Recipe Version | Displays the version of the recipe used in the batch. |
| Formula | Displays the formula used in the batch. |
| Formula Version | Displays the version of the formula used in the batch. |
| Routing | Displays the routing used in the batch. |
| Routing Version | Displays the routing version number. |
Ingredients:
The following table lists and describes various fields in the Ingredients section.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Line | Displays the batch line number for the ingredient. |
| Item | Displays the item code for the ingredient. |
| Description | Displays a brief description of the ingredient as it appears on the Item Master. |
| Original Qty | Displays 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 | Displays the quantity of ingredients planned. |
| WIP Plan Qty | Displays the work in process planned quantity of ingredients. This field displays for batches with a status of WIP, Completed, or Closed. |
| UOM | Displays the unit of measure for the original and planned quantities. |
| Actual Qty | Displays 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. |
| Allocated | This options is selected if the material displayed on the ingredient line is fully allocated. |
| Consumption Type | Displays the type of ingredient consumption as:
|
| Contribute to Yield | Displays as Yes if the ingredient contributes to yield. |
| Scale Type | Displays as:
|
| Scale Multiple | Displays the scaling increment for the ingredient. |
| Scale Rounding Variance | Displays 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:
|
| Scrap Factor | Displays 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. |
| Phantom Type | Displays as:
|
| 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 | Displays the step associated to the ingredient. |
Products:
The following table lists and describes various fields in the Products section.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| 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. |
| Allocated | is selected if the material displayed on the product line is fully allocated. |
| Yield Type | displays the type of product yield as:
|
| Scale Type | displays as:
|
| Scale Multiple | is the scale multiple for the product. |
| Scale Rounding Variance % | Ss the percent variance allowable for rounding when the Scale Type is Integer. |
| Rounding Direction | displays:
|
| 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:
The following table lists and describes various fields in the By-Products section.
Note: The following fields are display only.
| Field Name | Description |
|---|---|
| Line | Displays the batch line number for the byproduct. |
| Item | Displays the item code for the byproduct. |
| Description | Displays a brief description of the byproduct as it appears on the Item Master. |
| Original Qty | Displays 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 | Displays 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 | Displays the work in process planned quantity of byproducts. This field displays for batches with a status of WIP, Completed, or Closed. |
| Actual Qty | Displays the actual quantity of byproducts yielded. This field displays for batches with a status of WIP or Completed. |
| UOM | Displays the unit of measure for the original and planned quantities. |
| By-Product Type | Displays as Rework, Sample, Waste, or Yield depending on the byproduct. |
| Allocated | This option is selected if the material displayed on the product line is fully allocated. |
| Yield Type | Displays the type of product yield as:
|
| Scale Type | Displays as:
|
| Scale Multiple | Displays the scaling increment for the ingredient. |
| Scale Rounding Variance % | Displays the percent variance allowable for rounding when the Scale Type is Integer. |
| Rounding Direction | Displays as:
|
| Contribute to step Qty | Displays Yes if the byproduct contributes to step quantity. |
| Step | Displays the step associated to the product. |