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 MARCH 03, 2016

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

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)
...
...
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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms