ORA-01950: no privileges on tablespace 'USERS'

Solution:

Verify User Quota from dba_ts_quotas dictionary table :

SQL>select TABLESPACE_NAME,USERNAME,MAX_BYTES,BYTES from dba_ts_quotas where USERNAME='SCOTT';

no rows selected

Assign unlimited Quota on users tablespace using alter command :

SQL>alter user scott DEFAULT TABLESPACE USERS quota unlimited on USERS;

User altered.

SQL> Grant unlimited tablespace to scott;

SQL>  select TABLESPACE_NAME,USERNAME,MAX_BYTES,BYTES from dba_ts_quotas where USERNAME='SCOTT';

TABLESPACE_NAME        USERNAME         BYTES         MAX_BYTES
---------------------------------------------------------------
 USERS                   SCOTT             327680           -1

Note: Max_Bytes - refers to User's Quota in bytes, or -1 if no limit.

SQL> exec DBREPORT.PROC_DB_GROWTH_INFO

PL/SQL procedure successfully completed.

Issue Resolved.