E-Business suit 11i and 12i good notes

Abstract:

This document was created to help the Apps DBA with good documents exist on oracle support website http://metalink.oracle.com.

This document should help the Apps DBA with different topics like upgrade,cloning and health check. This is the first version and I will try to add more input to it.

Version Control:

This article was created 26-MAR-2013.I will try to update it when possible with new good documents I meet in day to day activities.

The Document was updated 28-MAR-2013.

E-Business Suit 11i and 12i Notes:

Health Check:

bde_chk_cbo.sql - EBS initialization parameters - Healthcheck (Doc ID 174605.1)

Concurrent manager:

Concurrent Requests Remain in Status Pending Normal For a Long Period Before Running [ID 749176.1]

Password:

Changing APPS Password Using Fndcpass Gives 'not able to decrypt password' Message [ID 733427.1]

Tried To Change Apps Password And A "Not Able To Decrypt" Message Came Up [ID 459601.1]

FNDCPASS Was Not Able To Decrypt Password For Applsyspub When Changing Apps Password [ID 454299.1]

Profile Options:

Note: 470102.1 - How To Check If a Profile Option Is Set In Oracle Application

Note: 201945.1 - How to list E-Business Suite Profile Option values for all levels using SQLPlus

How To Set A System Profile Value Without Logging In To The Applications [ID 364503.1]

How to Change Profile Option Value Without Forms [ID 943710.1]

Script To List The Values Of A Profile Option At All Levels [ID 803587.1]

Note: 282382.1 - How to Search all of the Profile Options for a Specific Value

Note: 367926.1 - How To Find All Users With A Particular Profile Option Set?

Note: 282382.1 - How to Search all of the Profile Options for a Specific Value

Account Payable:

 11i: Payment Batch in Built Status Errors with APP-SQLAP-10771: Could not reserve record (Doc ID 358910.1)
APXINWKB - Unable to Update or Cancel Invoice APP-SQLAP-10771 Could Not Reserve Record (Doc ID 1200053.1)

Sysadmin and workflow:

How To Remove Error Notifications From The Worklist (Doc ID 357904.1)

SYSADMIN User Gets Thousands of WFERROR Notifications [ID 1299167.1]

Cloning:

Oracle E-business suite (11i & R12) Cloning Master Note

Master Note: Rapid Clone Documentation Resources For Release 11i and 12 [ID 799735.1]

 Rapid Clone of E-Business Suite Release 11i:

Note 230672.1 - 'Cloning Oracle Applications Release 11i with Rapid Clone'
Note 216664.1 - 'FAQ: Cloning Oracle Applications Release 11i'
Note 398619.1 - 'Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)'
Note 165195.1 - 'Using AutoConfig to Manage System Configurations with Oracle Applications 11i'
Note 364565.1 - 'Troubleshooting RapidClone issues with Oracle Applications 11i'
Note 760637.1 - 'Manually Cloning Oracle Applications Release 11i with 10g or 11g RAC'
Note 362473.1 - 'Cloning E-Business Suite Using Hot Backup for Minimal Downtime of Source Environment'
Note 233428.1 - 'Sharing the Application Tier File System in Oracle Applications 11i'
Note 243880.1 - 'Shared APPL_TOP FAQ'
Note 238276.1 - 'Migrating to Linux with Oracle Applications Release 11i'
Note 218089.1 - 'Autoconfig FAQ'
Note 270519.1 - 'Customizing an AutoConfig Environment'
Note 316806.1 - 'Oracle Applications Installation Update Notes, Release 11i (11.5.10.2)'

Rapid Clone of E-Business Suite Release R12:

 Note 406982.1 - 'Cloning Oracle Applications Release 12 with Rapid Clone'
Note 603104.1 - 'Troubleshooting RapidClone issues with Oracle Applications R12'
Note 559518.1 - 'Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone'
Note 387859.1 - 'Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12'
Note 549389.1 - 'Oracle Applications Release Notes, Release 12.0.4'
Note 394692.1 - 'Oracle Applications Documentation Resources, Release 12'

Generic - Rapid Clone of E-Business Suite Release 11i or R12:

