Skip Headers

Oracle Work in Process User's Guide
Release 12.1
Part Number E13678-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Resource Management

This chapter explains how to manage resources in Work in Process.

This chapter covers the following topics:

Overview of Resource Management

In Work in Process, you can define and control resources (people, machines, and so on) during your production process using these features:

Resource Types

You can charge resources based upon their charge type: WIP Move, Manual, PO Move, and PO Receipt.

Manual Resource Transactions

You can manually charge resources associated with discrete job and repetitive schedule operations. Manual resources can be charged as you move assemblies. They can also be charged independent of move transactions resource transaction. You can correct erroneously entered Manual resource charges.

Automatic Resource Transactions

When you move job and schedule assemblies forward in their routing, pre-assigned WIP Move resources are automatically charged at their standard rate. If you move assemblies backward, WIP Move resource charges are reversed.

When you receive purchasing items that are associated with PO Move and PO Receipt resources back from an outside processing supplier, they are automatically charged. In the case of PO Move resources, the purchasing items are also completed at the operation. If you return assemblies to an outside processing supplier or enter correcting receipts for an outside processing supplier, resource charges and moves are reversed.

Resource Requirements

You can add resources to existing routing operations as well as to operations not on the original routing.

Phantom Resources

You can include phantom resources in your routings. When the phantom is the parent or higher level assembly, its component costs are included in the parent cost, they inherit the operation sequence number from the parent, and their resources and overheads are excluded from the parent or higher level assembly cost. If you want phantom components to maintain their own operation sequence numbers, and if you want resource costs included in the parent cost - set the Bills of Material parameters BOM:Use Phantom Routings and BOM:Inherit Phantom Operation Sequence parameters. See: Phantom Assemblies.

Outside Processing Resources

You can assign outside processing resources to job and schedule routing operations. You can move assemblies to and receive them back from these outside operations. The system automatically charges outside processing resources, tracks your supplier costs, and directly interfaces with Oracle Purchasing for closed loop control. See: Overview of Outside Processing.

Constraint-based Scheduling of Resources

Oracle provides constraint-based scheduling enabling you to schedule resources:

Simultaneous and Alternate Resources

You can set up simultaneous and alternate resources. Simultaneous resources consist of two or more resources scheduled with the same start date and time. Alternate resources consist of other resources used instead of the primary resource. You can also use alternate resource sets. In constraint-based scheduling, this gives you the option to specify an alternate for a group of resources spanning multiple schedule sequences. See: Adding and Updating Resource Requirements and Defining Manufacturing Scheduling Resources

Resource Instances

You can define specific machines to any of your machine type resources. You can also define specific employees to labor type resources. Resource instances are defined on the Resource Instance window.

Open Resource Transaction Interface

You can load resource transaction information from external systems - such as bar code readers, payroll systems, time cards, routing sheets, and custom data entry forms - into the Open Resource Transaction Interface table. When this data is processed, it is validated, and invalid records are marked so that you can correct and resubmit them. See: Open Resource Transaction Interface.

Flexible Labor Transactions

You can charge person-type resources with or without entering an employee. If you enter an employee, the employee hourly rate is used to calculate the resource charge. Otherwise, the charge is calculated using the standard resource rate.

Actual Rate Resource Transactions

If you define a resource as costed at an actual rate, you can enter the actual rate during a manual resource transaction using the Open Resource Transaction Interface. If you do not enter an actual rate, the standard rate is used, but it is treated as an actual rate.

Automatic Overhead Charging

The appropriate overhead costs are automatically charged as you move assemblies through the shop floor. You can charge overheads directly based on move transactions or based on resource charges. You can base the material overhead charge on the number of units, or on the percentage of resource value. The overhead rate with the basis of resource value must be directly assigned to the resource's respective routing. Overhead charges are automatically reversed during a backward move transaction.

Mobile Manufacturing

If Oracle Mobile Supply Chain Applications is installed, the Mobile Manufacturing component enables you to perform resource transactions using a mobile client device networked with a computer system. You can charge resources defined to operation sequences. See: Resource Transactions, Oracle Mobile Supply Chain Applications User's Guide.

Resource Reporting

You can report on resource transactions, efficiencies, and costs by job, repetitive schedule, department, or resource to get a complete history of resource activities. See: Resource Performance Report and Resource Transaction Report.

Related Topics

Overview of Outside Processing

Overview of Resource Transactions

Setting Up Resource Management

Resource Transaction Options

Defining Overhead, Oracle Cost Management User's Guide

Setting Up Resource Management

Prerequisites

Resource Charge Types

You can specify how to charge resources when you create routings in Oracle Bills of Materials. You can also specify how to charge resources when you create resource requirements in Work in Process.

You can specify how to charge resources when you assign resources to routing operations in Oracle Bills of Materials. You can also specify how to charge resources when you add resources to work in process routing operations. There are four resource charge types: WIP Move, Manual, PO Move, and PO Receipt.

WIP Move

Manual

PO Move and PO Receipt

WIP Move

WIP Move resources are automatically charged at their standard rate as you move assemblies forward from the Queue or Run intraoperation step to the To move, Reject, or Scrap intraoperation step of the same operation, or to the next operation.

WIP Move resources with a basis of Item are charged upon completion of each assembly in the operation. WIP Move resources with a basis of Lot are charged upon completion of the first assembly at the operation. In both cases, the amount charged is based upon the resource's usage rate or amount multiplied by the resource's standard cost at the time of the transaction.

You can reverse a WIP Move resource charge by moving assemblies backward from Queue or Run of the current operation to Queue or Run of any prior operation, or by moving assemblies from the To move, Reject, or Scrap intraoperation steps backward to the Queue or Run intraoperation steps of the same operation, or to any intraoperation step of any prior operation.

WIP Move resource charges are applied on a first in-first out basis to multiple repetitive schedules on a line based on how the assemblies being moved are allocated. For example, if you have 2 released schedules for 100 assemblies each and you move 150 assemblies, the system automatically allocates 100 to the earliest schedule and 50 to the next.

Operation Completion Moves

Performing Move Transactions

Manual

Manual resources can be charged independent of move transactions using the Resource Transactions window. If you complete an operation with a move transaction, and there are Manual resources assigned to that operation, a message informing you that Manual resources exist at that operation is displayed. You can then charge these Manual resources by choosing the Resources button in the Move Transactions window.

Note: You can control whether the Resources button appears in the Move Transactions window using function security. See: Security Functions.

When you charge Manual resources, you must enter the actual resource units applied rather than autocharging the resource's usage rate or amount based on the move quantity. You can charge Manual resources using that resources unit of measure or any valid alternate unit of measure. If the resource is a person-type resource, you can enter an employee number. Manual resources for repetitive schedules are charged to the first open repetitive schedule on the line.

You can create ad hoc resource requirements as you charge resources. Ad hoc resource requirements an be created for any resource that is defined for the department that is associated with the operation.

You can reverse Manual resource charges by entering negative resource units. For example, if you intend to charge 8 hours but mistakenly enter 10, you can correct the error by entering an additional resource charge transaction for -2 hours.

Operation Completion Moves

Charging Resources Manually

PO Move and PO Receipt

The WIP Requisition Creation Time parameter determines whether or not requisitions are created for resources assigned to outside processing operations, and when they will be created. You can set this parameter so that requisitions are created at job or schedule release, or at the outside processing operation. See: WIP Parameters.

When you receive assemblies back from an outside processing supplier in Oracle Purchasing, PO Receipt or PO Move resources, also known as outside processing resources, are automatically charged at the standard or the actual rate. If the receipt involves a PO Move resource, the assemblies are also moved from the Queue intraoperation step of the outside processing operation into the Queue intraoperation step of the next operation. If the outside processing operation is the last operation in the routing, the assemblies are moved into the To move intraoperation step of that operation. The assemblies are then immediately completed into inventory if the following conditions are also met:

You can track the progress of outside processing assemblies that have been sent to a supplier by moving assemblies within the outside processing operation. You can optionally disallow move transactions from an outside processing step unless they are launched by a purchase order receipt. You can do this by using the Shop Floor Status for PO Move Resource parameter. See: Shop Floor Statuses.

If, in Oracle Purchasing, you return assemblies to an outside processing supplier using the Receiving Returns window, or enter correcting receipts for an outside processing supplier using the Receiving Corrections window, the system creates reversing charges for the PO Move and PO Receipt resources associated with the outside processing operation. If you enter a return or correction that involves a PO Move resource, the assemblies are moved from the Queue intraoperation step of the operation immediately following the outside processing operation into the Queue intraoperation step of the outside processing operation. If the outside processing operation is the last operation on the routing, the assemblies automatically move from the To move intraoperation step to the Queue intraoperation step of the outside processing operation.

PO Move resource transactions are applied to multiple repetitive schedules on a line based on how the assemblies being moved are allocated. Moves are allocated across multiple repetitive schedules on a first-in-first-out (FIFO) basis. PO Receipt resource transactions are allocated across schedules on a first-in-first-out basis.

For example, if you have two released schedules for 100 assemblies each and you move 150 assemblies, the system automatically allocates 100 to the earliest schedule and 50 to the next.

Outside Processing

Resource Charges, Oracle Cost Management User's Guide

Detailed Scheduling

Overview of Resource Requirements

Resources can be assigned to routing operations. Resources are used to cost and schedule jobs and repetitive schedules.

Resources

A resource is anything of value, except material and cash, required to manufacture, cost, and schedule products. People, tools, machines, outside processing services, machines, and physical space are commonly used resources. See: Defining a Resource, Oracle Bills of Material User's Guide.

Note: In order for resources to be viewable in the applications windows, Unit of Measure values in manufacturing must be consistent with the values in Oracle General Ledger Set of Books. Use the Unit of Measure Conversions window in Oracle Inventory to create UOM conversion values. See: Defining Unit of Measure Conversions, Oracle Inventory User's Guide

Standard versus Non-Standard

You can specify whether to charge resources at a standard or non-standard rate. Non-standard resources can be charged manually in Work in Process. If the resource is a non-standard, outside processing resource, its costs are derived from the purchase order it is associated with.

Outside Processing Resources

You can define a resource as an outside processing resource. Outside processing resources must be associated with the item that they are used to produce. See: Overview of Outside Processing.

Phantom Assembly Resources

Phantom assemblies are non-stocked items that group material needed to produce an assembly or a subassembly. When parent or high level assemblies are phantoms, resource costs, including overheads are not charged to the parent or higher level assembly cost. When phantoms arse used as subassemblies, however, you can set a parameter in Oracle Bills of Material to specify that its resource and overhead costs are charged to the parent or higher level assembly. See: Phantom Assemblies.

Charge Types

You must assign a charge type to each resource. Charge types determine how resources are charged in Work in Process.

Resource Activities

You can assign the activities you define in Oracle Cost Management to resources. Activities are processes or procedures that consume costs and time. The can be used to assign indirect costs.

Resource Basis

You can assign a resource basis type of Item to a resource if its per unit usage rate is dependent on the number of assembly items being produced. If the per unit usage rate is fixed, for example labor to setup a machine for a job, you can assign a resource basis of Lot. See: Resource Usage, Oracle Bills of Material User's Guide.

Departmental Resources

You can identify which resources are available to a department when you define departments. Departments can have multiple resources.

Operation Resources

You can define routing operations as you create routings in Oracle Bills of Material. You can also add and update job and schedule routing operations in Work in Process. When you define a routing operation you must identify the department at which the operation is performed. You can assign any resource that is defined for that department to the routing operation. See: Assigning Operation Resources, Oracle Bills of Material User's Guide.

Multiple Resources

You can assign multiple resources to routing operations. You can sequence these resources as required. If you assign multiple resources, they are scheduled sequentially based on their resource sequence number, or in parallel, based on their scheduled attribute

Costing Multiple Resources

You can assign multiple resources to charge labor, machine usage, and other activities performed within the operation. For example, if you have costs associated with running a machine and costs associated with the machine operator, you can define them as two resources at the same operation. For each resource you can specify the sequence number of the resource, the usage rate, and the number of resources assigned to the operation working in parallel.

Scheduling Multiple Resources

Resource requirements are used for detailed scheduling. When multiple resources are assigned to an operation, operation start and end dates and times are scheduled based upon the sum of the times required for each resource. Job and repetitive schedule start and end dates and times are scheduled based upon sum of the time required for each operation.

