oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT MAKE,YEAR FROM XXXXX_ICUST_ABC_YMM_LOV1 WHERE YEAR=: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 452203, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT MAKE,YEAR FROM XXXXX_ICUST_ABC_YMM_LOV1 WHERE YEAR=:1
via Oracle Community by user11258661, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT ship_uid, concat(concat(ship_uid,', '),ship_name) AS ship_name FROM APPS.XXFC_ASO_CNC_SHIPMENT_STAG WHERE quote_header_id =:1 ORDER BY ship_uid
via Oracle Community by sreese, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct meaning , attribute4 from splwms.so_lookups where lookup_type = 'SHIPMENT_PRIORITY' and enabled_flag = 'Y' and attribute4 = :Carrier order by meaning
via Oracle Community by sreese, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct cont_cd account, cont_cd||' - '||customer acct_desc from spldat.spl_account_map where cont_cd not in (select acct_number from spldat.spl_disposition_accts where disp_code = :1) order by 1
via Oracle Community by 818948, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT GANTT_VIEW_ID ,NAME FROM PA_GANTT_VIEWS_VL where ENABLE_FLAG ='Y' and GANTT_VIEW_USAGE = ?
via Oracle Community by Jenny_Gomez, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct to_char(paydate,'Month RRRR') PaySlip_of_month ,to_char(paydate,'DD-MON-RRRR') Payroll_date,payyear,paymonth from apps.XX_TEST_VIEW where person_id=:1 order by payyear desc,paymonth desc
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT MAKE,YEAR FROM XXXXX_ICUST_ABC_YMM_LOV1 WHERE YEAR=:1
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1064)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2651)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2459)

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

Write tip

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