You are not authorized to access this site. On accessing Extranet URL from Internet, we got this message:Access DeniedYou are not authorized to access this site. The application you are attempting to access requires additional authorization. If you feel you have received this message in error, please contact your local business Help Desk.This error is coming because we have SSO enabled our Extranet also. If the user exists in the SSO database and doesn't exist in the FND_USER table of Oracle E-Business Suite, this error would appear.After creating the users locally in E-Business Suite, this error should disappea...

How to download password protected patch from updates.oracle.com A metalink search revealed note 731257.1 which has the details. In short before issuing the get command you are required to issue the command site protected .In fact if you directly issue the get command you get the error message which says the same:ftp> bing200 TYPE changed to I.ftp> et p8995444_11i_d.zip200 PORT command OK.550-File or directory not found.550-This is a password protected patch.550-Enter the password with site command:550-quote site protected550 Then get the patch again.After issuing the site protected command it workedftp> site protected V5pIHQqk200 The password was received successfully.ftp> get p8995444_11i_d.zip200 PORT command...

What really happens when you enable maintenance mode before applying patches Maintenance Mode was introduced in AD.I patchset. Here's what the readme of AD.I (Article ID: 233044.1):Maintenance mode provides a clear separation between normal runtime operation of Oracle Applications and system downtime for maintenance. Enabling the maintenance mode feature shuts down the Workflow Business Events System and sets up function security so that no Oracle Applications functions are available to users. Used only during AutoPatch sessions, maintenance mode ensures optimal performance and reduces downtime when applying a patch. For more information, refer to Preparing your System for Patching in Oracle Applications Maintenance...

connect / as sysdba ORA-01031 Insufficient privileges On a freshly installed 11gR2 Oracle Database, I set the following environment variables:ORACLE_BASEORACLE_HOMEORACLE_SIDTNS_ADMINTWO_TASKLD_LIBRARY_PATHHowever when I tried to connect to it:sqlplus /nologconn / as sysdbaORA-1031 Insufficient PrivilegesA search on My Oracle Support showed this:Error: ORA 1031Text: insufficient privileges------------------------------------------------------------------------------- Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to UPDATE a table with only SELECT privileges, if attempting to CONNECT INTERNAL, or if attempting...

adgendbc.sh java.sql.SQLException: Invalid number format for port number One of collegue asked me about this one. While running adconfig on an R12 clone, the following error was being reported:Unique constraint error (00001) is OK if key already existsCreating the DBC file...java.sql.SQLException: SO Exception was generatedDatabase connection to jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=R1213q2.justanexample.com)(PORT=1553)))(CONNECT_DATA=)) failedADD call failed with exit code 1Updating Server Security Authenticationjava.sql.SQLException: Invalid number format for port numberDatabase connection to jdbc:oracle:thin:@host_name:port_number:database failedUpdating...

UX: useradd: ERROR: Inconsistent password files While using useradd command to add my user, I got this error:UX: /usr/sbin/useradd: ERROR: Inconsistent password files. See pwconv(1M).Logged in as root, I checked the no. of lines in /etc/passwd and /etc/shadow:# cat /etc/shadow |wc -l 299# cat /etc/passwd |wc -l 300vi /etc/passwdI saw that last line was a blank and removed the blank line.Using useradd command worked now without issues...

Where is OA_HTML defined in R12 OA_HTML is defined in $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/oc4j.propertie...

Upgrade Java plug-in (JRE) to the latest certified version If you have already migrated to Java JRE with Oracle EBS 11i you may want to update EBS to the latest update from time to time. For example, if your EBS environment is configured to work with Java JRE 6 update 5 and you want to upgrade your clients with the latest JRE 6 update 13.This upgrade process is very simple:    Download the latest Java JRE installation file The latest update can be downloaded from here. Download the "JRE 6 Update XX" under "Java SE Runtime Environment".   Copy the above installation file to the appropriate directory: $> cp jre-6uXX-windows-i586-p.exe $COMMON_TOP/util/jinitiator/j2se160XX.exe...

Patch failed but the fix is another patch! Fortunately this happens infrequently (in my experience) and is usually caught the first time patch(es) are applied in a sandbox or dev environment. There could be a few reasons why this happens, a couple off the top of my head:- Your patch analysis wasn't complete. [If you have been in pre-req hell before, it can be very easy to miss a patch.]- You've hit a bug and Oracle informs you another patch is required.- Some large patches, especially family packs usually have functional prerequisites. These are usually in the README file as a chart which lists the product, feature and patches required. If you are using, or plan to use the products listed in the chart, you are required...

Adpatch seems to hang? While applying a patch to a cloned environment adpatch seemed to hang on the following line:Attempting to instantiate the current-view snapshot...If you perform a search of metalink you will get a couple of hits which may solve your problem. One of the problems is that the AD module level is lower than the required version for the patch. The other note mentions that it could be a temp tablespace issue. In my case, both of those checked out ok.Before I continue, what is a snapshot?There are two types of snapshosts, APPL_TOP and global. APPL_TOP snapshots contain version of files and patches applied within that APPL_TOP. A global snapshot contains the same information but for the entire environment,...

