oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT orc.action_code action_code, fl.meaning action_name FROM okc_rep_con_actions orc, fnd_lookups fl WHERE orc.status_code = :1 AND fl.lookup_code = orc.action_code AND fl.lookup_type = 'OKC_REP_CON_ACTIONS' AND (:2 is null OR orc.action_code <> :3) AND (:4 is null OR orc.action_code <> :5) AND nvl(disabled_flag, 'N') = 'N' AND ((OKC_REP_UTIL_PVT.has_contract_access(:6, 'OKC_REP_AU_UPDATE') = 'T' AND orc.page_mode = 'UPDATE') OR (OKC_REP_UTIL_PVT.has_contract_access(:7, 'OKC_REP_AU_SELECT') = 'T' AND orc.page_mode = 'VIEW')) AND (:8 is null OR orc.action_code <> :9)

Oracle Community | User544872 | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Running seeded OAF page in JDeveloper

    Oracle Community | 3 years ago | User544872
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT orc.action_code action_code, fl.meaning action_name FROM okc_rep_con_actions orc, fnd_lookups fl WHERE orc.status_code = :1 AND fl.lookup_code = orc.action_code AND fl.lookup_type = 'OKC_REP_CON_ACTIONS' AND (:2 is null OR orc.action_code <> :3) AND (:4 is null OR orc.action_code <> :5) AND nvl(disabled_flag, 'N') = 'N' AND ((OKC_REP_UTIL_PVT.has_contract_access(:6, 'OKC_REP_AU_UPDATE') = 'T' AND orc.page_mode = 'UPDATE') OR (OKC_REP_UTIL_PVT.has_contract_access(:7, 'OKC_REP_AU_SELECT') = 'T' AND orc.page_mode = 'VIEW')) AND (:8 is null OR orc.action_code <> :9)
  2. 0

    java.lang.ArrayIndexOutOfBoundsException

    Oracle Community | 2 years ago | Afaf Aboutabit
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 2
  3. 0

    attachmentTable item type and null pointer exception....

    Oracle Community | 1 year ago | 3152164
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JBO-25005: Object name&#160; for type View Object is invalid

    Oracle Community | 3 years ago | abhishek1981
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidObjNameException: JBO-25005: Object name for type View Object is invalid
  6. 0

    Absence Management OAF Form Personalization

    Oracle Community | 3 years ago | Ravi91349
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select ppf.list_name full_name, hr_person_type_usage_info.get_user_person_type(ppf.effective_end_date, ppf.person_id) person_type, Decode(paf.assignment_type, 'C', hr_general.decode_lookup('CWK_ASG_CATEGORY', paf.employment_category), hr_general.decode_lookup('EMP_CAT', paf.employment_category) )employment_category, ppf.start_date, ppf.original_date_of_hire, decode(paf.period_of_service_id, null, pop.date_start, pos.date_start) date_start, decode(paf.period_of_service_id, null, pop.actual_termination_date, pos.actual_termination_date) actual_termination_date, Decode(paf.assignment_type, 'C', hr_general.decode_lookup('HR_CWK_TERMINATION_REASONS', pop.termination_reason), hr_general.decode_lookup('LEAV_REAS', pos.leaving_reason) ) leaving_reason, paf.effective_start_date, hr_util_misc_ss.getObjectName('JOB', paf.job_id, ppf.business_group_id, jtl.name) job, paf.job_id, orgtl.name organization, orgtl.organization_id, bgtl.name business_group, bgtl.organization_id business_group_id, lvl.location_code, hr_util_misc_ss.getObjectName('GRADE', paf.grade_id, ppf.business_group_id, gtl.name) grade, paf.supervisor_id, ppf.person_id, paf.assignment_id, paf.primary_flag, paf.assignment_number, ppf.employee_number, ppf.npw_number cwk_number, nvl(paf.effective_start_date, ppf.effective_start_date) Asg_start_date, decode(nvl(paf.effective_end_date, ppf.effective_end_date), to_date('31/12/4712','DD/MM/RRRR'), null, nvl(paf.effective_end_date, ppf.effective_end_date) ) Asg_end_date, hr_general.decode_lookup('YES_NO', paf.primary_flag) Prim_Flag, lvl.derived_locale, v.vendor_name Supplier, paf.VENDOR_ASSIGNMENT_NUMBER Supplier_id_assignment, paf.VENDOR_EMPLOYEE_NUMBER Supplier_id_worker, Decode(paf.assignment_type, 'C', hr_general.decode_lookup('HR_CWK_TERMINATION_REASONS', pop.termination_reason), hr_general.decode_lookup('LEAV_REAS', pos.leaving_reason) )term_reason, decode(ppf.rehire_recommendation, 'N', null, hr_general.decode_lookup('YES_NO', ppf.rehire_recommendation)) rehire, ast.user_status assignment_status, decode(paf.period_of_service_id, null, pop.date_start, pos.date_start) latest_hire_date, hr_util_misc_ss.getObjectName('POSITION', paf.position_id, ppf.business_group_id, ptl.name) position, ppf.REHIRE_REASON, paf.supervisor_assignment_id, null Work_Phone, null Position_Id, null Disc_Title, 'Y' Manager_Enabled, null Payroll, null Normal_Hours, 'Y1' details_enabled, ppf.email_address, org_info.org_information9 LegislationCode from per_assignments_f2 paf, per_assignment_status_types_tl ast, per_people_f ppf, hr_all_organization_units_tl orgtl, hr_all_organization_units_tl bgtl, per_jobs_tl jtl, hr_all_positions_f_tl ptl, hr_locations_all lvl, po_vendors v, per_grades_tl gtl, per_periods_of_service pos, per_periods_of_placement pop, hr_organization_information org_info where trunc(sysdate) between paf.effective_start_date and paf.effective_end_date and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date and (ppf.current_employee_flag = 'Y' or ppf.current_npw_flag = 'Y') and paf.primary_flag = decode(:0 ,'Y', paf.primary_flag, 'Y') and paf.assignment_type in ('E','C') and paf.person_id = ppf.person_id and paf.vendor_id = v.vendor_id(+) and paf.assignment_status_type_id = ast.assignment_status_type_id and ast.language = userenv('LANG') and paf.period_of_service_id = pos.period_of_service_id(+) and paf.period_of_placement_date_start = pop.date_start(+) and paf.person_id = pop.person_id(+) and paf.job_id = jtl.job_id(+) and jtl.language(+) = userenv('LANG') and paf.position_id = ptl.position_id(+) and ptl.language(+) = userenv('LANG') and paf.organization_id = orgtl.organization_id and orgtl.language = userenv('LANG') and ppf.business_group_id = bgtl.organization_id and bgtl.language = userenv('LANG') and paf.location_id = lvl.location_id(+) and paf.grade_id = gtl.grade_id(+) and gtl.language(+) = userenv('LANG') and org_info.organization_id = ppf.business_group_id and org_information_context = 'Business Group Information') QRSLT WHERE (:1 = SUPERVISOR_ID)AND (:2 = SUPERVISOR_ASSIGNMENT_ID or hr_general2.supervisor_assignments_in_use = 'FALSE' ) ORDER BY FULL_NAME

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.apps.fnd.framework.OAException

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT orc.action_code action_code, fl.meaning action_name FROM okc_rep_con_actions orc, fnd_lookups fl WHERE orc.status_code = :1 AND fl.lookup_code = orc.action_code AND fl.lookup_type = 'OKC_REP_CON_ACTIONS' AND (:2 is null OR orc.action_code <> :3) AND (:4 is null OR orc.action_code <> :5) AND nvl(disabled_flag, 'N') = 'N' AND ((OKC_REP_UTIL_PVT.has_contract_access(:6, 'OKC_REP_AU_UPDATE') = 'T' AND orc.page_mode = 'UPDATE') OR (OKC_REP_UTIL_PVT.has_contract_access(:7, 'OKC_REP_AU_SELECT') = 'T' AND orc.page_mode = 'VIEW')) AND (:8 is null OR orc.action_code <> :9)

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)
      4 frames
    3. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:87)
      1 frame
    4. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    5. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    7. com.evermind.server
      HttpRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
      6. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
      7. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
      7 frames
    8. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    9. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    10. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame