KentW Limited

Back to R12 – Upgrade Overview

Many changes has been made to AP but all great improvements though.

Overview

• Suppliers: are now defined in Trading Community Architecture – TCA
• Invoice lines: entity added between header and distributions
• Banks and bank accounts: now part of Cash Management
• Banks and branches: are now defined in TCA like suppliers
• Payment document sequence numbers: has been moved to bank account uses
• Payments: moved to and integrated with Payments for funds disbursements
• Accounting: moved to and integrated with Subledger Accounting
• Tax: moved to and integrated with E-Business tax

Suppliers

Supplier entry has moved from the professional screens to OAF screens:

Invoice Lines

The addition of invoice lines enables AP to retain the external representation of an invoice keeping internal accounting on the distribution lines.

So an external invoice with two products would have an invoice header with two invoice lines. If each of the products are split between two departments then the invoice would have four distribution lines.

The invoice lines are added as an extra tab in the invoice workbench:

The representation also ties better in with Purchasing where items are ordered at line level and distributed at shipment level.

The distribution lines are still in a separate screen as in the old days:

Banks, Bank Branches and Banks Accounts

Banks and bank accounts have been split into two parts:

• Bank and bank branches as organisations is now defined in TCA
• Bank accounts as financial information is now defined in Cash Management – CE
• Bank accounts are owned by the legal entity and can now be shared by multiple organisations

More details in the R12 – Cash Management blog entry.

Payments

Payment has been completely revamped and got it’s own module now – Oracle Payments – however the payments screens can still be accessed from Payables if user setup allows.

Payments can also be setup for a central treasury organisation to issue payments from different payables organisations as long as they are all in same legal entity. In the latter case the payables clerk would issue a payment request however the central treasury organisation would issue the payment instruction to the bank.

More details in the R12 – Payments blog entry.

Accounting

The Payables accounting architecture has been changed from being local to AP to utilise the new module Subledger Accounting.

To generate accounting and transfer to GL process itself is not much different however.

Concurrent program “Create Accounting”:

The Invoice Workbench – Create Accounting options matches the Subledger Accounting functionality:

Draft: to create accounting that can be viewed and modified

Final: to create accounting ready for posting to GL

Final Post: to create accounting and immediately post it to GL

All Subledger Accounting is now based on Payables accounting events. These accounting events are predefined in Payables and can be translated into actual accounting by the Subledger Accounting system.

Accounting Events form:

Note this is a standard Subledger Accounting form so it will look similar in other subledgers as well.

How the accounting event to account translation works is described in the blog section: R12 – Subledger Accounting

Tax

The tax architecture has changed from being part local to AP and AR to be a separate module – E-Business Tax.

An invoice still has the same amount of tax lines however new fields has been added like Tax Regime.

The tax regime determines what tax codes are available.

Tax Details form:

This tax architecture is for sales and value added taxes only and does not manage income and withholding tax.

When tax is calculated is determined by tax events similar to accounting events.

Tax Events form:

To determine the tax defaults – AP has a number of predefined tax drivers. This is very different from 11i but gives more flexibility for defaulting based on the type of invoice which is mapped to an event class.

Tax Drivers form:

More details in the R12 E-Business Tax blog entry.

So you got R12 up and running and want to connect to it from a Vbox machine?

I’m running R12.0.4 on OEL5.3 with Virtualbox 2.2.2 having a Windows 7 machine.

R12

R12 is installed on OEL with the hostname: localhost.localdomain

Firefox works locally against R12 so the EBS stack in working at this point.

Start the database, listener and apps. See Managing R12:

$ addbctl start

$ addlnctl start VIS

$ adstrtal apps/apps

To test if a database network connection would work try:

$ sqlplus apps/apps@VIS

Virtualbox

Installed Vbox 2.2.2 on OEL. Get it from http://www.virtualbox.org

Setup Vbox host-only network in \File\Preferences

 

and give it a ip like 192.168.2.7 on the adapter tab:

 

and setup the dhcp tab like this:

