Oracle Solution for Error ora-36802

Solution for Oracle Error ORA-36802

ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.

What triggered the Error:

There is no limitmap on the table function and either the datamap does not contain a fetch, or it errored before the fetch was called.

What should we do to fix it:

Check the datamap for errors, make sure that it executes a fetch statement, if it is not intended to execute the fetch then make sure that the table function has a valid limitmap.