Tuesday, October 16, 2018

Oracle Work in Process

Oracle Work in Process

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. Complete picture of transactions, materials, resources, costs, and job and schedule progress can be tracked. 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 chapter describes the following test flows in Oracle Work in Process:
  • Create, Transact and Complete Standard Discrete Job
  • Work Order Less Completion Transactions
  • Mobile Serialized Transactions
Prerequisites
None.
Profile Options
Table 42-1 Profile Options for Oracle Work in Process
Profile NameProfile Value
WIP: Define Discrete Job FormInteractive definition
Predefined Data
Table 42-2 Page Predefined Data for Oracle Work in Process
Page NameField NameField Value
UserUser name /passwordMFG/welcome
ResponsibilityResponsibility NameManufacturing and Distribution Manager
Table 42-3 Mobile Predefined Data for Oracle Work in Process
MobileField NameField ValueComments
TelnetResponsibility NameMaterial & MfgAccessibility for this responsibility is for the user
Setup Data
Table 42-4 Setup Data for Oracle Work in Process
Window NameField NameField ValueComments
OrganizationOrganization NameV1V1 master organization

Organization NameM1M1 child organization

42.1 Create, Transact and Complete Standard Discrete Job

Creates standard work order; performs move, issue and resource transactions and completes the work order.
Prerequisites
  • Finished assembly is plain.
  • BOM, routing for the item.
  • All the dependent components with on-hand inventory.
  • Routing for the assembly with two standard operations.
Profile Options
Not applicable.
Predefined Data
Table 42-5 Predefined Data for Create, Transact and Complete Standard Discrete Job Flow
Window NameField NameField Value
Discrete JobTypeStandard
WIP ParametersClassDiscrete
Discrete JobStatusReleased
Discrete Job Routing tabSub inventoryStores
Setup Data
Table 42-6 Setup Data for Create, Transact and Complete Standard Discrete Job Flow
Window NameField NameField ValueComments
Discrete JobAssemblyFORTE_STND_ASSY
Bill of MaterialComponentsRP_COMP1Plain component with supply type : push
Sub inventory : Stores
Operation sequence : 20

ComponentsCHA_SR1Serial controlled component with supply type : Push
Sub inventory : Stores
Operation sequence : 20

ComponentsCHA_LOT_SR_CMP1Lot and serial controlled component with supply type : Push
Sub inventory : Stores
Operation sequence : 20

ComponentsRP_COMP2Plain component with supply type : assembly pull
Sub inventory : Stores
Operation sequence : 10

ComponentsCHA_SR3Serial controlled component with supply type assembly pull
Sub inventory: Stores
Operation sequence: 10

ComponentsCHA_LOT_SR_CMP3Lot and serial controlled component with supply type : assembly pull
Sub inventory : Stores
Operation sequence : 10
RoutingStandard OperationAPRTStandard operation should have resource attached

Standard OperationASBLStandard operation should have resource attached

42.2 Work Order Less Completion Transactions

Work order less completion transaction for plain and lot controlled assembly, work order less scrap transaction for plain.
Prerequisites
  • Finished assemblies are plain and lot controlled.
  • BOM, routing for the item.
  • All the dependent components with on hand inventory.
  • Routing for the assemblies with two standard operations.
Profile Options
Not applicable.
Predefined Data
Table 42-7 Predefined Data for Work Order Less Completion Transactions Flow
Window NameField NameField Value
WIP ParametersClassDiscrete

Sub inventoryStores
Setup Data
Table 42-8 Setup Data for Work Order Less Completion Transactions Flow
Window NameField NameField ValueComments
Work Order lessAssemblyFORTE_WOL_ASSY1

AssemblyFORTE_WOL_ASSY2Lot controlled assembly with start prefix 'L' and Start Num=0001.
Bill of MaterialComponentsPLAINPlain component with supply type : Operation pull, Sub inventory as Stores at operation : 10 for assembly : FORTE_WOL_ASSY1

ComponentsSERIALITEMSerial controlled component with supply type : Operation push, sub-inventory as Stores at operation : 20 for assembly : FORTE_WOL_ASSY1

ComponentsPLAIN2Plain component with supply type : Operation push, sub-inventory as Stores at operation : 10 for assembly : FORTE_WOL_ASSY2

ComponentsLOTITEMLot controlled component with start prefix 'LT' and Start Num=0001.
Supply type=Operation pull ,Sub inventory as Stores at operation : 20 for assembly FORTE_WOL_ASSY2
RoutingStandard OperationAPRTStandard operation should have resource attached

Standard OperationASBLStandard operation should have resource attached

42.3 Mobile Serialized Transactions

Creates work order for a serialized assembly; performs move, scrap, reject, and return, issue and resource transactions, and completes the work order.
Prerequisites
  • Finished assembly is serial controlled.
  • BOM and routing for the item.
  • All the dependent components with on hand inventory.
  • Lot & serial control assemblies with more than one lot number.
  • Routing for the assembly with three operations, first two being standard.
Profile Options
Not applicable.
Predefined Data
Table 42-9 Predefined Data for Mobile Serialized Transactions Flow
Window NameField NameField Value
Discrete JobSub inventoryStores
WIP ParametersDefault serialization start operationCheck

ClassDiscrete

Required Scrap AccountCheck

Default Scrap AccountAlias and Scrap Number should be empty

Transaction Processing ModeOnline

Default Intra Operating Step for Assembly MovesTo move
Setup Data
Table 42-10 Setup Data for Mobile Serialized Transactions Flow
Window NameField NameField ValueComments
Master ItemsAssemblyMOB_SER_ASSYSerial controlled assembly
Bill of MaterialComponentsMOB_PLAIN1Plain component with supply type Push, Sub inventory as Stores at Operation sequence: 10

ComponentsMOB_SR1Serial controlled component with supply type Push, Sub inventory as Stores at Operation sequence: 10

ComponentsMOB_LOT_SR1Lot and serial controlled component with supply type Push, Sub inventory as Stores at Operation sequence: 10

ComponentsMOB_LOT_SR2Lot and serial controlled component with supply type operation Pull, Sub inventory as Stores at Operation sequence: 10

ComponentsMOB_SR2Serial controlled component with supply type operation Pull, Sub inventory as Stores at Operation sequence: 10

ComponentsMOB_PLAIN2Plain component with supply type operation pull, Sub inventory as Stores at Operation sequence: 10

ComponentsMOB_PLAIN3Plain component with supply type Assembly pull at Operation sequence: 20

ComponentsMOB_SR3Serial controlled component with supply type Assembly Pull, Sub inventory as Stores at Operation sequence: 20

ComponentsMOB_LOT_SR3Lot and serial controlled component with supply type Assembly Pull, Sub inventory as Stores at Operation sequence: 20
RoutingStandard OperationAPRTAt Operation sequence 10

Standard OperationASBLAt Operation sequence 20

Non Standard Operation
Operation (without referring to standard operations) should be added at operation sequence 30

No comments:

Post a Comment

SQL Important Queries

  How to delete rows with no where clause The following example deletes  all rows  from the  Person.Person  the table in the AdventureWork...