Oracle Solution for Error ora-14752

ORA-14752: Interval expression is not a constant of the correct type

What triggered the Error:

You attempted to use either a nonconstant interval or an interval whose data type does not correspond to the partitioning column

What should we do to fix it:

Use only constant expressions for the interval. If the data type of partitioning column is numeric, the interval must be a numeric constant. If the data type is of type date/time, the interval must be a constant of interval type