REP-1401: 'cf_nameformula0007': Fatal PL/SQL error occurred. ORA-06502: PL/SQL: numeric or value error

         Reasons

i.                    Return data type of formula column is a Number and you are returning character data type

ii.                  If both are of same data type then length of characters returning are exceeding from the declared variable in formula column or formula column itself.

Solution

Make sure data types are same and length is enough.