Oracle 11i Work In Process Training Presentation.ppt

Oracle 11i Work In Process Training Presentation.ppt

1. Oracle Work In
Process
Release 11i

2. Oracle WIP

3. Integration with Other Modules
Inventory
UOM, Item Information, On-Hand Information
Oracle WIP
Purchasing
Sub-Contract POs, Receipts
BOM
Product Structure, Routing, Resource Information
Planning
Planned Jobs, Schedules, Resource Load
Quality
Inspection related data

4. Repetitive Manufacturing
Process in which specific quantities of parts
are manufactured in batches or groups
e.g. Computer Assembler
Process in which parts are manufactured
continuously as defined by a daily rate, over a period
of time
e.g. Automobile Manufacturer
Oracle WIP
Different Manufacturing Methods:
Discrete Manufacturing

5. Oracle WIP

6. Define WIP Parameters
NAVIGATION:
WIP Setup Parameters
Oracle WIP
Setup

7. Define WIP Accounting Classes
NAVIGATION:
WIP Setup WIP Accounting Classes
Oracle WIP
Setup

8. Define WIP Profile
NAVIGATION:
WIP OtherProfile
Oracle WIP
Setup

9. Some Important definitions
Oracle WIP
Repetitive Schedule--production order to manufacture assemblies on
a continuos basis as defined by a daily rate,
using resources.
Production Line --physical location for manufacturing a repetitive
assembly, usually associated with a routing.
Repetitive schedules are built on production
lines.
Discrete Job --production order to manufacture a specific
quantity of an assembly, using resources.
Use discrete jobs to do :
Standard Production
Nonstandard production ( rework,disassembly)
ATO production , including standard items
and unique configurations

10. Oracle WIP

11. Oracle WIP

12. Oracle WIP

13. Oracle WIP

14. Oracle WIP

15. Oracle WIP

16. Oracle WIP

17. Oracle WIP

18. Oracle WIP

19. Oracle WIP

20. Oracle WIP
Updating Discrete Job Requirements

21. Oracle WIP

22. Repetitive Manufacturing
Oracle WIP
Use Oracle WIP to manage shop floor activities in a
repetitive environment to do the following :
•Build the same repetitive assemblies on the same production line
•Build different assemblies on the same line
•Plan future rates of production based on Requirements
•Change production rates
•Push or Pull work in process material requirements
•Purge complete and canceled repetitive schedules
•Report on all aspects of the repetitive production

23. Oracle WIP

24. Oracle WIP

25. Repetitive Manufacturing –Defining Production Line
Oracle WIP

26. Repetitive Manufacturing –Line Assembly Association
Oracle WIP

27. Repetitive Manufacturing –Defining Production Line
Oracle WIP

28. Oracle WIP

29. Oracle WIP

30. Oracle WIP

31. Oracle WIP

32. Oracle WIP

33. Oracle WIP

34. Oracle WIP

35. Oracle WIP

36. Oracle WIP
WIP Material Transactions
There are two types of issue transactions: Push issue and
Backflush .
Materials are issued to fulfil material requirements in a Job
or Schedule.
Negative requirements can be transacted using the WIP
negative component issue transaction or the WIP negative
component return transaction.
Materials are backflushed upon completion of operations
or assemblies.

37. Oracle WIP
WIP Material Transaction
All the
Components in
BOM gets
defaulted
Components
Not in BOM
can be
transacted
through
Specific
Component
transaction
Types of Push
Material
transactions

38. Oracle WIP
WIP Material Transaction

39. Oracle WIP

40. Oracle WIP

41. Oracle WIP

42. Performing Resource Transaction
Resources can be charged manually to a discrete job or repetitive assembly/line with or
without an associated move transaction. Manual resource charged can also be reversed
through Resource Transaction window.
Oracle WIP
For Actual Costing
Purpose, Employee
No of the person
worked on the job can
be provided
Resource Unit
absorbed by
the job

43. Oracle WIP

44. Oracle WIP

45. Oracle WIP

46. Oracle WIP

47. Oracle WIP

48. Oracle WIP

49. Oracle WIP

50. Oracle WIP

51. Oracle WIP

52. Oracle WIP

53. Oracle WIP

54. Oracle WIP

55. Oracle WIP

56. Oracle WIP

57. Oracle WIP

58. Oracle WIP

59. Oracle WIP

60. Oracle WIP

61. Oracle WIP

62. Oracle WIP

63. Oracle WIP

64. Oracle WIP

65. Oracle WIP

66. Oracle WIP

67. Oracle WIP

