Oracle Message ORA-00166 - remote/local nesting level is too deep

ERRORremote/local nesting level is too deep
CAUSEToo many remote table operations required a reverse trip back to the local site, for example to execute a local function on a remote table.
ACTIONRearrange the query or co-locate the functions with the tables.