APPS DBA - IMPORTANT NOTES

Oracle Applications Technology Stack - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

GOAL

This note is to list the main Setup, Installation and Diagnostics notes available related to the Oracle E-Business Suite Technology stack.

FIX

Java
----------------------------------------------------------------------------------------------------
Note 418664.1 Overview of Using Java with Oracle E-Business Suite Release 12
Note 455492.1 Using Latest Update of Java 6.0 with Oracle E-Business Suite Release 12
Note 384249.1 Using Latest Update of JDK 5.0 with Oracle E-Business Suite Release 12
Note 300482.1 Overview of Using Java with Oracle E-Business Suite Release 11i
Note 401561.1 Using J2SE Version 6 with Oracle E-Business Suite 11i
Note 304099.1 Using J2SE Version 5.0 with Oracle E-Business Suite 11i, Release 11.5.10
Note 246105.1 Upgrading to J2SE 1.4.2 with Oracle Applications 11i
Note 130091.1 Upgrading Oracle Applications 11i to use JDK 1.3

JRE/Jinitiator/EBS Client Software
----------------------------------------------------------------------------------------------------
Note 389422.1 Recommended Browsers for Oracle E-Business Suite Release 12
Note 393931.1 Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12
Note 285218.1 Recommended Browsers for Oracle Applications 11i
Note 290807.1 Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i
Note 124606.1 Upgrading JInitiator with Oracle E-Business Suite 11i
Note 1155883.1 Oracle E-Business Suite Desktop Client Hardware and Software Requirements

Forms
----------------------------------------------------------------------------------------------------
Note 437878.1 Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12
Note 750359.1 Upgrading to Previous Version of OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12
Note 384241.1 Using Forms Socket Mode with Oracle E-Business Suite Release 12
Note 438652.1 R12 Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications
Note 125767.1 Upgrading Developer 6i with Oracle Applications 11i
Note 232313.1 Information on Previous Versions of Developer 6i Patchsets
Note 201340.1 Using Forms Listener Servlet with Oracle Applications 11i
Note 150168.1 Obtaining Forms Runtime Diagnostics (FRD) In Oracle Applications 11i
Note 760250.1 Diagnosing Forms Mouse Focus Problems Using JRE in Release 11i

Note 1207184.1 Enhanced Signing of Oracle E-Business Suite JAR Files

OracleAS
----------------------------------------------------------------------------------------------------
Note 454811.1 Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12
Note 743518.1 Starting up AS10g services in an EBusiness Suite Release 12 environment

JDBC
----------------------------------------------------------------------------------------------------
Note 557194.1 monitor_jdbc_conn.sql - Script to monitor JDBC connections in Apps eBusiness Suite

Note 427759.1 How To Prevent Inactive JDBC Connections In Oracle Applications

JVM
----------------------------------------------------------------------------------------------------
Note 362851.1 Guidelines to setup the JVM in Apps Ebusiness Suite 11i and R12
Note 567551.1 Configuring various JVM tuning parameters for Oracle E-Business suite 11i and R12
Note 370583.1 Basic troubleshooting of JVM consuming cpu or too many JDBC connections in Apps 11i

Apache/mod_jserv
----------------------------------------------------------------------------------------------------
Note 230688.1 11i Basic Apache/mod_jserv Troubleshooting with Hello.class

Debug/Trace
----------------------------------------------------------------------------------------------------
Note 422419.1 R12 - How To Enable and Collect Debug for HTTP, OC4J and OPMN
Note 443671.1 R12 - Collecting Configuration Information for HTTP, OC4J and OPMN
Note 427848.1 How to Enable Execution Context ID (ECID) in the R12 access_log
Note 455154.1 R12: How To Obtain A Thread Dump When OC4J is shutdown
Note 603390.1 How To Create a User Event Trace in R11i / R12

OA Framework
----------------------------------------------------------------------------------------------------
Note 391554.1 Oracle Application Framework Documentation Resources, Release 12
Note 275880.1 Oracle Application Framework Release 11i Documentation Road Map
Note 275875.1 Oracle Application Framework Troubleshooting Release 11i (11.5.10)
Note 357597.1 How To Generate A SQL Trace In OA Framework For Oracle Applications

WebCache
----------------------------------------------------------------------------------------------------
Note 380486.1 Installing and Configuring Web Cache 10g and Oracle E-Business Suite 12
Note 306653.1 Installing and Configuring Web Cache 10.1.2 and Oracle E-Business Suite 11i

JDeveloper
----------------------------------------------------------------------------------------------------
Note 330236.1 Configuring JDeveloper For Use With Oracle Applications 11i and R12
Note 357218.1 Troubleshooting JDeveloper setup for Oracle Applications
Note 416708.1 How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x

Performance
----------------------------------------------------------------------------------------------------
Note 163208.1 bde_last_analyzed.sql - Verifies CBO Statistics
Note 174605.1 bde_chk_cbo.sql - Reports Database Initialization Parameters related to an Apps 12 or 11i instance
Note 396009.1 Database Initialization Parameters for Oracle Applications Release 12
Note 216205.1 Database Initialization Parameters for Oracle Applications 11i
Note 744143.1 Tuning performance on eBusiness suite
Note 169935.1 Troubleshooting Oracle Applications Performance Issues
Note 244040.1 Oracle E-Business Suite Recommended Performance Patches

Security
----------------------------------------------------------------------------------------------------
Note 738923.1 Oracle E-Business Suite Releases 11i and 12 Critical Patch Update note (January 2009)
Note 403537.1 Best Practices for Securing Oracle E-Business Suite Release 12
Note 189367.1 Best Practices for Securing the E-Business Suite Release 11i

Ihelp
----------------------------------------------------------------------------------------------------
Note 740834.1 R12: Troubleshooting iHelp

Advanced Configurations
----------------------------------------------------------------------------------------------------
Note 380483.1 Oracle E-Business Suite Release 12 Additional Configuration and Deployment Options
Note 384248.1 Sharing The Application Tier File System in Oracle E-Business Suite Release 12
Note 217368.1 Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11i
Note 233428.1 Sharing the Application Tier File System in Oracle Applications 11i
Note 233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
Note 364439.1 Tips and Queries for Troubleshooting Advanced Topologies

DMZ
----------------------------------------------------------------------------------------------------
Note 380490.1 Oracle E-Business Suite R12 Configuration in a DMZ
Note 726953.1 Case History: Implementing a Reverse Proxy Alone in the DMZ Configuration - R12
Note 287176.1 DMZ Configuration with Oracle E-Business Suite 11i
Note 438744.1 Case History: Implementing a Reverse Proxy Alone in a DMZ Configuration - 11i
Note 460564.1 Hints and Tips for Troubleshooting the URL Firewal

Loadbalancer
----------------------------------------------------------------------------------------------------
Note 380489.1 Using Load-Balancers with Oracle E-Business Suite Release 12
Note 727171.1 Implementing Load Balancing On Oracle E-Business Suite - Documentation For Specific Load Balancer Hardware
Note 601694.1 How To Check Session Persistence On BigIP F5 And Cisco Ace Load Balancer Appliances
Note 603325.1 Using Cisco ACE Series Application Control Engine with Oracle E-Business Suite Release 12

SSL
----------------------------------------------------------------------------------------------------
Note 376700.1 Using SSL with Oracle E-Business Suite Release 12

Note 1330799.1 Login Page Fails To Render On SSL Terminated Application Tiers  

Note 123718.1 11i A Guide to Understanding and Implementing SSL for Oracle Applications

Portal
----------------------------------------------------------------------------------------------------
Note 380484.1 Using Oracle Portal 10g with Oracle E-Business Suite Release 12

Note 305918.1 Using Oracle Portal 10g with Oracle E-Business Suite Release 11i

SSO/OID
----------------------------------------------------------------------------------------------------
Note 876539.1 Using the Latest Oracle Internet Directory 11gR1 Patchset with Oracle Single Sign-on and Oracle E-Business Suite

Note 376811.1 Integrating Oracle E-Business Suite Release 12 with 10g AS Oracle Internet Directory and Oracle Single Sign-On
Note 261914.1 Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On
Note 444573.1 Basic checks for user integration when using Oracle E-Business Suite 11i with Oracle AS 10g

Orace Access Manager / AccessGate
----------------------------------------------------------------------------------------------------
Note 975182.1 Integrating Oracle E-Business Suite with Oracle Access Manager using Oracle E-Business Suite AccessGate
Note 1077460.1 Troubleshooting Oracle Access Manager and Oracle E-Business Suite AccessGate

Webcenter
----------------------------------------------------------------------------------------------------
Note 1074345.1 Using WebCenter 11.1.1 with Oracle E-Business Suite Release 12 

Note 557221.1 Oracle WebCenter 10g Application Creation and Deployment Guide for Oracle E-Business Suite Release 12

