Showing posts with label Work in Process (WIP). Show all posts
Showing posts with label Work in Process (WIP). Show all posts
Wednesday, May 19, 2010
WIP Accounting in Oracle Applications
Please send in your comments on applearn@gmail.com
Labels:
Cost Management,
SAM,
Work in Process (WIP)
Monday, March 9, 2009
Oracle WIP Tables
Oracle WIP Tables
WIP_PARAMETERS
WIP_DISCRETE_JOBS
WIP_ENTITIES
WIP_OPERATIONS
WIP_REQUIREMENT_OPERATIONS
WIP_OPERATION_RESOURCES
WIP_ACCOUNTING_CLASSES
WIP_EMPLOYEE_LABOR_RATES
WIP_INTERFACE_ERRORS
WIP_MOVE_TRANSACTIONS
WIP_MOVE_TXN_INTERFACE
WIP_OPERATION_OVERHEADS
WIP_OPERATION_RESOURCES
WIP_OPERATION_RESOURCE_USAGE
WIP_PERIOD_BALANCES
WIP_SHOP_FLOOR_STATUSES
WIP_SO_ALLOCATIONS
WIP_TRANSACTIONS
WIP_TRANSACTION_ACCOUNTS
-
WIP_PARAMETERS
WIP_DISCRETE_JOBS
WIP_ENTITIES
WIP_OPERATIONS
WIP_REQUIREMENT_OPERATIONS
WIP_OPERATION_RESOURCES
WIP_ACCOUNTING_CLASSES
WIP_EMPLOYEE_LABOR_RATES
WIP_INTERFACE_ERRORS
WIP_MOVE_TRANSACTIONS
WIP_MOVE_TXN_INTERFACE
WIP_OPERATION_OVERHEADS
WIP_OPERATION_RESOURCES
WIP_OPERATION_RESOURCE_USAGE
WIP_PERIOD_BALANCES
WIP_SHOP_FLOOR_STATUSES
WIP_SO_ALLOCATIONS
WIP_TRANSACTIONS
WIP_TRANSACTION_ACCOUNTS
-
Monday, December 29, 2008
What is Assemble-to-Order (ATO) Manufacturing ?
What is Assemble-to-Order (ATO) Manufacturing ?
ATO simplifies the process of manufacturing finished goods. These goods are standard products and are often configured by customers from Bills of material, where you can define available options for unique product configurations. Based on forecasting, subassemblies are manufactured prior to receiving the customer order and when the order is received, the stocked subassemblies and components are assembled to make the finished products. It is an environment where you open a final assembly order to assemble items that customers orders. It is manufacturing method/strategy which allows a product to be made or service to be available to meet the needs of a specific customer order. While producing finished goods on a large scale, this requires sophisticated planning processes which master schedules ATO models and options and then create work orders to build the unique configuration in WIP module while maintaining control of inventory, planning, cost accounting and Bills of Material. Planning process also anticipates changing demand for external or internal components or accessories and at the same time focuses on product customizations for individual customers.
WIP, Order Management and Shipping modules support building and shipping of ATO configurations. A discrete job is created from a configuration. An assemble to order item/assembly then can be linked to a sales order. Assemble-to-order is also an item attribute in Inventory module that you can apply to standard, model, and option class items. In Bills of Material module, a model bill can be either assemble-to-order or pick-to-order and an option class bill can be either assemble-to-order or pick-to-order. Assemble–to–Order Model (ATO Configuration) is a Model bill of material with optional items and option selection rules or Configuration manufactured from mandatory components and selected options, or purchased from a supplier. An ATO model can have ATO option class, ATO Option item, PTO Option Class and PTO Option item under it. ATO Model can be a finished good or it be a part of another bills i.e it is component on another bill. Assemble-to-Order Item is a Standard bill of material with mandatory standard components or Item manufactured from mandatory standard components, or purchased from a supplier.
For Example: Automobiles, computer manufacturing.
Suppose you want to produce a laptop computer. Then, it requires carrying case, key board, CPU, Monitor and Operating system. While defining a bills of material for laptop computer, you can define computer as ATO Model. A Model comes at the top of the configuration hierarchy, second comes the Option Class and then the Option item. Carrying case and keyboard are purchased items under the bill of laptop. CPU, monitor and Operating system are option classes and 386 processor and 486 processor are optional items under the option class CPU. Similarly ,you can have optional item under other option classes. It is quite possible that ATO Model itself is component on another bills of material.
ATO simplifies the process of manufacturing finished goods. These goods are standard products and are often configured by customers from Bills of material, where you can define available options for unique product configurations. Based on forecasting, subassemblies are manufactured prior to receiving the customer order and when the order is received, the stocked subassemblies and components are assembled to make the finished products. It is an environment where you open a final assembly order to assemble items that customers orders. It is manufacturing method/strategy which allows a product to be made or service to be available to meet the needs of a specific customer order. While producing finished goods on a large scale, this requires sophisticated planning processes which master schedules ATO models and options and then create work orders to build the unique configuration in WIP module while maintaining control of inventory, planning, cost accounting and Bills of Material. Planning process also anticipates changing demand for external or internal components or accessories and at the same time focuses on product customizations for individual customers.
WIP, Order Management and Shipping modules support building and shipping of ATO configurations. A discrete job is created from a configuration. An assemble to order item/assembly then can be linked to a sales order. Assemble-to-order is also an item attribute in Inventory module that you can apply to standard, model, and option class items. In Bills of Material module, a model bill can be either assemble-to-order or pick-to-order and an option class bill can be either assemble-to-order or pick-to-order. Assemble–to–Order Model (ATO Configuration) is a Model bill of material with optional items and option selection rules or Configuration manufactured from mandatory components and selected options, or purchased from a supplier. An ATO model can have ATO option class, ATO Option item, PTO Option Class and PTO Option item under it. ATO Model can be a finished good or it be a part of another bills i.e it is component on another bill. Assemble-to-Order Item is a Standard bill of material with mandatory standard components or Item manufactured from mandatory standard components, or purchased from a supplier.
For Example: Automobiles, computer manufacturing.
Suppose you want to produce a laptop computer. Then, it requires carrying case, key board, CPU, Monitor and Operating system. While defining a bills of material for laptop computer, you can define computer as ATO Model. A Model comes at the top of the configuration hierarchy, second comes the Option Class and then the Option item. Carrying case and keyboard are purchased items under the bill of laptop. CPU, monitor and Operating system are option classes and 386 processor and 486 processor are optional items under the option class CPU. Similarly ,you can have optional item under other option classes. It is quite possible that ATO Model itself is component on another bills of material.
Sunday, December 28, 2008
Which are different types of discrete jobs ?
Which are different types of discrete jobs ?
There are 2 types of discrete jobs 1) Standard and 2) Non-Standard
Non Standard discrete jobs are further devided in to Non standard Asset jobs and non-standard expense jobs. Standard discrete jobs control the material, resources, and operations which are required to build an assembly and collect its manufacturing cost.
Some comparison is done as below:
1) Non-standard discrete jobs control material and collect costs for miscellaneous manufacturing activity. They may or may not build an assembly. This type of activity can include rework, field service repair, upgrade, disassembly, maintenance, engineering prototypes and other projects.
2) Non-standard jobs are more flexible than standard jobs. Because of this, they can be used to manage such different activities as rework, field service repair, upgrades, disassembly, maintenance, engineering prototypes and other miscellaneous projects.
3) MS/MRP module does not create planned orders or reschedule recommendations for non-standard jobs like standard jobs. You must manually define and reschedule non-standard jobs. However, if a non-standard job is assigned an assembly bill of material, a routing, or both, MS/MRP considers the job’s material requirements as demand and its assemblies as supply. Oracle Capacity module considers resource load for non-standard jobs.
4) MS/MRP does not deduct scrapped assemblies from the MRP net quantity, or deduct the MRP net quantity by the item shrinkage rate for non-standard jobs. As such, you must identify planned assembly shrinkage by entering an MRP net quantity that is less than the job quantity.
5) Non-standard expense jobs are period costed and are not subject to cost updates, whereas standard discrete and asset type non-standard jobs are job costed i.e. costed when job is closed and are automatically revalued by the cost update.
6) Non-standard discrete jobs do not earn overhead on completion. Instead material overhead at completion is posted directly to the subinventory material overhead account.
7) Work in Process does not implement engineering change orders (ECOs) on non-standard jobs like it does on standard jobs
8) You can use a bill and routing from another assembly in non-standard jobs. For example, you can set up a standard upgrade routing to use for a group of assemblies.
9) For non-standard jobs, you can define bill of material loops, that is, you can define the assembly itself as a requirement on its bill. This is useful for upgrade, disassembly, and repair activities.
10) You can return a greater quantity of assemblies to non-standard discrete jobs than you completed into inventory.
11) Non standard asset jobs create assets/assemblies and are job costed. For example repair jobs where as Non-standard expense jobs do not create any assets and are period costed,For example maintenance jobs. Due to this, you need to define separate WIP accounting class for each.
There are 2 types of discrete jobs 1) Standard and 2) Non-Standard
Non Standard discrete jobs are further devided in to Non standard Asset jobs and non-standard expense jobs. Standard discrete jobs control the material, resources, and operations which are required to build an assembly and collect its manufacturing cost.
Some comparison is done as below:
1) Non-standard discrete jobs control material and collect costs for miscellaneous manufacturing activity. They may or may not build an assembly. This type of activity can include rework, field service repair, upgrade, disassembly, maintenance, engineering prototypes and other projects.
2) Non-standard jobs are more flexible than standard jobs. Because of this, they can be used to manage such different activities as rework, field service repair, upgrades, disassembly, maintenance, engineering prototypes and other miscellaneous projects.
3) MS/MRP module does not create planned orders or reschedule recommendations for non-standard jobs like standard jobs. You must manually define and reschedule non-standard jobs. However, if a non-standard job is assigned an assembly bill of material, a routing, or both, MS/MRP considers the job’s material requirements as demand and its assemblies as supply. Oracle Capacity module considers resource load for non-standard jobs.
4) MS/MRP does not deduct scrapped assemblies from the MRP net quantity, or deduct the MRP net quantity by the item shrinkage rate for non-standard jobs. As such, you must identify planned assembly shrinkage by entering an MRP net quantity that is less than the job quantity.
5) Non-standard expense jobs are period costed and are not subject to cost updates, whereas standard discrete and asset type non-standard jobs are job costed i.e. costed when job is closed and are automatically revalued by the cost update.
6) Non-standard discrete jobs do not earn overhead on completion. Instead material overhead at completion is posted directly to the subinventory material overhead account.
7) Work in Process does not implement engineering change orders (ECOs) on non-standard jobs like it does on standard jobs
8) You can use a bill and routing from another assembly in non-standard jobs. For example, you can set up a standard upgrade routing to use for a group of assemblies.
9) For non-standard jobs, you can define bill of material loops, that is, you can define the assembly itself as a requirement on its bill. This is useful for upgrade, disassembly, and repair activities.
10) You can return a greater quantity of assemblies to non-standard discrete jobs than you completed into inventory.
11) Non standard asset jobs create assets/assemblies and are job costed. For example repair jobs where as Non-standard expense jobs do not create any assets and are period costed,For example maintenance jobs. Due to this, you need to define separate WIP accounting class for each.
Which are the different methods for creating Discrete jobs in Oracle WIP ?
Which are the different methods for creating Discrete jobs in Oracle WIP ?
You can create discrete jobs in the following ways:
a) Manually (both standard and non-standard discrete jobs)
b) Manually from a simulation of job (standard discrete jobs only)
c) Automatically using Oracle MRP module to plan your standard discrete production requirements
d) Automatically using Advanced Planning and Scheduling’s High Level Scheduling Engine to schedule jobs and import them into Work in Process
e) Automatically (standard discrete jobs only) from final assembly orders for specific customer configurations and/or standard assemble-to-order(ATO)/configure-to-order items
f) Using the Work Order Interface to import planned orders and updated planned order recommendations
You can create discrete jobs in the following ways:
a) Manually (both standard and non-standard discrete jobs)
b) Manually from a simulation of job (standard discrete jobs only)
c) Automatically using Oracle MRP module to plan your standard discrete production requirements
d) Automatically using Advanced Planning and Scheduling’s High Level Scheduling Engine to schedule jobs and import them into Work in Process
e) Automatically (standard discrete jobs only) from final assembly orders for specific customer configurations and/or standard assemble-to-order(ATO)/configure-to-order items
f) Using the Work Order Interface to import planned orders and updated planned order recommendations
WIP Profle option - WIP:configuration Reservation Level
When I link a sales order to a job in the Discrete Job screen, after I complete this Discrete Job I have my Finish good item reserved in a "Subinventory 1", but I need to transfer it to "Subinventory 2", but I can't transfer because the material is reserved. I use 2 subinventories because one is for inspection and the second is the Sales Subinventory. What should I do?
You may set the Profile Option WIP:configuration Reservation Level to 'Item'. It indicates that the completed configuration (Assemblies) will be reserved at organization level in the inventory without subinventory and locator information. In that case, you will be able to transfer materials from Inspection Subinventory to Sales Subinventory.
You may set the Profile Option WIP:configuration Reservation Level to 'Item'. It indicates that the completed configuration (Assemblies) will be reserved at organization level in the inventory without subinventory and locator information. In that case, you will be able to transfer materials from Inspection Subinventory to Sales Subinventory.
What is a Scheduled Group?
What is a Scheduled Group ?
A schedule group is group of flow schedules and discrete jobs which can be sequenced for the purpose of giving priority. Schedule groups are defined in the Define Schedule Groups window and can be optionally assigned to jobs, in the Discrete Jobs window, or to Flow schedules, in the Line Scheduling Workbench Options window. The schedule group assigned in the Line Scheduling Workbench Options window can be overridden in the Work Order-less Completions window, but only with a schedule group that is associated with a Flow schedule (an not associated with discrete job)
Sequencing is done by assigning a unique schedule number to each job or Flow schedule within a scheduled group.
You can assign flow schedules and discrete jobs to the schedule groups you define as per your requirement. Sequencing jobs and flow schedules within a schedule group makes it possible to prioritize, for example, by customer the jobs or Flow schedules being built on a specific production line.
You can update schedule groups but cannot delete schedule groups that are assigned to jobs and flow schedules. For example, you can create a Week01 schedule group to identify which jobs are to be released and built during the first week of your current production cycle.
A schedule group is group of flow schedules and discrete jobs which can be sequenced for the purpose of giving priority. Schedule groups are defined in the Define Schedule Groups window and can be optionally assigned to jobs, in the Discrete Jobs window, or to Flow schedules, in the Line Scheduling Workbench Options window. The schedule group assigned in the Line Scheduling Workbench Options window can be overridden in the Work Order-less Completions window, but only with a schedule group that is associated with a Flow schedule (an not associated with discrete job)
Sequencing is done by assigning a unique schedule number to each job or Flow schedule within a scheduled group.
You can assign flow schedules and discrete jobs to the schedule groups you define as per your requirement. Sequencing jobs and flow schedules within a schedule group makes it possible to prioritize, for example, by customer the jobs or Flow schedules being built on a specific production line.
You can update schedule groups but cannot delete schedule groups that are assigned to jobs and flow schedules. For example, you can create a Week01 schedule group to identify which jobs are to be released and built during the first week of your current production cycle.
What are shop floor statuses in Oracle WIP ?
What are shop floor statuses in Oracle WIP ?
You define shop floor statuses in WIP and assign these statuses to intraoperation steps of the work in process routing operations. Shop floor statuses can be used to control/stopping shop floor move transactions due to various reasons. For example there could be some quality problem in the materials being used in manufacturing. You can view these statuses during move transactions you can define as many shop floor statuses as are required.
When assigned to an intraoperation step of an operation that is associated with a particular repetitive line and assembly, the status applies to all repetitive schedules building that assembly on that line. You can remove or unassign shop floor statuses once your problem is over.
You define shop floor statuses in WIP and assign these statuses to intraoperation steps of the work in process routing operations. Shop floor statuses can be used to control/stopping shop floor move transactions due to various reasons. For example there could be some quality problem in the materials being used in manufacturing. You can view these statuses during move transactions you can define as many shop floor statuses as are required.
When assigned to an intraoperation step of an operation that is associated with a particular repetitive line and assembly, the status applies to all repetitive schedules building that assembly on that line. You can remove or unassign shop floor statuses once your problem is over.
WIP accounting classes
What is WIP accounting class ?
Which are different accounting classes in WIP ?
Which different accounts are associated with it ?
An accounting class is a group of various General Ledger accounts which allows you to arrive at job cost, production cost and maintenance costs.
The following are different accounting classes in Oracle WIP:
1) Standard discrete
Standard discrete accounting classes can be used to group job costs for building subassemblies and finished goods on shop floor. You can define and attach this accounting classes so that you can separately value and report the costs associated with subassembly and finished goods production.
2) Asset non standard discrete
If you use non-standard discrete jobs to track production costs as assets, you can define and assign an accounting class with a type of asset non-standard. Asset non-standard discrete jobs are costed the same as standard discrete jobs. Valuation accounts are charged when material is issued to a job and final costs and variances are calculated and posted to the appropriate variance and valuation accounts when the job is closed.
3) Expense non-standard discrete
Non-standard discrete accounting classes can be used to group and report various types of non-standard production costs, such as field service repair. For example to track recurring expenses - machine maintenance or engineering projects- with non-standard jobs, you can define and assign an accounting class with a type ofexpense non-standard to these jobs. The valuation accounts carry the costs incurred on these expense jobs as an asset during the period and automatically writes them off to the variance accounts at period close.
4) Repetitive accounting class
Repetitive accounting classes are used to group production costs and must be assigned to each repetitive line/assembly association that is created. Every repetitive schedule for that assembly on that line uses these accounts.
5) Standard Lot based
Standard lot based jobs control the material, resources, and operations required to build an assembly and collect costs. When you build lot based jobs, the standard lot based accounting class is used to separately value and report costs associated with yielded production at each individual operation on the routing.
6) Expense non standard lot based
Expense non-standard lot based accoubting class jobs control material and collects costs for miscellaneous activity. These jobs are used for expense work orders for testing, prototypes, and rework where operation yield costing is not considered. You can perform all transactions (moves, jumps, scrap, splits, and update assemblies or routings) with the exception of job merge.
7) Maintenance accounting class
Maintenance accounting classes are used to group costs for work orders used in Oracle Enterprise Asset Management (eAM) Module . For example, if you are creating work orders for plant maintenance activities, you can define your accounting classes to separately value and report the costs related to asset.
The following valuation and variance accounts are associated with each accounting class.
Valuation accounts
1) Material account
2) Material overhead
3) Resouce
4) Overhead
5) Outside Processing
Variance accounts
1) Material account
2) Material overhead
3) Resouce
4) Overhead
5) Outside Processing
6) Standard cost
7) Bridging
8) Expense
Standard cost account is applicable to only standard costing method and Bridging and Expense accounts are applicable to average costing method only. Rest all accounts are appliable to both standard and avergae costing methods.
Which are different accounting classes in WIP ?
Which different accounts are associated with it ?
An accounting class is a group of various General Ledger accounts which allows you to arrive at job cost, production cost and maintenance costs.
The following are different accounting classes in Oracle WIP:
1) Standard discrete
Standard discrete accounting classes can be used to group job costs for building subassemblies and finished goods on shop floor. You can define and attach this accounting classes so that you can separately value and report the costs associated with subassembly and finished goods production.
2) Asset non standard discrete
If you use non-standard discrete jobs to track production costs as assets, you can define and assign an accounting class with a type of asset non-standard. Asset non-standard discrete jobs are costed the same as standard discrete jobs. Valuation accounts are charged when material is issued to a job and final costs and variances are calculated and posted to the appropriate variance and valuation accounts when the job is closed.
3) Expense non-standard discrete
Non-standard discrete accounting classes can be used to group and report various types of non-standard production costs, such as field service repair. For example to track recurring expenses - machine maintenance or engineering projects- with non-standard jobs, you can define and assign an accounting class with a type ofexpense non-standard to these jobs. The valuation accounts carry the costs incurred on these expense jobs as an asset during the period and automatically writes them off to the variance accounts at period close.
4) Repetitive accounting class
Repetitive accounting classes are used to group production costs and must be assigned to each repetitive line/assembly association that is created. Every repetitive schedule for that assembly on that line uses these accounts.
5) Standard Lot based
Standard lot based jobs control the material, resources, and operations required to build an assembly and collect costs. When you build lot based jobs, the standard lot based accounting class is used to separately value and report costs associated with yielded production at each individual operation on the routing.
6) Expense non standard lot based
Expense non-standard lot based accoubting class jobs control material and collects costs for miscellaneous activity. These jobs are used for expense work orders for testing, prototypes, and rework where operation yield costing is not considered. You can perform all transactions (moves, jumps, scrap, splits, and update assemblies or routings) with the exception of job merge.
7) Maintenance accounting class
Maintenance accounting classes are used to group costs for work orders used in Oracle Enterprise Asset Management (eAM) Module . For example, if you are creating work orders for plant maintenance activities, you can define your accounting classes to separately value and report the costs related to asset.
The following valuation and variance accounts are associated with each accounting class.
Valuation accounts
1) Material account
2) Material overhead
3) Resouce
4) Overhead
5) Outside Processing
Variance accounts
1) Material account
2) Material overhead
3) Resouce
4) Overhead
5) Outside Processing
6) Standard cost
7) Bridging
8) Expense
Standard cost account is applicable to only standard costing method and Bridging and Expense accounts are applicable to average costing method only. Rest all accounts are appliable to both standard and avergae costing methods.
Labels:
Cost Management,
SAM,
VKD,
Work in Process (WIP)
Saturday, December 27, 2008
Explain the field 'Respond to sales order changes' in Oracle WIP parameters ?
Explain the field 'Respond to sales order changes' in Oracle WIP parameters ?
This field is applicable to configure-to-Order (CTO) sales orders and their related discrete jobs. It determines whether and how the system responds to changes to CTO sales orders and their linked and reserved discrete jobs/work orders (Both standard and Non-standard).
You can set the following options if a configured item is de-linked from a sales order or sales order line placed on hold.
a) Never
The corresponding work order will not be placed on hold if you de-link the configured item from the sales order, or if the sales order is placed on hold.
b) Always
The work order will be placed on hold if you de-link the configured item from the sales order, or if the sales order is placed on hold.
c) When Linked 1 to 1
The work order will be placed on hold if it is the only work order reserved to
that sales order. If there are more than one work orders for the sales order, this will not happen. If you cancel sales order lines with ATO items, this parameter, is ignored by the system.
You cannot cancel jobs linked to sales orders without first undoing the links between them.
This field is applicable to configure-to-Order (CTO) sales orders and their related discrete jobs. It determines whether and how the system responds to changes to CTO sales orders and their linked and reserved discrete jobs/work orders (Both standard and Non-standard).
You can set the following options if a configured item is de-linked from a sales order or sales order line placed on hold.
a) Never
The corresponding work order will not be placed on hold if you de-link the configured item from the sales order, or if the sales order is placed on hold.
b) Always
The work order will be placed on hold if you de-link the configured item from the sales order, or if the sales order is placed on hold.
c) When Linked 1 to 1
The work order will be placed on hold if it is the only work order reserved to
that sales order. If there are more than one work orders for the sales order, this will not happen. If you cancel sales order lines with ATO items, this parameter, is ignored by the system.
You cannot cancel jobs linked to sales orders without first undoing the links between them.
Friday, December 26, 2008
What are intraoperation steps in Oracle WIP ?
What are intraoperation steps in Oracle WIP ?
There are 5 intra operation steps in WIP. The options are Queue, Run, To Move, Reject and Scrap. You can select intraoperation steps in WIP parameters by checking check boxes. It determines which intraoperation steps are enabled in WIP routing operations. The 'Queue' intraoperation step is automatically enabled for all operations and it cannot be disabled. The 'To Move' intraoperation step, even if disabled, is automatically enabled for the final operations in routings so that assemblies can be completed into inventory.
There are 5 intra operation steps in WIP. The options are Queue, Run, To Move, Reject and Scrap. You can select intraoperation steps in WIP parameters by checking check boxes. It determines which intraoperation steps are enabled in WIP routing operations. The 'Queue' intraoperation step is automatically enabled for all operations and it cannot be disabled. The 'To Move' intraoperation step, even if disabled, is automatically enabled for the final operations in routings so that assemblies can be completed into inventory.
What is Assemble-to-Order(ATO) Manufacturing ?
What is Assemble-to-Order(ATO) Manufacturing ?
You can define available options in Bills of Material for unique product configurations. You can master schedule models and options and then create work orders to build these unique product configuration in WIP while maintaining control of inventory, planning and cost accounting. Bills of Material, WIP and Order Management/Shipping modules support building and shipping of ATO configurations. A discrete job is created from a configuration or an assemble to order item and then can be linked to a sales order.
You can define available options in Bills of Material for unique product configurations. You can master schedule models and options and then create work orders to build these unique product configuration in WIP while maintaining control of inventory, planning and cost accounting. Bills of Material, WIP and Order Management/Shipping modules support building and shipping of ATO configurations. A discrete job is created from a configuration or an assemble to order item and then can be linked to a sales order.
What is Flow Manufacturing ?
What is Flow Manufacturing ?
Flow Manufacturing is an innovative manufacturing method which synchronizes production with customer demand.
The characteristics of flow processes are:
a) Straight and short product flow patterns
b) Make to order strategy
c) Single-piece production
d) Just-In-Time materials/pull/dependent demand scheduling
e) Short production cycle times
f) Highly flexible and responsive processes
g) Highly flexible machines and equipment
h) Quick changeover
i) Continuous flow work cells
j) Compressed space
k) Multi-skilled employees
l) Empowered employees
m) High first inspection - pass yields with major reductions in defects
Oracle Flow Manufacturing module supports the entire build-to-order manufacturing process which includes make-to-stock, configure-to-order, discrete-repetitive, assemble-to-order, and engineer-to-order manufacturing strategies and methods. It initiates schedules as soon as customer orders are received, and ensures shipment as soon as build is complete. Flow manufacturing employs pulls material using kanbans planning and backflushes material and costs upon completion. This in turn helps decrease inventories, optimize machine utilization, reduce response time to customer orders, and simplify shop floor activities.
Flow manufacturing production lines are designed to support the inter-mixed production of multiple products within a family on the same line at a constant rate. It can be used in Inventory module to replenish kanbans and in Work in Process to complete assemblies without having to create a job or a schedule (work order less job)
Flow Manufacturing is an innovative manufacturing method which synchronizes production with customer demand.
The characteristics of flow processes are:
a) Straight and short product flow patterns
b) Make to order strategy
c) Single-piece production
d) Just-In-Time materials/pull/dependent demand scheduling
e) Short production cycle times
f) Highly flexible and responsive processes
g) Highly flexible machines and equipment
h) Quick changeover
i) Continuous flow work cells
j) Compressed space
k) Multi-skilled employees
l) Empowered employees
m) High first inspection - pass yields with major reductions in defects
Oracle Flow Manufacturing module supports the entire build-to-order manufacturing process which includes make-to-stock, configure-to-order, discrete-repetitive, assemble-to-order, and engineer-to-order manufacturing strategies and methods. It initiates schedules as soon as customer orders are received, and ensures shipment as soon as build is complete. Flow manufacturing employs pulls material using kanbans planning and backflushes material and costs upon completion. This in turn helps decrease inventories, optimize machine utilization, reduce response time to customer orders, and simplify shop floor activities.
Flow manufacturing production lines are designed to support the inter-mixed production of multiple products within a family on the same line at a constant rate. It can be used in Inventory module to replenish kanbans and in Work in Process to complete assemblies without having to create a job or a schedule (work order less job)
What is Project Manufacturing ?
What is Project Manufacturing ?
Large contracts or projects received by the companies can not be completely fulfilled by process manufacturing or disrete or repetitive manufacturing methods. It requires a separate manufacturing method known as project manufacturing. Project manufacturing meets demand driven production requirements for large contracts or projects. It allows you to plan, schedule, process and cost against a specific contract or a group of contracts or project for a specific customer.
Oracle Project Manufacturing supports companies in the Engineer-To-Order, Make-To-Order manufacturing strategies and Aerospace and Defense industries. These industries plan, track, procure, and cost based on project, contract, or Seiban numbers.
If Oracle Projects is installed and the Project References Enabled and Project Control Level parameters are set in the Organization Parameters window in Inventory module, you can assign project and, if required, task references to planned orders, jobs, purchase orders, sales orders, miscellaneous transaction and other entities within Oracle Manufacturing. If the Project Cost Collection Enabled parameter is also set in inventory organization parameters, you can optionally collect and transfer manufacturing cost to Oracle Projects module. Project costs are tracked by project/task and expenditure type.
Large contracts or projects received by the companies can not be completely fulfilled by process manufacturing or disrete or repetitive manufacturing methods. It requires a separate manufacturing method known as project manufacturing. Project manufacturing meets demand driven production requirements for large contracts or projects. It allows you to plan, schedule, process and cost against a specific contract or a group of contracts or project for a specific customer.
Oracle Project Manufacturing supports companies in the Engineer-To-Order, Make-To-Order manufacturing strategies and Aerospace and Defense industries. These industries plan, track, procure, and cost based on project, contract, or Seiban numbers.
If Oracle Projects is installed and the Project References Enabled and Project Control Level parameters are set in the Organization Parameters window in Inventory module, you can assign project and, if required, task references to planned orders, jobs, purchase orders, sales orders, miscellaneous transaction and other entities within Oracle Manufacturing. If the Project Cost Collection Enabled parameter is also set in inventory organization parameters, you can optionally collect and transfer manufacturing cost to Oracle Projects module. Project costs are tracked by project/task and expenditure type.
Oracle WIP - Move transaction parameters

Explain move transaction parameters in Oracle WIP?
a) Require Scrap Account
This check box determines whether a scrap account is required when you use the Move Transactions window to move job and repetitive assemblies into and out of the Scrap intraoperation step of an operation. It also determines whether a scrap account is required when flow schedule assemblies are scrapped or returned from scrap through the Work Order-less Completions window. It is not madatory to keep scrap account. This parameter also determines how scrap transactions are processed. If you enter a scrap account, the system debits this account and credits the job or schedule elemental accounts through the operation at which the assemblies are scrapped. If you enter a reversing scrap transaction, the system credits this account and debits the job or schedule elemental accounts through the operation at which the assemblies are returned. If you do not provide a scrap account, the cost of scrap remains in the
job or schedule until job or period close and is then written off as a variance.
b) Allow Creation of New Operations
This check box determines whether you can or cannot add a new operation to a discrete job work in process routing during a move transaction. For example, you may want to add an operation to keep track of rework which you were not expecting.
c) Allow Moves Over No Move Shop Floor Statuses
This check box decides whether moves are disallowed if an intraoperation step that disallows moves exists at an autocharge operation and intraoperation step between the Setting Up From and To operations or at intervening intraoperation step at the From and To operations if they are direct charge. If an intraoperation step that disallows moves is found, a warning message is displayed and the move is disallowed. Allow Skipping Over No Move Statuses security function can be set to override no move shop floor statuses. Direct charge operations between the From and To Operations are not considered when the system checks for no move shop floor statuses. Scrap and Reject intraoperation steps at autocharge operations are also not considered.
For original post, please visit http://applearn.blogspot.com
Thursday, December 25, 2008
WIP Parameters - Backflush Transactions, Lot number generation
Which parameters affect backflush Transactions?
a) Supply Subinventory
b) Supply Locator
c) Lot Selection Method
d) Alternate Lot Selection Method
e) Lot Verification
f) Release Backflush Components
g) Allow Quantity Changes During Backflush
How lot numbers are assigned to discrete jobs?
a) By Job Name: Lot numbers are based on the job name you enter when you define the job. This is the default.
b) Based on Inventory Rules: Lot numbers are based on the lot number rules which you defined in Inventory parameters in Inventory module
a) Supply Subinventory
b) Supply Locator
c) Lot Selection Method
d) Alternate Lot Selection Method
e) Lot Verification
f) Release Backflush Components
g) Allow Quantity Changes During Backflush
How lot numbers are assigned to discrete jobs?
a) By Job Name: Lot numbers are based on the job name you enter when you define the job. This is the default.
b) Based on Inventory Rules: Lot numbers are based on the lot number rules which you defined in Inventory parameters in Inventory module
Wednesday, December 24, 2008
What is Backflush?
What is meant by backflush? When exactly backflush happens?
How can we detect that backflush is happening?
In Bills of Material module when you create a bill for any assembly or sub assembly or a finished good, you define component supply type for each component in a bill. These supply types are push, operation pull, assembly pull, Bulk, vendor/supplier, phantom etc. This Bills of material is used in Work in Process module for manufacturing a job. When you manufacture an assembly, it requires components at the shop floor as per the list given in a bill. If your supply type of a component is Push you have to manually issue components to shop floor for manufacturing process but if the supply type of a component is either assembly pull or operation pull, you need not to issue components manually to the shop floor but when a particular operation or an assembly is completed during manufacturing ie during move transactions or completion transactions, Oracle application system automatically backflushes components from the supply subinventory and locator Here ,backflushing means deduction( reducing) of required quantity from Inventory on hand quantity. In case of push supply type you have to deliver materials to shopfloor and deduct quantity yourself .Incase of backflushing you have to delivery materials to shopfloor and need not deduct quantity yourself but system( Oracle Applications) automatically deducts quantity from subinventory-locator on hand quantity when any assembly or an operation is completed in WIP module manufacturing process.
Once any assembly is completed in WIP, please go to inventory module and check the subinventory and locator quantity for the item for which assembly is completed. You will observe that on hand quantity has reduced .If total was 100 numbers and 10 numbers are pulled, by WIP assembly or operation pull, balance will be 90 numbers.
How can we detect that backflush is happening?
In Bills of Material module when you create a bill for any assembly or sub assembly or a finished good, you define component supply type for each component in a bill. These supply types are push, operation pull, assembly pull, Bulk, vendor/supplier, phantom etc. This Bills of material is used in Work in Process module for manufacturing a job. When you manufacture an assembly, it requires components at the shop floor as per the list given in a bill. If your supply type of a component is Push you have to manually issue components to shop floor for manufacturing process but if the supply type of a component is either assembly pull or operation pull, you need not to issue components manually to the shop floor but when a particular operation or an assembly is completed during manufacturing ie during move transactions or completion transactions, Oracle application system automatically backflushes components from the supply subinventory and locator Here ,backflushing means deduction( reducing) of required quantity from Inventory on hand quantity. In case of push supply type you have to deliver materials to shopfloor and deduct quantity yourself .Incase of backflushing you have to delivery materials to shopfloor and need not deduct quantity yourself but system( Oracle Applications) automatically deducts quantity from subinventory-locator on hand quantity when any assembly or an operation is completed in WIP module manufacturing process.
Once any assembly is completed in WIP, please go to inventory module and check the subinventory and locator quantity for the item for which assembly is completed. You will observe that on hand quantity has reduced .If total was 100 numbers and 10 numbers are pulled, by WIP assembly or operation pull, balance will be 90 numbers.
Sunday, December 21, 2008
Oracle WIP related Item attributes

