Oracle Error ORA-36220: (XSLPDSC01) All dimensions in LIST number are also in the IGNORE clause.

Oracle 18 Views 0 Min Read

Oracle Error Message

ORA-36220: (XSLPDSC01) All dimensions in LIST number are also in the IGNORE clause.

Reason for the Error

One of the dimension lists in the dimension loop descriptor had no base dimensions except those in the IGNORE list. This leaves no dimensions for looping over.

Solution

Fix the dimension loop descriptor.

Tags: