Merge Patches using admrgpch Admrgph utility is used to merge two or more patches in oracle apps. The advantage of merging patches is that it reduces downtime as the repetitive task of compiling invalid database objects,  generating forms and reports,jar files etc. How to use Admrgpch to merge patches ch_client = "shreemanravula"; ch_width = 500; ch_height = 250; ch_type = "mpu"; ch_sid = "Chitika Default"; ch_color_site_link = "0000CC"; ch_color_title = "0000CC"; ch_color_border = "FFFFFF"; ch_color_text = "000000"; ch_color_bg = "FFFFFF"; Download the  patches in /patch directory. Now create 2 subdirectory in /patch say mergesource -which contains  the unzipped patches to be merged and mergedest...

Purge old files on Linux/Unix using “find” command Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table...

Troubleshooting APP-FND-01630: Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table...

Rebuild Index in oracle In the following scenarios, one can think about rebuilding indexes-> 1 If the ratio of deleted to actual leaf entries is more than 20% or 2 If the "blevel">3 (in table dba_indexes) Here's how you can find it.You are supposed to do analyze index validate structure ; and then query the view INDEX_STATS SELECT name,height,lf_rows,del_lf_rows,(del_lf_rows/lf_rows)*100 FROM INDEX_STATS; Here's the command to rebuild indexes -> alter index rebuild online; You will require twice the space because during index rebuilding, the old index will still be there and will be dropped only when the new one has been created successfully. References-> Oracle metalink document Id-182699.1 when and how to...

This summary is not available. Please click here to view the po...

This summary is not available. Please click here to view the po...

How to find if server is single node or multi node Oracle apps can be implemented on single node or multi node. In single node-database,CM,Reports,forms,Apache are all on one single server only. In multi-node we can have these components on different servers. A typical 2-node server has the following-> 1st node-database,CM,reports 2nd node-forms,Apache A typical 3 node server has the following-> 1st node-database 2nde node-CM,reports 3rd node-forms,Apache Here's how to find out if the server is single node or multi node-> 1-select * from fnd_nodes(It also contain column like "support_forms","support_web","support_web","support_db","support_admin" which identifies which tier it supports) 2-OAM-oracle...

Merge Patches using admrgpch Admrgph utility is used to merge two or more patches in oracle apps. The advantage of merging patches is that it reduces downtime as the repetitive task of compiling invalid database objects,  generating forms and reports,jar files etc. How to use Admrgpch to merge patches Download the  patches in /patch directory. Now create 2 subdirectory in /patch say mergesource -which contains  the unzipped patches to be merged and mergedest -which contains the merged patch. Please note that both mergesource and mergedest should be created as immediate child of same parent directory say /patch. Now you can execute the following command to merge the patches. admrgpch -s <source>...

Differences between Oracle Apps 11i and R12 The Database Version was 9i Release 2 in Oracle Apps 11i. It has been replaced by 10g Release 2 (10.2.0.2) in Apps R12. HTTP server consist of iAS (1.0.2.2.2) in apps 11i. It has been replaced by 10.1.3 (10g AS) in apps R12. Forms 6i in apps 11i has been replaced by Forms 10.1.2 (10g AS) in apps R12. Socket mode was the default for forms connectivity in apps 11i. In R12, servlet mode is the default. Jserv in apps 11i has been replaced by OC4J in R12. JDK 1.3.1 in apps 11i has been replaced by JRE 1.5 in apps R12. JDBC version 9 in apps 11i has been replaced by JDBC 10.2.0 in Apps R12. Modplsql/ mod_pls has been removed from Apps R12. NOTE:- Although Release 12 uses OracleAS...

Unable to lock Central Inventory. OPatch will attempt to re-lock Sometimes while applying a patch on the database (opatch) i come across the following error-> Unable to lock Central Inventory. OPatch will attempt to re-lock. Do you want to proceed? [y|n] n User Responded with: N Unable to lock Central Inventory. Stop trying per user-request? OPatchSession cannot load inventory for the given Oracle Home /u01/XXXXDB/product/10.2.0. Possible causes are: No read or write permission to ORACLE_HOME/.patch_storage Central Inventory is locked by another OUI instance No read permission to Central Inventory The lock file exists in ORACLE_HOME/.patch_storage The Oracle Home does not exist in Central Inventory ApplySession failed:...

Oracle Applications SQL Scripts oa_info.sql - Nice script to show the physical layout of an Oracle Applications database. Includes product installations and versions (e.g. duplicates information from auto install and adutconf.sql). fndlock.sql - This is lockmon with the Oracle Applications user added for apps account logins. fndreq.sql - Show currently running concurrent requests fndusrmap.sql - Maps Oracle Applications user information, similar...

How to find if module is installed or not in Oracle Apps We have 3 ways to find out if a module is installed in oracle apps1 We can run the following scriptcd $AD_TOP/sql/adutconf.sqlIn this script, there is a section->"Product Installation Status, Version Info and Patch Level"In this, status of installed means the product is installed.2  Through OAMIn oracle apps, navigate toOAM>Site Map>/License Manager>Reports>Licensed ProductsHere filter the products by  using "Licensed". These are the licensed and installed products in oracle apps.3 Using a sql query->We can use the following querySELECT a.application_name,a.product_code,DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,patch_levelFROM...

How to audit users accessing responsibility/forms in Apps Manytimes we want to audit, which users access which responsibilities. There is a direct way of doing it in oracle apps.There is a System Profile in Oracle Apps "Sign-on Audit level". The profile "sign on audit level" can be set to any of the 4 values->Users-determines login and log-off timings,terminal from which user logs in oracle appsResposibilty-does user level auditing + which user logs in responibilty at which time, and when does the user navigates off  from it.Forms-does respobility level auditing + which user access which forms and how  much time user spends on that form.None-noneOnce the above profile is set to the desired value, it will start...

Oracle Installation Error Long time back, while installing Oracle on Windows XP, i faced the following strange problem."Error in writing to directory "C:\DOCUME~1\XP\LOCALS~1\Temp\OraInstall2009-04-12_08-26-12PM. Please ensure that this directory is writable and has atleast 60 MB of free space. Installation cannot continue."I checked that the directory was writable and C: had over 5 GB free space.The solution was however, also very strange.I copied the software directory directly in C: and then started the installation. It worked without any error.Earlier i was running the setup from "Desktop". Even running it from "My Documents" did not wor...

How to FIND and REPLACE in unix Many times we want to find and replace all the occurences of  one word in a file to another word in Unix. Using the power of vi editor, it can be done easily.Here is the syntax for the same in unix:1,$s/oldword/newword/gexampleTo find and replace all occurences of "erp" with "BERP" in a file, we have to do the following->Open the file in vi editor, and issue the following command:1,$s/erp/BERP...