Oracle Solution for Error ora-34143

ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object

because it is type INTEGER.

What triggered the Error:

The user attempted to assign a value to a dimension surrogate whose data type is INTEGER. INTEGER surrogates, like INTEGER dimensions, cannot have values assigned to them. They can only be referenced by position.

What should we do to fix it:

Do not attempt to assign values to an INTEGER surrogate. Values will automatically appear and disappear from the INTEGER surrogate as positions are added to or removed from the underlying dimension.