You can assign but not schedule resources at an operation. You can also assign resources used solely for scheduling, even though these resources do not actually provide value added work. See: Detailed Scheduling

Simultaneous and Alternate Resources

Simultaneous resources consist of two or more resources scheduled with the same start date and time within a job operation. These resources have the same value in the Scheduled Seq field of the Routing window. Simultaneous resources must begin at the same time, but they may complete at different times depending on the Usage Rate or Amount.

Alternate resources consist of other resources-or groups of resources-used instead of the primary resource in the job operation. Alternate resources are defined on the Alternate Resources window. They are invoked in one of two ways:

You can also use alternate resource sets. In infinite scheduling, you can change an alternate resource to a primary resource, This specifies it as a one-for-one substitution, or substitution by a group when the resources in the group are simultaneous. In constraint-based scheduling, you can specify the resources in a sequence, and have them span multiple schedule sequences. See: Alternate Resource Sets

Manufacturing Scheduling Resources

The Oracle Manufacturing Scheduling application provides additional resource capability with constraint-based scheduling of resources. See: Defining Manufacturing Scheduling Resources

Oracle also provides Production Scheduling, a constraint-based automated scheduling tool using sophisticated scheduling algorithms. It optimizes production, enforcing minimum run length constraints, and minimizing changeover times on your resources. See: Supply Chain Planning Production Scheduling

Constraint-based Scheduling of Resources

The Constraint-based Scheduling engine provides the ability to schedule jobs based on available resources and material. Constraint-based scheduling is enabled when you set the Schedule field on the Resources Requirements window. It must be one of the following values in order for the constraint-based scheduling engine to consider the capacity for the resource:

Adjusting Resource Capacity

You can adjust resource capacity from the Scheduler Workbench. This can be done manually or automatically:

Simulation sets are used to link resource changes for scheduling. Simulation sets are defined, associated to resources in Oracle Bills of Material, and linked to Work in Process scheduling parameters. See: Defining WIP Parameters

Resource Instances

You can define specific machines to any of your machine type resources, and specific employees to labor type resources. All instances for a resource are viewable in the Resource Property window on the Scheduler Workbench, Job Workbench, and Resource Workbench.

Related Topics

Charging Resources Manually

Defining a Resource, Oracle Bills of Material User's Guide

Defining WIP Resource Definition, Oracle Manufacturing Scheduling User's Guide

Adding and Updating Resource Requirements

Defining Manufacturing Scheduling Resources

Resource Factors in Lead Time Calculation

Material and resource requirement lead times are calculated using the Calculate Manufacturing Lead Time concurrent program. This program determines the lead time for items and assemblies using information from the bill of material and routing setup. This includes lot size, item lead time attributes (such as processing and cumulative lead times), and fixed and variable components. The lead time calculation rollup program also includes resource usage features that can affect processing lead time.

You can set the profile option WIP: Round Off Resource Usage to Minutes in Lead Time Calculations to change resource usage calculations. If set to Yes—when entry of resource usage values of a routing resource is less than a minute value, this profile enables the value to be rounded to the next minute to be compatible with Advanced Supply Chain Planning calculations. This setting can change the resource usage rate. Otherwise, if set to No, resource usage is not rounded.

For scheduling and lead time calculations, extended resource usages are rounded to the next minute. In the following example, each resource usage is 72 seconds. The scheduling logic and lead time calculation round to the next minute—therefore each resource usage is rounded to 120 seconds, and the total duration is 240 seconds.

Operation Resource Usage Scheduled Flag Basis
10 Resource1 72 seconds Yes Item
10 Resource2 72 seconds Yes Item

Note: Alternate resources are not considered in lead time calculation.

Resource Efficiency

Resource usage is divided by the efficiency percentage to capture the resource lead time. Values of less than 100 percent elongate the lead time.

Resource Utilization

You define a utilization percentage in order to capture true available-for-work time. Utilization represents the difference between the theoretical and actual production from a resource, For example, is the resource actually working 8 hours of productive time in an 8 hour shift. If the difference is expected to be significant, you can model utilization on that resource. Values of less than 100 percent elongate lead time.

Simultaneous Resources

When using two or more resources at the same time, the resource taking the most extended time is used in lead time calculation. This is the resource with the longest lead time within the same schedule number, for an operation. Simultaneous resources shorten lead time.

Assigned Units for 24 Hour Resources

For resources available 24 hours, the more resource units assigned to an operation in a routing - the less elapsed time for that operation to complete. This shortens the lead time.

Related Topics

Calculating Manufacturing Lead Times, Oracle Bills of Material User's Guide

Manufacturing Lead Time Computations , Oracle Bills of Material User's Guide

Adding and Updating Resource Requirements

You can add and update resources as you add and update operations. You can add resources that are not pre-assigned to job or repetitive schedule routing operations. You can add resources to jobs and schedules that do not have operations.

You can add resource requirements regardless of their charge type: Manual, PO move, PO receipt, or WIP move. When you add a resource with an charge type of PO move, PO receipt, or WIP move, the resource is added to the job or repetitive schedule as a Manual resource.

Prerequisites

