Friday, December 27, 2013

Clearing Cache in R12 instance


1- Stop Apache --- adapcctl.sh stopall

2- Clear cache  cd $COMMON_TOP/-----remove _pages  and create _pages

mkdir _pages
chmod 777 _pages

3-  cd $FND_TOP/patch/115/bin


$ ./ojspCompile.pl --compile --flush -p 2
logfile set: /test/mtlog/test_localhost/logs/appl/rgf/ojsp/ojspc_error.log
starting...(compiling all)
using 10i internal ojsp ver: 10
synchronizing dependency file:
enumerating jsps...8001
parsing jsp...8001
writing deplist...8001
initializing compilation:
eliminating children...5912 (-2089)
translating and compiling:
translating jsps...5912/5912 in 4m39s                
compiling jsps...5912/5912 in 17m30s                
Finished!
$

4- Start Apache -- adapcctl.sh startall

Compiling single jsp

ojspCompile.pl --compile -s 'fnd%' -p 20


How to clear cache for a specific component in R12

As we all know the normal tendency for clearing cache in Oracle Apps is to delete the $COMMON_TOP/_pages directory.In 11i, after deleting we dont have to recompile the jsps but in R12 we have to recompile the pages since s_jsp_main_mode is set to justrun by default which is in turn updated in orion-web.xml

How can i clear cache for a specific component of Oracle Apps R12 viz., iprocurement, istore etc.,
Is this even possible ? Yes it is and this option comes handy when somebody modifies a jsp page which is part of say istore,then it makes sense to clear cache for istore and not for the whole server.

Clearing cache for specific Component/Application in R12

Login as sysadmin
Select Functional Administrator responsibility
Go to Core Services ==> Caching Framework ==> Tuning
Query the application (for example iStore) or by Name or code.
Select the component and clear the cache.

Note: For some specific configuration changes, we need to bounce Apache also.

Clearing Global Cache in R12

a) Go to Functional Administrator Responsibility
b) Go to Core Services ==> Caching Framework
c) Go to Global configuration and clear all the cache from there.(Only If you want to clear all the  cache)


For further reading:
http://applicationsdba.blogspot.in/2008/01/r12-beware-executing-rm-rf.html
http://www.pythian.com/blog/jsp-cache-issues-in-11i-and-r12/
 

Wednesday, December 25, 2013

Difference between Simle Past and Present Perfect

Simple Past:
I read the article yesterday.
--specific time, task completed.

Examples:
I worked hard "yesterday/last week/last month"

Questioning:
When did you move to USA? --- exact time


Present Perfect:
I have read the article.
--no specific time, task completed sometime in past.

Examples:
I have worked hard this "week/semester"
I have worked hard since "6 am/January"

Questioning:
How long have you been in USA? --- duration of time

Usage of Past Simple and Past Perfect

8:00 -- wake up
8:15 -- eat breakfast

After I had woken up, I ate breakfast.
Past Perfect + Simple Past

5:15 -- have a bath
5:30 -- watch TV

After I had had a bath, I watched TV.

English Grammar

Sites for English Grammar.

http://web2.uvcs.uvic.ca/courses/elc/studyzone/

Sunday, December 22, 2013

Some of the known issues on Forms in EBS









[Document 758661.1]




[Document 973632.1]




[Document 1269544.1]




[Document 1062246.1]




[Document 465926.1]




[Document 429627.1]




[Document 779065.1]




[Document 1175400.1]





