How to clear cache automatically to ensure smooth performance in Oracle iProcurement ?

This can be achieved by using the following profile option,

POR: Cache Time To Live Minutes - Time, in minutes, until the middle tier server performs a garbage collection.

The profile 'POR: Cache Time To Live' allows setting of OA Framework caching lifetime within the iProcurement application.  In Release 12 and later the profile is renamed as 'POR: Cache Time To Live Minutes'.

The profile is updatable at Site level only.

The default value specified in minutes is 15. 

There is an option to set this to lesser value so that clearing of cache takes place more frequently; conversely it may be set higher also to increase the duration of cache retention.

Note:

If the value is 0 or null the application will not utilize the cache facility; thus it would not be required to clear OA Framework cache after making certain changes.

There is no impact to the Procurement functions by changing this profile, however for setting the value to 0 or null, users may experience a minor reduction in performance in some production environments. Hence it is recommended to set it to any value greater than Zero.

---X---