R12: Clicking on Supplier Accounting Link Errors: JBO-27122: SQL error during statement preparation and ORA-01722: invalid number
(Doc ID 1218903.1)
Last updated on APRIL 18, 2025
Applies to:
Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]Oracle iSupplier Portal - Version 12.0.1 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Symptoms
- Clicking on the Supplier Accounting link in the Suppliers form results in the system indicating that there is an unexpected error
- Supplier accounting link gives error when attempt to access the Accounting page (ByrAcctPG) for Supplier from Update Supplier Details page (QuickUpdatePG).
You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details.
Exception Details:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement:
SELECT CUSTVO.VALUE_CODE AS "ValueCode", LOVVO.NAME AS "ValueMeaning", CUSTVO.VALUE_DISPLAY_SEQUENCE AS "ValueDisplaySequence", CUSTVO.VALUE_SOURCE AS "ValueSource"
FROM
(SELECT FndLovChoiceValuesEO.VALUE_SOURCE, FndLovChoiceValuesEO.USER_ID, FndLovChoiceValuesEO.FULL_REF_NAME,
FndLovChoiceValuesEO.VALUE_DISPLAY_SEQUENCE, FndLovChoiceValuesEO.VALUE_CODE, FndLovChoiceValuesEO.CREATED_BY,
FndLovChoiceValuesEO.CREATION_DATE, FndLovChoiceValuesEO.LAST_UPDATED_BY, FndLovChoiceValuesEO.LAST_UPDATE_DATE,
FndLovChoiceValuesEO.LAST_UPDATE_LOGIN
FROM FND_LOV_CHOICE_VALUES FndLovChoiceValuesEO
WHERE ((VALUE_SOURCE = 'USER' OR VALUE_SOURCE = 'SEEDCOPY')
AND USER_ID = :1 AND FULL_REF_NAME = :2)
OR (VALUE_SOURCE = 'SEED' AND FULL_REF_NAME = :3
AND NOT EXISTS
(SELECT NULL
FROM fnd_lov_choice_values
WHERE (VALUE_SOURCE = 'USER' OR VALUE_SOURCE = 'SEEDCOPY')
AND USER_ID = :4
AND FULL_REF_NAME = :5))
ORDER BY FndLovChoiceValuesEO.VALUE_DISPLAY_SEQUENCE ) CUSTVO,
(select set_of_books_id, name, short_name, description, currency_code, period_set_name
from gl_sets_of_books where set_of_books_id in
(SELECT hou2.set_of_books_id
FROM hr_operating_units hou2
WHERE mo_global.check_access(hou2.organization_id) = 'Y') ) LOVVO
where CUSTVO.VALUE_CODE = LOVVO.SET_OF_BOOKS_ID
order by CUSTVO.VALUE_DISPLAY_SEQUENCE
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3241)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3036)
at _OA._jspService(_OA.java:228) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:889)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
...
...
Statement:
SELECT CUSTVO.VALUE_CODE AS "ValueCode", LOVVO.NAME AS "ValueMeaning", CUSTVO.VALUE_DISPLAY_SEQUENCE AS "ValueDisplaySequence", CUSTVO.VALUE_SOURCE AS "ValueSource"
FROM
(SELECT FndLovChoiceValuesEO.VALUE_SOURCE, FndLovChoiceValuesEO.USER_ID, FndLovChoiceValuesEO.FULL_REF_NAME,
FndLovChoiceValuesEO.VALUE_DISPLAY_SEQUENCE, FndLovChoiceValuesEO.VALUE_CODE, FndLovChoiceValuesEO.CREATED_BY,
FndLovChoiceValuesEO.CREATION_DATE, FndLovChoiceValuesEO.LAST_UPDATED_BY, FndLovChoiceValuesEO.LAST_UPDATE_DATE,
FndLovChoiceValuesEO.LAST_UPDATE_LOGIN
FROM FND_LOV_CHOICE_VALUES FndLovChoiceValuesEO
WHERE ((VALUE_SOURCE = 'USER' OR VALUE_SOURCE = 'SEEDCOPY')
AND USER_ID = :1 AND FULL_REF_NAME = :2)
OR (VALUE_SOURCE = 'SEED' AND FULL_REF_NAME = :3
AND NOT EXISTS
(SELECT NULL
FROM fnd_lov_choice_values
WHERE (VALUE_SOURCE = 'USER' OR VALUE_SOURCE = 'SEEDCOPY')
AND USER_ID = :4
AND FULL_REF_NAME = :5))
ORDER BY FndLovChoiceValuesEO.VALUE_DISPLAY_SEQUENCE ) CUSTVO,
(select set_of_books_id, name, short_name, description, currency_code, period_set_name
from gl_sets_of_books where set_of_books_id in
(SELECT hou2.set_of_books_id
FROM hr_operating_units hou2
WHERE mo_global.check_access(hou2.organization_id) = 'Y') ) LOVVO
where CUSTVO.VALUE_CODE = LOVVO.SET_OF_BOOKS_ID
order by CUSTVO.VALUE_DISPLAY_SEQUENCE
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3241)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3036)
at _OA._jspService(_OA.java:228) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:889)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
...
...
Steps to Reproduce the Issue:
1. Log in and go to Payables responsibility.
2. Navigate: Supplier + Inquiry
3. Search and select Supplier.
4. Click on update for supplier.
-- This opens the iSupplier Portal page: Update Supplier (QuickUpdatePG).
5. Click on Accounting link, the system gives an error.
2. Navigate: Supplier + Inquiry
3. Search and select Supplier.
4. Click on update for supplier.
-- This opens the iSupplier Portal page: Update Supplier (QuickUpdatePG).
5. Click on Accounting link, the system gives an error.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |