Previous	Next		Contents	Index	Navigation	Glossary	Library

The work performed by the snapshot can be broken down into individual tasks, such as copying on-hand, discrete job, purchase order, bill of material, sourcing information, and so on. These tasks are completely independent of each other and can be performed in parallel. Each of these tasks consists of the following sub-tasks: deleting data from the last plan run, taking a snapshot of the current data and creating a flat file, and loading the flat file into the MRP tables. While creating the flat file does not require that old data has been deleted, the flat file can only be loaded into the MRP tables after the data from the last plan run has been deleted.

Oracle Master Scheduling/MRP and Oracle Supply Chain Planning maximizes the degree of multi-threading in all these tasks and sub-tasks by using multiple processes. For example, the Snapshot Delete Worker deletes the data; the Snapshot and the Snapshot Workers create the flat files; the Loader Workers load the data to MRP tables. The Snapshot Monitor coordinates all these tasks to minimize processing time without violating dependencies among tasks.

See Also