This chapter covers the following topics:
Oracle Complex Maintenance, Repair, and Overhaul is an integrated, web-enabled, software application suite designed for complex equipment maintenance organizations. It supports typical maintenance processes such as scheduled and unscheduled maintenance visits, component monitoring, job scheduling and routing, labor time collection, cost collection, inventory management, and maintenance document management.
You can view maintenance practice improvement opportunities, and opportunities to improve fleet readiness. The application provides models for electromechanical systems and defines rules for assembling units. You can record unit-specific information, allowing quick access to the maintenance history of a product component. It provides maintenance organizations a means to reduce operational costs, and thereby to yield improved profitability.
Oracle Complex Maintenance, Repair, and Overhaul enables maintenance organizations to meet customer expectations, and draw maximum benefit by improving the operational readiness of equipment. Key features include:
Maintenance requirements creation allowing maintenance personnel to create maintenance requirements with attributes uniquely defining the requirement
Maintenance routes association by attaching appropriate routes created in the Route Management module to the maintenance requirement
Maintenance documents association by attaching appropriate documents from Document Index to the maintenance requirement
Effectivity definition allowing automatic notification to personnel of the maintenance requirements applicable to certain physical units within the database
Interval and threshold definition enabling a schedule to be set that counts down until the maintenance requirement is due for a unit
Maintenance requirements and dependent relationships management allowing use of group relationships for non-complicated parent child components where the parent maintenance requirement accomplishment includes the children
Affected items listing providing a comprehensive view of the items that are covered by a maintenance requirement's effectivity
Work card or route authoring
Maintenance planning information helps organizations plan maintenance activities based on system, zone, process, skill of technician, and significant task
Resource requirements definition providing a set of resource requirements such as estimated labor, tools, and material, associated with each maintenance operation
Sign-off requirements definition allowing the association of Quality Plans in order to define sign-off requirements and accomplishment recordings for each work card and/or operation
Resource collection check point definition allowing capture of resource utilization details at different maintenance operation levels
Receipt and registration of documents
Upload and revision of electronic documents
Document subscription control through supplier information recording and subscription status tracking
Document revision control ensuring current and accurate information
Document status lookup allowing document version verifications from multiple levels during maintenance operations
Document Distribution Control ensuring authorization of a person (who requests a document) to receive a document
Associate Aircraft Maintenance Manual (AMM) Tasks to Route Management
Associate Enigma Configuration Information to Master Configurations
Associate Enigma Configuration Information to Unit Configurations
View and Print Enigma Content in Production
Assembly tree structure representing the positions of tracked or required components that make up a complex assembly
Assembly qualification by identifying the components required to meet a certain specification
Tracked parts positioning
Definition of parent child relationships between components in an assembly
Configuration template for unit configuration modeling the general characteristics of a fleet unit
Cost roll up structure allowing division of maintenance cost by the modules of an assembly
Definition of alternate parts allowable for each component position in an assembly
Definition of position ratios for usage counter updates between positions in a master configuration hierarchy
Maintenance document association to master configuration positions
Unit composition providing information on the hierarchical positions of parts within a unit
Physical location tracking of parts
Recording of child unit installation and removal on or from parent assemblies
Recording of utilization or age of parts in an assembly based on different parameters related to usage of parts and events that affect the parts
Utilization population from parent to child units enabling determination of component aging as a result of attachment to other parts, or parent units, that gain utilization
Unit maintenance history tracking through all previously accomplished maintenance requirement records
Equipment ownership history tracking enabling analysis of impact on business procedures due to ownership change
Temporary part identification allowing assignment of temporary serial numbers to parts in an acquired unit
Hierarchy based product classification creation and maintenance.
Association of maintenance requirements and documents to any level in the product classification using a tree based hierarchy in order to reduce the administration necessary with adding a new product to a maintenance program.
Logical grouping of products across multiple levels.
Primary and supplementary classification support which allows part and unit grouping from multiple viewpoint.
Utilization forecast maintenance that provides the utilization forecast in terms of the applicable time based unit of measures for each unit in the fleet
Serviceable time (UOM) of units viewing for the parent unit and all child units expressed in terms of appropriate UOM, such as hours, cycles, mileage, etc.
Repetitive maintenance requirement modeling over a user defined period providing the UOM remaining for each occurrence of a maintenance requirement
Due date calculation of maintenance requirements based on utilization forecasts and maintenance frequencies in the absence of a specified fixed due date
Association of maintenance requirement groups to a visit
Equipment based maintenance visit definition enabling an equipment item to be connected with a block of tasks, a location, and a period of time
Maintenance visit template definition enabling a maintenance planner to develop a shop visit plan without access to a unit maintenance plan for the equipment
Visit creation from a template allowing a planner to add attribute values like visit location, visit start date, and description to a template definition, and copy the template to a visit object
Visit and task structure conversion to a template allowing a visit object, or the visit header, and all attached tasks that comprise the work package, to be transformed into a visit template
Merging of imminent maintenance requirements with visits allowing a maintenance planner to select imminent maintenance requirements for an equipment unit based on an effective date range
Addition of ad hoc repair tasks to visits allowing association of ad hoc tasks, not associated with a route, to a visit
Visit task work breakdown structure definition enabling calculation of the labor, parts, and material costs incurred during a maintenance visit
Visit task sequence definition permitting precise definition of the order of completion of all tasks that comprise a maintenance facility visit
Visit work package export to Oracle Projects enabling export of the entire visit object to Oracle Projects, on completion of the visit definition, as a project record with equivalent tasks
Searching unit and its visits. Viewing the progress and status of each visit.
Viewing the material requirements of a visit. This view organizes the material requirements by their association within the associated configuration and positions of the visit.
Issuing required materials from other subinventories when the visit subinventory and locator cannot accommodate the material requirement of a work order.
Assessment of a maintenance base's work load capacity analysis of available labor by skill, available tooling/machinery, available materials and the location's capabilities—such as the list of units and requirements the location can support—balanced against known workloads.
Visit creation in order to group together events for long and short term capacity planning and to facilitate scheduling to a maintenance base.
Definition of a visit's resource requirements based on the unit, man hour requirements by skill, required tooling, required materials, duration and required completion times of the visit's maintenance requirements and routes.
Visit appointment creation based on maintenance base resource forecasting and visit requirements.
Resource balancing capacity versus work load requirements for scheduling purposes and efficiency assurance.
Resource leveling on different simulation plans allowing identification of the best plan with regards to resource capacity.
Departmental work shift schedule definition allowing maintenance planners to select shift schedules for the departmental workers who will accomplish the inspections and repairs
Calculating spaces and space unavailability
Job creation from visit tasks for Scheduled, Unscheduled, and Convenience maintenance
Service Request creation for tracking reported problems
Creation of Operations to Non-Routine Jobs for work definition and tracking
Job maintenance through status, completion, and start/end date adjustments of the schedule.
Operation maintenance by addition, removal, material and resource requirement updates, cost capture, and resource assignment review.
Quality maintenance using Route Management.
Assign production jobs for third party service
Add or remove production jobs to an existing OSP Work Order
Determine how and when the parts will be shipped to the supplier
Create and Approve Purchase Orders
Create Purchase Requisitions for an OSP Order
Receive shipments for an OSP Order
The Fleet Maintenance Program module in Oracle Complex Maintenance, Repair, and Overhaul allows maintenance organizations to record, organize, and plan maintenance requirements. The maintenance planner can create maintenance requirement records and attach attributes to these records. The attributes attached to the record enables maintenance planning, and increased operational efficiency while accomplishing a requirement. Maintenance planners can:
Search the database for a specific maintenance requirement for reference, or for editing purposes.
Create a maintenance requirement record in the database.
Attach documents, maintenance routes, actions, effectivity, and maintenance requirement relationships to the record.
Create revisions for maintenance requirements that are complete.
View items that are affected by a maintenance requirement.
Search the database for a specific operation for reference purposes, or for editing purposes.
Create an operation or define instructions for carrying out a maintenance task.
Search for maintenance routes, for reference, or for editing route information.
Create a maintenance route.
Associate major and sub zones in a system to a product type to facilitate tracking of maintenance operations on complex electromechanical systems.
The intuitive user interface of Oracle Complex Maintenance, Repair, and Overhaul is designed to enable maintenance personnel handle operational needs as effortlessly and quickly as possible.
The Document Index module in Oracle Complex Maintenance, Repair, and Overhaul is the central place for managing all maintenance documents. The maintenance personnel can access an online catalog of documents used in maintenance, repair, and overhaul operations. The Document Index allows personnel to receive, distribute, and control revisions in technical documentation. Maintenance personnel can:
Search the database to quickly refer to a document.
Create new documents or document revisions.
Associate subtypes to document types for easy identification.
Upload electronic documents
Maintenance document management involves tracking documents and their revisions, validating document references from multiple levels of maintenance operations, and making them easily accessible to the maintenance personnel.
Minimum Equipment List (MEL) and Configuration Deviation List (CDL) functionality identifies equipment, as opposed to structural items, that can be inoperative or missing on aircraft—but still enable the aircraft to maintain airworthiness. This includes items such as radios, seats, lights, air conditioning, heaters, and indicators. These items, called provisos, can be inoperative under certain conditions. Limitations may be required as how the aircraft is operated. For example—there may be limitations regarding ice conditions, night flights, or altitude limits. When non-routine maintenance requirements are discovered during inspections, you can create a service request and determine if the requirement should be deferred to subsequent visits using MEL or CDL instructions.
MEL addresses defective equipment, and CDL addresses missing parts in an aircraft. This functionality includes:
Definition of the lists is based on Air Transport Association of America (ATA) specification codes. MEL and CDL instructions are associated to a product classification. The applicable ATA codes are defined—along with the corresponding repair times, installed quantities and minimum required quantities. These ATA codes and minimum quantities are used to identify the eligibility of MEL and CDL deferrals for the unit based on the ATA code definitions in corresponding master configurations.
Issues can be logged by a pilot, crew member, or technician—and flagged as a potential MEL or CDL item. The system automatically identifies applicable MEL/CDL instructions based on the associated configuration position.
Maintenance requirements are deferred against associated MEL and CDL instructions. When a requirement is deferred against the MEL or CDL, applicable Maintenance and Operation (M) and(O) procedures are automatically added to the maintenance visit. These procedures are defined in engineering as maintenance requirements, and the applicability is determined based on effectivity definitions and defined ATA codes.
See: Minimum Equipment List (MEL) and Configuration Deviation List (CDL) Setup
Oracle Complex Maintenance, Repair, and Overhaul uses modules from other Oracle applications.
Organizations perform maintenance operations on an electromechanical system to maximize the service life of that asset. Maintenance operations require that the service life of a system, or the components comprising it, be measured. Timers and counters become important here. Car odometers, for example, are counters. Meters used to record the operating hours of power plants on aircraft and boats are timers. Maintenance is typically performed periodically, based on elapsed operating time. Oracle Complex Maintenance, Repair, and Overhaul meets these needs through its integration with Oracle Counters application.
Oracle Complex Maintenance, Repair, and Overhaul user will use an Oracle Counters instance to represent a timer when defining models for system configurations. The service life of a component is measured according to the nature of that component's role, and service life measurements are selected by failure mode analysis. Calendar time is of interest because of possible corrosive conditions resulting in damage over time. Counter instances are sufficiently flexible, and Oracle Complex Maintenance, Repair, and Overhaul users can define the counters using the appropriate unit of measurement associated with a component.
Maintenance organizations gain many advantages by modeling a template for electromechanical system assemblies and individual fleet units. After an Oracle Complex Maintenance, Repair, and Overhaul user completes the definition of a master configuration, a framework that describes the general characteristics of the system including the engineering rules for assembly, exists. The user can then create a unit configuration.
Oracle Complex Maintenance, Repair, and Overhaul will invoke the Install Base methods to populate the database with a transaction representing the as-operated or unit configuration of an electromechanical system.
Maintenance organizations can greatly improve operational efficiency by planning their material requirements. The Master Configuration module of Oracle Complex Maintenance, Repair, and Overhaul provides a template for the structure of an electromechanical system, and lists the components that are allowable in the different positions of a system configuration. The Unit Configuration module describes the as-installed configuration of a specific fleet unit. This helps organizations predict to an extent, the material requirement for maintaining operational readiness of fleet units.
Oracle Complex Maintenance, Repair, and Overhaul user will use instances of Oracle Inventory when defining the allowable parts in a master configuration for an electromechanical system, and when describing the components in a unit configuration.
Oracle Complex Maintenance, Repair, and Overhaul uses the setup from Route Management and the system profile options in Oracle Quality, to allow maintenance organizations to capture quality elements for operations, jobs, deferrals, scrap management, and capturing counter value snapshots. This gives maintenance facility the flexible integration required to maintain reliable products. Oracle CMRO provides seeded plan templates for routes, operations, job deferrals, MRB dispositions and counter reading capturing. These templates can either be used as-is or adjusted with additional quality elements, except the counter reading template which is used by CMRO in the background and cannot be changed.
Oracle Complex Maintenance, Repair, and Overhaul integrates with Oracle’s Advanced Planning and Scheduling (APS) applications for supply chain management. Advanced Supply Chain Planning (ASCP), is used to schedule required materials from maintenance visits. Available to Promise (ATP), is used for material availability inquiries, as well as scheduling through ASCP. Demand Planning (DP), is used for creating material demand from three sources: global demand from forecasted requirements in Unit Maintenance Plan; scheduled demand from requirements scheduled to maintenance visits; and historical non -routine (and routine) demand from maintenance accomplished at specific faculties. Additionally, Oracle APS’s Inventory Optimization (IO) application is required for complete supply chain planning.
Oracle Complex Maintenance, Repair, and Overhaul integrates with Oracle Purchasing to set up buyers, approvals, purchasing options, receiving options, financial options, and open accounting periods. Oracle Purchasing is directly integrated with CMRO's OSP module and enables the creation of Purchase Requisitions or Purchase Orders when required for outside vendor service.
Oracle Warehouse Management provides maintenance organizations, the functionality to control their inventory by status/condition and associate subinventories with a department.
Oracle Complex Maintenance, Repair, and Overhaul integrates with Oracle Order Management to set up processing constraints and create customers. Oracle Order Management is directly integrated with CMRO's OSP module and enables the creation of Service Orders with shipping lines for shipping and receiving items when required for outside vendor service.
Oracle Complex Maintenance, Repair, and Overhaul uses the same work order system as Oracle Enterprise Asset Management (eAM). It also uses the Oracle eAM functionality to complete operations. Oracle CMRO benefits from Oracle eAM’s enhanced integration with Oracle Costing.
Oracle Support provides Oracle Complex Maintenance, Repair, and Overhaul with the functionality to create and update service requirements in a maintenance organization. The association of a service request to a visit task and production job allows the maintenance organization to track the service difficulty (non-routine) to the associated progress or resolution performed by the maintenance personnel.
Integration of Oracle Complex Maintenance, Repair, and Overhaul and Enigma 3C Oracle Complex Maintenance, Repair, and Overhaul delivers the total functionality to manage entire maintenance operations from configuration management and engineering to maintenance planning and execution for a maintenance organization.
Enigma 3C ® delivers a dynamic service index of maintenance, parts and diagnostic information, that captures operational expertise and connects to vital corporate systems to manage and optimize the service and support workflow.
The integration between Oracle’s Complex Maintenance, Repair, and Overhaul and Enigma’s 3C is to provide an unique solution for maintenance service providers to enable the technicians with a set of tools that connect Complex Maintenance, Repair, and Overhaul’s extensive back office functionality for configuration management, engineering and maintenance planning with Enigma’s flexible and easy to use documentation centric maintenance execution system in a wireless environment.