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
  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 | 9 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 | 9 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