Merging Patches in E-Business Suite One method to decrease the amount of time it takes to apply a large number of patches is to use AD Merge. AD Merge allows you to combine multiple patches into a single patch. If you have applied multiple patches separately in the past, you've probably noticed that some steps may be repeated for each patch. For example, autoconfig, compiling JSP or database objects, etc may be executed automatically multiple times. You can pass parameters in to adpatch to avoid and perform those tasks manually at the end. As well, even tho its minor, just running through the adpatch prompts for each patch adds up.. (I'll talk about defaultsfile in another post.)There are some restrictions with AD Merge,...

Why are R12 patches so large? While performing patch analysis for some one-off patches I noticed there was quite a size difference between codelines.  (ie. R12.AP.A vs R12.AP.B)   For example, take a look at payables patch 8733916.   The version compatible with AP.A is 35.4MB while the AP.B version is only 9MB. A coworker forwarded me a note from Metalink which describes the issue:  Release 12: Why are One-Off Patches so Large? [ID 841218.1] The note has an interesting chart which shows how many files are applied from a patch based on the codelevel.   Basically a one-off patch contains all the files necessary to fix the problem on a base R12 release.   So to summarize...

R12.1.2 Relinking issues after 64bit Migration We have a large R12 upgrade coming up on the horizon.  Upgrading to R12.1.2, 11gR2 and migrating to 64bit.   As part of the post 64bit migration you have to relink the application programs.  A number of modules wouldn’t relink tho:Example:g++: /u01/TEST/apps/apps_st/appl/sht/12.0.0/lib/ilog/6.2/libschedule.a: No such file or directoryg++: /u01/TEST/apps/apps_st/appl/sht/12.0.0/lib/ilog/6.2/libsolveriim.a: No such file or directoryg++: /u01/TEST/apps/apps_st/appl/sht/12.0.0/lib/ilog/6.2/libconcertext.a: No such file or directoryg++: /u01/TEST/apps/apps_st/appl/sht/12.0.0/lib/ilog/6.2/libsolver.a: No such file or directoryg++: /u01/TEST/apps/apps_st/appl/sht/12.0.0/lib/ilog/6.2/libconcert.a:...

401 Unauthorized” error when tried to loging into SSO application Recently I have faced one issue in one of our development node. The problem is “401 Unauthorized” when tried to login into sso integrated application and upto two days back it was...

