Oracle Solution for Error ora-36862

ORA-36862: (XSTFRC02) Column number for this SQL Cache must be between 1 and number

. Specified column number number

is invalid.

What triggered the Error:

Column Map references a column number that is greater than the maximum column number in SQL Cache

What should we do to fix it:

Reference a correct column number. Normally, users should not call OLAP Random Access Cursor table function themselves and therefore should not encounter this error.