When the Vbox machine is started you should be able to ping it:

Windows 7 in Virtualbox

I use Windows 7 RC.

Create a Vbox machine and mount the downloaded Win7 ISO as CDROM and run install:

 

You get it from here:

 

Setup Vbox networking like this:

This will communicate through the 192.168.2.7 ip address.

When Window 7 is installed create a new entry in the file:

C:\windows\system32\drivers\etc\hosts

like this:

Pointing to localhost.localdomain so Firefox R12 login works.

To ensure everything work try to ping localhost:

SQLDeveloper

If you want to do development then this tool is great. Get it from:

http://www.oracle.com/technology/products/database/sql_developer/index.html

I installed version 1.5.1.

Setup the connection:

I just used the ip address here and it works fine.

Firefox

To run R12 forms and framework you need Firefox 2.

Install Firefox 2 in Win7. I installed version 2.0.0.14. Get it from:

http://www.mozilla.com/en-US/firefox/all-older.html

Allow localhost.localdomain is Firefox security:

and pop-ups:

To start R12 enter the URL:

http://localhost.localdomain:8000/OA_HTML

And you get the login screen:

Java

Java is a must for R12. Check the version required when you have logged in to R12 and click a forms screen

In 12.0.4 it is 1.5.0.13:

Then install Java 1.5.0.13 to ensure you don’t get plug-in issues with R12. Get it from:

http://java.sun.com/products/archive/j2se/5.0_13/index.html

As Firefox only supports one Java plug-in at any one time check the directory for plug-ins:

C:\ > DIR “C:\Program Files\Mozilla Firefox\plugins”

Ensure you only have one Java plug-in here. If it is missing the do this:

C:\ > copy C:\Program Files\Java\jre1.5.0_13\bin\NPJPI150_13.dll C:\Program Files\Mozilla Firefox\plugins

Restart Firefox and now everything should work.

Well why make a post about this?

OEL does not seem to be a complete operating system – it feels like Linux 5 years ago with loads of drivers missing and command line fiddling.

One chapter for each part…

Graphics

This does work out of the box but the built in driver is not great and make the fan run at full all the time.

If you installed in Virtualbox then fix the graphics card by getting this driver:

http://www.nvidia.com/object/linux_display_ia32_180.51.html

You have to install it outside X11 so issue this command:

$ init 3

To exit X11 and login to a command prompt.

Then run the Nvidia install script:

$ ./NVDIA*run

When done then:

$ init 5

To get X11 back.

Network

Should work. Ensure that \System\Administration\Network has a entry using Marvell network driver.

Wireless

I configured the network is two steps.

First ensure you got a wlan0 device in \System\Administration\Network in Devices and Hardware tab.

Next ensure you have define wlan security in \System\Preferences\More Preferences\Network Connections in Wireless tab.

After all this wireless still doesn’t work but try these two lines:

$ chkconfig NetworkManager on
$ service NetworkManager start

This starts the wireless service and now it should work.

Bluetooth

Bluetooth does not work immediately – for some reason it does not detect any devices. You normally get this:

$ hcitool scan
Scanning …
Inquiry failed: Connection timed out

First reset Bluetooth to enable discovery:

$ hciconfig hci0 reset

If the Bluetooth does not discover after reboot try to add the reset to /etc/modprobe.con

options hci_usb reset=1

Then scan for any devices:

$ hcitool scan
00:1D:D8:98:6F:23       Microsoft Bluetooth Notebook Mouse 5000

Bingo – things start to work now…

Next configure the security settings by editing /etc/bluetooth/hcid.conf and change to (in bold):

# HCId options options {         # Automatically initialize new devices         autoinit yes;         # Security Manager mode         #   none – Security manager disabled         #   auto – Use local PIN for incoming connections         #   user – Always ask user for a PIN         #         security auto;         # Pairing mode         #   none  – Pairing disabled         #   multi – Allow pairing with already paired devices         #   once  – Pair once and deny successive attempts         pairing multi;         # Default PIN code for incoming connections         passkey ""; } device 00:1D:D8:98:6F:23  {         name "Microsoft Bluetooth Notebook Mouse 5000"; }

Then ensure the Bluetooth manager discovers the device by editing /etc/default/bluetooth:

# Defaults for bluez # start bluetooth on boot? # compatibility note: If this variable is not found bluetooth will # start BLUETOOTH_ENABLED=1 # This setting will switch HID devices (e.g mouse/keyboad) to HCI mode, that is # you will have bluetooth functionality from your dongle instead of only HID. # Note that not every bluetooth dongle is capable of switching back to HID # mode, see http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=355497 HID2HCI_ENABLED=1 HID2HCI_UNDO=1 HIDD_ENABLED=1 HIDD_OPTIONS="–connect 00:1D:D8:98:6F:23 –server"

Then restart Bluetooth:

$ /etc/init.d/bluetooth restart

Connect to the new device using:

$ hidd –search
Searching …
        Connecting to device 00:1D:D8:98:6F:23

And everything should work now!!!

At least my MS BT mouse did except for the scroll wheel.

MS BT Mouse – Microsoft Bluetooth Notebook Mouse 5000

First get the Bluetooth to work as above.

 

Touchpad

When touching my touchpad it is erratic.

First get hold of your input devices.

Probe the mouse devices using this command:

$ udevinfo -a -p `udevinfo -q path -n /dev/input/mouse1`

And change the mouse# until you get an output like:

looking at device ‘/class/input/input2/mouse1′:   KERNEL=="mouse1"   SUBSYSTEM=="input"   SYSFS{dev}=="13:33" looking at parent device ‘/class/input/input2′:   ID=="input2"   BUS=="input"   DRIVER==""   SYSFS{modalias}=="input:b0011v0002p0008e7321-e0,1,2,3,k110,111,112,145,14A,r0,1,a0,1,18,mlsfw"   SYSFS{uniq}==""   SYSFS{phys}=="isa0060/serio1/input0"   SYSFS{name}=="AlpsPS/2 ALPS GlidePoint"

The ALPS is your touchpad.

Update your /etc/X11/xorg.conf to include mouse1:

… Section "ServerLayout"     Identifier     "single head configuration"     Screen      0  "Screen0" 0 0     InputDevice    "Mouse0" "CorePointer"     InputDevice    "Mouse1" "SendCoreEvents"     InputDevice    "Keyboard0" "CoreKeyboard" EndSection Section "InputDevice"     # KWI: Synaptics     Identifier     "Mouse1"     Driver         "synaptics"     Option         "Protocol" "auto-dev"     Option         "Device" "/dev/input/mice"     Option         "SendCoreEvents" "true"     Option "LeftEdge" "120"     Option "RightEdge" "830"     Option "TopEdge" "120"     Option "BottomEdge" "650"     Option "FingerLow" "14"     Option "FingerHigh" "15"     Option "MaxTapTime" "180"     Option "MaxTapMove" "110"     Option "ClickTime" "0"     Option "EmulateMidButtonTime" "75"     Option "VertScrollDelta" "10"     Option "HorizScrollDelta" "0"     Option "MinSpeed" "0.45"     Option "MaxSpeed" "0.75"     Option "AccelFactor" "0.020"     Option "EdgeMotionMinSpeed" "200"     Option "EdgeMotionMaxSpeed" "200"     Option "UpDownScrolling" "1"     Option "CircularScrolling" "0"     Option "SHMConfig" "true" EndSection

Now we need to fix the erratic behaviour.

Edit /boot/grub/menu.lst and include “i8042.nomux=1” when starting Linux:

# grub.conf generated by anaconda # # Note that you do not have to rerun grub after making changes to this file # NOTICE:  You do not have a /boot partition.  This means that #          all kernel and initrd paths are relative to /, eg. #          root (hd0,0) #          kernel /boot/vmlinuz-version ro root=/dev/sda1 #          initrd /boot/initrd-version.img #boot=/dev/sda default=0 timeout=5 splashimage=(hd0,0)/boot/grub/splash.xpm.gz hiddenmenu title Enterprise Linux (2.6.18-128.el5)     root (hd0,0)     kernel /boot/vmlinuz-2.6.18-128.el5 ro root=LABEL=/ rhgb quiet i8042.nomux=1     initrd /boot/initrd-2.6.18-128.el5.img

Reboot and the touchpad should work now.

This post is written in Windows 7 RC running in Virtualbox inside Oracle Enterprise Linux (OEL) 5.3 – good fun!

OEL is in reality a Red Hat Enterprise Linux, which is a bit amputated in term of applications and drivers.

The reason for this constellation is OEL 5.3 Supports eBusiness Suite R12 and RDBMS 10g.

Next step is to make Win7 to speak to a R12 installation.

Using
c:> net use x: d:/path
To assign drive.

Copy and paste of files works fine but if you try to install any software from the shared drive or read media it doesn’t work.

Even running WIN7 on top of Vista resulted in errors using shared folders.

Would be nice to resolve this problem…

Until then just copy/paste files from the shared drive to C: and work from there.

I recommend you to start with this article to get R12 up and running.

Firefox

Firefox 3 does not work with R12. I could get forms to work however framework pages had problems with buttons. So install Firefox 2 instead.

Java Plug-in

For R12.0.4 on OEL desktop you want to use JRE 1.5.0.13 otherwise you have to fiddle with the context file.

You can always connect to the EBS from Windows but you want to test if the EBS stack works at all first.

I tried and could not get it to work in Linux with any other JRE version.

Download Java plug-in JRE 1.5.0.13 from:

http://java.sun.com/products/archive/j2se/5.0_13/index.html

For Linux

Install JRE using this script (java.sh):

#!/bin/bash SOURCE=/oracle/install/jre JAVA=/usr/java DIR=jre1.5.0_13 PLUGIN=libjavaplugin_oji.so if [ ! -d $JAVA/$DIR ] #check if already installed then     if [ ! -d $DIR ] #check if already unpacked     then         $SOURCE/jre-1_5_0_13-linux-i586.bin     fi fi if [ ! -d $JAVA/$DIR ] #check if already installed then     mv $DIR $JAVA fi if [ -d $JAVA/$DIR ] #check if already installed then     rm -f /usr/lib/mozilla/plugins/$PLUGIN #remove plugin     ln -s $JAVA/$DIR/plugin/i386/ns7/$PLUGIN /usr/lib/mozilla/plugins #recreate plugin link fi

The script is using the plugin in …/ns7/… otherwise Firefox will regularly crash especially “manage addons” in preferences.

For WindowsXP

First ensure no NP* plug-in files exist in C:\Program Files\Mozilla Firefox\plugins:

$ del C:\Program Files\Mozilla Firefox\plugins\NP*

Manually copy the correct java version plug-in to the Mozilla plug-in:

$ copy C:\Program Files\Java\jre1.5.0_13\bin\NP* C:\Program Files\Mozilla Firefox\plugins

In case you have more than one version of java installed you may need to disable Mozilla Java plugin scan.

Enter the URL: about:config like this:

In the filer box enter JRE and you will get:

Double click on the value and update to 1.9 which is a java version that does not exist yet and hence essentially disables the java plug-in scan.

Close and restart the browser and now 1.5.13 should always be the default.

Connect

Enter the following URL in Firefox to connect to EBS

http://localhost.localdomain:8000/OA_HTML/AppsLogin

Login as SYSADMIN and password SYSADMIN

Use this script (vis.sh) to initialise the Oracle environment.

I recommend you to start with this article to get R12 up and running.

Run as Oracle user:

$ . ./vis.sh

Note the dot and space in front of a script to assign variables to the current environment.

#!/bin/bash shopt -s expand_aliases ORACLE_SID=VIS ORACLE_HOST=`hostname -s` CONTEXT_NAME=${ORACLE_SID}_${ORACLE_HOST} TECH_HOME=/oracle/${ORACLE_SID}/db/tech_st/11.1.0 APPS_HOME=/oracle/${ORACLE_SID}/apps/apps_st/appl alias techenv=’. ${TECH_HOME}/$CONTEXT_NAME.env’ alias appsenv=’. ${APPS_HOME}/$CONTEXT_NAME.env’ APPSENV="$APPS_HOME/$CONTEXT_NAME.env" if [ ! -f $APPSENV ]; then    echo "Environment file $APPSENV is not found"    exit else    . $APPSENV fi for SCRIPT in $ADMIN_SCRIPTS_HOME/*.sh do     BASE=`basename $SCRIPT | sed ’s/.sh//g’`     alias $BASE="$SCRIPT" done TECHENV="$TECH_HOME/$CONTEXT_NAME.env" if [ ! -f $TECHENV ]; then    echo "Environment file $TECHENV is not found"    exit else    . $TECHENV fi for SCRIPT in $TECH_HOME/appsutil/scripts/$CONTEXT_NAME/*.sh do     BASE=`basename $SCRIPT | sed ’s/.sh//g’`     alias $BASE="$SCRIPT" done

This article applies to:

EBS 12.0.4 on OEL5.3
EBS 12.1.1 on OEL5.4
RDBMS 10g on OEL5.3
RDBMS 11g on OEL5.3 and OEL5.4

I recommend you to start with this article to get R12 up and running.

Login

This is my own login script which you can see here.

Login to OEL as Oracle and run login script:

$ . ./vis.sh

Ensure you also got the first dot so it is the current environment you are setting environment variables for.

Startup

Start database:

$ addbctl start

Start database listener:

$ addlnctl start VIS

Start application server and concurrent managers:

$ adstrtal apps/apps

Shutdown

Start with shutting down application server and concurrent managers:

$ adstpall apps/apps

Wait until all concurrent processes has stopped.

I use this commend to check for that:

$ ps –fed | grep VIS

When only the database processes are left then shut down the database:

$ addbctl stop

Then finally stop the listener:

$ addlnctl stop VIS

Connect

Enter the following URL in Firefox to connect to EBS

http://localhost.localdomain:8000/OA_HTML/AppsLogin

Login as SYSADMIN and password SYSADMIN

Modify Managers

After installing R12 you have more than 200 oracle processes running – check with:

$ ps –fed | grep VIS | wc –l

The managers take up cpu and disk i/o.

Reduce the number of concurrent managers running to something like this:

Use Define Concurrent Managers and reduce to workshift to 0 for non-essential managers.

Also reduce the Standard Manager to 2. You need a minimum of two of a program starts a sub process.

This should get you down to around 120 processes. The system should feel more responsive now.

If you need to work with Inventory or similar find the managers relating to this application and re-activate.

Errors

Remove Persistent Locks (error 204)

If the adstrtal.sh returns error 204 it may be due to locks. Use the following script rmlock.sh:

#!/bin/bash rm -frv $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/* rm -frv $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/* rm -frv $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*

Timeouts (error 150)

If the adstrtal.sh returns error 150 it may be due to timeouts. This can happen for any of the subscripts called by adstrtal.sh especially if you try to start EBS within Virtualbox or you have a slow USB disk.

To remedy do the following:

$ vi $CONTEXT_FILE

Manually search and replace >100< with >900<

$ vi opmn/config/opmn.xml

Manually update timeout from >600< to >1800<

Internal Server Error (error 500)

If the browser comes out with:

500 Internal Server Error

…and much more…

Then the JSP files may be corrupt.

I fixed it by compiling them:

Compile JSP:

$ cd $FND_TOP/patch/115/bin
$ perl ojspCompile.pl –compile –flush -p 2

Temp Tablespace Exceeded (ORA-01652)

The default temp tablespace datafile is around 1G which may be too small

In order to change this you can issue this command from SQL as SYSTEM:

sql> alter database tempfile ‘/oracle/VIS/db/apps_st/data/temp1_01.dbf’ autoextend on maxsize 10000m ;

Which enables the system to extend the file to 10Gb

