oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT hou.organization_id,hou.name org_name,hou.cost_allocation_keyflex_id cost_allocation_keyflex_id FROM hr_organization_units hou where cost_allocation_keyflex_id = (SELECT distinct pcak.cost_allocation_keyflex_id FROM pay_cost_allocation_keyflex pcak WHERE pcak.segment2=:1)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 784264, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT hou.organization_id,hou.name org_name,hou.cost_allocation_keyflex_id cost_allocation_keyflex_id FROM hr_organization_units hou where cost_allocation_keyflex_id = (SELECT distinct pcak.cost_allocation_keyflex_id FROM pay_cost_allocation_keyflex pcak WHERE pcak.segment2=:1)
via Oracle Community by 784264, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT organization_id,name FROM hr_organization_units where COST_ALLOCATION_KEYFLEX_ID in(SELECT pcak.COST_ALLOCATION_KEYFLEX_ID FROM pay_cost_allocation_keyflex pcak WHERE pcak.segment2 like :1)
via Oracle Community by HaroonAfridi, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT EmpTestEO.EMPNO, EmpTestEO.ENAME, EmpTestEO.JOB, EmpTestEO.MGR, EmpTestEO.HIREDATE, EmpTestEO.SAL, EmpTestEO.COMM, EmpTestEO.DEPTNO FROM EMP_TEST EmpTestEO WHERE EMPNO = :1
via Oracle Community by 868733, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select customer_id from XXCUR_TRADE_CONSOL_SUMMARY
via Oracle Community by 27091988, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT VAC.NAME vname, meaning status FROM XX_VACANCY_VIEW VAC, xx_fnd_lookups ST WHERE VAC.STATUS=ST.LOOKUP_CODE AND VAC.NAME like :1 AND MEANING like :2
via Oracle Community by Myvizhi Selvi, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select f.user_name , f.description , a.currency_code, a.amount_to , a.amount_from from seacds.ar_approval_user_limits_nv a , seacds.fnd_user_nv
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT hou.organization_id,hou.name org_name,hou.cost_allocation_keyflex_id cost_allocation_keyflex_id FROM hr_organization_units hou where cost_allocation_keyflex_id = (SELECT distinct pcak.cost_allocation_keyflex_id FROM pay_cost_allocation_keyflex pcak WHERE pcak.segment2=:1)
at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
14 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.