Secure Enterprise Search
----------------------------------------------------------------------------------------------------
Note 566097.1 Oracle E-Business Suite Secure Enterprise Search Release Notes, Release 12.1.1
Note 744820.1 Oracle E-Business Suite Secure Enterprise Search Best Practices, Release 12
Note 462377.1 Installing Oracle E-Business Suite Secure Enterprise Search, Release 12
Note 740499.1 Oracle E-Business Suite Secure Enterprise Search Release Notes, Release 12.0.6
Note 726239.1 Oracle E-Business Suite Secure Enterprise Search Troubleshooting Guidelines, Release 12

SOA/BPEL/Webservices
----------------------------------------------------------------------------------------------------
Note 556540.1 Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1
Note 565922.1 Oracle E-Business Suite Integrated SOA Gateway Release Notes, Release 12.1.1
Note 815196.1 Oracle E-Business Suite Integrated SOA Gateway 12.1.1 Consolidated One-Off
Note 726414.1 Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12
Note 755067.1 Using Oracle BPEL 10g with E-Business Suite Release 12.1.1
Note 782455.1 How Can I Expose E-Business Suite Integration Interfaces as Web Services in Release 11i and R12.0

MWA
----------------------------------------------------------------------------------------------------
Note 782162.1 MWA Troubleshooting Tips for Release 12
Note 269991.1 MWA Troubleshooting Tips for Release 11i

Certified/Supported
----------------------------------------------------------------------------------------------------
http://blogs.oracle.com/stevenchan/certifications.html
Note 363827.1 Rebaselined Oracle Applications Technology Components for Releases 11.5.7, 11.5.8, 11.5.9, and 11.5.10

Note 883202.1 Minimum Baseline Patch Requirements for Extended Support on Oracle E-Business Suite 11.5.10 

Note 1199724.1  E-Business Suite 11.5.10 Minimum Patch Level and Extended Support Information Center

WEBADI
----------------------------------------------------------------------------------------------------
Note 417692.1 Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator)
Note 452452.1 R12 Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator)
Note 294739.1 How to enable tracing for WEBADI
Note 726989.1 List of Patches in Web Applications Desktop Integrator (Web ADI) for Releases 11i and 12

Diagnostics
----------------------------------------------------------------------------------------------------
Note 167000.1 E-Business Suite Diagnostics Installation Guide
Note 421245.1 E-Business Suite Diagnostics References for R12
Note 179661.1 E-Business Suite Diagnostics 11i Test Catalog

Installation
----------------------------------------------------------------------------------------------------
Note 761564.1 Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86
Note 402310.1 Oracle Applications Installation and Upgrade notes Release 12 (12.0) for Linux (32-bit)
Note 406982.1 Cloning Oracle Applications Release 12 with Rapid Clone
Note 559518.1 Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone
Note 421409.1 Unbreakable Linux enviroment check before R12 install
Note 458533.1 How to Enable Enterprise Manager on the Oracle E-Business Suite Release 12
Note 603716.1 Using AS10g AS Control with eBusiness Suite Rel 12
Note 452120.1 How to locate the log files and troubleshoot RapidWiz for R12
Note 316806.1 Oracle Applications Installation Update notes, Release 11i (11.5.10.2)
Note:230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
note 207296.1 How to Find out Linux Version Information?

Database
----------------------------------------------------------------------------------------------------
Note:454750.1 Oracle Apps Release 12 with Oracle Database 10.2.0 interoperability notes
Note 735276.1 Interoperability notes E-Business Suite R12 with Oracle Database 11gR1
Note 388577.1 Configuring Oracle Applications Release 12 with 10g R2 RAC
Note 466649.1 Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 12
Note 216550.1 Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
Note 362203.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
Note 452783.1 Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0)
Note 362135.1 Configuring Oracle Applications Release 11i with 10g R2 RAC and ASM
Note 554539.1 Using Database Partitioning with Oracle E-Business Suite

Current workflow mailer log file location

select fl.meaning,fcp.process_status_code, 
decode(fcq.concurrent_queue_name,'WFMLRSVC','maile r container','WFALSNRSVC','listener container',fcq.concurrent_queue_name),
fcp.concurrent_process_id,os_process_id, fcp.logfile_name
from fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups fl
where fcq.concurrent_queue_id=fcp.concurrent_queue_id and fcp.process_status_code='A'
and fl.lookup_type='CP_PROCESS_STATUS_CODE' and
fl.lookup_code=fcp.process_status_code
and concurrent_queue_name in('WFMLRSVC','WFALSNRSVC')
order by fcp.logfile_name;

Workflow Service Containers Will Not Start: oracle.jms.AQjmsException: JMS-120: Dequeue failed

APPLIES TO:

Oracle Workflow Cartridge - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 20-APR-2013

SYMPTOMS

The Workflow Service Container logs shows error:

oracle.jms.AQjmsException: JMS-120: Dequeue failed
at oracle.jms.AQjmsError.throwEx(AQjmsError.java:233)
at oracle.jms.AQjmsConsumer.dequeue(AQjmsConsumer.java:1424)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:692)
at oracle.jms.AQjmsConsumer.receive(AQjmsConsumer.java:629)
at oracle.apps.fnd.wf.bes.ControlListener.run(ControlListener.java:74)

Monitoring failed this iteration -> oracle.apps.fnd.cp.gsc.ProcessorException: Could not start automatic component -> oracle.apps.fnd.cp.gsc.server.GenericSvcComponentEOException: ORA-20002: 3825: Error '-24033 - ORA-24033: no recipients for message' encountered during execution of Rule function 'WF_RULE.ERROR_RULE' for event 'oracle.apps.fnd.cp.gsc.SvcComponent.start' with key 'SVC:15/JAN/2010'. FUNCTION_NAME=WF_EVENT_OJMSTEXT_QH.enqueue()

CHANGES

Payroll patch 9204430 was applied which revoked DBA role from the APPS user by running script:
$AD_TOP/patch/115/sql/adrevdba.sql.

CAUSE

The APPS user do not have the privilege to execute the SYS.DBMS_AQIN package.

The following error is thrown when run describe from the apps schema sys.dbms_aqin.

sqlplus apps/apps_pw

desc sys.dbms_aqin

ERROR:
ORA-04043: object sys.dbms_aqin does not exist

SOLUTION

1. Grant AQ_ADMINISTRATOR_ROLE to APPS which includes execute privilege on DBMS_AQIN.

sqlplus / @$AD_TOP/patch/115/sql/adgrnaq.sql

Example

sqlplus apps/apps @$AD_TOP/patch/115/sql/adgrnaq.sql manager apps apps

2. Confirm AQ_ADMINISTRATOR_ROLE is granted to APPS as BOTH ADMIN and DEFAULT.

This is the result for R12.1.  Some roles are not in 11.5.x. The APPS user need to always have the DEFAULT profile.  Do not revoke DEFAULT from the APPS User.

select * from DBA_ROLE_PRIVS where grantee='APPS';

GRANTEE	GRANTED_ROLE	ADM	DEF
APPS	RESOURCE	NO	YES
APPS	CONNECT	NO	YES
APPS	HR_REPORTING_USE	YES	YES
APPS	CTXAPP	NO	YES
APPS	OWS_STANDARD_ROLE	NO	YES
APPS	WEBDB_DEVELOPER	NO	YES
APPS	APPS_CONNECT	NO	YES
APPS	JAVASYSPRIV	NO	YES
APPS	HR_SECURE_USER	YES	YES
APPS	AQ_ADMINISTRATOR_ROLE	YES	YES

3. Give the Default profile to the APPS user if it has been revoked.

alter user APPS default role ALL;

4. Shutdown and restart the Concurrent Manager.

11.5.x

cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME

12.x

cd $ADMIN_SCRIPTS_HOME

sh adcmctl.sh stop apps/apps_pw

sh adcmctl.sh start apps/apps_pw

Integrated SOA Gateway EBS-R12 - 'SOA Provider Access is not available'

Hello Tech Community,


In this post, I will be discussing the issue that I came across the Integrated SOA Gateway. Everything was configured as per the implementation guide and was working fine. Then came the R1213 upgrade from R1212 and here we are with the issue. Let's get started. This is Linix (RedHat 5.5 x86-64) with EBS R12.1.3.


Error:


This issue is encountered while generating web service from a native java api through SOA Gateway.

Also cannot view the wsdl file from the hyperlink. Infact the hyperlink seems to be freezed.
The webservice must be deployed with the usename/password token- 
This generates a secondary error when deploy button is pressed.


The Error that display is - 'SOA Provider Access is not available'


The Navigation path is: EBS Login --> Integration Repository Administrator --(select the Integration Repository Tab)--> java -->(Your application) then the WSDL that you want to generate to




Debugging:


1- Since the Integrated SOA Gateway was working before the upgrade - so thought may be there is an issue with getting the WSDL generated so tried the following from the mid-tier:


$FND_TOP/bin/soagenerate  irepname= logfile= 


I gave the irepname that developer was using while he got the error. My irep name was "
oracle.apps.po.service.poxrqerq.POXRQERQServices_DocStyle"


The WSDL was generated fine.


2- Tried from the front end to deploy and I got the same error.


