How to fix the Oracle error ORA-35952: (XSSPFC01) The string dimension workspace object and the string dimension workspace object must have the same number of values in status for SPFCEXEC method number.?

In this post, you’ll learn more about the Oracle ErrorORA-35952: (XSSPFC01) The string dimension workspace object and the string dimension workspace object must have the same number of values in status for SPFCEXEC method number. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-35952: (XSSPFC01) The string dimension workspace object and the string dimension workspace object must have the same number of values in status for SPFCEXEC method number.

Reason for the Error ORA-35952: (XSSPFC01) The string dimension workspace object and the string dimension workspace object must have the same number of values in status for SPFCEXEC method number.

This method requires the named dimensions to have the same number of values in status, but the user provided statuses of different lengths.

How to fix the Error ORA-35952: (XSSPFC01) The string dimension workspace object and the string dimension workspace object must have the same number of values in status for SPFCEXEC method number. ?

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

Relimit the dimensions so that their status lengths are the same.