How to define tool for planners visibility of availability and capacity for critical tools

Summary:

The business needs a centralized tool master in Oracle, replacing Legacy system as the system of record, that holds tool and design attributes, links mandatory tools to parts, tracks tools by serial number, and gives planners visibility of availability and capacity for critical tools (including the 3-uses of tool-per-shift mould limit, and Tool as 5-component kit logic, and maintenance downtime).

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):