Tuesday, January 28, 2014

Load Balancer

Using Load-Ba lancers with Oracle E-Business Suite Release 12 [ID 380489.1]
Implementing Load Balancing On Oracle E-Business Suite - Documentation For Specific Load Ba lancer Hardware [ID 727171.1]

Friday, January 24, 2014

How to apply India Localization Patches

How to apply India Localization Patches

1. How to apply india Localizatin Patches?


1. We have to install India localization Patch Application Tool by downloading patch 6491231 


2. Copy the downloaded patch to $JA_TOP and unzip the same there


3. A directory inpatch will be created afer unzipping. In which india localization patch tool avaialable 


4. Go to india localization patch directory 


5. use following command


perl $JA_TOP/inpatch/indpatch.pl drvr_file=6355941.drv fnd_patchset=H appspwd=apps japwd=ja logfile=6355941.log systempwd=manager


fnd_patchset= FND PATCHSET LEVEL

japwd = ja_top password

drv_file=patchnumber.drv file


2. How do you know what are india localization patches applied?

Solution : using JAI_APPLIED_PATCHES

Thursday, January 23, 2014

Unable to find an Output Post Processor service to post-proces

Concurrent Processing - Unable to Find the Concurrent Request Output Post Processor (OPP) Service [ID 465036.1]
Troubleshooting Oracle XML Publisher For The Oracle E-Business Suite [ID 364547.1]
The Output Post Processor does not process all requests. [ID 1399463.1]
BI Publisher Requests in Pending Status End in Warning When Starting Concurrent Managers [ID 375208.1]
R12: Troubleshooting Known XML Publisher and E-Business Suite (EBS) Integration Issues [ID 1410160.1]

Tuesday, January 21, 2014

Mobile Web Applications Server - MWA Troubleshooting Tips for E-Business Suite 11i and R12

Mobile Web Applications Server - MWA Troubleshooting Tips for E-Business Suite 11i and R12 Oracle Mobile Application Server (Doc ID 269991.1)

MWA connection by Machine:


sqlplus -s "/ as sysdba" <
   set echo off
   set pagesize 220
   set markup html on spool on
   spool ${SPOOL_FILE_MWA}
   TTITLE  CENTER 'Hourly Report - MWA sessions Count By Machine'
   select count(machine),machine from  v$session where module='MWAJDBC' group by machine
/
ALTER SESSION
   SET NLS_DATE_FORMAT = 'YYYY MM DD HH24:MI:SS';

select machine,action,logon_time,last_call_et,status from v$session where module='MWAJDBC'
order  by machine
/

   spool off
   set markup html off spool off
EOF


select count(machine),machine from  v$session where module='MWAJDBC' group by machine




CANNOT STOP MWA TELNET SERVER FROM THE MWACTL.SH SCRIPT

CANNOT STOP MWA TELNET SERVER FROM THE MWACTL.SH SCRIPT

Cause:

Missing entry in etc/hosts file 

127.0.0.1 localhost.localdomain localhost

Solution:


1. Add the following entry :

127.0.0.1 localhost.localdomain localhost
2. Retest the issue

CANNOT STOP MWA TELNET SERVER FROM THE MWACTL.SH SCRIPT. (Doc ID 1080172.1)

Oracle Apps public Vision Instances

Oracle Apps public Vision Instance

Reference: Oracle
You can access vision instance for FREE. No need to do any setups. You just need a browser!

Instance 1:
Public vision instance which does not require any CSI
http://demo.appshosting.com/OA_HTML/AppsLocalLogin.jsp
Username: operations
Password: welcome

Instance 2:
Another instance
http://www.biztech.com/services/vision-instance/

Instance 3: (Requires CSI)
http://vis1200.solutionbeacon.net/OA_HTML/AppsLogin

Important:

In order to access the environment, each new user will need to complete the Release 12 Vision User Registration form! You will need to supply an email address and a CSI# (Oracle Customer Identifier). When the form is submitted, your unique username/password will be generated automatically and will be emailed to the address provided. Once you receive the email, you will be able to login to the Vision environment and enjoy the same access levels as the default operations user.

Note:
You can access 11i instance also. Here is the link.
http://vis11510ext5.solutionbeacon.net/OA_HTML/DiagLogin.jsp

Workflow Related Metalink Notes

How To Troubleshoot Java-based Workflow Notification Mailer (Doc ID 242941.1)

Unable To Start Workflow Notification Mailer (Doc ID 418329.1)


How to Check Whether Notification Mailer is Working or Not (Doc ID 415516.1)


Workflow Notification Mailer Will Not Start (Doc ID 278427.1)

Workflow Notification Mailer Will Not Start (Doc ID 278163.1)

Notification Mailer Does Not Start, Remains In Status Starting (Doc ID 371830.1)


Unable To Make A Network Connection For IMAP Username/Password In Workflow Mailer Configuration [ID 784247.1]


Workflow Cannot Connect to IMAP Sever: "Unable to Make a Network Connection" [ID 577592.1]

Error Validation Error Has Occurred: Unable To Make A Network Connection During Mailer Setup [ID 834054.1]

How to Perform a Meaningful SMTP Telnet Test to Troubleshoot Java Mailer For Sending Email Notifications [ID 753845.1]

How to Troubleshoot 'Validation failed' Errors when Starting the Mailer [ID 463354.1]

Unable To Connect To The Mail Account. Check The Host, User Name And Password [ID 1123684.1]Workflow Mailer Will Not Start Stays In Starting Status [ID 837893.1]Mailer cannot Connect to IMAP Server on Oracle Applications R12.1.1 [ID 1300542.1]Java Mailer not Starting Error in Handling Component Event [ID 297725.1]Inbound Processing Is Not Happening While Approving/Rejecting From Emails [ID 418931.1]Unable To Start Notification Mailer After Upgrade To 10.2.0.3 [ID 725852.1]

AUTOPATCH ARGUMENTS

AUTOPATCH ARGUMENTS

apply Purpose: Tells AutoPatch whether to run in test mode.Default: y
driver Purpose: Tells AutoPatch the name of the patch driver file. This is usually used during non-interactive processing.
patchtop Purpose: Tells AutoPatch the top-level directory for the current patch. This is normally used during non-interactive processing. Values: A fully qualified directory name.
preinstall Purpose: Tells AutoPatch whether to run in pre-install mode. Pre-install mode is used to update AD utilities before an upgrade and to apply pre-upgrade patches.
uploadph Purpose: Tells AutoPatch to upload patch history information from the patch information files

AutoPatch Options

The options= argument is used to pass generic options to AutoPatch. It takes the form of a comma-separated list. Enter one option or a comma-separated list of options. For example, options=nocopyportion,nogenerateportion. As with AutoPatch arguments, there must be no space after the comma.

autoconfig Purpose: Tells AutoPatch to run AutoConfig automatically.Default: autoconfig
Use options=noautoconfig if you are applying a number of patches in sequence and want to run AutoConfig once, after applying the last patch of the sequence. The more common method is to merge the patches first with AD Merge Patch.
checkfile Purpose: Tells AutoPatch to either skip running EXEC, SQL, and EXECTIER commands if they are recorded as already run, or to record them as having run after running them. checkfile provides significant performance benefits.
compiledb Purpose: Tells AutoPatch to automatically compile invalid objects in the database after running actions normally found in the database portion of the driver. Use nocompiledb for standard patch translations, documentation patches, and documentation patch translations. Use options=nocompiledb to save time when multiple non-merged patches are applied in a maintenance window.
compilejsp Purpose: Tells AutoPatch whether to automatically compile out-of-date JSP files. JSP files are only compiled if the patch contains copy actions for at least one JSP file.compilejsp for standard patches. nocompilejsp for standard patch translations, documentation patches, and documentation patch translations.
Use options=nocompilejsp to save time when multiple non-merged patches are applied in a maintenance window.
copyportion Purpose: Tells AutoPatch whether to run commands normally found in the copy portion of the driver.
databaseportion Purpose: Tells AutoPatch whether to run commands normally found in the database portion of the driver.
generateportion Purpose: Tells AutoPatch whether to run commands normally found in the generate portion of the driver. Use options=nogenerateportion to tell AutoPatch not to perform generate actions of the driver.
hotpatch Purpose: Tells AutoPatch to apply a patch regardless of whether the Oracle E-Business Suite system is in Maintenance mode.Default: nohotpatch
integrity Purpose: Tells AutoPatch whether to verify that the version of each file referenced in a copy action matches the version present in the patch.Default: nointegrity, nointegrity is safe and avoids some AutoPatch overhead.
maintenancemode Purpose: Tells AutoPatch to enable Maintenance mode at the beginning of a patch session and disable it at the end (if patch application was successful). Default: nomaintenancemode
parallel Purpose: Tells AutoPatch whether to run actions that update the database in parallel (such as SQL) and actions that generate files in parallel (such as genform).
Default: parallel Comments: Oracle does not recommend changing the default, as Oracle E-Business Suite patches are tested on systems using parallel processing.
phtofile Purpose: Tells AutoPatch where to place patch history information after applying the patch.
Default: nophtofile. Use options=phtofile to tell AutoPatch to write patch history information to the patch information files in the file system ($APPL_TOP/admin/$TWO_TASK) instead of uploading it to the database. Comments: Using phtofile allows you to defer the uploading of patch history information to the database until after the system downtime. Use the adpatch uploadph=y command to upload patch history information from the patch information files (in $APPL_TOP/admin/$TWO_TASK) to the database during uptime.
validate Purpose: Tells AutoPatch whether to connect to all registered Oracle E-Business Suite schemas at the start of the patch. Use options=validate to validate password information for all Oracle E-Business Suite schemas. Comments: Useful for finding problems with incorrectly registered Oracle E-Business Suite schemas or schemas with invalid passwords.