3- Now the testing time for the SOA Gateway  and found the issue.


First  Test got me to the issue. Tried following and got Error.


http://amghost5:8090/webservices/SOAProvider/?testquery


This should return " Test Response" but it  returned HTTP 500 Error.




Cause:


During the upgrade the xml file that host the ASADMIN password was reset to defalut of "welcome" while the DB has the modified password.


Solution:


edit the following file with the password that you have in DB with clear text for ASADMIN as "!MyPassw0rd" - Please note the "!" before the real password.



$ORA_CONFIG_HOME/10.1.3/j2ee/oafm/config/system-jazn-data.xml

The password can be verified as:

select fnd_web_sec.validate_login('ASADMIN','MyPassw0rd') from dual;

If password is not known the change the password as:

       1. Log on to Oracle E-Business Suite using sysadmin/sysadmin.

         2. Select the User Management responsibility in the Navigator.

         3. Click the Users link from the navigation menu to open the User Maintenance window.

         4. Locate 'ASADMIN' user by entering information in the search area to retrieve the 'ASADMIN' user.

         5. Click the Update icon next to the ASADMIN user to open the Update User window.

         6. Remove the Active To date field and click Apply.

         7. Click the Reset Password icon next to the ASADMIN user to open the Reset Password window.

         8. Enter new password twice and click Submit.

Restart the OAFM 

cd $ADMIN_SCRIPTS_HOME


./adoafmctl.sh stop

./adoafmctl.sh start

./adoacorectl.sh stop

./adoacorectl.sh start

Then check the status by:

./adopmnctl.sh status

Now test the SOA Gateway page again:


http://amghost5:8090/webservices/SOAProvider/?testquery 


and it resturns the test response.


Now Generate and deploy the WSDL - all is fine.

Integrated SOA Gateway Setup in EBS R12.1.3

Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1.3 [Metalink ID 556540.1]


1. Source the file $INST_TOP/ora/10.1.3/.env and then apply the following patches to the Oracle Application Server 10.1.3.5 Oracle Home:

i) Patch 13800972: Merge Request on Top of 10.1.3.1.0 for Bugs 8857799 9223438 12352047 (Patch 13800972 is also compatible with Oracle Application Server 10.1.3.5.0.)

ii) Patch 9371120: Web Service Framework Takes More Time for Giving the Response

iii) Patch 7366746: WLP: Enabling "Use SAML Authority: Verify Signature" Doesn't Require SAML Token

iv) Patch 15914125: Merge Request on Top of 10.1.3.5.1 for Bugs 9187189 9668283 13248533


2. Apply the following Oracle E-Business Suite patches:

i) Patch 13347633:R12.OWF.B: Performance Issues in PIM Load

ii) Patch 13957925:R12.OWF.B: One-off:13029726:12.1.3: SQL Exception in SOA Monitor Page

iii) Patch 14063221:R12.OWF.B: Consolidated Fixes on Top of 11688301:R12.OWF.B

iv) Patch 9139673:R12.OWF.B: IREP Issues When APPLSYS Schema Name is Changed

v) Patch 13516999:R12.OWF.B: Performance Degradation of Web Service Calls Hosted in R12 SOA Gateway

vi) Patch 14741766:R12.TXK.B: Need to Add a New Property for Session in OC4J.Properties


3. Set applications environment and stop all application tier processes.

i) From the applications instance $APPL_TOP, set the environment by running the APPS.env script 

ii) Stop all application tier processes for the instance by running the script $ADMIN_SCRIPTS_HOME/adstpall


4. Run TXK development script to install Oracle Application Server Adapter for Oracle Applications as shown below:

i) $FND_TOP/bin/txkrun.pl -script=CfgOC4JApp -applicationname=pcapps -oracleinternal=Yes -oc4jpass=welcome -runautoconfig=No

Note: If the 'oc4jadmin' password for the OAFM oc4j instance is not known, then reset the password in the file $INST_TOP/ora/10.1.3/j2ee/oafm/config/system-jazn-data.xml before running the script. Take the backup of system-jazn-data.xml before resetting the password. Replace the modified system-jazn-data.xml with backup of system-jazn-data.xml after running the script.

For example, if you want to reset the password to '!welcome', below should be the entry:


oc4jadmin
OC4J Administrator
23C8E4F0BDDE11DCBFB8AF3B7E0DDB2D
OC4J Administrator
!welcome

5. Run TXK deployment script to install forms-c4ws.ear and configure container Forms-c4ws J2EE group correctly, as shown below:

i) $FND_TOP/bin/txkrun.pl -script=DeployForms-c4ws

6. Enable the new container forms-c4ws. (By default, the new OC4J container forms-c4ws will be disabled.)

i) To enable the new container forms-c4ws, modify the following values of context variables in the $CONTEXT_FILE:

Set 's_forms-c4wsstatus' to "enabled".
Set 's_forms-c4ws_nprocs' to "1".

Note: The 's_forms-c4ws_display' context variable is used by the forms-c4ws OC4J instance. It must be set properly in order to use the Java APIs for Forms interfaces. This display must always be accessible during runtime. It should be set to an active and authorized X Windows display, and should point to a machine that is always available to the application instance.

7. Run AutoConfig script present in $ADMIN_SCRIPTS_HOME on the application tier. For example, $ADMIN_SCRIPTS_HOME/adautocfg.sh

8. Start all application tier processes for the instance by running the script $ADMIN_SCRIPTS_HOME/adstrtal

9. Enable ASADMIN user using the following steps:

i) Log on to Oracle E-Business Suite using sysadmin/sysadmin.

ii) Select the User Management responsibility in the Navigator.

iii) Click the Users link from the navigation menu to open the User Maintenance window.

iv) Locate 'ASADMIN' user by entering information in the search area to retrieve the 'ASADMIN' user.

v) Click the Update icon next to the ASADMIN user to open the Update User window.

vi) Remove the Active To date field and click Apply.

vii) Click the Reset Password icon next to the ASADMIN user to open the Reset Password window.

viii) Enter new password twice and click Submit.

10. After activating the ASADMIN user, verify if the ASADMIN user has the 'Apps Schema Connect Role' (UMX
APPS_SCHEMA_CONNECT) role in wf_user_roles.

If the 'Apps Schema Connect Role' role is not present in the wf_user_roles for the ASADMIN user, then run the 'Workflow Directory Services User/Role Validation' concurrent program to grant the role.

11. Reset the 'ASADMIN' password in the file system.

i) After 'ASADMIN' user is enabled from Oracle E-Business Suite, update the file

$INST_TOP/ora/10.1.3/j2ee/oafm/config/system-jazn-data.xml as shown below to reset the password:


ASADMIN
Default Apps SOA User
Used by SOAProvider for DB connection
!


Note: The password should be preceded by a '!' (Exclamation) so that when OAFM is started,
it gets encrypted. For example, if your password is 'welcome', then you should write it in the above file as "!welcome".

12. Bounce the middle tier.


Issues:

$FND_TOP/bin/txkrun.pl -script=DeployForms-c4ws issue was fixed by fixing jvm option for OC4J in opmn.xml file under IAS_ORACLE_HOME/opmn/conf

Determine OAS (10.1.3) version

$ORACLE_HOME/OPatch/opatch lsinventory -detail

Get version Oracle Containers for J2EE

cd $ORACLE_HOME/j2ee/home
java -jar oc4j.jar -version

Output:

Oracle Containers for J2EE 10g (10.1.3.5.0) (build 090727.2000.36696)

“REP-0004: Warning: Unable to open user preference file” while running reports.

“REP-0004: Warning: Unable to open user preference file” while running reports.
=*=*=*=*=* Error: REP-0004
Text: Warning - "Unable to open user preference file". while running reports.

=======================================================================
Cause:

Your local (customized) Oracle Reports preference file could not be opened.
This is just a warning, so the product will continue to run even if this occurs.
The possible causes of this error include the following:

Case 1: The file was not found under the specified name in the specified location.

Case 2: You lacked the necessary privileges to open the file.

Case 3: A system error made it impossible to open the file.

Action:

You can take the following actions to rectify this error:

Case 1: Make sure the file prefs.ora is located in your "home" directory.

Case 2: Make sure that you have the privileges necessary to access the file. If you don't, change your privileges accordingly.

Case 3: Consult your operating system documentation or contact your system administrator.

======================================================================

The preferences file referred to above is:

Windows
ORACLE_HOME\CAUPREFS.ORA (user preferences)
ORACLE_HOME\CAGPREFS.ORA (global preferences)

UNIX
your_home_directory/prefs.ora (user preferences)
$ORACLE_HOME/tools/admin/prefs.ora (global preferences)

=====================================================================
Simple Way:

Check whether u have prefs.ora file in your application user's home

eg: prefs file should be in /home/applmg/prefs.ora

if not please copy prefs.ora file from  $ORACLE_HOME/tools/admin/prefs.ora  to /home/applmg/prefs.ora location.

Run your concurrent request/program.

======================================================================

