Understand Production and Maintenance Data
Bulk upload the production and maintenance data for your factories using CSV files.
Production Line
Define the arrangement of the machines used to manufacture a product. Your factory may have multiple production lines.
This table shows the fields and the descriptions for the CSV file to upload the data for the production lines in your factories:
| Field | Description |
|---|---|
| Production Line ID |
Enter an ID to identify this production line. |
| Production Line Name |
Enter a name to identify the production line. |
| Factory ID |
Enter the factory ID for the factory where the production line operates. |
| Machine ID |
Enter the machine ID for the first machine in the production line. |
| Machine ID 2 |
Enter the machine ID for the second machine in the production line. |
| Ellipsis (...) |
(Optional) Update the header to Machine ID 3 and enter the machine ID for the third machine in the production line. If required, repeat this step in the next columns to add additional machines to the production line. The column heading for each additional machine must be unique. |
Product Routing
Define the path that your products follow during the manufacturing process. Each line in this CSV file associates a certain product with a task and a machine.
This information is used to generate the product routing diagram for each product and production line in your factory.
This table shows the fields and the descriptions for the CSV file to upload the data for product routing in your factories:
| Field | Description |
|---|---|
| productId |
Enter the ID for the product produced using this product routing. |
| taskId |
Enter a unique identifier for the routing task. |
| taskName |
Enter a unique name for the routing task. |
| machineId |
Enter the machine ID for the first machine that performs the first routing task. |
| Ellipsis (...) |
(Optional) Update the header to Machine ID 2 and enter the machine ID for the second machine that performs a secondary routing task. If required, repeat this step in the next columns to add additional machines. The column heading for each additional machine must be unique. |
Production Plan
Define the expected production rated for a product in a factory, a production line, or a machine in a certain period.
This table shows the fields and the descriptions for the CSV file to upload the production plan:
| Field | Description |
|---|---|
| Start Time |
(Required) Enter the start time and date for the production plan. Use the format |
| End Time |
(Required) Enter the end time and date for the production plan. Use the format |
| Product ID |
(Required) Enter the ID for the product manufactured using this production plan. |
| Factory ID |
(Optional) Enter the ID for the factory where the product is produced. If this is the only optional field specified, all products produced by the specified factory are used to determine the production quantity. If you enter a Factory ID value, you must not enter values for the Production Line ID, Routing Task ID, or Machine ID fields. |
| Production Line ID |
(Optional) Enter the ID for the production line that produces the product. If you only specify this field, then only the products produced by the specified production line are used to determine the production quantity. If you enter a value for the Production Line ID field, then you must not enter values for theRouting Task ID or Machine ID fields. |
| Routing Task ID |
(Optional) Enter the ID for the routing task associated with the product. If you only specify this field, then only the products produced by the specified routing task are used to determine the production quantity. If you enter a value for the Routing Task ID field, then you must also enter a value for the Machine ID or Operator ID fields. |
| Machine ID | (Optional) Enter the ID for the machine that produces the product. If you specify this field, then only the products produced by the specified machine are used to determine the production quantity. If you enter a value for the Machine ID field, then you must also enter a value for the Routing Task ID field. |
| Operator ID | (Optional) Enter the ID for the assigned operator. This is the user name (Login ID) of the operator. If you specify this field, then only the products produced by the specified operator are used to determine the production quantity. If you enter a value for the Operator ID field, then you must also enter a value for the Routing Task ID field. |
| Quantity | (Required) Enter the expected product quantity for the production plan. This value defines the number of products that you expect to produce in the specified period. |
Actual Production
Upload the actual production for a product in a factory, a production line, or a machine in a certain period.
This table shows the fields and the descriptions for the CSV file to upload the actual production for your factories:
| Field | Description |
|---|---|
| Start Time |
(Required) Enter the start time and date for the actual production plan. Use the format |
| End Time |
(Required) Enter the end time and date for the actual production plan. Use the format |
| Product ID |
(Required) Enter the ID for the product for which you are specifying the actual production.. |
| Factory ID |
(Optional) Enter the ID for the factory that manufactures this product. If you only specify this optional field, then all products produced by the specified factory are used to determine the production quantity. If you enter a value for the Factory ID field, then you must not enter values for the Production Line ID, Routing Task ID, or Machine ID fields. |
| Production Line ID |
(Optional) Enter the ID for the production line that produces the specified product. If you only specify this optional field, then only the products produced by this production line are used to determine the production quantity. If you enter a value for the Production Line ID field, then you must not enter a value for the Routing Task ID or Machine ID fields. |
| Routing Task ID |
(Optional) Enter the ID for the routing task associated with the product. If you only specify this optional field, then only the products manufactured in this routing task are used to determine the production quantity. If you enter a value for the Routing Task ID field, then you must also enter a Machine ID or Operator ID field. |
| Machine ID |
(Optional) Enter the ID for the machine that manufactures the specified product. If you only specify this optional field, then only the products produced by the specified machine are used to determine the production quantity. If you enter a value for the Machine ID field, then you must also enter a value for the Routing Task ID field. |
| Operator ID |
(Optional) Enter the ID (user name) for the operator that manufactures the specified product. If you only specify this optional field, then only the products produced by the specified operator are used to determine the production quantity. If you enter a value for the Operator ID field, then you must also enter a value for the Routing Task ID field. |
| Completed Quantity |
(Required) Enter a value representing the actual quantity of the product produced. At least one of Completed Quantity, Reject Quantity, or Scrap Quantity must be non-zero. |
| Reject Quantity |
(Optional) Enter a value representing the number of reject items produced. Reject quantities may eventually be scrapped or completed. At least one of Completed Quantity, Reject Quantity, or Scrap Quantity must be non-zero. |
| Scrap Quantity |
(Optional) Enter a value representing the number of scrapped items produced. Scrapped quantities cannot be completed. At least one of Completed Quantity, Reject Quantity, or Scrap Quantity must be non-zero. |
| Reject Reason |
(Optional) Enter a justification for the reject quantities. |
| Scrap Reason |
(Optional) Enter a justification for the scrap quantities. |
| Reject Details |
(Optional) Enter more details about the reject quantities, such as serial number information. |
| Scrap Details |
(Optional) Enter more details about the scrap quantities, such as serial number information. |
| Work Order Number |
(Optional) If the production plan was created in response to a work order from Oracle Fusion Cloud Manufacturing, then enter the work order number here. |
Maintenance Schedule
Schedule maintenance for the machines in your factory.
This table shows the fields and the descriptions for the CSV file to upload maintenance schedules:
| Field | Description |
|---|---|
| Machine ID |
Enter the ID for the machine that requires maintenance. |
| Start Time — End Time |
Enter the start and end time for the maintenance work. Use this format: YYYY-MM-DDTHH:MM:SS~YYYY-0MM-DDTHH:MM:SS. For example, |
| Start Time 2 — End Time 2 |
(Optional) Enter a second maintenance period. |
| Ellipsis (...) |
(Optional) Update the header to Start Time 3— End Time 3 and enter a third maintenance period. If required, repeat this step in the next columns to add additional maintenance periods. The column heading for each additional maintenance period must be unique. |
Machine
Bulk upload the data for the machines in your factories using a CSV file.
This table shows the fields and the descriptions for the CSV file to bulk upload machines:
| Field | Description |
|---|---|
| Machine ID |
(Required) Enter the ID that identifies this machine. |
| Machine Name |
(Optional) Enter the name of this machine. If you don’t specify a name, the Map view displays the ID below the machine icon. |
| Machine State |
(Optional) Enter the current status of the machine. Available options are: In Use, Idle, Down. |
| Machine Type |
(Optional) Enter the machine type for this machine. The machine type defines the icon and device model this machine uses. |
| Factory ID |
(Required) Enter the ID for the factory where this machine is located. |
| Attributes |
(Optional) The list of additional attributes for this machine. The additional attributes depend on the machine type you selected. Specify the name of the attribute followed by a comma and the value for this attribute. For example, if the machine type you selected specifies the additional attributes manufacturer and installation date then you can add |