[Document 734077.1











Note 1258305.1 Users Receive FRM-92101 oracle.forms.net.ConnectionException Errors When Launching E-Business Suite Forms Responsibility and Function
Note 454427.1 R12: "FRM-92101:There was a failure in the Forms Server during startup" Error When Attempting to Launch Forms
Note 438231.1 FRM-92050 Connecting and "Failed to exec runform f60webmx" Starting Forms Server
Note 1103744.1 R12: "FRM-92101: There Was a Failure in the Forms Server During Startup" Error When Loading Forms
Note 1056333.1 Forms Error With FRM-91126 invalid value timezlrg#dat
Note 744093.1 FRM-92050 With "Connection reset by peer: JVM_recv in socket input stream read" Error When Launching Form On Microsoft Servers
Note 1203773.1 Forms raises FRM-92100 Caused By Java.IllegalStateException:Cannot Open System Clipboard
note 130686.1 How to Generate Form, Library and Menu for Oracle Applications
Note 438652.1 R12: Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications
Note 840577.1 Getting FRM-41839 FRM-41092 FRM-40737 FRM-40734 When Using Mouse Scroll on Oracle Applications 12.0.4
Note 550364.1 FRM-40735: Pre-Update Trigger Raised Unhandled Exception ORA-04062
Note 754347.1 FRM-40833: Could not completely load the dynamic user exit libraries
Note 399652.1 Getting FRM-41800 when navigating to any LOV and Focus Lost
Note 1369830.1 R12 Forms Slow performance / Freezes / Hangs for large # Record details using View -> Last -> Record
For troubleshooting you may review the following:

Note 365529.1 Troubleshooting FRM-92XXX Errors in Oracle Applications
Note 311019.1 Troubleshooting FRM-92100 Issues In Oracle Applications 11i
Note 402674.1 Tips and Queries for Troubleshooting Forms Session Timeout Issues
Note 164220.1 Troubleshooting "FRM-92160: Web client version too old" Error in R11i
Note 810084.1 Troubleshooting"Forms CGI error: URL Contains One Or More Restricted Characters" In Apps 11i
Note 136027.1 Troubleshooting Oracle Forms 6i Issues With Oracle Applications 11i
Note 299187.1 11i: How to Troubleshoot Error "FRM-92050 Failed to connect to the server"
Note 164220.1 Troubleshooting "FRM-92160: Web client version too old" Error in R11i

Tuesday, December 17, 2013

OAF page issue in R12


Issues with some OAF pages in R12.


Solution: Note ID "How to Diagnose an 'You Have Encountered an Unexpected Error" (Doc ID 562796.1)"


1) Login from the front end.

2) Enable Debug for your session to collect the trace file for the infected OAF page.
    To Enable Debug,  launch any form, in the form Help --> Diagnostics --> Debug
3) Now Access the OAF page that is having the issue with, for next steps you can follow the Note ID.











Saturday, December 14, 2013

Housekeeping of R12 application & Database

 
http://dbataj.blogspot.in/2011/07/housekeeping-of-r12-application.html

Monday, November 18, 2013

Forms Issues in R12 --- Oracle error 1403: java.sql.SQLException


ISSUE:1

If you come up with below error in the web browser while you are login into the Oracle Applications or the Application Forms do not load for a very long time,
"<PRE>Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 has been detected in FND_SESSION_MANAGEMENT.CHECK_SESSION. Your session is no longer valid. </PRE> Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details."


Solution 1:
Please implement below steps, to overcome the issue.
1. Go to Control Panel
Start àControl Panel
2. Select Java Control Panel from the list.
3. From the popup window (Java Control Panel), uncheck “Enable the next-generation Java Plug-in” option.
4. Click “Apply” and click “OK”
5. Clear browsing history (Internet Explorer Menu Bar: Tools à Delete Browsing History) and close all the browser sessions.
6. Launch the browser and try to access Oracle Applications, if the issue still persists reboot the system. 

Solution 2:
Disable Internet Explorer 8.0 add-ons:

a. Click "Tools" and select "Internet Options".
b. Click the "Advanced" tab on the right.
c. Under "Browsing", remove the "Enable third-party browser extensions" check box.
d. Click "OK" and close out of all instances of Internet Explorer.
e. Relaunch Internet Explorer.
 

Solution 3:
If you still see the above issue you can try this as well.

 "Unable to authenticate session"
Open a new explorer window using its own session cookie by selecting File -> New Session from the Menu Bar in an existing browser window. (IE9 Users may have to enable the Menu Bar first by right clicking the browser header frame and selecting Menu Bar.)
Run from the command line adding the -noframemerging parameter e.g. Start -> Run -> iexplore -noframemerging
Create a new IE8 icon adding the -noframemerging parameter e.g.
Start -> Program Files
Right click on the Internet Explorer icon and select Properties
Add -noframemerging to the end of the link in the Target field e.g."C:\Program Files\Internet Explorer\iexplore.exe" -noframemerging
Click the OK button to close the window
This icon may then be copied to the desktop if desired

R12: Using IE8 to access two EBS Instances runs in error "Unable To Authenticate Session" (Doc ID 1098563.1)