To add or update resource requirements

  1. Navigate to the Operations from Job/Schedule Details in the menu.

  2. Select the Job or repetitive Line and Assembly.

    If you select a line and assembly, choose the repetitive schedule by selecting the first unit start date of that schedule. If you have selected a discrete job, the system displays the scheduled start date of the job.

  3. In the Main tabbed region, select the operation Sequence.

    If you are adding a resource, the operation Sequence specifies at which operation to add the resource.

  4. Choose the Resources button. The Resource Requirements window appears.

    the picture is described in the document text

  5. In the Main tabbed region of the Resource Requirements window, select or enter the resource Sequence number.

    Valid sequence numbers range from 1 to 9999 inclusive.

  6. Select the resource Name.

    You can add any resource that is assigned to the department of the operation you have selected. You can also add any multi- departmental resource.

    When you add a resource, the UOM, basis, activity, charge type, and rate or amount that are associated with the resource are defaulted. See: Assigning Resources to a Department, Oracle Bills of Material User's Guide and Defining a Resource, Oracle Bills of Material User's Guide.

    Note: You cannot update a resource if you have charged the resource to a job or schedule.

  7. Select a resource Basis basis. See: Resource Usage, Oracle Bills of Material User's Guide.

    The options are as follows:

    Item: Charge and schedule the resource on an item-by-item basis. Select Item when resource times and costs are dependent on the job or schedule quantity, such as when charging per unit labor costs.

    Lot: Charge and schedule the resource on a one per job or schedule basis. Select Lot when resource times and costs are independent of quantity, such as when setting up a machine to run an entire job.

    You cannot update the resource basis if you have charged against the resource.

  8. Enter the Usage Rate or Amount Value or Inverse.

    Value: Enter a Value if you know how much of the resource is consumed at the operation (per item or per lot) given the resource UOM. For example, if your manufacturing process consumes a mold (resource UOM=EA) for every 5 items produced, enter a Value of 0.2 (1/5). When you enter the Value of 0.2, the Inverse is automatically calculated as 5. In other words, producing one unit consumes 0.2 of the mold.

    Inverse: Enter an inverse amount if you know the number of units a resource can process given the resource UOM. For example, if you can process 10 units on a lathe (resource UOM = HR) in an hour, enter an inverse amount of 10. When you enter the inverse amount of 10, the value is automatically calculated as 0.1 (1/10). In other words, each unit takes 0.1 hours to process.

    You cannot enter a quantity less than zero for resources with time-based units of measure. When you enter the usage rate or amount, the inverse usage rate or amount is automatically supplied.

To schedule or reschedule a resource

  1. In the Scheduling tabbed region, enter the number of Assigned Units. See: Resource Usage, Oracle Bills of Material User's Guide.

    When you add a resource, the number of assigned units default value of 1. The number of Assigned Units must be greater than zero.

    The number of assigned units affects the scheduling of jobs and repetitive schedules. If you assign more than the default number of resource units, less elapsed time is scheduled for the operation.

    For example, if you have an operation that normally takes a machine 10 hours to complete, and you assign 2 machines, then only 5 hours are scheduled for the resource at that operation. You should only assign multiple resource units if they work simultaneously at an operation.

    Assigned units for 24 hour resources are also considered by the Calculate Manufacturing Lead Time concurrent program.

    Note: You should not assign multiple resource units unless each resource charges at the same rate. For example, if you have 2 person-type resources performing the same task at an operation, you can create 1 resource and assign 2 units if each person works at the same rate, charges at the same rate, and works in parallel on a job or schedule. If not, then you should create 2 separate resources at the operation.

    the picture is described in the document text

  2. Select the Scheduled option.

    Yes: The resource's start and completion dates and times are used to schedule the job or repetitive schedule operation.

    No: The resource's start and completion dates and times are not used to schedule the job or repetitive schedule operation.

    Prior: The resource's completion date and time are scheduled to overlap the completion date and time of the first scheduled resource (Scheduled option is Yes) of the previous operation which is earlier than a Next resource. This option is used when applied to setup resources that can work in parallel with work in previous operations.

    Next: The resource's start date and time are scheduled to overlap the start date and time of the first scheduled resource (Scheduled option is Yes) of the next operation which is earlier than a Prior resource. This option is used when applied to a teardown operation that can work in parallel with work in next operations.

    Note: For infinite scheduling, Prior and Next resource scheduling options are not available for simultaneous resources. These resources are scheduled as Yes, that is, the resource start and completion dates are used to schedule the operation.

    For constraint-based scheduling, alternate resources allow you to have multiple resources set to Prior or Next scheduled options at each operation. However, for alternate resource sets with at least one Prior or Next resource—the set must be defined with resources of the same scheduled type, or scheduled type equal to No.

  3. Enter the Start and Completion Dates and times for the resource operation.

To enter or update resource cost information

  1. In the Costing tabbed region, select the Activity.

    Activities are processes and procedures that consume costs and time. See: Defining Activities and Activity Costs, Oracle Cost Management User's Guide.

  2. Check the Standard Rate check box to charge the resource at its standard rate.

    If you choose the standard rate option, the resource is charged at its resource unit cost. If you charge an outside processing resources at the standard, Oracle Purchasing computes any purchase price variance and posts it to the variance account for the resource.

    If you choose non-standard, you can manually charge the resource at the employee rate or at actual cost. If the resource is a non-standard, outside processing resource, its costs are derived from the purchase order it is associated with.

    Note: Non-standard is recommended if you import charges from an outside labor system and want to enter actual costs or an employee's labor rate.

    You cannot change the standard rate option if you have charged the resource to the job or repetitive schedule.

  3. Select the Charge Type. See: Resource Charge Types.

    You can select any charge type if the resource is defined as an outside processing resource. You can only select PO receipt if the department of the current operation has a location assigned to it. You can only select PO move if the department of the next operation has a location assigned to it. Also, you can only assign one PO move resource to an operation.

    Charge types are defined as follows:

    WIP move: Resources with this charge type are automatically charged when you complete a job or repetitive schedule operation. See: Charging Resources with Move Transactions.

    Manual: Resources with this charge type must be manually charged. See: Charging Resources Manually

    PO receipt: Resources with this charge type are automatically charged when purchase orders are received. However, the assembly items associated with theses resources are not automatically moved to the next operation. They must be manually moved. See: Performing Move Transactions

    PO move: Resources with this charge type are automatically charged upon receipt of a purchase order and the assembly items associated with theses resources are moved to the Queue intraoperation step of the next operation, or to the To move intraoperation step if there is no next operation.

  4. Save your work.

To define simultaneous resources and designate to job routings

  1. Navigate to the Operations Resources window in Oracle Bills of Material.

  2. Enter your resource information in the Main tabbed regions. .

  3. In the Scheduling tabbed region, enter the same value in the Scheduled Seq field for all resources that are simultaneous for each sequence.

    The schedule sequence number indicates the sequence the resource is to be used - simultaneous resources have identical values.

  4. In the Principal Flag check box, you have the option to designated the resource that is the primary resource in a group of simultaneous resources.

  5. Save your work.

  6. Navigate to the Resource Requirements window in Oracle Work in Process.

  7. Enter resource information in the Main tabbed region.

  8. In the Scheduling tabbed region, enter the same value in the Scheduled Seq field for all resources that are simultaneous for each sequence.

    The schedule sequence number indicates the sequence the resource is to be used - simultaneous resources have identical values

  9. In the Scheduled field, select a value.

    If these resources are scheduled as Yes, the resource start and completion dates are used to schedule the operation.

    Prior and Next resource scheduling options are not available for simultaneous resources. These resources are scheduled as Yes, that is, the resource start and completion dates are used to schedule the operation.

    For constraint-based scheduling, alternate resources allow you to have multiple resources set to Prior or Next scheduled options at each operation. However, for alternate resource sets with at least one Prior or Next resource—the set must be defined with resources of the same scheduled type, or scheduled type equal to No.

  10. Select the Start dates and times for the resources - these dates must be the same date for the resources to be considered simultaneous.

    Simultaneous resources must begin at the same time, but they may complete at different times depending on the Usage Rate or Amount.

  11. Save your work.

