Maintenance
In the Maintenance data model, the add-in 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 add-in.
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.