Slow Performance of Install Base Instance Relationships Transaction History purge CSIRELARCH (Doc ID 1354887.1)

Last updated on AUGUST 05, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Install Base Instance Relationships Transaction History purge program (CSIRELARCH module) has extremly slow performance took 13 hours to complete and Number of Instance Relationships history records archived is 0.


EXPECTED BEHAVIOR
-----------------------
The program should have better performance and and there are no records to be purged and in a such a case it should not be more than a few seconds.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Login to Oracle Applications -> Oracle Install Base Admin -> Requests -> Select Install Base Transaction History purge program and enter parameters (for 3 montths worth of data).

Cause

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