EBS R12 Oracle Reports Cache Directory Not Being Cleaned Up

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

Applies to:

Oracle Applications Technology Stack - Version 12.0 to 12.0 [Release 12.0]
Information in this document applies to any platform.
Oracle Reports, Cache, Cleaned Up, $INST_TOP, purge, disk space, temporary, files

Symptoms

In E-Business Suite (EBS) Release 12, when concurrent requests of the 
execution method of Oracle Reports are submitted, temporary files are present 
under the path of $INST_TOP/logs/ora/10.1.2/reports/cache. 

The temporary files are identical to the file placed under the 
$APPLCSF/$APPLOUT path, however. These temporary files are not purged when 
the "Purge Concurrent Request and/or Manager Data" (FNDCPPUR) program runs. 

Cause

New Bug 8449763 / 8602992 due to the new architecture of EBS R12

Solution

1. Perform both of the following actions:

a) Apply patch 8602992 "APPS1012: CACHE DIRECTORY NOT BEING CLEANED OUT"--currently available via MOS (Metalink). 

b) Apply technology stack template fix patch 9032800 "SET CACHESIZE=0 RWBUILDER_CONF_1012.TMP"--as soon as it becomes available.

As a current workaround to patch 9032800:

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. 

NOTE 2:   Patch 8602992 will ensure that the Oracle Report rwrun executable deletes the cache file after the report runs, however. Any existing cache file prior to the fix will need to be deleted manually

Get Oracle Certifications for all Exams
Free Online Exams.com