Text box

Please note that the problems that i face may not be the same that exist on your environment so please test before applying the same steps i followed to solve the problem .

Saturday, 9 February 2013

Outsorucing Oracle DBA's to gulf

Hello All,

I noticed that a lot of oracle professionals exist now in Egypt.I noticed that if w can success in communicating those professionals in one group the investors from different countries may found a strong community to b able to outsource and find great consultants to do remote tasks using vpn or remote desktop connectivity or even provide consultation through the phone.I know the idea seems crazy but why not.I created  a new group on facbook for this purpose and th link is posted below:
http://www.facebook.com/pages/Outsourcing-Oracle-Profssionals-to-Gulf/540437332656456

Kind Regards
Mohamed

Sunday, 3 February 2013

FRM-92150 Web Client Too New


To solve the problem:

1. Open JInitiator from the Control Panel.
2. Open the "Cache" Tab.
3. Click the button "Clear JAR Cache".
4. Re-run the Form.
or
1. Open Java from the Control Panel.
2. Open press button "settings" on the general tabpage.
3. Click the button "delete files" to delete the cached jarfiles.
4. Re-run the Form.

Thursday, 3 January 2013

How to find the atg patch level in oracle apps 11i ?



Use below query to query for ATG patch level:
Connect to apps schema “sqlplus apps/apps”

SELECT (bug_number),
decode((bug_number),
'3438354','ATG_PF.H',
'4017300','ATG_PF.H RUP 1',
'4125550','ATG_PF.H RUP 2',
'4334965','ATG_PF.H RUP 3',
'4676589','ATG_PF.H RUP 4',
'5473858','ATG_PF.H RUP 5',
'5903765','ATG_PF.H RUP 6',
'6241631','ATG_PF.H RUP 7')
FROM ad_bugs
WHERE bug_number IN
('3384350',
'3438354',
'4017300',
'4125550',
'4334965',
'4676589',
'5473858',
'5903765',
'6241631')
order by bug_number desc;

Regards
Mohamed ElAzab

Sunday, 30 December 2012

Unable to create font cache directory in Apps 11i

The below error appeared in 11i Apps and we solved it as follows:


 

1. Navigation Path:

(Responsibility) XML Publisher Administrator > (Menu) Home > (Tab) Administration > (SubTab) Configuration > Properties > General > Temporary directory

2. Provide a valid value to 'Temporary directory', and click button 'Save'.

3. Re-test the issue.

The issue:

 
Error Page


Exception Details.

 oracle.apps.fnd.framework.OAException: oracle.apps.xdo.XDOException: Unable to create font cache directory:
 /appltop1/proderpcomn/temp/xdofonts/STAGERP
        at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:975)
        at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
        at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
        at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:785)
        at oracle.apps.per.irc.offers.webui.IrcSaveForLaterCO.processFormRequest(IrcSaveForLaterCO.java:238)
        at oracle.apps.per.irc.offers.webui.OfferReviewCO.processFormRequest(OfferReviewCO.java:152)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:810)
        at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
        at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1159)
        at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
        at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
        at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
        at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
        at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
        at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2676)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1683)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)
        at _oa__html._OA._jspService(_OA.java:84)
        at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
        at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
        at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
        at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
        at oracle.jsp.JspServlet.service(JspServlet.java:156)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
        at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
        at org.apache.jserv.JServConnection.run(JServConnection.java:294)
        at java.lang.Thread.run(Thread.java:662)
## Detail 0 ##