Reports Cache Directory in Oracle E-Business R12 is Growing Rapidly

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

The cache files are not being deleted when the cacheSize property is exceeded and files are also not deleted even after enabling and setting maxCacheFileNumber, which is the documented method.

Solution

Workaround:

  1- Shutdown the Concurrent Processing server.
  2- Manually delete all the temporary files under the $INST_TOP/logs/ora/10.1.2/reports/cache path
  3- Startup up the Concurrent Processing server.

OR

Change the Oracle Reports configuration file $INST_TOP/ora/10.1.2/reports/conf/rwbuilder.conf and bouncing the services. 

CHANGE: 
<property name="cacheSize" value="50"/> to 
<property name="cacheSize" value="0"/> 

NOTE: This change will be lost when Autoconfig is run. Apply patch 8602992 as soon as it becomes available.

Permanent Fix:

  1- Apply the following Patch 8602992.

Important Note: If facing Intermittent Oracle Reports REP-0069: REP-57054 Errors after applying the patch above please review Note 1237834.1 - Intermittent Oracle Reports REP-0069: REP-57054: Error

Get Oracle Certifications for all Exams
Free Online Exams.com