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.
oracleappstechnology.blogspot.com
Oracle Apps Technology: March 2014
http://oracleappstechnology.blogspot.com/2014_03_01_archive.html
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps. Tuesday, March 11, 2014. R122 adapcctl.sh: opmnctl: not found after fresh install / upgrade. This problem occurs during rapidwiz where it fails to create apache instance and the error is logged in deploytech.log:. ERROR: Failed to create the EBS domain. Failed to deploy the E-Business Suite domain. Create missing apache instance, not created by rapidwiz. Opmnctl ...
oracleappstechnology.blogspot.com
Oracle Apps Technology: java.sql.SQLException: Invalid number format for port number
http://oracleappstechnology.blogspot.com/2015/05/jim-pinged-me-with-this-error-today-on.html
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps. Wednesday, May 13, 2015. Javasql.SQLException: Invalid number format for port number. Jim pinged me with this error today:. On /adgendbc.sh i get. Creating the DBC file. Javasql.SQLRecoverableException: No more data to read from socket raised validating GUEST USER PWD. Javasql.SQLRecoverableException: No more data to read from socket. Wed May 13 18:50:51 2015.
oracleappstechnology.blogspot.com
Oracle Apps Technology: February 2014
http://oracleappstechnology.blogspot.com/2014_02_01_archive.html
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps. Wednesday, February 26, 2014. ORA-20010: ERROR: Unable to acquire lock on ad adop sessions table. ORA-06512: at "APPS.AD ZD ADOP", line 523. I reported this error to Oracle on an SR:. The adop phase=prepare fails before generating any log files. Whatever we get on the screen is what we have. I'll paste it for you again:. Enter the APPS password:. ERROR at line 1:.
oracleappstechnology.blogspot.com
Oracle Apps Technology: September 2014
http://oracleappstechnology.blogspot.com/2014_09_01_archive.html
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps. Saturday, September 27, 2014. Oracle.ias.cache.CacheFullException: J2EE JOC-017 The cache is full. Yesterday, the users of an EBS R12.2 instance got this error when they logged in:. You have Encountered an unexpected error. Please contact the System Administrator for assistance. Oracle.ias.cache.CacheFullException: J2EE JOC-017 The cache is full. At oracle.ap...
oracleappstechnology.blogspot.com
Oracle Apps Technology: opatch hangs on /sbin/fuser oracle
http://oracleappstechnology.blogspot.com/2015/04/opatch-hangs-on-sbinfuser-oracle.html
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps. Saturday, April 11, 2015. Opatch hangs on /sbin/fuser oracle. Pipu pinged me today about opatch hanging. The opatch log showed this:. Apr 11, 2015 5:24:13 PM] Start fuser command /sbin/fuser $ORACLE HOME/bin/oracle at Sat Apr 11 17:24:13 EDT 2015. I had faced this issue once before, but was not able to recall what was the solution. So I started fresh. Open("/proc...
sairamgoudmalla.blogspot.com
Oracle Apps: February 2015
http://sairamgoudmalla.blogspot.com/2015_02_01_archive.html
Thursday, February 26, 2015. Oracle Work in Process – Discrete Job Interface (WIP Mass Load) Common Errors. The following are some of the general errors we will be getting while running the WIP Mass Load. 1 Invalid or missing WIP Accounting Class. ANS): Set a default WIP accounting class in the WIP parameters for the organization. 2 Invalid value for Scheduling Method. 3 System cannot add or change operation because requested department id does not exist in bom departments table. ANS): You will be gettin...
sairamgoudmalla.blogspot.com
Oracle Apps: August 2015
http://sairamgoudmalla.blogspot.com/2015_08_01_archive.html
Thursday, August 27, 2015. How to join Projects and Customers tables. SELECT proj.segment1 project#, proj.NAME proj name,. Hcaccount number customer account number#. FROM pa projects all proj, pa project customers pc, hz cust accounts hc. WHERE 1 = 1. AND proj.project id = pc.project id. AND pc.customer id = hc.cust account id. Friday, August 21, 2015. Query to check before Disabling any Accounts in oracle. FROM xla ae headers xah, xla ae lines xal. WHERE 1 = 1. AND xah.gl transfer status code = 'N'.
sairamgoudmalla.blogspot.com
Oracle Apps: January 2015
http://sairamgoudmalla.blogspot.com/2015_01_01_archive.html
Friday, January 30, 2015. Query to check Internal Requisition Number and Internal Sales Order Number. Query to check Internal Requisition Number and Internal Sales Order Number. Select ORIG SYS DOCUMENT REF from OE ORDER HEADERS ALL. Select * from po requisition HEADERs all. 1 OE ORDER LINES ALL.SOURCE DOCUMENT LINE ID =. Po requisition lines all.REQUISITION LINE ID. 2 OE ORDER LINES ALL.ORIG SYS DOCUMENT REF=. Po requisition HEADERs all.SEGMENT1(Requisition Number). Tuesday, January 27, 2015. WHERE wsp&...