oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT EXA.SEGMENT5 ACCOUNT_NAME , EXA.SEGMENT4 ACCOUNT_NUMBER , EXA.SEGMENT3 SORT_CODE , HL.MEANING BANK_NAME , EXA.SEGMENT2 BRANCH , EXA.EXTERNAL_ACCOUNT_ID , EXA.OBJECT_VERSION_NUMBER , EXA.SEGMENT7 BUILDING_SOCIETY_ACCT FROM PAY_EXTERNAL_ACCOUNTS EXA , HR_LOOKUPS HL WHERE EXA.EXTERNAL_ACCOUNT_ID = :1 AND HL.LOOKUP_CODE = EXA.SEGMENT1 AND HL.LOOKUP_TYPE = 'HD_BANKS'

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 936194, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT EXA.SEGMENT5 ACCOUNT_NAME , EXA.SEGMENT4 ACCOUNT_NUMBER , EXA.SEGMENT3 SORT_CODE , HL.MEANING BANK_NAME , EXA.SEGMENT2 BRANCH
via freelists.org by Unknown author, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select effective_date||' - '|| pay_us_employee_payslip_web.get_meaning_payslip_label(:1||'', 'JOB')||' '|| action_information14
via Oracle Community by 541048, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT full_name, email_address,employee_num, to_char(employee_id), organization_name, business_group_name, hr_general.get_work_phone
via Oracle Community by 781391, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: ??????? SQL ?????: select column1, column2 from table t where t.id = :1 and t.name = :2
via Oracle Community by 781391, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: ??????? SQL ?????: select column1, column2 from table t where t.id = :1 and t.name = :2
via Oracle Community by 52382, 4 months ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT NtfEO.NOTIFICATION_ID, NtfEO.RECIPIENT_ROLE, NtfEO.BEGIN_DATE AS BEGIN_DATE_F, NtfEO.DUE_DATE AS DUE_DATE_F, DECODE(NtfEO.MORE_INFO_ROLE, NULL
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT EXA.SEGMENT5 ACCOUNT_NAME , EXA.SEGMENT4 ACCOUNT_NUMBER , EXA.SEGMENT3 SORT_CODE , HL.MEANING BANK_NAME , EXA.SEGMENT2 BRANCH , EXA.EXTERNAL_ACCOUNT_ID , EXA.OBJECT_VERSION_NUMBER , EXA.SEGMENT7 BUILDING_SOCIETY_ACCT FROM PAY_EXTERNAL_ACCOUNTS EXA , HR_LOOKUPS HL WHERE EXA.EXTERNAL_ACCOUNT_ID = :1 AND HL.LOOKUP_CODE = EXA.SEGMENT1 AND HL.LOOKUP_TYPE = 'HD_BANKS'
at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years 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
9 more bugmates

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