Oracle Message ORA-22971 - invalid datatype for PRIMARY KEY-based object identifier

ERRORinvalid datatype for PRIMARY KEY-based object identifier
CAUSEWhen creating an object view, the datatype of an expression in the WITH OBJECT OID clause is not allowed for PRIMARY KEY-based OID.
ACTIONReplace the expression with one of appropriate scalar datatype.