Describe WIP related Item attributes ?
a) Build in WIP
If you check this attribute, it indicates whether to create discrete jobs or repetitive assemblies in Work in Process module. This attribute must be turned off if the Inventory Item attribute is turned off or if the BOM item Type attribute is not set to Standard. You can not manufacture any item if item is not an inventory item and BOM item type is not standard. This attribute is optionally set by the Item Status code in inventory module
b) Supply Type
You can select a supply type attribute for components when you define an item in Item Master Organization. Supply types decides the method of supplying component materials to discrete jobs and repetitive job/schedules in WIP module. It also controls how materials are planned in MS/MRP module and how materials are costed in Cost Management module
c) Supply Subinventory
This attribute is controlled at the Organization level only. When you define an item in Item Master Organization, you can enter the primary subinventory from which to issue (push) or backflush (pull) an item to work in process during manufacturing.
d) Supply Locator
This attribute is controlled at the Organization level only. When you define an item in Item Master Organization, you can enter the supply locator from which to issue (push) or backflush (pull) an item to work in process. You can also define a WIP supply locator for any bill that uses this item; the bill supply locator overrides the supply locator which you define in Item Master Organization form. It is necesary to enter a WIP supply subinventory before you can enter a supply locator.
Saturday, December 20, 2008
Supply Types in Oracle WIP
Explain the concept of Supply types in Oracle WIP? Describe each supply type in detail?
Supply types decides the method of supplying component materials to discrete jobs and repetitive schedules in WIP module. It also controls how materials are planned in MS/MRP module and how materials are costed in Cost Management module.
You can assign supply types to the items when you define in Inventory module. You can also assign supply types to components when you create bills of material in Bills of Material and Engineering modules. The following is a list of the WIP supply types and the way they work:
a) Push
Push components can be manually issued directly to discrete jobs and repetitive schedule as per requirements. You can specify the subinventory for items in Item definition form or in Bills or define default subinventory in WIP parameters form. Work in Process defaults the supply subinventory associated with the component.
b) Operation Pull:
Operation pull components that are assigned to backflush operations, are automatically backflushed (pulled) from inventory and issued to discrete jobs and repetitive schedules when assemblies are moved and completed at that operation i.e. when you complete backflush operations. Also, operation pull component that have not been backflushed because they are assigned to non-backflush operations prior to the backflush operation are also backflushed.
The Components are pulled from the supply subinventory assigned to the component. You cannot assign this supply type to an assenbly without a routing or a non-standard discrete job without a routing. You can assign this supply type to assemblies that have routings with no operations or when the routing has disabled operations. However, all components with a supply type of operation pull are automatically changed to assembly pull.
c) Assembly pull:
Assembly Pull components are issued (backflushed) to discrete jobs and repetitive schedules when you complete all operations on assemblies in Work in Process. They are pulled from the supply subinventory assigned to the component requirement.
If you want to assign pull components to a bill of material or job that is not associated with a routing, you must assign an Assembly Pull supply type, rather than operation pull supply type. You cannot assign this supply type to a non-standard discrete job if you have not specified an assembly or bill of material reference for that non standard discrete job.
d) Based on Bill:
When you define a discrete job or a repetitive line/assembly association in WIP, the supply type for the assembly defaults to Based on Bill and assembly components are supplied based upon their bill of material supply types. You can change the defaulted Based on Bill supply type that is assigned to jobs and schedules as you define them. The Based on Bill supply type is WIP specific.
If the supply type for a job or line/assembly association is changed, the new supply type is applied to all component material requirements. For example, if you change the supply type of a job assembly from Based on Bill to Assembly Pull, the supply types of all assembly components are changed to Assembly pull. You can update the supply types of individual material requirements using the Material Requirements window in WIP
The system automatically changes components with a supply type of Operation Pull to Assembly Pull, when the Based on Bill supply type is applied to a job or repetitive job/ schedule that has a bill of material but has no a routing or operations.
e) Bulk:
Bulk component requirements can be viewed and are displayed on reports and inquiry forms (that display components requirements) when you include Bulk components on a bill of material. They can be used to communicate to the shop floor that bulk components must be used but need not be transacted. You can choose specific components in the type field of WIP material transaction form for issuing bulk components.
Bulk components are not backflushed nor do they default when issuing all components for an assembly. You can, however, manually issue specific bulk components to a discrete job or repetitive schedule. This supply type is selected for components like screws,nuts,bolts,nails,etc where it is difficult and may not be necessary to transact the exact quantity used.
f) Supplier/Vendor:
Supplier component requirements can be included on bills of material. Requirements for supplier components are created when you define discrete jobs and repetitive schedules in Work in Process. Supplier component requirements can be viewed and are displayed on reports. They provide information on the component materials that your suppliers provide but need not be transacted. Supplier components are not backflushed nor do they default when issuing all components for an assembly. You can, however, manually issue specific supplier components to discrete jobs and repetitive schedules/job.
g) Phantoms:
Phantom components can be assigned to bill of material component subassemblies and subassembly items in BOM and Engineering. Components of phantom subassemblies are used as if they were tied directly to the parent assembly. Phantom supply types cannot be assigned to jobs and repetitive lines/assembly associations in Work in Process. When model or option class bills are components to another bill of material, that component supply type is phantom.
Phantoms behave normally when they are top level assemblies, such as when master scheduled or manufactured on a discrete job. As subassemblies, they lose their distinct identity and become a collection of their components. Phantom components (not the phantom itself) are included on discrete jobs and repetitive job/schedules and are listed on the Discrete Job and Repetitive Schedule Pick List Reports.
For original post, please visit http://applearn.blogspot.com
Supply types decides the method of supplying component materials to discrete jobs and repetitive schedules in WIP module. It also controls how materials are planned in MS/MRP module and how materials are costed in Cost Management module.
You can assign supply types to the items when you define in Inventory module. You can also assign supply types to components when you create bills of material in Bills of Material and Engineering modules. The following is a list of the WIP supply types and the way they work:
a) Push
Push components can be manually issued directly to discrete jobs and repetitive schedule as per requirements. You can specify the subinventory for items in Item definition form or in Bills or define default subinventory in WIP parameters form. Work in Process defaults the supply subinventory associated with the component.
b) Operation Pull:
Operation pull components that are assigned to backflush operations, are automatically backflushed (pulled) from inventory and issued to discrete jobs and repetitive schedules when assemblies are moved and completed at that operation i.e. when you complete backflush operations. Also, operation pull component that have not been backflushed because they are assigned to non-backflush operations prior to the backflush operation are also backflushed.
The Components are pulled from the supply subinventory assigned to the component. You cannot assign this supply type to an assenbly without a routing or a non-standard discrete job without a routing. You can assign this supply type to assemblies that have routings with no operations or when the routing has disabled operations. However, all components with a supply type of operation pull are automatically changed to assembly pull.
c) Assembly pull:
Assembly Pull components are issued (backflushed) to discrete jobs and repetitive schedules when you complete all operations on assemblies in Work in Process. They are pulled from the supply subinventory assigned to the component requirement.
If you want to assign pull components to a bill of material or job that is not associated with a routing, you must assign an Assembly Pull supply type, rather than operation pull supply type. You cannot assign this supply type to a non-standard discrete job if you have not specified an assembly or bill of material reference for that non standard discrete job.
d) Based on Bill:
When you define a discrete job or a repetitive line/assembly association in WIP, the supply type for the assembly defaults to Based on Bill and assembly components are supplied based upon their bill of material supply types. You can change the defaulted Based on Bill supply type that is assigned to jobs and schedules as you define them. The Based on Bill supply type is WIP specific.
If the supply type for a job or line/assembly association is changed, the new supply type is applied to all component material requirements. For example, if you change the supply type of a job assembly from Based on Bill to Assembly Pull, the supply types of all assembly components are changed to Assembly pull. You can update the supply types of individual material requirements using the Material Requirements window in WIP
The system automatically changes components with a supply type of Operation Pull to Assembly Pull, when the Based on Bill supply type is applied to a job or repetitive job/ schedule that has a bill of material but has no a routing or operations.
e) Bulk:
Bulk component requirements can be viewed and are displayed on reports and inquiry forms (that display components requirements) when you include Bulk components on a bill of material. They can be used to communicate to the shop floor that bulk components must be used but need not be transacted. You can choose specific components in the type field of WIP material transaction form for issuing bulk components.
Bulk components are not backflushed nor do they default when issuing all components for an assembly. You can, however, manually issue specific bulk components to a discrete job or repetitive schedule. This supply type is selected for components like screws,nuts,bolts,nails,etc where it is difficult and may not be necessary to transact the exact quantity used.
f) Supplier/Vendor:
Supplier component requirements can be included on bills of material. Requirements for supplier components are created when you define discrete jobs and repetitive schedules in Work in Process. Supplier component requirements can be viewed and are displayed on reports. They provide information on the component materials that your suppliers provide but need not be transacted. Supplier components are not backflushed nor do they default when issuing all components for an assembly. You can, however, manually issue specific supplier components to discrete jobs and repetitive schedules/job.
g) Phantoms:
Phantom components can be assigned to bill of material component subassemblies and subassembly items in BOM and Engineering. Components of phantom subassemblies are used as if they were tied directly to the parent assembly. Phantom supply types cannot be assigned to jobs and repetitive lines/assembly associations in Work in Process. When model or option class bills are components to another bill of material, that component supply type is phantom.
Phantoms behave normally when they are top level assemblies, such as when master scheduled or manufactured on a discrete job. As subassemblies, they lose their distinct identity and become a collection of their components. Phantom components (not the phantom itself) are included on discrete jobs and repetitive job/schedules and are listed on the Discrete Job and Repetitive Schedule Pick List Reports.
For original post, please visit http://applearn.blogspot.com
Thursday, December 18, 2008
Oracle WIP setups & Open Interface
Why do you need to define WIP parameters?
You can use WIP parameters to define modes of operation and to assign default values for various work in process functions. You can only define one set of WIP parameters per inventory organization.
Which are optional implementation steps for WIP?
Define Production Lines
Define Repetitive Assemblies
Define Scheduled Groups
Define Employees
Define Employee Labor Rates
Define Shop floor Statuses
Define Job and Schedule documents
Define Operation Documents
Defining Report sets
What all can you import in WIP module?
a) Import move transactions from data collection devices, factory floor machines or controllers using the Open Move Transaction Interface
b) Import material transactions (component issue/return, assembly completion/return, replenishment) from data collection devices, custom data entry forms, and other manufacturing inventory systems using the Open Inventory Transaction Interface
c) Import resource transactions from data collection devices and labor tracking systems using the Open Resource Cost Transaction Interface
d) Import planned orders, update recommendations, and planned repetitive schedules directly from external sources using the Work Order Interface
e) Update scheduling dates at the operation or resource level using the Work Order Interface
You can use WIP parameters to define modes of operation and to assign default values for various work in process functions. You can only define one set of WIP parameters per inventory organization.
Which are optional implementation steps for WIP?
Define Production Lines
Define Repetitive Assemblies
Define Scheduled Groups
Define Employees
Define Employee Labor Rates
Define Shop floor Statuses
Define Job and Schedule documents
Define Operation Documents
Defining Report sets
What all can you import in WIP module?
a) Import move transactions from data collection devices, factory floor machines or controllers using the Open Move Transaction Interface
b) Import material transactions (component issue/return, assembly completion/return, replenishment) from data collection devices, custom data entry forms, and other manufacturing inventory systems using the Open Inventory Transaction Interface
c) Import resource transactions from data collection devices and labor tracking systems using the Open Resource Cost Transaction Interface
d) Import planned orders, update recommendations, and planned repetitive schedules directly from external sources using the Work Order Interface
e) Update scheduling dates at the operation or resource level using the Work Order Interface
Labels:
Interview Questions,
SAM,
VKD,
Work in Process (WIP)
Subscribe to:
Posts (Atom)
Please enter your email address to subscribe
You won't repent doing this!