REP-0004: Warning: Unable to open user preference file

Metalink id:
=======
R12: Request Logs Contain the Message "REP-0004: Warning: Unable to open user preference file" [ID 1120529.1]

Symptoms:

=======

All concurrent requests that run REPORTS are printing the following warning in the request log.

REP-0004: Warning: Unable to open user preference file.

Cause:

=====

This message occurs when the concurrent process attempts to open the Oracle Reports executable and your local preference file cannot be found or opened. This is just a warning, so the request will continue to run even if this occurs.

Solution:

=====

To resolve the warning, copy the prefs.ora file from your Reports Builder $ORACLE_HOME/tools/admin/ directory into the Applications $HOME directory.

Example:

Copy of the file prefs.ora in the directory /u01/prod/apps/tech_st/10.1.2/tools/admin to the directory  /home/appprod/.

appdev@ctssd $ pwd
/u01/erpapp/10.1.2/tools/admin
appdev@ctssd $ cp prefs.ora /export/home/apptest

Note: Bounce apache service.

After doing above steps my issue resolved.

Turning On And/Or Licensing Credit Management

Turning On And/Or Licensing Credit Management

Oracle Credit Management - Version: 11.5.10.2 to 11.5.10.3 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.
***Checked for relevance on 29-JUL-2010***

GOAL

Is Credit Management a separate Product License?

SOLUTION

Credit Managment is licensed through the Core Financial and Receivables License, you should
be able to use Credit Management without issue with either of these licenses enabled.

Lost Of SYSADMIN Password . How To Know The Password Of The SYSADMIN User

Oracle Application Object Library - Version 11.5.10.0 and later

GOAL

You lost the password of the user SYSADMIN. How can you identify the password for the SYSADMIN user ?

SOLUTION

The password of SYSADMIN is encrypted in the database, so if you forget it, it is not possible to retrieve it.

The only way is to change it. To change it, you can apply one of the following steps :


1 - log with a user which has the System Administrator responsibility, Go to the define User forms ,
then change the password by typing the new password in the field Password.

2 -From unix , run FNDCPASS to change the password :
FNDCPASS / 0 Y system/ USER sysadmin
Also please review the Note 423274.1 for changing the SYSADMIN password using FNDCPASS.

Multiplexing control files using SPFILE OR PFILE

Multiplexing control files using SPFILE OR PFILE

Multiplexing Control file using SPFILE

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u02/abcprod/db/tech_st/11.2.0
                                                 /dbs/spfilePROD.ora

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/abcprod/db/apps_st/data/cntrl01.dbf
/u01/abcprod/db/apps_st/data/cntrl02.dbf
/u01/abcprod/db/apps_st/data/cntrl03.dbf

SQL> ALTER SYSTEM SET CONTROL_FILES = '/u01/abcprod/db/apps_st/data/cntrl01.dbf'
  2  ,'/u02/abcprod/db/tech_st/11.2.0/prod_controlfile/cntrl02.dbf',
  3  '/u03/abcprod/prod_controlfile/cntrl03.dbf' SCOPE = SPFILE;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

Using cp or mv command to copy or move the control file to their location.

$ cp cntrl02.dbf /u02/abcprod/db/tech_st/11.2.0/prod_controlfile/
$ cp cntrl03.dbf /u03/abcprod/prod_controlfile/


Start the database

SQL> startup

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/abcprod/db/apps_st/data/cntrl01.dbf
/u02/abcprod/db/tech_st/11.2.0/prod_controlfile/cntrl02.dbf
/u03/abcprod/prod_controlfile/cntrl03.dbf

SQL>


Multiplexing Control file using PFILE

Shutdown the database

Edit the control_files parameter from init_ORACLESID.ora file

control_files='/u01/abcprod/db/apps_st/data/cntrl01.dbf',
'/u02/abcprod/db/tech_st/11.2.0/prod_controlfile/cntrl02.dbf',
'/u03/abcprod/prod_controlfile/cntrl03.dbf';

save the pfile

Now move or copy the control files to their appropraite locations using cp or mv command

Start the database

How to setup an IMAP server on LINUX for E-Business Suite usage

How to setup an IMAP server on LINUX for E-Business Suite usage


APPLIES TO:

Oracle Workflow Cartridge
Linux x86
Oracle Application Object Library - Version: 11.5.5 to 11.5.10
GOAL

This note will guide you through the steps to allow you to set up an IMAP server so that you can respond to Notifications via e-mail and fully implement the "Forgot Password" functionality.
SOLUTION