Related Topics

Overview of Work in Process Scheduling

Adding and Updating Operations

Defining Manufacturing Scheduling Resources

You can define resource instances, resource setups, and alternate resources. If your are using Oracle Manufacturing Scheduling this is used to determine feasible schedules for jobs. If you are not using Manufacturing Scheduling, you can still define this data for informational purposes. This information is defined on windows accessed from the Resource Requirements window.

Oracle also provides another constraint-based scheduling tool, Production Scheduling. Production Scheduling uses scheduling algorithms—optimizing production, enforcing minimum run length constraints, and minimizing changeover times on your resources. See: Supply Chain Planning Production Scheduling

To enter resource instance information

  1. Choose Instances on the Resource Requirements window.

    the picture is described in the document text

    Enter the number for the employee, or equipment and serial number applicable to the resource type. All instances for a resource are viewable in the Resource Property window on the Scheduler Workbench.

To enter resource setup information

  1. Choose Setup on the Resource Requirements window.

    You can create a performance model for machine and labor resource setups. The setups for a resource are independent of the department that the resource is defined in.

    the picture is described in the document text

  2. Enter a resource sequence in the Res Seq field.

    The resource sequence indicates the order of a resource relative to other resources.

  3. Select a value in the Resource field.

  4. Select the resource basis, indicating whether the usage required is by item or lot.

  5. In the Usage Rate or Amount section, enter the amount the resource is consumed at an operation.

  6. In the Setup Type field, select a setup that is specific to this resource.

  7. Save your work.

To enter alternate resource information

  1. Navigate to the Resource Requirements window. Select a record and choose the Scheduling tabbed region.

  2. Enter a value in the Substitute Group field.

    This value indicates which resources are replaced as alternates— alternates have the same substitute group number as the operation resource.

    Note: The Alternates button is active when a value is entered in the Substitute Group field, and the record is saved.

  3. Save your work.

  4. Choose Alternates to display the Alternate Resources window.

    Alternate resources consist of other resources used instead of the primary resource. See: Defining Simultaneous and Alternate Resources, Oracle Manufacturing Scheduling User's Guide

  5. In the Main tabbed region, optionally you can enter the Resource Sequence. The resource sequence indicates the order of a resource relative to other resources. The value must be unique for each operation.

  6. Navigate to the Scheduling tabbed region. For each alternate resource, enter a Replacement Group value.

    This is used in grouping several resources together as an alternate resource group. The primary resource is always a Replacement Group value of 0.

    the picture is described in the document text

  7. In the Scheduled Sequence field, enter a value.

    The schedule sequence number indicates the sequence the resource is to be used—this value defaults from the Resource Requirements window. The replacement group can contain different sequences even if the primary replacement group has only one schedule sequence.

  8. Save your work.

    Alternate Resource Sets

    Alternate Resource Sets enable resources to be substituted and replaced as a group. In infinite scheduling—alternate resources can be a one-for-one substitution, or substitution by a group when the resources in the group are simultaneous.

    In constraint-based scheduling—you can specify that a group, or set of resources, is substituted for another set. This enables resources to be sequential and span multiple schedule sequences. This functionality is used in manufacturing environments where groups of machines are used consecutively in an operation. The type of machine used in the first group determines the type of machine used in the second group. The groups are not simultaneous, therefore each corresponding pair of machines is assigned a replacement group value within a substitute group. Alternate resource sets are defined using the Resource Sequence, Schedule Sequence, Substitute Group, and Replacement Group fields:

    Resource Sequence

    Schedule Sequence

    Substitute Group

    Replacement Group

    Alternate Resource Sets Example

    Resource Resource Sequence Schedule Sequence Substitute Group Replacement Group
    Grinder-1 23 10 668 0
    Tool-50 24 11 668 0
    Grinder-2 23 10 668 1
    Tool-46 24 11 668 1

Related Topics

Overview of Work in Process Costing

Overview of Work in Process Scheduling

Overview of Resource Requirements

Deleting Resource Requirements

You can delete resource requirements as you update operations. You cannot delete resource requirement that have pending transactions, you cannot delete resource requirements that have been transacted even if their due quantity is zero. If you delete an operation, the resources associated with it are automatically deleted.

To delete resource requirements

  1. Navigate to the Operations window.

  2. Select the operation Sequence.

    The operation Sequence specifies from which operation the resource is to be deleted.

  3. Choose the Resources button. The Resource Requirements window appears.

  4. In the Main tabbed region of the Resource Requirements window, select or enter the resource Sequence number.

  5. Select the resource Name.

    You can delete a resource requirement regardless of the status of the job or repetitive schedule. You cannot delete a resource that has been charged at an operation (applied quantity exists) or that has pending resource transactions.

    If you delete an operation from a job or repetitive schedule, you may want to reschedule the job or repetitive schedule to correctly reflect the start and completion dates.

    You cannot delete a PO move or PO receipt resources or the operations they are assigned to if purchase requisitions (either approved or unapproved) or purchase orders exist for these resources.

  6. Choose Delete Record from the Edit Menu.

  7. Save your work.

Related Topics

Adding and Updating Operations

Deleting Operations

Adding and Updating Resource Requirements

Viewing Resource Requirements

You can view resource requirements for a specific discrete job or repetitive line and assembly. You can also view resource requirements across jobs and schedules.

To find and view resource requirements

  1. Navigate to the View Resource Requirements window. The Find Resource Requirements window appears.

    the picture is described in the document text

    You can query by Job or production Line and Assembly or a range of start dates. You can query to find resource requirements for jobs and schedules of a specific status. For example, you can query to find only resources for Released jobs and schedules

    You can also query by Department, Resource, Resource Type, Activity, and/or a range of First Unit and Last Unit Start or Completion Dates.

  2. Enter any combination of search criteria and choose the Find button. The results display in the View Resource Requirements window.

    the picture is described in the document text

    You can view the following information in View Resource Requirements window's tabbed regions:

    Main: Resource, UOM, Operation Sequence number, Department, Resource Sequence number, Basis, Rate or Amount of Usage and Inverse Value

    Quantities: Required, Applied, and Open quantities

    Scheduling: Assigned Units, Scheduled, Start Date, and Completion Date

    Costing: Activity, Standard Rate option, Charge Type

    Job or Schedule: Job/Assembly or production Line/Assembly and Status

    Type, Description: Resource Type and Description

    You can also view, if entered, descriptive flexfield information. See: Setting Up Descriptive Flexfields.

Related Topics

Overview of Resource Requirements

Searching for Information, Oracle E-Business Suite User's Guide

Overview of Resource Transactions

Resource charges can be transacted manually, with move or purchase order transactions, or imported from outside data sources or data collection devices. Resources are charged based upon their charge type: Manual, WIP Move, PO Receipt and PO Move. See: Resource Charge Types.

For all resources you charge either manually or automatically, Oracle Work in Process also records the units applied to the job or repetitive schedule, expressed in the unit of measure of the resource, when you complete an operation.

Actual Resource Charges

You can charge resource charges at actual in two ways. You can enter an actual rate for the resource using the Open Resource Transaction Interface or you can use the Persons window. The system computes the resources variances accordingly.

Actual Outside Processing Charges

Outside processing resources can be charged at standard rate or actual. Oracle Purchasing computes purchase price variances accordingly.

Overhead Charging

Overhead costs are appropriately charged as you charge resources. You can define overheads to be charged based on Resource units or Resource value, Lot, or Item. Oracle Work in Process calculates the appropriate overhead charge as you charge the resource. Oracle Work Overhead charges are automatically reversed as you reverse underlying resource charges. See: Default Basis Types, Oracle Cost Management User's Guide.

Resource Costs and Overheads for Phantoms

You have the option to include resource and overhead charges in the cost of the parent or higher level assembly. This feature is enabled when you set up the Oracle Bills of Material BOM:Use Phantom Routings parameter to have “Yes" as its value. You set this parameter at the inventory organization level and it applies to all phantoms within a single inventory organization. Routing resources and their costs are then also included in capacity planning.

Related Topics

Overview of Resource Management

Setting Up Resource Management

Resource Transaction Options

Open Resource Transaction Interface

You can load resource transaction information into the Open Resource Transaction Interface table from external sources such as bar code readers and payroll systems. The resource cost transaction manager, launched in Oracle Inventory, processes and validates this information to ensure accuracy and compatibility with other Oracle Applications information.

Resource transaction information that fails validation or processing is marked. You can use the Pending Resource Transactions window to view, update, and resubmit this information.

Related Topics

Processing Pending Resource Transactions

Transaction Managers, Oracle Inventory User's Guide

Resource Transaction Options

You can transact resources or reverse resource charges:

Charging Resources Manually

Manual resources can be charged to discrete jobs and repetitive schedules that have statuses of Released or Complete. Resources are charged based on how they are defined at the operation they are assigned.

Ad Hoc Resource Requirements

You can charge resources that are not assigned to job or repetitive schedule routing operations thus creating ad hoc resource requirements. You can choose to add ad hoc resources of any charge type - Manual, PO Move, PO Receipt, or WIP Move - however ad hoc resources are actually added as Manual resources and have with a required quantity of zero.

Prerequisites

To add, charge, or add and charge a resource

  1. Navigate to the Resource Transactions window.

    the picture is described in the document text

  2. Select a Sales Order, repetitive Line and Assembly, Assembly, or Job. The cursor defaults to one of these fields based on how the TP:WIP:Resource Transactions First Field profile option is set. See: Profile Option Descriptions.

    You must select a discrete job or repetitive line and assembly with a status of Released or Complete.

  3. Enter the transaction Date and time.

  4. Check the Find Manual Resources check box to find the manual resources operations for the Job or Line/Schedule.

    Note: Be aware that costed, manual resources on the manufacturing routing are part of the standard cost for the assembly you are building. If you do not apply the correct number of resource units, you may have a variance on the job or repetitive schedule.

  5. Enter the range of operation sequence numbers to transact manual resources.

  6. Check the Count Points Only check box to find only the count point operations for the Job or Line/Schedule. See: Count Point and Autocharge Fields, Oracle Bills of Material User's Guide.

  7. Choose the Transact button. The Resource Transactions window appears.

    the picture is described in the document text

  8. Select the Operation Sequence.

  9. Enter or select the Resource Sequence.

  10. In the Transaction tabbed region, enter or select a resource.

    You can select any resource associated with the department of the operation or any multi-departmental resource.

  11. Optionally, select the Employee.

    If you enter an employee, you can charge job or schedule resources at the employee's effective rate. If you do not specify an employee, the resource is charged at the standard rate for the person-type resource.

  12. Select the UOM. See: Overview of Units of Measure, Oracle Inventory User's Guide.

    You can use any valid, alternate unit of measure for the assembly you are moving.

  13. Enter the transaction Quantity.

    Enter the number of units charged by the resource. If you enter an amount different from the standard for a resource that is part of your standard manufacturing routing, a cost variance is incurred. All charges for 'ad hoc' resources, represent a cost variance.

    Note: If you add a manual resource, the transaction quantity is blank. The resource is not transacted unless you enter a transaction quantity.

  14. Select the Activity. See: Defining Activities and Activity Costs, Oracle Cost Management User's Guide.

    The enabled activity, if any, associated with the resource is displayed.

To enter additional resource transaction information

  1. In the Comments tabbed region, select the Operation sequence.

  2. Optionally, select the Reason code. See: Defining Transaction Reasons, Oracle Inventory User's Guide.

  3. Optionally, enter the transaction Reference.

    References can be used to identify transactions on standard reports. They can be up to 240 characters of alpha numeric text.

Related Topics

Overview of Resource Transactions

Overview of Work in Process Costing

Adding and Updating Operations

