My Oracle Support Banner

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 ---

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.