OFA client error odbc32.dll or odbcnt.dll

While installing Oracle Financial Analyzer client software you get some error regarding odbc32.dll or odbcnt.dll

rename odbc32.dll and odbcnt.dll in c:/windows/system32

and press retry

default values in discoverer plus login page

If you want these values default on your discoverer 10g plus/Viewer login page.

Connect to :
Database :

Edit your URL as follows :

http://disc-host.disc-domain:disc-port/discoverer/viewer?connectionAccessType=APPS&Database=database-SID

http://disc-host.disc-domain:disc-port/discoverer/viewer?connectionAccessType=APPS&Database=database-SID


replace the original value for bold characters

arabic report imp doc ids

arabic Appears As Question Marks In Reports -----key link---- Doc ID: Note:199429.1 Type: PROBLEM

9iAS: Arabic Characters Displayed Question Marks Doc ID: Note:208901.1 Type: PROBLEM
Difference between AR8MSWIN1256 and AR8ISO8859P6 characterset Doc ID: Note:260023.1 Type: BULLETIN

Question Marks (?) in Diagrammers and RON when using Arabic NLS Doc ID: Note:108973.1 Type: PROBLEM

Printing and Previewing Arabic Reports using PASTA in Oracle Applications 11i Doc ID: Note:179801.1 Type: HOWTO

Subject: How To Print Arabic Reports in PDF Format? Doc ID: Note:430774.1 Type: HOWTO

cannot connect 11i using Discoverer/ADI/TOAD

Problem cannot login through applications user using ADI/Discoverer/TOAD :

the Oracle Applications Authentication mode is defined in the the Applications context file:
$APPL_TOP/admin/_.xml context file

Look for the following context variable: s_appserverid_authentication
By default, in E-Business Suite 11.5.10, this is set to SECURE. In previous E-Business Suite 11i versions, this was set to OFF.There are 3 Modes of authentication:

* ON : Partial
* SECURE : activates full server security (SECURE mode)
* OFF : deactivates server security

As a workaround, you may set this to OFF from the default of SECURE.Run Autoconfig to instantiate the changes.
Now you should be able to access E-Business Suite 11.5.10 databases using Discoverer/ADI/TOAD.

enable all disabled triggers in 11i

query to see how many trigger disabled

select count(*)from dba_triggerswhere status = 'DISABLED' and owner !='SYS';


run this script as trig.sql as sysdba

--------------------------------------------------


set serveroutput on size 1000000set verify offset serveroutput on
DECLAREsql_cmd varchar2(1024);
cursor cur_record isselect distinct OWNER,TRIGGER_NAMEfrom dba_triggerswhere status = 'DISABLED' and owner!='SYS';
trig_rec cur_record%ROWTYPE;
BEGINDBMS_OUTPUT.PUT_LINE('START OF PROGRAM');
FOR trig_rec IN cur_record LOOP
BEGINsql_cmd := 'alter trigger 'trig_rec.owner'."'trig_rec.trigger_name'" enable ';
EXECUTE IMMEDIATE sql_cmd;
DBMS_OUTPUT.PUT_LINE('Enabled : 'trig_rec.owner'.'trig_rec.trigger_name);
EXCEPTION WHEN others THENdbms_output.put_line('Error : 'trig_rec.owner'.'trig_rec.trigger_name);dbms_output.put_line(SQLERRM);END;
END LOOP;
DBMS_OUTPUT.PUT_LINE('END OF PROGRAM');
END;
/



------------------------------------------------------------------------------