oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT score (1) AS score, doc.document_id, doc.file_name, doc.last_update_date, ppf.email_address, addr.derived_locale, addr.address_id, ppf.full_name, inp.notification_preference_id, ppf.person_id, ppf.effective_start_date, ppf.effective_end_date, ROWNUM AS rownumber, pov.vendor_id, pov.vendor_name, inp.creation_date, NULL AS selectflag, (SELECT meaning FROM hr_lookups WHERE lookup_code = ircreferralinfoeo.source_type AND lookup_type = 'REC_TYPE') AS sourcetype, DECODE (ircreferralinfoeo.source_type, 'ER', (SELECT full_name FROM per_all_people_f ppf3 WHERE ppf3.person_id = ircreferralinfoeo.source_person_id AND SYSDATE BETWEEN ppf3.effective_start_date AND ppf3.effective_end_date), ircreferralinfoeo.source_name ) AS sourcename FROM irc_notification_preferences inp, irc_documents doc, per_addresses addr, per_all_people_f ppf, po_vendors pov, irc_referral_info ircreferralinfoeo WHERE trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date AND doc.person_id = inp.person_id AND inp.person_id = addr.person_id(+) AND NVL (inp.address_id, DECODE (addr.address_type(+), 'REC', addr.address_id(+), -1)) = addr.address_id(+) AND trunc(sysdate) BETWEEN addr.date_from(+) AND NVL (addr.date_to(+), sysdate) AND doc.person_id = ppf.person_id AND doc.TYPE IN ('RESUME', 'AUTO_RESUME') AND doc.end_date IS NULL AND EXISTS (SELECT NULL FROM per_people_f ppfs WHERE ppfs.person_id = doc.person_id) AND contains (doc.character_doc,:1,1) >0 AND ( (inp.agency_id = fnd_profile.VALUE ('IRC_AGENCY_NAME')) OR ( fnd_profile.VALUE ('IRC_AGENCY_NAME') IS NULL AND inp.allow_access = 'Y' ) ) AND inp.agency_id = pov.vendor_id(+) AND ppf.party_id = ircreferralinfoeo.object_id(+) AND SYSDATE BETWEEN ircreferralinfoeo.start_date(+) AND ircreferralinfoeo.end_date(+) ORDER BY score (1) DESC

Oracle Community | 877023 | 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 pass parameters to view object having oracletext keyword contains

    Oracle Community | 6 years ago | 877023
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT score (1) AS score, doc.document_id, doc.file_name, doc.last_update_date, ppf.email_address, addr.derived_locale, addr.address_id, ppf.full_name, inp.notification_preference_id, ppf.person_id, ppf.effective_start_date, ppf.effective_end_date, ROWNUM AS rownumber, pov.vendor_id, pov.vendor_name, inp.creation_date, NULL AS selectflag, (SELECT meaning FROM hr_lookups WHERE lookup_code = ircreferralinfoeo.source_type AND lookup_type = 'REC_TYPE') AS sourcetype, DECODE (ircreferralinfoeo.source_type, 'ER', (SELECT full_name FROM per_all_people_f ppf3 WHERE ppf3.person_id = ircreferralinfoeo.source_person_id AND SYSDATE BETWEEN ppf3.effective_start_date AND ppf3.effective_end_date), ircreferralinfoeo.source_name ) AS sourcename FROM irc_notification_preferences inp, irc_documents doc, per_addresses addr, per_all_people_f ppf, po_vendors pov, irc_referral_info ircreferralinfoeo WHERE trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date AND doc.person_id = inp.person_id AND inp.person_id = addr.person_id(+) AND NVL (inp.address_id, DECODE (addr.address_type(+), 'REC', addr.address_id(+), -1)) = addr.address_id(+) AND trunc(sysdate) BETWEEN addr.date_from(+) AND NVL (addr.date_to(+), sysdate) AND doc.person_id = ppf.person_id AND doc.TYPE IN ('RESUME', 'AUTO_RESUME') AND doc.end_date IS NULL AND EXISTS (SELECT NULL FROM per_people_f ppfs WHERE ppfs.person_id = doc.person_id) AND contains (doc.character_doc,:1,1) >0 AND ( (inp.agency_id = fnd_profile.VALUE ('IRC_AGENCY_NAME')) OR ( fnd_profile.VALUE ('IRC_AGENCY_NAME') IS NULL AND inp.allow_access = 'Y' ) ) AND inp.agency_id = pov.vendor_id(+) AND ppf.party_id = ircreferralinfoeo.object_id(+) AND SYSDATE BETWEEN ircreferralinfoeo.start_date(+) AND ircreferralinfoeo.end_date(+) ORDER BY score (1) DESC
  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 score (1) AS score, doc.document_id, doc.file_name, doc.last_update_date, ppf.email_address, addr.derived_locale, addr.address_id, ppf.full_name, inp.notification_preference_id, ppf.person_id, ppf.effective_start_date, ppf.effective_end_date, ROWNUM AS rownumber, pov.vendor_id, pov.vendor_name, inp.creation_date, NULL AS selectflag, (SELECT meaning FROM hr_lookups WHERE lookup_code = ircreferralinfoeo.source_type AND lookup_type = 'REC_TYPE') AS sourcetype, DECODE (ircreferralinfoeo.source_type, 'ER', (SELECT full_name FROM per_all_people_f ppf3 WHERE ppf3.person_id = ircreferralinfoeo.source_person_id AND SYSDATE BETWEEN ppf3.effective_start_date AND ppf3.effective_end_date), ircreferralinfoeo.source_name ) AS sourcename FROM irc_notification_preferences inp, irc_documents doc, per_addresses addr, per_all_people_f ppf, po_vendors pov, irc_referral_info ircreferralinfoeo WHERE trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date AND doc.person_id = inp.person_id AND inp.person_id = addr.person_id(+) AND NVL (inp.address_id, DECODE (addr.address_type(+), 'REC', addr.address_id(+), -1)) = addr.address_id(+) AND trunc(sysdate) BETWEEN addr.date_from(+) AND NVL (addr.date_to(+), sysdate) AND doc.person_id = ppf.person_id AND doc.TYPE IN ('RESUME', 'AUTO_RESUME') AND doc.end_date IS NULL AND EXISTS (SELECT NULL FROM per_people_f ppfs WHERE ppfs.person_id = doc.person_id) AND contains (doc.character_doc,:1,1) >0 AND ( (inp.agency_id = fnd_profile.VALUE ('IRC_AGENCY_NAME')) OR ( fnd_profile.VALUE ('IRC_AGENCY_NAME') IS NULL AND inp.allow_access = 'Y' ) ) AND inp.agency_id = pov.vendor_id(+) AND ppf.party_id = ircreferralinfoeo.object_id(+) AND SYSDATE BETWEEN ircreferralinfoeo.start_date(+) AND ircreferralinfoeo.end_date(+) ORDER BY score (1) DESC

      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