oracle.apps.fnd.framework.OAException: 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)

Oracle Community | 784264 | 6 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

    how to add where clause in LOV..?

    Oracle Community | 6 years ago | 784264
    oracle.apps.fnd.framework.OAException: 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)
  2. 0

    Getting Error when setting the default value in LOV

    Oracle Community | 1 year ago | 2973180
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select oos.name, oos.description, mcv.segment3 "DefaultSourceFlag" from oe_order_sources oos , mtl_categories_v mcv , fnd_responsibility_tl frt WHERE (mcv.structure_name LIKE 'XXG_ORM_ORD_SOURCE_RESTRICT') AND mcv.segment2 = to_char(frt.RESPONSIBILITY_ID) AND mcv.ENABLED_FLAG = 'Y' AND mcv.segment1 = oos.name And frt.responsibility_name = :1
  3. 0

    Export data from advancedTable of Query Bean

    Oracle Community | 10 years ago | 574833
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Export from Advanced Table

    Oracle Community | 10 years ago | 574833
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select null node_id ,null version_id ,null status_name ,rs.SALESREP_ID ,rse.source_name ,rse.source_email SRP_EMAIL_ID ,rse.source_number SRP_EMPLOYEE_NUMBER ,comp.name ,comp.comp_plan_id ,Xxg2cGoalSheetHeaderEO.srp_goal_header_id ,XL.MEANING ,Xxg2cGoalSheetHeaderEO.status_code ,Xxg2cGoalSheetHeaderEO.start_date GS_START_DATE ,Xxg2cGoalSheetHeaderEO.end_date GS_END_DATE ,Xxg2cGoalSheetHeaderEO.PERIOD_YEAR ,Xxg2cGoalSheetHeaderEO.LAST_UPDATED_BY ,Xxg2cGoalSheetHeaderEO.LAST_UPDATE_DATE ,Xxg2cGoalSheetHeaderEO.LAST_UPDATE_LOGIN ,DECODE(Xxg2cGoalSheetHeaderEO.PERIOD_YEAR,(SELECT PERIOD_YEAR FROM GL_PERIODS WHERE PERIOD_SET_NAME = 'Fiscal Year' AND trunc(SYSDATE) BETWEEN START_DATE AND END_DATE),DECODE(Xxg2cGoalSheetHeaderEO.STATUS_CODE,'AUTH','copy_enabled','copy_disabled'),'copy_disabled') COPY_FLAG ,DECODE(Xxg2cGoalSheetHeaderEO.SRP_GOAL_HEADER_ID,null,'create_enabled',DECODE(Xxg2cGoalSheetHeaderEO.status_code,'AUTH','create_enabled','create_disabled')) CREATE_FLAG ,'N' CHECKED from xxg2c_srp_goal_headers_all Xxg2cGoalSheetHeaderEO ,cn_comp_plans_all comp ,jtf_rs_salesreps rs ,jtf_rs_resource_extns rse ,xxg2c_lookups xl where rs.resource_id = rse.resource_id and Xxg2cGoalSheetHeaderEO.STATUS_CODE = XL.LOOKUP_CODE and XL.LOOKUP_TYPE ='XXG2CG_GS_STATUS' and rs.salesrep_id = Xxg2cGoalSheetHeaderEO.salesrep_id and Xxg2cGoalSheetHeaderEO.comp_plan_id = comp.comp_plan_id and Xxg2cGoalSheetHeaderEO.org_id = comp.org_id and Xxg2cGoalSheetHeaderEO.status_code != 'DEL' and Xxg2cGoalSheetHeaderEO.org_id =:1 AND PERIOD_YEAR = :2
  6. 0

    urgent urgent: date in a view

    Oracle Community | 9 years ago | 607060
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: java.sql.Timestamp

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

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      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.OAPageErrorHandler.processErrors(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7 frames