During the process of upgrading from Apps 9 to Cloud we have noticed a number of Get- apis have been updated to use a micro-cache method rather than a sub query:

https://docs.ifs.com/techdocs/23r2/060_development/027_base_server_dev/060_performance/010_plsql-performance/001_micro_cache/#micro_cache_micro_cache_array_implementation

The performance hit on a quick report using these apis as been quite dramatic. Is there a was to speed these calls up? We obviously have the option to put sun-queries direct in the report but there could be lots of them.

Thanks.