This chapter covers the following topics:
Oracle Work in Process is the core of Oracle's Discrete Manufacturing solution. Oracle Work in Process by itself provides a complete production management system that improves productivity, quality, and responsiveness while maximizing throughput and production. Inquiries and reports give you a complete picture of transactions, materials, resources, costs, and job. In conjunction with other modules within Oracle Discrete Manufacturing foot print, Oracle Work in Process provides support for enterprise wide quality management, lot and serial genealogy and traceability and support for various methods of planning and cost accounting, irrespective of whether your entire manufacturing is in-house or you use services of contract manufacturers.
This section provides information on the common prerequisites, profile options, and data setups required for executing the Oracle Work in Process flows. Flow specific requirements are documented along with the flow in the subsequent sections.
None.
The following profile option must be set:
| Profile Option Name | Profile Option Value |
|---|---|
| WIP:Define Discrete Job Form | Interactive definition |
The following predefined data must be used:
| Page Name | Field Name | Field Value |
|---|---|---|
| User | User Name | MFG |
| Password | welcome | |
| Responsibility | Responsibility Name | Manufacturing and Distribution Manager |
| Mobile | Field Name | Field Value | Comments |
|---|---|---|---|
| Telnet | Responsibility Name | Material & Mfg | (User must have access to this responsibility in the mobile interface) |
| Telnet | Responsibility Name | Whse Mgmt | (User must have access to this responsibility in the mobile interface) |
The following data must be set up
| Window Name | Field Name | Field Value | Comments |
|---|---|---|---|
| Organization | Organization Name | V1 | V1 master organization |
| Organization | Organization Name | M1 | M1 child organization |
| Organization | Organization Name | W1 | W1 child organization |
This flow performs the following activities in the listed sequence:
Creates finished items and components.
Creates miscellaneous receipts for all components.
Creates resources, departments, routings, and bill of materials.
Books a sales order, creates a discrete job, and pick releases a component for the job.
Transacts on the move order and issues material for the discrete job.
Moves the discrete job to outside processing operation.
Creates a purchase order, receipt, and completes the discrete job with quality inspection.
Closes the discrete job and checks the job status.
This section provides information on prerequisites, profile options, and data setups required to execute the Schedule to Build with Plain Assembly flow.
Schedule_To_Build_Non_Lot_Serial_Controlled_Assembly
None.
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Discrete Job | Type | Standard |
| WIP Parameters | Class | Discrete |
| Discrete Job, Routing tab | Sub inventory | Stores |
Not applicable.
This flow performs the following activities in the listed sequence:
Creates serialized finished items, plain components, a miscellaneous receipt for the component, resources, departments, routings and bill of materials
Creates a discrete job and associates it with serial numbers.
Pick and releases a component for the job, transacts on the move order, and assigns the task to the resource or picker.
Loads the task and completes the material issue transactions in the mobile device.
Moves the serial numbers for the finished assembly to the last operation.
Generates the license plate number and directly drops the license plate number and closes the discrete job.
This section provides information on prerequisites, profile options, and data setups required to execute the Schedule to Build License Plate Number Transactions with Serialized Assembly in Mobile flow.
Schedule_To_Build_Mobile_LPN_Drop
The following are the prerequisites for executing this flow:
User Task Type VMTS is created in the Warehouse Manager Setup and the Standard Task Type is defined as Pick in the User Task Type Attribute form. The User Task Type Attribute is mapped to the Pick Load Page type template in the User Task Type Attribute form.
The fields listed in the Setup Data section below are enabled in the Pick Load Page Setup form. These fields are available during the pick load transaction in the mobile device. Property for serial items are set using the template General in the Pick Load Page Setup form.
The default picking rule is No LPN Location.
Shipping parameters are defined.
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Discrete Job | Type | Standard |
| WIP Parameters | Class | Discrete |
| Discrete Job | Sub inventory | AMOBULK |
| Discrete Job | Locator | AMO.1.1.1 |
The following data must be set up:
| Window Name | Field Name | Field Value |
|---|---|---|
| User Task Type Attributes | User Task Type | DFLT |
| User Task Type Attributes | User Task Type Description | Default Picking |
| User Task Type Attributes | Standard Task Type | Pick |
| User Task Type Attributes | Pick Load Page Type | GENERAL |
| User Task Type Attributes | Pick Load Page Description | Default Pick Load Configuration |
| Pick Load Page Setup | Name | GENERAL |
| Pick Load Page Setup | Item Description | (Display only, no confirmation) |
| Pick Load Page Setup | Item | (Two columns are displayed – one for displaying property of nonserial items and another for displaying property of serial items. Show both fields, confirm second with no LOV) |
| Pick Load Page Setup | Subinventory | (Two columns are displayed – one for displaying property of nonserial items and another for displaying property of serial items. Show both fields, confirm second with no LOV) |
| Pick Load Page Setup | Locator | (Two columns are displayed – one for displaying property of nonserial items and another for displaying property of serial items. Show both fields, confirm second with no LOV) |
| Pick Load Page Setup | Allocated LPN | (Display only, no confirmation) |
| Pick Load Page Setup | Outer LPN | (Display only, no confirmation) |
| Pick Load Page Setup | Revision | (Two columns are displayed – one for displaying property of nonserial items and another for displaying property of serial items. Show both fields, confirm second with no LOV) |
| Pick Load Page Setup | UOM | (Single line input with LOV, default value) |
| Pick Load Page Setup | Requested Quantity | (Display only, no confirmation) |
| Pick Load Page Setup | Transfer LPN | (Single line input with no LOV, default value) |
| Pick Load Page Setup | Into LPN | (Hide fields) |
| Pick Load Page Setup | Container | (Display only, no confirmation) |
| Pick Load Page Setup | Container Id | (Display only, no confirmation) |
| Pick Load Page Setup | Project | (Display only, no confirmation) |
| Pick Load Page Setup | Task | (Display only, no confirmation) |
This flow performs the following activities in the listed sequence:
Creates serialized finished items, components, and miscellaneous receipt for all components.
Creates resources, departments, routings and bill of materials
Creates the discrete job and associates the discrete job with the serial numbers.
Performs material issue transactions in the mobile device.
Moves the discrete serial number to the last operation and completes the discrete job.
Closes the discrete job and checks the job status.
This section provides information on prerequisites, profile options, and data setups required to execute the Schedule to Build with Serial Controlled Assembly in Mobile flow.
Schedule_To_Build_Serial_Controlled_Assembly
None.
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Discrete Job | Type | Standard |
| WIP Parameters | Class | Discrete |
| Department Class | Class | Production |
| Discrete Job | Sub inventory | Stores |
| WIP Parameters | Default serialization start operation | (Select the check box) |
| WIP Parameters | Default Intra operation Step for Assembly Moves | (Select the check box) |
Not applicable.
This flow performs the following activities in the listed sequence:
Creates plain and finished items and components, resources of type Machine, routings and bill of materials, and miscellaneous receipts for all components.
Creates discrete job, books sales order, and associates the sales order with the discrete job.
Verifies the reservation of the sales order with the discrete job.
Moves and completes the discrete job.
Verifies if the reservation for the sales order is linked to the on hand quantity.
This section provides information on prerequisites, profile options, and data setups required to execute the Discrete Job with Multiple Sales Orders Association flow.
Discrete_Job_With_Multiple_Sales_Order_Association
None.
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| WIP Parameters | Class | Discrete |
| WIP Parameters | Sub inventory | Stores |
| Department Class | Class | Production |
Not applicable.
This flow performs the following activities in the listed sequence:
Creates serial controlled finished items and two plain components in a warehouse management system (WMS), enabled organization.
Receives the components through miscellaneous receipt.
Creates resources and departments, and associates the departments with resources.
Creates routing and bill of material.
Creates a discrete job and associates the serial numbers with the discrete job.
Moves the serial numbers associated with the discrete job to the last operation, generates license plate numbers (LPN), and directly drops the LPN.
Loads and drops the LPN.
This section provides information on prerequisites, profile options, and data setups required to execute the License Plate Number Serialized Transactions in Mobile flow.
LPN_Serialized_Txns
None.
None.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Discrete Job | Type | Standard |
| Discrete Job | Type | Non Standard |
| Discrete Job | Sub inventory | AMOBULK |
| Discrete Job | Locator | AMO.1.1.1 |
| WIP Parameters | Default serialization start operation | (Select the check box) |
| WIP Parameters, Discrete tab | Default Discrete Class | Discrete |
| WIP Parameters, Serial Tab | Default Intra operation Step for Assembly Moves | (Select the check box) |
Not applicable.
This flow performs the following activities in the listed sequence:
Creates plain finished item, and plain, serial, lot, and serial controlled product items.
Receives the components through miscellaneous receipt.
Creates resources, departments, and associates the departments with resources.
Creates routing and bill of material, repetitive lines, and associates the line with assembly.
Creates a repetitive schedule, and performs material issue, and resource transactions.
Moves and returns from move, scraps and returns from scrap, rejects and returns from reject, and completes the return transactions with back flushing.
Creates a repetitive schedule for assembly completion and returns transaction with back flushing.
This section provides information on prerequisites, profile options, and data setups required to execute the Repetitive Schedule Transactions flow.
Repetitive_Schedule_Transactions
None.
None.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Repetitive line/assembly association | Class | Repetitive |
Not applicable.
This flow performs the following activities in the listed sequence:
Creates a nonstandard, discrete job for an assembly, adds routing and assembly in the Discrete Job form, and releases the discrete job.
Verifies operations and components, adds, modifies, and deletes operations and components from the discrete job.
Completes resource and material transactions for the discrete job.
Closes the discrete job and verifies its status.
This section provides information on prerequisites, profile options, and data setups required to execute the Nonstandard Discrete Job with Regular Assemblies flow.
Non_Standard_Discrete_Job_For_Regular_Assemblies
None.
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Discrete Job | Type | Non Standard |
| Discrete Job | Sub inventory | Stores |
| Discrete Job | Class | Rework |
Not applicable.
This flow creates serial controlled finished items, resources and departments, associates departments with resources, and creates routing.
The flow enables Requisition Creation Time as At Job/Schedule Release, sets the first operation as serializing start operations, creates and releases discrete job, and associates serial numbers to the job. It automatically creates a PO, triggered through job release.
It then moves the serial numbers to the last, outside the processing operation queue step, receives the PO and moves the transaction to the last step, and completes the discrete job in a mobile interface.
This section provides information on prerequisites, profile options, and data setups required to execute the Outside Processing at Last Operation for Serialized Assembly in Mobile flow.
OSP_Last_OP_For_PO_Move_Resources_For_LSR_Assembly
None.
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Discrete Job | Type | Standard |
| Discrete Job | Type | Non Standard |
| Discrete Job | Sub inventory | Stores |
| WIP Parameters | Default serialization start operation | (Select the check box) |
| WIP Parameters, Discrete tab | Default Discrete Class | Discrete |
| WIP Parameters, Serial Tab | Default Serialization Start Operation | (Select the check box) |
| WIP Parameters, Serial Tab | Default Intra operation Step for Assembly Moves | (Select the check box) |
| WIP Parameters, Mobile tab | Default Scrap Account Alias and Number | Empty |
| WIP Parameters, Mobile tab | Transaction Processing Mode | Online |
| WIP Parameters, Move Transaction tab | Required Scrap Account | (Select the check box) |
Not applicable.
This flow performs the following activities in the listed sequence:
. Creates finished items, resources, departments, and associates departments with resources.
Creates routing.
Sets second and third operations as Outside Processing Operations, the Requisition Creation Time parameter as Job/Schedule Release, and the Propagate Job Quantity Changes parameter as Manual.
Creates a discrete job and automatically creates a PO with the status as Incomplete.
Scraps and unscraps the assembly. The quantity in the PO does not change based on the changes in the discrete job.
This section provides information on prerequisites, profile options, and data setups required to execute the Outside Processing Scrap, Over Move through Forms when Propagate Job Changes to Purchase Order Set to Manual flow.
OSP_Scrap_And_Overmove_Txns_Through_Desktop_PO_Set_To_Manual
None.
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Discrete Job | Type | Standard |
| Discrete Job | Sub inventory | Stores |
| WIP Parameters, Discrete tab | Default Discrete Class | Discrete |
Not applicable.
This flow performs the following activities in the listed sequence:
Creates finished items, resources and departments, and associates departments with resources..
Creates routing.
Sets second and third operations as Outside Processing Operations, the Requisition Creation Time parameter as Job/Schedule Release, and the Propagate Job Quantity Changes parameter as Automatic.
4. Creates a discrete job and a manual requisition for the outside processing item, and associates it with the discrete job. The job quantities are increased or decreased and the changes in the PO are verified.
This section provides information on prerequisites, profile options, and data setups required to execute the Outside Processing, Change Quantity of Job Having More Than One Requisition with Parameter Set to Propagate Job Changes to Purchasing as Manual flow.
OSP_Job_Quantity_Change_For_More_Than_One_Requistion
None.
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Discrete Job | Type | Standard |
| Discrete Job | Sub inventory | Stores |
| WIP Parameters, Discrete tab | Default Discrete Class | Discrete |
Not applicable.
This flow performs the following activities in the listed sequence:
Creates routing for an assembly with the last operation as Outside Processing.
Sets the Outside Processing parameter to Requisition Creation Time to At Job/Schedule Release, and the Propagate Job Changes parameter to Purchasing Automatic.
Creates a discrete job and verifies the requisition created for the outside processing assembly. In the mobile interface the assembly quantity changes for the discrete job are verified.
This section provides information on prerequisites, profile options, and data setups required to execute the Outside Processing, Scrap Transactions through Mobile flow.
OSP_Scrap_Transactions_Through_Mobile
None.
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Discrete Job | Type | Standard |
| Discrete Job | Sub inventory | Stores |
| WIP Parameters, Discrete tab | Default Discrete Class | Discrete |
Not applicable.
This flow creates routing for an assembly with the last operation being outside processing. It sets the Outside Processing parameter to Requisition Creation Time to At Job/Schedule Release, and the Propagate Job Changes parameter to Purchasing Automatic. It then creates a discrete job and verifies the requisition created for the outside processing assembly, creates an 'over move' transaction for the assembly and verifies the requisition quantity as per the over move transaction.
This section provides information on prerequisites, profile options, and data setups required to execute the Outside Processing, Scrap and Over Move Transaction through Forms, Verify the Quantity Changes in the Created Purchase Requisition flow.
OSP_Scrap_And_Overmove_Txns_Through_Desktop
None.
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Discrete Job | Type | Standard |
| Discrete Job | Sub inventory | Stores |
| WIP Parameters, Discrete tab | Default Discrete Class | Discrete |
Not applicable.
This flow creates routing for an assembly with the second and fourth operations being Outside Processing. It sets the Outside Processing parameter to Requisition Creation Time to Operation, and the Propagate Job Changes parameter to Automatic. It then creates a discrete job and automatically creates a PO with the status Complete for the second operation. The PO Need by Date is changed and is received. Next, a PO is automatically created for the fourth operation, and the PO Need by Date is changed and is received.
This section provides information on prerequisites, profile options, and data setups required to execute the Outside Processing, Change PO Need By Date through Form PO in Status Incomplete Approved flow.
OSP_Change_PO_NBD_Thorugh_Oper_From_PO_In_Status_Incomp_Aprv
None.
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Discrete Job | Type | Standard |
| Discrete Job | Sub inventory | Stores |
Not applicable.
This flow creates components and assembly. It also creates routing and bill of materials, and simulates and creates a discrete job..
This section provides information on prerequisites, profile options, and data setups required to execute the Simulate Discrete Job flow.
Simulate_Discrete_Job
None.
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value |
|---|---|---|
| Discrete Job | Type | Standard |
| WIP Parameters, Discrete tab | Default Discrete Class | Discrete |
Not applicable.
This flow creates a discrete assembly, resources and routing, and schedules two resources in the same operation sequence. It also calculates the variable lead time based on the resources scheduling with and without constraint based scheduling, and verifies the lead time computed in both cases.
This section provides information on prerequisites, profile options, and data setups required to execute the Check Schedule Completion Dates and Lead Time Calculation flow.
Lead_Time_Calculation_For_Assy_With_Simultaneous_Resources
The following is a prerequisite for executing this flow:
Multiple shifts are defined and associated with the production workday calendar
Not applicable.
The following predefined data must be used:
| Window Name | Field Name | Field Value | Comments |
|---|---|---|---|
| WIP Parameters | Default Discrete Class | Discrete | |
| Department | Class | Production | |
| Shift Times | Shift num | 1 | Start time 07:00:00 Stop: 15:00:00 |
| Shift Times | Shift num | 2 | Start time: 15:00:00 Stop: 23:00:00 |
| Shift Times | Shift num | 3 | Start time: 23:00:00 Stop: 07:00:00 |
| WIP Parameters | Include Resource Efficiency | Yes | |
| WIP Parameters | Include Resource Utilization | Yes | |
| WIP Parameters | Resource and Material | Yes | |
| Workday Calendar | Name | Vision01 | |
| Workday pattern | Seq | 1 | On 5 days, off 2 days |
Not applicable.