ramumble.blogspot.com
RAM-ble: Read by other session - Strange issue
http://ramumble.blogspot.com/2009/08/read-by-other-session-strange-issue.html
Friday, August 21, 2009. Read by other session - Strange issue. We faced a really strange performance issue in our database today. One report was running for ever. It uses only one SQL and that SQL was completing really fast from TOAD(backend). When we looked at our database monitoring software, we found a new strange wait event " read by other session. Was the major culprit. After rigorous googling we decided to flush the shared pool. Alter system flush shared pool;. Subscribe to: Post Comments (Atom).
ramumble.blogspot.com
RAM-ble: March 2008
http://ramumble.blogspot.com/2008_03_01_archive.html
Thursday, March 27, 2008. Cursor Focus for OAF Mobile Pages. OABodyBean.setInitialFocusId() wont work in mobile. We did the following to get the cursor focus on mobile page (11.5.10 RUP3). A Copy OA.jsp to XXOAMobile.jsp. B Modify the following code in XXOAMobile.jsp. RedirectURL = pageBean.preparePage(pageContext);. Jsp:forward page=" %= redirectURL % " /. RedirectURL = pageBean.preparePage(pageContext);. String x = redirectURL.substring(2); / modified. X= "XXOAMobile" x; / modified. Where N can vary.
shiv-saroj.blogspot.com
Oracle Applications: Paper presentation in OAUG Collaborate 10
http://shiv-saroj.blogspot.com/2010/04/paper-presentation-in-oaug-collaborate.html
My learnings and views on Oracle Applications, Human Resource Management System, Oracle Time and Labor, Oracle Applications Framework, Business Process Execution Language and Service Oriented Architecture. Paper presentation in OAUG Collaborate 10. My abstract on technology direction regarding choice of framework for Oracle E-Business Suite has been selected for presentation. I am looking forward to present my paper at the OAUG Collaborate 10 conference. Below are the details of my session:. Over 400 use...
ramumble.blogspot.com
RAM-ble: June 2009
http://ramumble.blogspot.com/2009_06_01_archive.html
Tuesday, June 9, 2009. Oracle Ebusiness Suite password. Oracle Ebusiness Suite password. You need either read only access to database or you can work it out in a cloned instance. Step 1: Create the following function in database. Alternatively you can create a Java class and move it to JAVA TOP. CREATE OR REPLACE function APPS.my decrypt(key in varchar2, value in varchar2). Step 2: Get database APPS schema password. SELECT my decrypt( SELECT fpov.profile option value. FROM fnd profile options fpo,. Theor...
shiv-saroj.blogspot.com
Oracle Applications: Oracle Open World Paper Presentation
http://shiv-saroj.blogspot.com/2010/09/oracle-open-world-paper-presentation.html
My learnings and views on Oracle Applications, Human Resource Management System, Oracle Time and Labor, Oracle Applications Framework, Business Process Execution Language and Service Oriented Architecture. Oracle Open World Paper Presentation. I am going to present 2 sessions in the Oracle OpenWorld next week and am the guest speaker for one of the Oracle’s session. Do catch me if you are going to be there. More details on Oracle OpenWorld @ http:/ www.oracle.com/us/openworld/index.html. Oracle Applicati...
ramumble.blogspot.com
RAM-ble: August 2009
http://ramumble.blogspot.com/2009_08_01_archive.html
Friday, August 21, 2009. Read by other session - Strange issue. We faced a really strange performance issue in our database today. One report was running for ever. It uses only one SQL and that SQL was completing really fast from TOAD(backend). When we looked at our database monitoring software, we found a new strange wait event " read by other session. Was the major culprit. After rigorous googling we decided to flush the shared pool. Alter system flush shared pool;. Subscribe to: Posts (Atom).
ramumble.blogspot.com
RAM-ble: January 2009
http://ramumble.blogspot.com/2009_01_01_archive.html
Thursday, January 29, 2009. Printing Word doc FND attachments. Technical Overview of FND attachments. All file attachments are stored in FND LOBS table in file data column. You can link this back to your attachment entity using the following query. SELECT fl.file data,. FROM fnd attached documents fad,. Fnd documents tl fdt,. WHERE fad.document id = fdt.document id. AND fl.file id = fdt.media id. AND fdt.language = userenv('Lang'). AND fad.entity name = 'MTL SYSTEM ITEMS'. AND fad.pk1 value = 183. Soffic...
ramumble.blogspot.com
RAM-ble: Row.STATUS_INITIALIZED
http://ramumble.blogspot.com/2009/04/we-were-experiencing-very-strange-p.html
Friday, April 3, 2009. We were experiencing a very strange problem with an OA page. The page is used to update multiple rows from a transient VO using a table region. Following were the symptoms. Sometimes after save, the old value used to reappear. Sometimes after save, value from different row gets updated to current row. It was not happening for all kind of data. Finally (by sheer luck) we found that it was because the way we preparing the VO for update. Row row = vo.createRow();.
ramumble.blogspot.com
RAM-ble: April 2009
http://ramumble.blogspot.com/2009_04_01_archive.html
Friday, April 3, 2009. We were experiencing a very strange problem with an OA page. The page is used to update multiple rows from a transient VO using a table region. Following were the symptoms. Sometimes after save, the old value used to reappear. Sometimes after save, value from different row gets updated to current row. It was not happening for all kind of data. Finally (by sheer luck) we found that it was because the way we preparing the VO for update. Row row = vo.createRow();.