1. Install Dovecot IMAP/POP3 Mailer
- check if dovecot is installed
$ rpm -q dovecot

- Download dovecot-0.99.13-1.2.el4.test.i386.rpm if needed
( http://dag.wieers.com/packages/dovecot/ )


2. Install sendmail-mc if it is not installed


3. Create directory structure for dovecot if needed
- /var/run/dovecot/login
- /var/run/dovecot-login


4. Setup sendmail by editing mail configuration files

a. Look for and edit the following lines as needed in /etc/mail/sendmail.mc. Remove the "dnl" at the beginning of the line to make the line active.  Replace the IP address and host with your local values.

- LOCAL_DOMAIN(`AOL-linux.us.oracle.com')dnl
- MASQUERADE_DOMAIN(AOL-linux.us.oracle.com)dnl
- MASQUERADE_DOMAIN(AOL-linux)dnl

Change the following line to allow connection from the Internet. Be aware that this opens up your sendmail to public access.

From:
DAEMON_OPTIONS(`Port=smtp,Addr=127.0.0.1, Name=MTA')dnl
To:
DAEMON_OPTIONS(`Port=smtp, Name=MTA')dnl


b. Add a line with your IP Address in /etc/mail/access
###.##.##.### RELAY

c. Add your hostname and full qualified hostname as needed in /etc/mail/local-host-names
AOL-linux.us.oracle.com
AOL-linux

d. Add mail accounts as needed in /etc/mail/virtusertable
applmgr@AOL-linux.us.oracle.com applmgr
wfmailer@AOL-linux.us.oracle.com wfmailer

e. Compile the mail configuration files
- $ make

f. Restart the sendmail service
- $ service sendmail restart


5. Setup dovecot by editing /etc/dovecot.conf. Edit and/or add the following lines as needed. These values are set for small usage and most defaults are being used for processes. Remove the comments (#) from any lines as needed.


Change the following and/or remove comment:

protocols = imap pop3
default_mail_env = mbox:~/mail:INBOX=/var/mail/%u
auth_userdb = passwd
mbox_locks = fcntl

base_dir = /var/run/dovecot
login_dir = /var/run/dovecot/login
imap_listen = *
pop3_listen = *
login_executable = /usr/libexec/dovecot/imap-login
login_user = dovecot
login_executable = /usr/libexec/dovecot/pop3-login
imap_executable = /usr/libexec/dovecot/imap
pop3_executable = /usr/libexec/dovecot/pop3
auth_executable = /usr/libexec/dovecot/dovecot-auth
auth_count = 1

These are already defaulted:

login = imap
login = pop3
auth = default
auth_mechanisms = plain
auth_user = root


6. Start the dovecot service (root user)

$ service dovecot start


7. Test connect to sendmail account testmail

$ telnet testsystem.domain 25
$ helo  
$ quit

Example:

$ telnet testsystem.domain 25
Trying ###.#.##.###...
Connected to testsystem.domain (###.#.##.###).
Escape character is '^]'.
220 testsystem.domain ESMTP Sendmail 8.13.1/8.13.1; Fri, 3 Mar 2006 15:24:02 -0500
helo AOLTest-sun
250 testsystem.domain Hello testsystem.domain [###.#.##.###], pleased to meet you
quit
221 2.0.0 testsystem.domain closing connection
Connection closed by foreign host.


8. Test connection to the Dovecot IMAP vaild user - i.e. "testmail" with password "testmail1"

Type the following three commands:

$ telnet testsystem.domain 110
$ user testmail
$ pass testmail1

Example:

$ telnet testsystem.domain 110
Trying ###.#.##.###...
Connected to testsystem.domain (###.#.##.###).
Escape character is '^]'.
+OK dovecot ready.
user testmail
+OK
pass testmail1
+OK Logged in.
quit
+OK Logging out.
Connection closed by foreign host.


9. Configure an E-mail client to test you IMAP Server

Outlook 2000

a. Open Outlook

b. Click Tools -> Accounts

c. Click the [Add] button then choose “Mail” to create a new account

d. Choose the Account Name and click the [Next] button

e. Verify the email address (i.e. wfmailer@dovecot host.com)

f. Click the (next] button

g. Choose IMAP for the incomping Mail server

h. Enter the Server Name into the “Incoming Mail Server” and “Outgoing Mail Server” fields

i. Click the [Next] button

j. Enter the Username(wfmailer) and Password

k. Click the [Next] button

l. Choose the LAN connection type

m. Click the [Next] button

n. Click the [Finish] button to save the settings

o. Click the [Close] button on the “Internet Accounts” screen