How to fix the Oracle error ORA-36815: (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.?

In this post, you’ll learn more about the Oracle ErrorORA-36815: (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36815: (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.

Reason for the Error ORA-36815: (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.

The OLAP_TABLE aw_attach parameter was set to DURATION QUERY.

How to fix the Error ORA-36815: (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY. ?

You can fix this error in Oracle by following the below steps

Change the OLAP_TABLE aw_attach parameter to DURATION SESSION.