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.
gomia.blogspot.com
Travelogue: September 2005
http://gomia.blogspot.com/2005_09_01_archive.html
Wednesday, September 21, 2005. To view few of my shared photos. Wednesday, September 21, 2005. Links to this post. 2005-09-17: Trip to TungaBhadra Dam and Hampi. Here I am, with the first ever blog! And with an account of my last trip, during the just gone weekend! As been the case with me, there seemed no way for my trip to Hampi getting materialized. As you might be knowing, Hampi was the capital city of Vijaynagar Empire, and flourished during Krishna Dev Raya (associated with the legendary Tenali Ram).
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...
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();.
ramumble.blogspot.com
RAM-ble: Sunday Night Cricket
http://ramumble.blogspot.com/2009/03/sunday-night-cricket.html
Tuesday, March 24, 2009. Subscribe to: Post Comments (Atom). View my complete profile. No one going to India or Pakistan. Cursor Focus on OA page.
ramumble.blogspot.com
RAM-ble: Cursor Focus on OA page
http://ramumble.blogspot.com/2009/03/cursor-focus-in-oa-page.html
Wednesday, March 25, 2009. Cursor Focus on OA page. Initial cursor focus on single row region is simple and straightforward. String id = "myId"; / ID of the field. OABodyBean bB = (OABodyBean)pageContext.getRootWebBean();. We need to find the current active tab and then focus on the field for that tab. OABodyBean bB = (OABodyBean)pageContext.getRootWebBean();. OASubTabLayoutBean tBean = (OASubTabLayoutBean)webBean.findIndexedChildRecursive("tabRegionId");. Else if (tabIndex = 1). Id is ID of your bean.