Oracle Apps DBA - - Some Observations

Arabic in pdf reports

2008-09-18T04:55:00.000-07:00

Arabic is not possible in 6i pdf reports. The two solutions which is possible are following :

1. Use xml publisher and develop all reports in xml.

2. Install Acrobat distiller software in ur PC (client machine). Develop report in 6i. And register that report output format as PostScript format. But in this you will have to install Acrobat Distiller on every users PC who is using this report.

arabic report coming as question marks ???????

2008-07-05T07:02:00.000-07:00

The standard report was not coming with arabic data though character set supports Arabic :

There are two solutions :

1. Try set profile option FND: NATIVE CLIENT ENCODING to ARISO..... or ARWINS.....

OR

2. Use pasta viewer to view non english language :

login through sysadmin > install > viewer > add a new line
text apps/bidi pasta viewer

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

search .prt file you are using with the help of below query --

SELECT PRINTER_DRIVER_NAME, USER_PRINTER_DRIVER_NAME, PRINTER_DRIVER_METHOD_CODE, SPOOL_FLAG, SRW_DRIVER, COMMAND_NAME, ARGUMENTS, INITIALIZATION, RESET
FROM FND_PRINTER_DRIVERS
WHERE PRINTER_DRIVER_NAME = (SELECT PRINTER_DRIVER
FROM FND_PRINTER_INFORMATION
WHERE PRINTER_STYLE = (SELECT PRINT_STYLE
FROM FND_CONCURRENT_REQUESTS
where request_id = <>) AND PRINTER_TYPE = (SELECT PRINTER_TYPE
FROM FND_PRINTER
WHERE PRINTER_NAME = (SELECT PRINTER FROM FND_CONCURRENT_REQUESTS where request_id = <>)))

insert these lines in .prt file at the end

----------------------------------------
nls locale "arabic"
nls datastorageorder "logical"
nls contextuallayout "no"
nls contextualshaping "yes"
-------------------------------------------

set this in system profile options :
Viewer: Application for Text = pasta viewer

OFA client error odbc32.dll or odbcnt.dll

2008-06-24T07:22:00.000-07:00

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

2008-06-24T07:00:00.000-07:00

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

2008-06-24T06:59:00.000-07:00

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

2008-06-24T06:54:00.000-07:00

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

2008-06-24T06:50:00.000-07:00

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;
/

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

Reverse Proxy

2007-11-05T11:34:00.000-08:00

Reverse proxy is an intermediate server that sits between a client and the actual web server and makes requests to the web server on behalf of the client.
It is generally used when configuring DMZ with Oracle applications. If it is properly configured it enhances the security level.

More post on this is on the way....

Implementing HRMS in 11i

2007-09-27T01:35:00.000-07:00

To implement HRMS apply patch HR_PF.K Rup 1 (patch 5055050).
Now you can follow the following patch sets to implement HRMS with india legislation :

1. 6196112 Global HR patch
2. 6339534 Global HR patch
3. 6348219 Global HR patch
4. 5853811 India Legislation Patch

Apply additional payroll updates also :

1. 5972562 END OF YEAR 2006-2007 CHANGES AND NEW YEAR STATUARY UPDATE

2. 6021023 FORM 16/16AA - AMENDMENTS

Refer to these metalink documents for more details :

NOTE. 375001.1 IN Legislation : Mandatory installation and Patch list.
NOTE. 297146.1 Oracle HRMS for India Supplement
NOTE. 283267.1 APAC HRMS Mandatory Patches
NOTE. 369718.1 India Income Tax Reports

Change IP address of an existing Apps server

2007-08-19T05:07:00.000-07:00

This scenario solely depends on how you have carried out Installations. While installations if you have used only hostname of servers instead of IP address then the activity becomes very simple.

Otherwise you can check fnd_profile_option_values where profile_option_value has an ip style number in it. Check icx_parameters so see whether an vals in there are IP numbers, check the tnsnames and listener.ora files in the oracle homes to see if they have ips or names and a quick check, if someone has not manually updated it ... if you are autoconfig enabled, check the context file ( $APPL_TOP/admin/.xml ) to see whether it has IPs or names in it.

Steps :

1. Shut down the Application as well as database.

2. Change the IP address at OS level and restart the Network daemon.

3. Bring up the database listener.

4. Startup the databse.

