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 | 5 years ago
  1. 0

    How to pass parameters to view object having oracletext keyword contains

    Oracle Community | 5 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 | 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 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