Overview of Resource Requirements

Adding and Updating Resource Requirements

Transaction Control by Status

Charging Resources with Move Transactions

You can charge manual resources as you move assemblies by choosing the Resources button. The system automatically displays the resources you should charge based upon the move. When you perform a move transaction across more than one repetitive schedule, only manual resources associated with the first schedule are displayed.

You can also add and charge resources not already associated with a job or repetitive schedule. You can add a resource regardless of the autocharge type. When you add a resource with an autocharge type of PO move, PO receipt, or WIP move, the system adds the resource to the job or repetitive schedule as a manual resource.

If you add a standard operation that has manual resources in the Move Transactions window, then complete assemblies at that operation, the system automatically displays the resources you should charge.

Prerequisites

To manually transact a resource with a move

  1. Perform a Move Transaction. See: Performing Move Transactions.

  2. Choose the Resources button. The Resource Transactions window appears.

    the picture is described in the document text

  3. Perform a Resource Transaction. See: Charging Resources Manually.

    Note: The Reason, if any, entered for the move transaction is displayed as the default.

Related Topics

Setting Up Resource Management

Overview of Resource Transactions

Viewing Resource Transactions

You can find and view resource transactions for an individual job or schedule using the View Resource Transactions window. This window enables you to view resource transactions across jobs and schedules, and access subledger accounting transaction windows in Oracle Cost Management. You can choose to view only resource and overhead transactions, or also include variance transactions in the display.

To find and view resource transactions

  1. Navigate to the View Resource Transactions window. The Find Resource Transactions window first appears.

    You can query to find resource transactions by Transaction Date range, Job or Schedule, Line, Assembly, Department, Resource, Employee Number, Activity, PO Number, and Transferred to Projects values.

    the picture is described in the document text

  2. Enter any combination of search criteria.

    For the Include Variance Transactions check box, when the check box is:

  3. Choose Find. The results display in the View Resource Transactions window.

    the picture is described in the document text

  4. Select the following tabs to view information:

  5. You can access accounting windows by choosing Distributions, and using options in the Tools menu:

Related Topics

Resource Transactions Options

Viewing WIP Transaction Distributions, Oracle Cost Management User's Guide

Overview of Subledger Accounting (SLA), Oracle Cost Management User's Guide

Setting Up Cost Management Subledger Accounting , Oracle Cost Management User's Guide

Viewing Accounting Lines

When you query a resource transaction in Oracle Work in Process, you can choose to view the detail accounting lines for the queried transaction in the form of a balanced accounting entry (such as debits equal credits). You can also choose to view the detail accounting as t-accounts. Use these features to see how a transaction will affect the account balances in your general ledger.

To view accounting lines and t-accounts

  1. Query the resource transaction for which you want to view accounting lines.

  2. From the Tools menu, choose View Accounting.

    The View Resource Accounting window opens.

    the picture is described in the document text

  3. To view the accounting detail, choose T-Accounts.

    View Accounting Windows

    The first time you open the View Resource Accounting window, the following information will be displayed for the detailed accounting lines:

    Account Line
    Accounting Date Line Type
    Assembly Operation Sequence
    Basis Primary Quantity
    Cost Element Reference
    Credit Resource
    Curr Conversion Rate Resource Sequence
    Debit Set of Books Short Name
    Department Trans Reason
    Entered Credit Trans Source
    Entered Curr Transaction Class
    Entered Debit Transaction Date
    Flow Schedule Transaction Num
    GL Batch Transaction Type
    Inventory Organization Code Unit Cost
    Job UOM

    When you select a detailed accounting line, the system displays the following information at the bottom of the View Resource Accounting window:

    Account Desc Line
    Assembly Quantity
    Basis Resource
    Flow Schedule Unit Cost
    Job UOM

    Customizing the View Accounting Window

    The View Resource Accounting window is a folder. You can easily customize the information that is displayed in the window. When you select a detailed accounting line, the system displays additional information at the bottom of the View Resource Accounting window.

    Drilling Down to Oracle Work in Process from Oracle General Ledger

    From General Ledger, you can drill down to subledger details from the Account Inquiry, Journal Entry Inquiry, or Enter Journals windows for journals that have specific journal sources assigned to them. For example, if a journal source is WIP, you can drill down to the transaction details in Oracle Work in Process.

    When you drill down from General Ledger, the WIP Accounting Lines window will open. The first time you open this window, the following information will be displayed:

    Accounting Date Line
    Assembly Line Type
    Basis Operation Sequence
    Cost Element Primary Quantity
    Credit Reference
    Currency Resource
    Curr Conversion Rate Resource Sequence
    Debit Trans Reason
    Entered Credit Trans Source
    Entered Curr Transaction Date
    Entered Debit Transaction ID
    Flow Schedule Transaction Type
    GL Batch Unit Cost
    Job UOM

    When you select a detailed accounting line, the system displays the following information at the bottom of the window:

    Assembly Quantity
    Basis Resource
    Flow Schedule Unit Cost
    Job UOM
    Line  

    From the WIP Accounting Lines window, you can drill down even further to view detail transactions or you can choose to view the underlying transaction accounting.

    To drill down to detail transactions or to view transaction accounting

    1. From the WIP Accounting Lines window, select a detail accounting line.

    2. Choose the Show Transaction button to view detail transactions.

    3. Choose the Show Transaction Accounting button to view the transaction accounting.

      Viewing Accounting Lines

Finding Pending Resource Transactions

You can find pending resource transactions for an individual job or schedule name. You can also find pending resource transactions for multiple jobs and schedules simultaneously.

You can find pending resource transactions by a range of Transaction Dates, Organization, Job or Schedule Name, Line, Process Phase (Move validation, Move processing, or Backflush setup), Process Status (Pending, Running, or Error), Source Code, Source Line ID, and Transaction ID. You can limit or expand your selection by combining selection criteria.

To find pending resource transactions

  1. Navigate to the Pending Resources Transactions window. The Find Pending Resources Transactions window appears.

    the picture is described in the document text

  2. Enter any combination of search criteria and choose the Find button. The Pending Resource Transactions window appears with the results of your query.

    the picture is described in the document text

Related Topics

Processing Pending Resource Transactions

Processing Pending Resource Transactions