5. run auto config at databse then at all middle tier starting from admin node. It should complete successfully.

6. Bring up the middle Tier. They should come up without any error.

Chaging port of Web listener after installation

2007-08-03T22:00:00.000-07:00

This note applies to Oracle Applications 11.5.10.2
I have implemented this in one of my project at client location.

Follow these easy steps to change the port of web listener of your live system.

Assumptions:

1. Current port is 8080 and need to be changed to 8000.

Steps :

1. Logon to middle Tier and open the confiduration .xml file (resides in $APPL_TOP/admin) with editor. I have used vi as my editor.

2. Replace any occurrance of 8080 with 8000. You can use this command in vi to replace the string 8080
:%s/8080/8000/g

3. Save the file and exit.

4. Now run the autoconfig on the middle Tier. And Restart all the middle tier services.

5. Now try to open the instance login page with new port.

If you are using multi-Node system. The you have to edit every node's xml file and run autoconfig on each node seperately.

Cloning (multi node to single node) oracle Shared Application file system

2007-08-01T23:20:00.000-07:00

I didn't find any clear note on cloning of shared application tier file system. I have implemented this for one of our client. Hence, I am posting. Hope it help you out.

Source server Specifications :

Number of Nodes : 3
Node1 : Database
Node2 : Admin & Concurrent server (NFS Share)
Node3 : Forms $ web (NFS mount)

Target server Specification :

Node 1 : All services

Operating System : Solaris 10

Application Version : 11.5.10.2

Steps :

note : While cloning assume the shared file system server as single node server.

1. Run adpreclone.pl at node on which admin server is installed.

$perl adpreclone.pl appsTier

In shared application file system you need NOT use "merge" option with adpreclone.

If you are using solaris you will have to define env varaiable PATH and PERL5LIB to successfully run this command.

2. Run adpreclone.pl at database tier.

$perl adpreclone.pl dbTier

3. Copy all the file system from source node to target node. You can use tar and gzip command to create file for transfer.

Copy the following application tier directories from the primary node of your source system to the target application tier node, retaining the original directory structure:

– [APPL_TOP]
– [OA_HTML]
– [OA_JAVA]
– [COMMON_TOP]
– [806 ORACLE_HOME]
– [iAS ORACLE_HOME]

4. At target node uncompress the files.

5. Run the adcfgclone.pl at database end first then at appsTier.

perl adcfgclone.pl dbTier (DBTier)
perl adcfgclone.pl appsTier (appsTier)

6. run autoconfig on database end first then on apps tier.

7. Post Clone Tasks

Log in to the target system application tier node as the APPLMGR user.
Run the following tasks in adadmin for all products:
o generate JAR files
o generate message files
o relink executables
o copy files to destination

Installing Oracle Application with shared File system

2007-07-30T06:29:00.000-07:00

This activity I carried out in one of my Project for setting up a production. I am putting exact steps.

Installation Specifications :

Number of Nodes : 3
Node1 : Database
Node2 : Admin & Concurrent server (NFS Share)
Node3 : Forms $ web (NFS mount)

Operating System : Solaris 10

Application Version : 11.5.10.2

Steps :

1. create nfs share on node2 say /prodxyz. share /prodxyz.
2. create same directory /prodxyz in node3 also. Be sure when you do pwd in node2 or node3 this should exact same directory structure.
3. share (by nfs) /prodxyz in node2.
4. mount node2 /prodxyz on node3 /prodxyz.
5. check /prodxyz should have sufficient space for installation.

6. create database user in node1 say oraprod with home directory /prodxyz/oraprod. Note that there is no nfs mount from node2 on this node1. we are just following uniformity.

7. create apps user in node2 and node3. take care that they should have same userid and group(generally dba) id. Also the oraprod should also have same group and group id as apps user. say apps user is appsprod.

8. Home directory of appsprod is /prodxyz/appsprod (which is shared).

9. Now begin the installation from database end (node1)

10. select multi node installation. It will ask you at some stage for node information. on that stage click on details tab. select node2 "INSTALL" and for node3 "share existing".

11. rest follow the screen as normal installation.

12. after installation on node1. begin installation on node2 sourcing the context file from node1.

13. after installation on node2 begin on node3 sourcing the same context file. Note that begin installation at node3 with appsprod user. otherwise installation will error out.

now leave rest on installer.

wow you have implemented applications shared file system !!