Note 783188.1 - 'Certified RAC Scenarios for E-Business Suite Cloning'
Note 375650.1 - 'How To Run Rapid Clone (adcfgclone.pl) Non-Interactively'
Note 760772.1 - 'Cloning Oracle Application 11i /R12 with Rapid Clone - Database (9i/10g/11g) Using Hot Backup on Open Database'
Note 343917.1 - 'Frequently Asked Questions: Oracle E-Business Suite Support on x86-64'
Note 311717.1 - 'Frequently Asked Questions: Oracle E-Business Suite Support on Itanium'
Note 419475.1- 'Removing Credentials from a Cloned EBS Production Database'

Cloning via the E-Business Suite Plugin 4.0 (Grid Manager Plugin)

Note 1224313.1 - 'Getting Started with Oracle E-Business Suite Plug-in, Release 4.0'
Note 812294.1 - 'Troubleshooting Guide and Known Issues List for the Oracle Application Management Pack for Oracle E-Business Suite'
Note 250262.1 - 'RDA 4 - HCVE Users' Guide and Available Rule Sets' = OS pre-check diagnostics for EBS 11i & 12

(Doc ID 230672.1) Cloning Oracle Applications Release 11i with Rapid Clone  ==> Section 4: Advanced Cloning Methods >> 6. Cloning a RAC System=(Doc ID 760637.1)Manually Cloning Oracle Applications Release 11i with 10g or 11g RAC.

Clean Nonexistent Nodes or IP Addresses From FND_NODES [ID 260887.1]

Upgrade:

Additional Information: See Oracle 10gR2 Database Preparation  Guidelines for Oracle E-Business Suite Release 12 Upgrade (Doc ID:  403339.1) for more information.

11i Upgrade Document:

Note 881505.1 Oracle Applications Release 11i with Oracle 11g Release 2

Oracle AMP for grid control:

Certified RAC Scenarios for E-Business Suite Cloning (Doc ID 783188.1) 

Getting Started with Oracle E-Business Suite Plug-in, Release 4.0 (Doc ID 1224313.1)

 Step by Step to Install New AMP Plugin - Oracle E-Business Suite Plug-in 12.1.0.1.0 on top of Grid Control 12c (Doc ID 1463040.1)

https://blogs.oracle.com/stevenChan/entry/additional_platforms_certified_for_oracle

11i Browsers:
Note:285218.1-Recommended Browsers for Oracle E-Business Suite 11i
Note:290807.1-Upgrading Sun JRE (Native Plugin) with Oracle Applications 11i for Windows Clients

Security:
Note 189367.1 (Best Practices for Securing your E-Business Suite)

Outsorucing Oracle DBA's to gulf

Hello All,

I noticed that a lot of oracle professionals exist now in Egypt.I noticed that if w can success in communicating those professionals in one group the investors from different countries may found a strong community to b able to outsource and find great consultants to do remote tasks using vpn or remote desktop connectivity or even provide consultation through the phone.I know the idea seems crazy but why not.I created  a new group on facbook for this purpose and th link is posted below:
http://www.facebook.com/pages/Outsourcing-Oracle-Profssionals-to-Gulf/540437332656456

Kind Regards
Mohamed

FRM-92150 Web Client Too New

To solve the problem:

1. Open JInitiator from the Control Panel.
2. Open the "Cache" Tab.
3. Click the button "Clear JAR Cache".
4. Re-run the Form.
or
1. Open Java from the Control Panel.
2. Open press button "settings" on the general tabpage.
3. Click the button "delete files" to delete the cached jarfiles.
4. Re-run the Form.

How to find the atg patch level in oracle apps 11i ?

Use below query to query for ATG patch level:

Connect to apps schema “sqlplus apps/apps”

SELECT (bug_number),
decode((bug_number),
'3438354','ATG_PF.H',
'4017300','ATG_PF.H RUP 1',
'4125550','ATG_PF.H RUP 2',
'4334965','ATG_PF.H RUP 3',
'4676589','ATG_PF.H RUP 4',
'5473858','ATG_PF.H RUP 5',
'5903765','ATG_PF.H RUP 6',
'6241631','ATG_PF.H RUP 7')
FROM ad_bugs
WHERE bug_number IN
('3384350',
'3438354',
'4017300',
'4125550',
'4334965',
'4676589',
'5473858',
'5903765',
'6241631')
order by bug_number desc;

Regards
Mohamed ElAzab