You can view, update, delete, and resubmit resource transactions that have failed validation and remain in the Open Resource Transaction Interface table (WIP_RESOURCE_TNX_INTERFACE). You can also resubmit transactions whose concurrent process has failed and have a processing phase of Complete and process status of Error. You can view error messages associated with failed records. Error messages can assist you in updating failed records before resubmission.

To find pending resource transactions

  1. See: Finding Pending Resource Transactions.

To view pending resource transaction records

  1. Navigate to the Pending Resources Transactions window. The Find Pending Resource Transactions window appears.

    the picture is described in the document text

    You can find pending records by Transaction Date range, by Organization, by Job, Schedule Name, and production Line. You can also search for records that have a specific Process Phase (Move validation, Move processing, or Backflush setup, Process Status (Pending, Running, or Error), Source Code, Source Line ID, or Transaction ID.

  2. Enter any combination of search criteria and choose the Find button. The Pending Resource Transactions window appears with the results of your query.

    the picture is described in the document text

To view pending resource transaction records

  1. For each pending record displayed, you can view the following information using the Pending Resource Transactions window's tabbed regions:

    Processing: Group ID, processing Phase, processing Status

    Source: Source Code, Source Line (if applicable), Created By

    Concurrent Request: Request ID, Phase, Status, Message

    Job or Schedule Name: Organization, Job, Schedule Name, Line

    Operations: Operation Sequence, Department, resource Sequence, resource Name, resource Type, Employee Number

    Resource: Activity, Charge Type, PO Number, Currency, Actual Rate

    Transaction: UOM, Quantity, Date and Time, Type

    You can also view the descriptive flexfield information entered for the transaction record. See: Setting Up Descriptive Flexfields.

To view error details for failed resource transactions

  1. In the Pending Resource Transactions window, select the failed record.

  2. Choose the Errors button. The Pending Resource Transactions Error window appears.

    the picture is described in the document text

    All errors for the selected transaction are displayed. Column indicates the name of the column in the resource transaction interface table that failed validation. Message indicates why the transaction failed.

    Messages that are not specific to a Column, for example processing errors, may also be displayed. In such cases, a Message but no Column is shown.

To update failed resource transaction records

  1. Select the record to update.

    You can update records with a processing status of Error.

  2. In the Source tabbed region, enter the Source Code and Source Line.

    When you insert records into the Open Resource Transaction Interface table, you can optionally identity a record's source using the source code and source line. For example, you can enter a different source code and source line for records from a bar code reader versus those from a radio frequency device.

  3. Select the Created By identifier.

    The name of the user that created the transaction is displayed. This field can be updated.

  4. In the Job or Schedule Name tabbed region, select the Organization.

    You can only select enabled organizations. See: Creating an Organization, Oracle Human Resources User's Guide.

  5. In the Operations tabbed regions, select the Operation Sequence for the resource.

    You can select any operation defined for the job or repetitive schedule.

  6. Select or enter the resource Sequence.

    You can update this field with any resource sequence defined for your operation or you can add a resource ad hoc by entering a new resource sequence. If you choose a predefined resource sequence, all fields specific to that resource are automatically populated.

  7. Select the Name.

    If you inserted an 'ad hoc' resource requirement into the Open Resource Transaction Interface table by entering a new resource sequence, you can select resources associated with the department of the operation or multi-departmental resources. All related fields are automatically populated based on your selection.

    If you choose a resource of type Person and the employee number has no value, you are prompted to enter an employee number.

    If you choose a resource type other than Person and the employee number has a value, you are prompted to clear the employee number.

  8. Select the Employee Number.

    If you have entered a person-type resource, you can update this field with any valid employee number.

  9. In the Resource tabbed region, select the Activity.

    You can select an activity defined for your organization or an activity that is not tied to any specific organization and is not inactive.

  10. Select the Currency code. .

  11. Enter the Actual Rate for your resource.

    This rate is used to determine the cost of a resource when the resource's standard rate option is set to No.

  12. In the Transaction tabbed region, select the UOM. See: Overview of Units of Measure, Oracle Inventory User's Guide.

    You can update this field with any resource alternate UOM that is not inactive.

  13. Enter the transaction Quantity.

    This is a quantity of the UOM which you are charging to a job or schedule. The job/schedule is costed at the resource standard, the employee rate, or the actual rate. You can update this field with any number.

  14. Enter the transaction Date and time.

    The date and time must fall within an open accounting period. It cannot be greater than the current date or less than the release date of the job or the earliest valid repetitive schedule.

  15. In the Comments tabbed region, select the Reason code. See: Defining Transaction Reasons, Oracle Inventory User's Guide.

  16. Enter the transaction Reference.

    References can be used to identify transactions on standard reports. They can be up to 240 characters of alpha numeric text.

  17. Save your work.

To resubmit individual failed resource transaction records

  1. In the Pending Resource Transactions window, check the transaction's Resubmit check box.

    You can resubmit transactions of any processing status. If you leave the check box unchecked you can still update your transaction record but the transaction manager does not process it again when polling the resource interface table.

  2. Save your work to resubmit the transaction.

    When you resubmit a transaction, the system nulls the Transaction ID, Group ID, and concurrent Request ID and changes the processing status to Pending. The resubmit level of the Resource Cost Transaction Manager determines at what specific start date and time or at what specific intervals transactions are processed.

To select and resubmit all failed resource transactions

  1. In the Pending Resource Transactions window, chose Select All for Resubmit from the Tools menu. .

    You can deselect selected transactions as required.

  2. Save your work to resubmit the transactions.

    When you resubmit transactions, the system nulls their Transaction IDs, Group IDs, and concurrent Request IDs, and changes their processing Statuses to Pending. The resubmit level of the Resource Cost Transaction Manager determines at what specific start date and time or at what specific intervals transactions are processed.

To delete pending resource transaction records

  1. In the Pending Resource Transactions window, select the transaction.

  2. Choose Delete from the Edit Menu

    You can delete failed records that have a processing status of Error regardless of their processing phase. When you delete transaction records, their corresponding error messages are also deleted.

Related Topics

Open Resource Transaction Interface, Oracle Integration Repository at http://irep.oracle.com

Open Resource Transaction Interface

Overview of Resource Transactions

Changing Resources Manually

Charging Resources with Move Transactions

Adding and Updating Resource Requirements