REP-0004: Warning: Unable to open user preference file while running reports.

May 2nd, 2026, posted in Oracle EBS Application
Share
Error :

Enter Password:
REP-0004: Warning: Unable to open user preference file.
REP-0069: Internal error
REP-57054: In-process job terminated:Finished successfully but output is voided
Cause :

Windows
ORACLE_HOME\CAUPREFS.ORA (user preferences)
ORACLE_HOME\CAGPREFS.ORA (global preferences)
UNIX
your_home_directory/prefs.ora (user preferences)
$ORACLE_HOME/tools/admin/prefs.ora (global preferences)

Share

RMAN SCRIPT TO MAKE BACKUP WITH DATES

April 12th, 2026, posted in Oracle
Share
Share

Checking Tablespace Utilization In Oracle

April 4th, 2026, posted in Oracle Queries
Share
SELECT TABLESPACE_NAME, USED_SPACE,TABLESPACE_SIZE,USED_PERCENT FROM DBA_TABLESPACE_USAGE_METRICS ORDER BY USED_PERCENT DESC;
Select f.tablespace_name , to_char(t.total_space,'9999,9999') "TOTAL(MB)" , to_char((t.total_space-f.free_space),'9999,9999')"USED(MB)", to_char(f.free_space,'999,999') "FREE(MB)", to_char((round(((t.total_space-f.free_space)/t.total_space)*100)),'999')||'%' PER_USED, to_char((round((f.free_space/t.total_space)*100)),'999')||'%'PER_FREE from (select tablespace_name , round (sum(blocks * ( select value/1024 from v$parameter where name='db_block_size')/1024)) free_space from dba_free_space group by tablespace_name)f , (select tablespace_name , round(sum(bytes/1048576)) total_space from dba_data_files group by tablespace_name ) t where f.tablespace_name=t.tablespace_name ;
select tablespace_name , file_name, autoextensible , bytes/1024/1024 "USED SPACE(MB)", maxbytes/1024/1024 " MAX SIZE(MB) " from dba_data_files order by tablespace_name,file_name ;
Share

Dua Ahad

March 19th, 2026, posted in Dua
Share

Share

Happy Birthday With A Cake

March 7th, 2026, posted in DAtEs iN a YeAR
Share
Share