Latest Technology Blog

Agenda : Apply NLS patch on top of 12.1.x In this artcile, i will explain how we can add second language to our Oracle E-Business Suite R12 NLS is not software its a patch which mean after you install EBS as you mention only American English avaliable. For instance you are living in United Arab Emirates and you need to Arabic language too for your EBS. So you have to follow: 1. First, donwload related language NLS pack from e-delivery 2. Upload this zip to your EBS server 3. Unzip file and change files permisson to applmgr user (let us say your applmgr user is applprod) 4.  Before start NLS be sure your Db character set should support related NLS(In this example Turkish language,dont forget this please 5. Open your Oracle Application Manager screen from EBS than license your Language(here its turkish)from OAM by using: Oracle Applications Manager >> License Manager >> Languages >> Turkish 6. Login as applmgr user,soru...

DATABASE MIGRATION (Windows 32-Bit to Linux 64-Bit) AIM:  Migrate the database from Windows 32-bit to Linux 64 bit Operating System. Environment:                 1. Oracle 11.2.0.1 on Windows 32-bit server                 2. Linux 5 installed on server Requirements:                 1. Oracle 11G Software for Linux 64 bit.                 2. WinScp                 3. Putty                 Procedure: Prepare Source Side for Migration: 1. Check whether the source is compatible with target OS      ...

Login fails “You are trying to access a page that is no longer active.” The issue can be reproduced at will with the following steps: Issue : After cloning process the login page of Oracle E-Business Suite R12 show the above error. Solution :  For this you need to update the new hostname in the  icx_parameteres table 1.   SQL> SELECT SESSION_COOKIE_DOMAIN FROM icx_parameters; SESSION_COOKIE_DOMAIN --------------------- erp.local.com (This is hostname of Source Application Tier) 2. SQL>update icx_parameters set SESSION_COOKIE_DOMAIN = ‘target.local.com’; 1 row updated. SQL> commit; Commit complete. (This has changed the SESSION_COOKIE_DOMAIN of target application to target hostname.domain_name) 3. SQL> SELECT SESSION_COOKIE_DOMAIN FROM icx_parameters; SESSION_COOKIE_DOMAIN --------------------- target.local.com