Skip to content

Expert Oracle Posts

REP-0189: Cannot write to Reports Server cache

Published June 17, 2016 By Brijesh Gogia

We had seen one issue in EBS R12 in which simple report porgamrs like “Active users”  were throwing erorrs like below:

 Enter Password:
 REP-0118: Unable to create a temporary file.

REP-0189: Cannot write to Reports Server cache
 REP-0069: Internal error
 REP-57054: In-process job terminated:Terminated with error:
 REP-189: Cannot write to Reports Server cache
 this is the error in Log file
 APPLLCSP Environment Variable set to :

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
 American_America.UTF8
Continue ReadingREP-0189: Cannot write to Reports Server cache
1 Comment

Move SQL PROFILE to other database

Published May 17, 2016 By Brijesh Gogia

A)  CREATE STAGING TABLE

First Create the staging table which will hold sql profiles to be moved over.

SQL> exec DBMS_SQLTUNE.CREATE_STGTAB_SQLPROF (table_name=>’SQL_STG_TAB’,schema_name=>’SYS’);

(This will create a table SQL_STG_TAB, which will be able to hold the required sql profiles, the structure of this table is exactly same as that of DBA_SQL_PROFILES table)

Continue ReadingMove SQL PROFILE to other database
Leave a Comment

Oracle Workflow related frequently used queries

Published April 12, 2016 By Brijesh Gogia

Below are some of the useful workflow script that we use frequently in our 11i/R12 instances

VERIFY THE WORKFLOW IMAP SETTING

set pagesize 100
set linesize 132 
set feedback off 
set verify off 
col value format a35 
col component_name format a30 
select c.component_id, c.component_name, p.parameter_id, p.parameter_name, v.parameter_value value 
from fnd_svc_comp_param_vals_v v, fnd_svc_comp_params_b p, fnd_svc_components c 
where c.component_type = 'WF_MAILER' 
and v.component_id = c.component_id and v.parameter_id = p.parameter_id and p.parameter_name in ( 'INBOUND_SERVER','ACCOUNT', 'REPLYTO') 
order by c.component_id, c.component_name,p.parameter_name;
1 Comment

Online Patching (ADOP) in Oracle EBS R12.2

Published February 21, 2016 By Brijesh Gogia

Online patching is supported by the capability of storing multiple application editions in the database, and the provision of a dual application tier file system. At any given point in time, one of these file systems is designated as run (part of the running system) and the other as patch (either being patched or awaiting the start of the next patching cycle).

Continue ReadingOnline Patching (ADOP) in Oracle EBS R12.2
32 Comments