Maintenance
In the Maintenance data model, the server models data such as debriefs, base assets, and stocking locations as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your Oracle Fusion Cloud SCM account are immediately reflected in the server.
Views
The Views section, which lists read-only SQL tables, contains samples of what you might have access to in your Oracle Fusion Cloud SCM account.
Common views include:
| View | Description |
| InstalledBaseAssets | Manages customer-owned and maintainable assets, including lifecycle and operational data. |
| InstalledBaseAssetsrelationships | Handles structural relationships between assets, including hierarchical and linked associations. |
| InstalledBaseAssetsmeters | Manages details about meters associated with assets, including readings and configurations. |
| InstalledBaseAssetscharges | Tracks asset-related charges, including billing and renewal pricing information. |
| InstalledBaseAssetsfixedAssetAssociations | Maintains associations between installed base assets and fixed assets, including updates and terminations. |
| InstalledBaseAssetspartsListComponents | Handles the serial numbers for items in an organization, ensuring precise tracking and control. |
| InstalledBaseAssetsnotes | Enables management of asset-related notes for documentation and communication. |
| InstalledBaseAssetsassetDFF | Holds descriptive flexfields for adding customizable details about assets. |
| Debriefs | Maintains detailed records for service events, including technician data, customer accounts, and service outcomes. |
| Debriefslines | Tracks service line details such as labor, materials, expenses, and activity durations. |
| DebriefslineslinesDFF | Holds customizable fields for capturing additional attributes on service lines. |
| DebriefsprojectDetailsDFF | Contains customizable fields for detailed project tracking within debriefs. |
| StockingLocations | Creates and manages stocking location records to track inventory across organizations and subinventories. |
| StockingLocationssiteDedicatedLocations | Defines stocking location addresses dedicated to specific customer sites for logistics. |
| TrunkStocks | Tracks trunk stock inventory, including quantities and serial numbers for sub-inventories. |
| Finders | Lists view finder names along with associated attributes for efficient querying. |
| FlexFndDffDescriptiveFlexfieldContexts | Provides methods for managing descriptive flexfield contexts through REST API endpoints. |
| FlexFndPvsCharacterValues | Contains character values for managing flexfield configurations. |
| FlexFndPvsNumberIdCharacterValues | Stores numeric values for flexfield configurations. |
| StandardLookupsLOV | Provides a list of standard lookup codes and their translations for shared reference data. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including resequencing operations and performing midpoint rescheduling.