Message Oracle ORA-36315 - (PHYS04) You must specify the VALUE option for scalar relation workspace object.

ERROR(PHYS04) You must specify the VALUE option for scalar relation workspace object.
CAUSEThe VALUE argument to PHYSICAL was omitted for a scalar relation
ACTIONspecify VALUE or choose a dimensioned relation