68. Oracle WIP

69. Oracle WIP

70. Oracle WIP

71. Outside Processing Business Needs
Companies go for Outside Processing mainly from the following
compulsions.
To use specialized suplier skills in their manufacturing process
to help lower engineering and manufacturing costs and increase
production quality.
To use supplier capacity to temporarily or permanently increase
overall production capacity.
Oracle WIP

72. Oracle WIP

73. Oracle WIP

74. Key Business Decisions
Before setting up for outside processing in Oracle Manufacturing
some key business decisions are to be taken in the following
areas.
Determining the Kitting Method
Determinig the Shipping method
Determining the Inspection Method
Oracle WIP

75. Oracle WIP

76. Oracle WIP

77. Defining Outside Processing Items
Oracle WIP

78. Setup Steps in Oracle Purchasing
Defining outside processing line types.
Defining employees and linking them to apllication users.
Defining supplier Auto-Source rules.
Defining outside-processing item list prices.
Defining outside-processing item lead times.
Defining over-receipt tolerance and control.
Controlling receiving routing.
Defining Ship-to and Deliver-to locations.
Oracle WIP

79. Setup Steps in Oracle BOM
Defining outside resources.
Defining departments and attach outside resources to those
departments.
Defining routings and linking outside resources to operations.
Including supplier-sourced components in bills of materials.
Oracle WIP

80. Defining Outside Resources
Oracle WIP
OSP Item is
attached to
OSP resource

81. Outside resources in Routings
Oracle WIP

82. Setup Steps in Oracle WIP
Defining WIP parameters.
Defining WIP accounting class.
Oracle WIP

83. Requisition Import for OSP from WIP
Oracle WIP
OSP operation
sequence
Job should
be put at
QUEUE of
OSP
operation
step for Req.
Import

84. Running Requisition Import from Purchase
Oracle WIP

85. Autocreating Purchase Orders
Oracle WIP

86. Outside Processing Purchase Orders
Oracle WIP

87. Oracle WIP

88. Oracle WIP

89. Oracle WIP
Costing Outside Processing
Oracle Purchasing Debits the outside processing valuation
account of the accounting class associated with the job or schedule
when outside processing item is delivered.
Oracle Work In Process charges the outside processing variance
account for outside resiurce efficiency variance and, optionally, rates
variances when you close a job (standard or asset nonstandard) or
when you close a period (for repetitive schedules or expense
nonstandard jobs).

90. Oracle WIP
New Features in 11i
Discrete Workstation
Production Kanban
Completion Transaction Integration with Oracle Quality
Workflow based Alerts and Intelligent Messaging
Over-Completion
Automatic updation of job status to “Complete”
Supplier Management Portal integration in outside processing
Sales Order reservation for standard items in discrete jobs

91. Oracle WIP
Discrete Workstation -Different Job Parameters

92. Oracle WIP
ERD for WIP Discrete Manufacturing
WIP_DISCRETE_JOBS
#* WIP_ENTITY_ID
BOM_BILL_OF_MATERIALS
#* BILL_SEQUENCE_ID
MTL_SYSTEM_ITEMS
WIP_REQUIREMENT_OPERATIONS
#* INVENTORY_ITEM_ID
#* WIP_ENTITY_ID
#* OPERATION_SEQ_NUM
#* REPETITIVE_SCHEDULE_ID
WIP_OPERATIONS
#* WIP_ENTITY_ID
#* OPERATION_SEQ_NUM
#* REPETITIVE_SCHEDULE_ID
BOM Routing
Tables
WIP_OPERATION_RESOURCES
#* WIP_ENTITY_ID
#* OPERATION_SEQ_NUM
#* RESOURCE_SEQ_NUM
WIP_ENTITIES
#* WIP_ENTITY_ID
WIP Transaction
Tables

93. Oracle WIP
Table Descriptions
WIP_ENTITIES --Information about Jobs, Repetitive Schedules
WIP_DISCRETE_JOBS --Discrete Job Information
WIP_REPETITIVE_SCHEDULES --Repetitive Schedule
WIP_REQUIREMENT_OPERATIONS --Material Req. for jobs, sched.
WIP_OPERATIONS --Each operation detail
WIP_OPERATION_RESOURCES --Resource Req. for each operation
WIP MOVE TRANSACTION TABLES
WIP_TRANSACTIONS --WIP Resource Charge information
WIP_TRANSACTION_ACCOUNTS --Accounting information for each
resource transaction
WIP_MOVE_TRANSACTIONS --Each Operation Move Transaction

94. THANK YOU