Oracle Solution for Error ora-37104

Solution for Oracle Error ORA-37104

ORA-37104: (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.

What triggered the Error:

User attempted to define a partitioned variable with more than one partition templates, or a partition template and one or more other dimensions, in the dimension list.

What should we do to fix it:

Use only a partition template in the dimension list of the variable. All dimensions of the variable must be included in the definition of the partition template.