In this post, you’ll learn more about the Oracle ErrorORA-36816: (XSTBLFUNC09) The workspace object dimension is of datatype string which does not support custom member upserts. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-36816: (XSTBLFUNC09) The workspace object dimension is of datatype string which does not support custom member upserts.
Reason for the Error ORA-36816: (XSTBLFUNC09) The workspace object dimension is of datatype string which does not support custom member upserts.
Custom members were attempted to be added via an upsert to a dimension that does not support them
How to fix the Error ORA-36816: (XSTBLFUNC09) The workspace object dimension is of datatype string which does not support custom member upserts. ?
You can fix this error in Oracle by following the below steps
Disable the AW Hash optimization for this query