Questions for Oracle Apps 11i & R12 Integration with 10g AS/SSO Here are few questions which you should think/ask/discuss for Oracle Applications 11i & R12 Integration with 10g Application Server (Portal, Discoverer, SSO, OID) Do you need 10g Portal component of 10g AS with Oracle Applications 11i & R12 ? (*Integration of 10g AS can be without portal and dicoverer as well i.e. OID & SSO only. For 10g portal Integration you must have SSO and OID) Do you need 10g Discoverer component of 10g AS with Oracle Application 11i ? (* You can have discoverer with or without SSO access) Do you need SSO and OID component of 10g AS with Oracle Applications 11i / R12 ? (*You can configure only SSO/OID for Single Sign-On...

What languages and currencies are enabled in EBS One of my colleague asked me about the languages and currencies being used in a new instance which has gone live. For languages we have this query:select language_codefrom fnd_languageswhere installed_flag='I'For currencies, I told him that in EBS all currencies are enabled. I executed the following query:select CURRENCY_CODE,symbolfrom apps.fnd_currencieswhere enabled_flag='Y'It returned 71 rows.Total rows in fnd_currencies was 249.However, I thought of a more logical way of getting this data. That would be to query transaction tables. Which transaction table to query here ? I queried dba_segments for the largest objects:select object_name,bytesfrom dba_segmentsorder by...

File too large zip error: Output file write failure Recently while zipping a few directories for a clone, I got this error when the file size became greater than 2 GB.File too largezip error: Output file write failure (write error on zip file)I tested the file system's ability to create files greater than 2 GB by creating a dummy 3GB file:dd if=/dev/zero of=3gb-file bs=1024k count=3000The 3 GB file got created without issues.Then I checked the zip version.$ zip -vCopyright (c) 1990-2006 Info-ZIP - Type 'zip "-L"' for software license.This is Zip 2.32 (June 19th 2006), by Info-ZIP.Currently maintained by Onno van der Linden. Please send bug reports tothe authors using http://www.info-zip.org/zip-bug.html; see README for...

Query to check CPU patch level After moving from CPU patches to PSU patches for Database, we no longer get the CPU information from the query:SQL> select comments from registry$history;SQL> select comments from registry$history;COMMENTS--------------------------------------------------------------------------------CPUOct2008CPUApr2008view recompilationUpgraded from 10.2.0.3.0CPUJan2009CPUJul2009PSU 10.2.0.4.1CPUOct2009PSU 10.2.0.4.2CPUJul2010CPUOct2010view invalidationUpgraded from 10.2.0.4.0Patchset 11.2.0.2.0CPUApr2011CPUJul2011CPUOct2011PSU 11.2.0.2.518 rows selected.If you notice it only shows Patchset 11.2.0.2.5 instead of having two rows one for PSU and one for Jan 2012 CPU which is included in the PSU.We always...

Upgrade Oracle Applications to 12.0.4 Oracle Applications Release 12 update 4 (12.0.4) is available now.  This post covers top level steps for upgrading Oracle Applications R12 (12.0.0, 12.0.1, 12.0.2, 12.0.3) to latest patchset i.e. 12.0.4 Key Points for Upgrade to 12.0.4 1. You can upgrade to 12.0.4 directly from following releases 11.5.8, 11.5.9 (Base, Update1 and Update2), 11.5.10 (Base, Update1 and Upadte2), R 12 (Base, 12.0.1, 12.0.2, 12.0.3) 2. Patch Number for 12.0.4 is 6435000  (Apply this patch if you are upgrading from R12 i.e. 12.0.0, 12.0.1, 12.0.2 or 12.0.3) 3. If you are upgrading from R12 (12.0.1, 12.0.2, 12.0.3), first apply R12.AD.A.DELTA.4 (6510214). 4. After applying 12.0.4 patch (6435000)...

R12 Instance Home Overview Oracle Applications/E-Business Suite Release 12 introduces a new concept of a top-level directory for an Applications Instance which is known as Instance Home and is denoted the environment variable $INST_TOP.            Instance Home contains all the config files, log files, SSL certificates etc. Advantages of new INSTANCE HOME The additional Instance Home makes the middle tier more easy to manage and organised since the data is kept separate from the config files. The Instance Home also has the ability to share the Applications and Technology stack code across multiple instances. Another advantage of the Instance Home is that the...

Upgrade Oracle Apps 11i to R12/12i (12.0.4) – Key Points This post covers overview/top level steps to upgrade Oracle Applications (E-Business Suite) 11i (11.5.8,11.5.9,11.5.10) to R12/12i (12.0.4).    This post is useful to understand...

Difference between Oracle Apps 11i and R12 (Technical) Database: Database Version in 11i (11.5.9 & 11.5.10) was 9i Rel 2 where as in Release 12 its 10g R2 (10.2.0.2) Application Tier: Tech Stack in Application Tier consist of iAS(1.0.2.2.2)...

How to troubleshoot Concurrent Manager in 11i/R12 – Apps Listener How to check if Concurrent Manager is Up and running ? Login as user with System Administrator responsibility. Under Concurrent : Manager click on Administer (Actual should be...

Concurrent manager Phase and Status Codes meaning in Oracle E-Business Suite You can find meanining of  Concurrent Manager status codes meaning. Here is the lists PHASE CODE: I = Inactive P = Pending R = Running C = Completed STATUS CODE: U = Disabled W = Paused X = Terminated Z = Waiting M = No Manager Q = Standby R = Normal S = Suspended T = Terminating D = Cancelled E = Error F = Scheduled G = Warning H = On Hold I =  Normal A = Waiting B = Resuming C = Normal You can find in-detail about the Phase and status of the Concurrent managers in the previous post  ie : Concurrent Request Phase and Status If you like this post please comment ......

Post Clone Checks,Procedures for 11i / R12 Clone Procedures are outlined in : Clone-ie-Refresh-Oracle-Applications-11i-R12 Cloning-from-Multinode-to-Single-Node-Merge-APPL_TOP Post Clone checks and steps can differ . Listed are some of the common Post clone activities : (Here DEV is the target and PROD is the source) CHECKS =========== THE CHECKS/STEPS LISTED HERE SHOULD BE PERFORMED AFTER DATABASE CLONE BEFORE APPLICATIONS CLONE 1 Check the Target - If its in ARCHIVELOG / NOARCHIVELOG MODE as desired. 2 Create the Temp datafiles , using the commands taken from the control file , if the temporary tablespace tempfiles is not existing. ALTER TABLESPACE TEMP ADD TEMPFILE __________ Verify dba_temp_files, for all...

Concurrent Request Phase and Status Phase Status Description PENDING Normal Request is waiting for the next available manager.   Standby Program to run request is incompatible with other program(s) currently running.   Scheduled Request is scheduled to start at a future time or date.   Waiting A child request is waiting for its Parent request to mark it ready to run. For example, a request in a request set that runs sequentially must wait for a prior request to complete. RUNNING Normal Request is running normally.   Paused Parent request pauses for all its child requests to finish running. For example, a request...