My Oracle Support Banner

How To Expire Instance Party Relationships In Install Base For Multiple Instances (Doc ID 1570921.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Installed Base - Version and later
Information in this document applies to any platform.


This datafix has been approved by development for customer consumption on 02/Sep/2013.

IMPORTANT: The information contained in this document may contain omissions, inaccuracies or other errors. It is provided "as is" and without warranty. Oracle does not warrant that the information in the materials is up to date or error free, nor does it provide any other warranties, whether expressed or implied in law, including the implied warranties of merchantability or fitness for a particular purpose. The materials are not a program or documentation under the terms of your license agreement(s) with Oracle.
In no event shall Oracle be liable for any direct, indirect, incidental, special or consequential damages, or damages for loss of profits, revenue, data or use, incurred by you or any third party, whether in an action in contract or tort, arising from your access to, or use of, this information.

If you have any questions or concerns please contact Oracle Support before running the script.


 Sometimes instance party relationships need to be expired 'en masse'. In earlier releases of Install Base this used to be possible using the Mass Edit feature. However, the ability to change the dates on party relationships was disabled from this form because it was found to cause many unintended errors both within Install Base and external to it by dates being adjusted inappropriately. Development took the decision to disable this feature. The following notes explain this a little more:

Note.821968.1 - Install Base Mass Edit Party Start Date And End Date Fields Are Disabled
Note.1496093.1 - Unable To Enter Start Or End Date For Resource Group In Install Base Mass Edit Form

Currently the only supported standard method of altering this information in your release is via the Parties screen in the Oracle Installed Base User responsibility - but this means doing it one by one which may, in some circumstances be impractical.

This note provides a data fix script which can be used to expire instance party relationships for multiple instances using the i_party_relationships_pub.expire_inst_party_relationship API. This effectively provides the same functionality as the Install Base UI screen but for multiple instances rather than one by one.


To view full details, 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 a vibrant support community of peers and Oracle experts.