Be sure to extend all tempfiles which on a standard VIS installation is temp1_01.dbf and temp2_01.dbf.

Unable to authenticate session

You might see this screen instead of the login screen.

If this happends in Firefox but IE works ok then try to clear the Firefox cache in \Tools\Clear Private Data and then ensure to also select Cookies.

Slow database connection

You might see Oracle Applications starting very slowly – like taking more than a half an hour. This could be due to slow sqlnet connection.

First open a command line and type:

$ sqlplus apps/apps

This should connect fast as it bypasses sqlnet. If not you have a CPU or IO performance problem.

Next try:

$ sqlplus apps/apps@VIS

If this is slow then you might have a slow sqlnet connection.

Check /etc/hosts:

# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
::1                     localhost.localdomain localhost

I have experiences either the ::1 is missing or pointing to the wrong ip name. Ensure the two lines points to the same name. The problem arises as the new sqlnet has started to use ipv6 which is the ::1 entry.

In 12.0.4 ipv6 was not used but in 12.1.1 ipv6 was introduces maybe with RDBMS 11g

ORA-01031: insufficient privileges

If you get this during database startup on 11g on OEL 5.4 it may be because you have incorrect security setup.

This was not a problem in 10g but Oracle can’t stop changing things…this is also called progress!

1. Check /etc/passwd and ensure you got the following line:

oracle:x:500:500:oracle:/home/oracle:/bin/bash

This is normally set correct. The important bit is the default group – the second 500 value.

2. Check /etc/group and ensure you got the following lines:

bin:x:1:root,bin,daemon,oracle
deamon:x:2:root,bin,daemon,oracle
sys:x:3:root,bin,adm,oracle
adm:x:4:root,adm,daemon,oracle
oracle:x:500:oracle
oinstall:x:501:oracle

So add oracle user not only to the usual oralce created groups but also to bin,daemon,sys and adm groups.

This is the hardware and software I use for the R12 Laptop.

I recommend you to start with this article to get R12 up and running.

Laptop

My laptop is a Dell XPS M1530 with the following specs:

CPU	Intel® Core™ 2 Duo Processor T8300 (2.40 GHz, 800 MHz FSB, 3 MB L2 cache)
Memory	3072MB 667MHz Dual Channel DDR2 SDRAM [1x2048+1x1024]
Video Card	NVIDIA® GeForce™ Go 8600M GT with 256Mb dedicated graphic memory
Hard Drive	500Gb (5.400rpm) SATA Hard Drive
OS	Microsoft VISTA SP1
LCD	15.4" Widescreen WXGA+ (1440×900) TFT Display with TrueLife™

Virtualbox

Get it from http://www.virtualbox.org

I have tried to run EBS from Vbox both using a VDI and direct to EXT3 however it just doesn’t perform on a laptop.

I even tried to use my eSATA as well to no avail.

Ubuntu

Get it from http://www.ubuntu.com/

Using Virtualbox you install Ubuntu to a VDI and when booted into this you can install it onto a USB stick attached with a USB Vbox filter.

If you then boot into Ubuntu using a USB stick file transfers is much faster. Very useful indeed when transferring Oracle files from NTFS to the external OEL USB disk.

Use this script (apmall.sh) to update OEL5.3 with correct libraries.

I recommend you to start with this article to get R12 up and running.

Update the SOURCE environment variable with your source dir.

First try to run

$ ./rpmall.sh chk

to show what is missing and then install with:

$ ./rpmall.sh inst

But beware this script is flawed. I did change it a few times and you will have to as well.

#!/bin/bash RPMDO=$1 SOURCE=/oracle/install/oel5.3 cd $SOURCE rpmchk(){     if [ -z $2 ]     then         rpmname="$1"     else         rpmname="$1-$2"     fi     rpm –quiet -q $rpmname     if [ $? -eq 0 ]     then         echo "GOOD $rpmname installed"     else         rpm –quiet -q $1         if [ $? -eq 0 ]         then             echo "OK   $1 installed – different version"         else             cnt=`ls $rpmname*.rpm 2> /dev/null | wc -l`             if [ $cnt -gt 0 ]             then                 getitfrom=`ls $rpmname*.rpm`             else                 getitfrom=`grep "$rpmname" cdrom.[1-5]`             fi             echo "BAD  $1 not installed: in $getitfrom"         fi     fi } rpminst(){     rpmname="$1"     rpm –quiet -q $rpmname     if [ $? -gt 0 ]     then         cnt=`ls $rpmname*.rpm 2> /dev/null | wc -l`         if [ $cnt -gt 0 ]         then             echo "Installing: $rpmname*.rpm"             rpm –nosignature -i $rpmname*.rpm         else             echo "Install file missing: $rpmname*.rpm"         fi     fi } rpmact(){     case "$RPMDO" in         chk)             rpmchk $1 $2         ;;         inst)             rpminst $1 $2         ;;         *)             echo "Bad argument – use inst, chk or all"             exit         ;;     esac } # #Field1: always "rmpact" #Field2: package name (optionally add version if must exist) #Field3: package version (minimum version) # #Next required by Openmotif rpmact libXp 1.0.0-8.1.el5 #Following 3 downloaded from: #    http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux rpmact openmotif21 2.1.30-11.EL5 rpmact xorg-x11-libs-compat 6.8.2-1.EL.33.0.1 rpmact binutils 2.17.50.0.6-6.0.1 #Requirements from Metalink: rpmact compat-glibc 2.3.4-2.26 rpmact gcc 4.1.2-14.el5 rpmact gcc-c++ 4.1.2-14.el5 rpmact glibc 2.5-12 rpmact glibc-common 2.5-12 rpmact glibc-devel 2.5-12 rpmact libgcc 4.1.2-14.el5 rpmact libstdc++-devel 4.1.2-14.el5 rpmact libstdc++ 4.1.2-14.el5 rpmact make 3.81-1.1 rpmact gdbm 1.8.0-26.2.1 rpmact libXp 1.0.0-8.1.el5 rpmact libaio 0.3.106-3.2 rpmact libgomp 4.1.2-14.el5 rpmact compat-libstdc++-296-2.96-138 rpmact compat-libstdc++-33-3.2.3-61 #Following not in 5.3 discs #rpmact sysstat 7.0.0-3.el5 #Following on disc 3 rpmact sysstat 7.0.2-3.el5.i386

This article applies to version 12.0.4.

I recommend you to start with this article to get R12 up and running.

Download

• Oracle E-Business Suite – EBS
  from http://edelivery.oracle.com/
• Rapid Install patch 6919017
  from http://metalink.oracle.com

Transfer Files

Boot into Ubuntu and transfer files to the /oracle partition for example /oracle/install

Unzip

Boot into OEL and login as oracle.

Alternatively you can unzip from NTFS to /oracle using Ubuntu but be sure to set file ownership correctly when in OEL:

$ chown –R oracle:oracle /oracle

Unzip EBS files into /oracle/stage:

$ ./unzip.sh V*

Unzip patch 6919017 into /oracle/stage

$ ./unzip.sh p6919017*

I used this script (unzip.sh):

#!/bin/bash SOURCE=/oracle/install/ebs12.0.4 if [ -z "$1" ] then     echo "enter filename with wildcard to unzip"     exit fi for zipfile in $SOURCE/$1.zip do     unzip -o $zipfile -d /oracle/stage done

Also I had a bug once caused by security issues in the stage directory – to fix do this:

$ chmod –R 777 /oracle/stage/startCD

Install

Always do this in OEL as the oracle user.

Many other people has described this process for example:

http://newappsdba.blogspot.com/2008/10/walk-through-installing-r12.html

Use /oracle as base directory though. This will create EBS in /oracle/VIS.

This directory can easily be moved around to different disks as long as you keep the mount point to /oracle.

I call the rapidwiz using a script – useful if you have to restart:

#!/bin/bash cd /oracle/stage/startCD/Disk1/rapidwiz ./rapidwiz