OPM demo Flow

OPM stands for Oracle process manufacturing. Unlike Discrete Manufacturing, OPM is mainly used in the pharmaceutical and food industries.

Process manufacturing vs Discrete Manufacturing

Process manufacturing is a production line that makes raw materials into finished products, such as integrated circuits, pharmaceuticals, and food/beverage manufacturing.
Process manufacturing features: in terms of production planning, the planning is simple, and the planning is usually issued in the form of daily production, and the planning is relatively stable; The production equipment capability is fixed; in terms of production process control, the process is fixed, and the Work Center arrangement conforms to the process route. The time of each work center is close to the same; The Work Center is dedicated to produce limited similar products, and tools and equipment are designed for specialized products; materials are driven by machines from one work point to another. There are some products in stock. The production process mainly focuses on the control of the quantity, quality and process parameters of materials; production leads are usually conducted in reverse rush mode.

Discrete Manufacturing is to assemble different elements and subsystems into larger systems, such as computer, automotive and industrial supplies manufacturing.
The main feature of discrete manufacturing is that there is basically no material change in the production process, but the shape and combination of materials have changed. That is, the final product is assembled by various materials, in addition, there is a definite proportion between the product and the required materials, such as how many parts a product has and how many parts a component has. These materials cannot be too many or less.

According to the general industry, typical industries belonging to discrete industries include machinery manufacturing, automobile manufacturing, and home appliance manufacturing.

Feature differences

Industry differences

Product Layout (discrete)

Product Layout (process)

Demo

Taking the chocolate manufacturing process as an example, we assume that a chocolate finished product consists of two kinds of raw materials (IngredientOne is chocolate syrup and the other is water ).

Demo in vision demo, Login User: process_ops/welcome, responsibility: OPM all, organization: PR1

1. The organizational unit must be process manufacturing enabled.

(Mtl_parameters.process_enabled_flag = y)

2. Material Definition

First, define the finished product made by chocolate, and inherit the finished good template.

Select required properties for process manufacturing

Then define the raw material necessary for making chocolate: chocolate syrup, and water)

(For the two raw materials, select the four attributes in the process manufacturing check box. Otherwise, the four attributes cannot be selected when formula is defined)

3. OPM setups Overview

The points contained in OPM can be viewed from

* A routing is composed of a series of sequential operation processes.

* Each operation contains several other activities (actions)

* Each activity is composed of several resources.

* Formula is composed of ingredient (raw material), product, and byproduct (by-product ).

* Finally, the recipe connects formula and routing.

4. Definition of Resource

Navigation: process engineer> setup> generic Resource

Resource is the resource used in the production process, such as production equipment and labor. In this example, we want to make chocolate, so we need a chocolate mixer.

5. Operations Definition

Navigation: process engineer> process operations

Define operation. As mentioned earlier, an operation can have multiple activities, and each activity contains multiple resources. These associations are bound to process operations. Here we select a defined activity: mix, and then click the resource button to bind the resource: mixer we defined in the previous step to the mix activity.

(If you want to define a new activity, the path is process engineer> setup> activities)

After saving, the operation status should be approved for general use. (change the status in the menu, tools> change status)

Here, only one operation is defined. You can also define multiple operations.

6. Definition of process route Routing

Navigation: process engineer> process routings

A routing is composed of a series of sequential operation processes.

Table:

Fm_rout_hdr: Routing header information

Fm_rout_dtl: routing details. Contains the operations that comprise a routing and Their scaleability types.

7. Set the organization to plant and Laboratory

Responsibilities: Product Development Security Manager> organization Parameters

Select plant and laboratory to indicate that the current organization can be used as a factory or research institute.

Yield UOM is the unit of measurement for the final output product.

8. Definition of formula (formula)

After defining routing, operation, activity, and resource, you need to define formula.

Navigation: OPM all responsibilities> formulator> Formulas

1 chocolate product = 0.5 chocolate syrup + 0.5 water

(Note: The previous UOM definition of item is a bit problematic. It is defined as ea. It should be defined as LBS, and the above operation uses lbs, therefore, we need to increase the conversion rate of LB and EA in UOM conversion)

In, products: 1 indicates one product, by-products: none, and ingredients: 2 indicates two raw materials.

Next, choose action> change status in the menu,

Related tables:

Fm_form_mst_ B: formula header base table. Attach attributes to formula as a whole (e.g. classes ).

Fm_matl_dtl: formula material details. Product, ingredient, byproduct data for a formula.

Fm_form_mst_ B .formula_id <--> fm_matl_dtl.formula_id

9. Definition of recipe

Recipe connects formula and Routing

Then, change the status of recipe and validity rules twice, from new to approved for general use.

10. batch numbering

Navigation: Production Supervisor> setup> Parameter

Set Bach numbering to automatic

11. Create a batch

Navigation: Production Supervisor> Create document

The next step is the real OPM production process, including the generation and execution of batch, which will deal with batch in the future. The main steps and statuses include:
Process batch status
Create document (batch creation) pending
Batch release WIP (can revert back to pending)
Complete the batch completed (can revert back to WIP-caution-can lose the material transactions)
Close the batch closed (final close can not be reverted back)
Cancel the batch cancelled

We need to produce 10 pounds of chocolate

Click OK. Because we set the document encoding rules in step 1, the document number will be generated automatically and recorded. This number will be used later.

12. view the generated batch.

The tables corresponding to batch at the database level are gme_batch_header and gme_material_details.

Gme_batch_header:

Batch/FPO header. this table stores the header information for both firm planned orders (FPOs) and batches, including the plant, the validity rules, formula, and routing on which the batch was based, and the planned and actual start and completion dates.

Batch_id: PK

Batch_no: batch or FPO number

Recipe_validity_rule_id: surrogate key to the recipe validity rule ID the batch or FPO was based on.

Formula_id: --> fm_form_mst_ B .formula_id

Routing_id: --> fm_rout_hdr.routing_id

Gme_material_details:

Batch or FPO material details. This table contains data on the products, ingredients, and by products of an FPO or batch, including the planned and actual quantity.

Fields
Material_detail_id: Primary Key
Batch_id: Batch identifier fk to the gme_batch_header table
Formulaline_id: FK to the formular fm_matl_dtl table
Line_type:-1 = ingredient, 1 = product; the product on Line 1 is the primary product.2 = byproduct

Related queries:

-- Batch header information
Select * From gme_batch_header where batch_no = '201312 ';

-- Batch lines
Select GMD .*
From gme_material_details GMD, gme_batch_header GBH
Where GMD. batch_id = GBH. batch_id
And GBH. batch_no = '000000 ';

-- Formula lines
Select FMD .*
From fm_matl_dtl FMD, gme_material_details GMD
Where FMD. formulaline_id = GMD. formulaline_id
And GMD. material_detail_id = & material_detail_id

13. Release the batch

After release, the batch status changes to WIP

14. Misc receipsome quantity ingredient

Production is coming soon, so we should at least ensure that the amount of raw materials is sufficient. Here we will increase the amount of miscellaneous.

15. Process batch

Navigation: Production Supervisor> batch details> click transact material button

Transaction type item type

------------

WIP issue ingredient

WIP completion finished good

Select ingredient, then focus on transaction type, enter the sub-database with inventory, and click the transact button.

After transact, the actual qty in the batch main interface changes accordingly.

Then you can view material transaction to see what transactions we have performed on ingredients or production.

At this time, the number of Ingredient items is sufficient (five more chocolate syrup), so we can produce finished products.

After finishing, check material transactions to see that the chocolate finished product has been produced and imported into the database.

Transaction_type_id: 44

16. Complete the batch

Status: WIP --> completed

17. Close the batch

Status: Completed --> closed

References:

Http://www.oracleappshub.com/beginner/discrete-process-manufacturing-in-erp/

Http://ajayatre.blogspot.jp/2012/10/opm-setup-in-r12_29.html

Reprinted please indicate the source: http://blog.csdn.net/pan_tian/article/details/8907106