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]