How To Determine What Updates Have Been Made By Install Base Transactions (Doc ID 1490087.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Installed Base - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for Relevance 10-Jul-2016***

Goal

How to find the instances and attributes updated in Install Base for a given transaction

Every transaction processed by Install Base, no matter what the source, is recorded in the csi_transactions table and at least one of the history tables - depending on the transaction type and the details of the transaction. The following provides queries which can be used to identify the updates performed by a given transaction id

 

Note that in the following queries, the transaction_id is the Install Base transaction_id NOT the Inventory material transaction_id.
To determine the Install Base transaction_id from a known material transaction_id use the following query:

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms