Home » Applications » Oracle Fusion Apps & E-Business Suite » Error while creating customers on sales pages (merged 4) Oracle e-business suite---CRM Sales
Error while creating customers on sales pages (merged 4) Oracle e-business suite---CRM Sales [message #418696] Tue, 18 August 2009 03:31 Go to next message
exboy
Messages: 14
Registered: March 2009
Junior Member
Hi Everyone,

When trying the process below:

Resp: Sales Online Super user

Sales Online

Customer tab--> Click on Create Button.

Enter mandatory fields and click on Create.

You will get the below error:

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1 java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:736) at oracle.apps.ar.hz.v2api.HzPartyV2Pub.createOrganization(HzPartyV2Pub.java:1298) at oracle.apps.asf.customer.organization.OrganizationEO.createOrg(OrganizationEO.java:484) at oracle.apps.asf.customer.organization.OrganizationEO.create(OrganizationEO.java:548) at oracle.apps.asf.webbean.FormWebBean.process(FormWebBean.java:172) at oracle.apps.asf.webbean.WebBeanHandler.process(WebBeanHandler.java:255) at _oa__html._asfOrgznCreatMain._jspService(_asfOrgznCreatMain.java:1267) 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:534)

Kindly help out on the steps to take to correct this error.

Best Regards.
Re: Error while creating customers on sales pages [message #418701 is a reply to message #418696] Tue, 18 August 2009 03:42 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Quote:
Enter mandatory fields and click on Create.
what are they?
Cross check whether you are entering any character in number fields.

By
Vamsi
Re: Error while creating customers on sales pages [message #418713 is a reply to message #418701] Tue, 18 August 2009 05:14 Go to previous message
exboy
Messages: 14
Registered: March 2009
Junior Member
no i am not, i only enter the customer details to create the customer and i get the error, any ideas?

Previous Topic: The PL/SQL procedure that generates a PL/SQL document
Next Topic: gl_code_combinations_kfv package
Goto Forum:
  


Current Time: Wed Dec 07 12:46:13 CST 2016

Total time taken to generate the page: 0.08860 seconds