SQL Queries And Scripts To Analyze Install Base Data
(Doc ID 466925.1)
Last updated on AUGUST 08, 2023
Applies to:
Oracle Service Fulfillment Manager - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]Oracle Installed Base - Version 11.5.6 to 12.1.3 [Release 11.5 to 12.1]
Oracle Installed Base - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.
Purpose
This document lists sql queries and scripts to analyze the Install Base data. The scripts can be used toresearch Install Base transaction errors and data issues and the results of the scripts can be passed to Oracle Support when creating Service Requests for Install Base issues.
The scripts are categorized in 3 groups:
1. Scripts to analyze Install Base transaction errors
2. Scripts to analyze the data in the Install Base tables
3. Scripts to analyze the SFM Queue messages
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Troubleshooting Steps |
| --- Scope and Application --- |
| --- SQL Queries And Scripts To Analyze Install Base Data --- |