oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT VAC.NAME vname, meaning status FROM XX_VACANCY_VIEW VAC, xx_fnd_lookups ST WHERE VAC.STATUS=ST.LOOKUP_CODE AND VAC.NAME like :1 AND MEANING like :2

Oracle Community | 27091988 | 6 years ago
  1. 0

    Search based on a shuttle

    Oracle Community | 6 years ago | 27091988
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT VAC.NAME vname, meaning status FROM XX_VACANCY_VIEW VAC, xx_fnd_lookups ST WHERE VAC.STATUS=ST.LOOKUP_CODE AND VAC.NAME like :1 AND MEANING like :2
  2. 0

    Daniel Borgstrom talking about Oracle: Fix for java.sql.SQLException: Invalid column type when extending a VO

    blogspot.com | 3 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.   Statement: SELECT * FROM (SELECT ca.location LocId, ca.party_site_number LocNumber, ca.party_name PartyName, ca.party_number PartyNumber, ca.address1 Address1, ca.address2 Address2, ca.address3 Address3, ca.address4 Address4, ca.city City, ca.state State, ca.zip PostalCode, ca.country Country, ca.party_id partyId, hzp.site_use_type CurrSiteUsage FROM csi_hzpty_addresses_v ca, hz_party_site_uses hzp, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu WHERE ca.party_id = :1 AND ca.location = hzp.party_site_id(+) AND site_use_type(+) = 'INSTALL_AT' AND ca.status = 'A' AND SYSDATE BETWEEN NVL(ca.start_date_active, SYSDATE) AND NVL(ca.end_date_active, SYSDATE) AND hzp.status(+) = 'A' AND ca.location = hcas.party_site_id AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id AND hcsu.status = 'A' AND hcsu.site_use_code = 'SHIP_TO' AND hcas.org_id = nvl(FND_PROFILE.VALUE('ORG_ID'), hcas.org_id) AND hcsu.org_id = nvl(FND_PROFILE.VALUE('ORG_ID'), hcsu.org_id)) QRSLT WHERE (( UPPER(ADDRESS1) like UPPER(:2) AND (ADDRESS1 like :3 OR ADDRESS1 like :4 OR ADDRESS1 like :5 OR  ADDRESS1 like :6)))
  3. 0

    How to Replace the View Object with the New View Object

    Oracle Community | 6 years ago | 802240
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PORTFOLIO_CODE PortfolioCode , PORTFOLIO_NAME PortfolioName , PORTFOLIO_DESCRIPTION PortfolioDescription , ATTRIBUTE1 Attribute1 , ATTRIBUTE2 Attribute2 , ATTRIBUTE3 Attribute3 FROM XXOTL_XX_XX_PORTFOLIOV_V
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    How to sort based on date

    Oracle Community | 6 years ago | 807913
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Vac.VACANCY_ID, Vac.DATE_FROM, Vac.NAME, Vac.DATE_TO, Vac.DESCRIPTION, Vac.NUMBER_OF_OPENINGS, Vac.LAST_UPDATE_DATE, Vac.CREATION_DATE, Job.NAME AS JobName, Job.JOB_ID, Grade.NAME AS GradeName, Grade.GRADE_ID, Org.NAME AS OrgName, Org.ORGANIZATION_ID, Loc.LOCATION_CODE, Loc.LOCATION_ID, Recruiter.FULL_NAME AS RECRUITER_NAME, Recruiter.PERSON_ID AS RECRUITER_ID, Recruiter.EFFECTIVE_START_DATE, Recruiter.EFFECTIVE_END_DATE, Recruiter.EMAIL_ADDRESS, Manager.FULL_NAME AS MANAGER_NAME, Manager.PERSON_ID AS MANAGER_ID, Manager.EFFECTIVE_START_DATE AS MAN_EFFECTIVE_START_DATE, Manager.EFFECTIVE_END_DATE AS MAN_EFFECTIVE_END_DATE, Manager.EMAIL_ADDRESS AS EMAIL_ADDRESS1, Status.MEANING, Status.LOOKUP_TYPE, Status.LOOKUP_CODE, Vac.REQUISITION_ID, (select count(assignment_type) from per_all_assignments_f paaf where paaf.vacancy_id = Vac.vacancy_id and paaf.assignment_type = 'A' and :1 between PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE AND NOT EXISTS (SELECT NULL FROM per_all_assignments_f paf3 WHERE paf3.vacancy_id = paaf.vacancy_id AND paf3.person_id = paaf.person_id AND paf3.assignment_type ='E' ) and exists ( select null from per_all_assignments_f paf4 where paf4.assignment_id = paaf.assignment_id and paf4.effective_end_date = to_date('31/12/4712','DD/MM/RRRR') and paf4.assignment_type = 'A' ) and (fnd_profile.value('IRC_AGENCY_NAME') is null or exists (select 1 from irc_agency_vacancies iav1 ,per_all_people_f per1 ,irc_notification_preferences inp1 where iav1.vacancy_id=vac.vacancy_id and iav1.agency_id=fnd_profile.value('IRC_AGENCY_NAME') and per1.person_id=paaf.person_id and per1.party_id=inp1.party_id and (inp1.agency_id=iav1.agency_id or iav1.manage_applicants_allowed='Y')) ) ) AS APPLICANTS, (select count(distinct assignment_id) from per_all_assignments_f paaf where paaf.vacancy_id = Vac.vacancy_id and assignment_type = 'E' ) AS FILLED, decode(vac.manager_id,:2,'Y','N') AS MY_VACANCIES, Vac.BUDGET_MEASUREMENT_TYPE, Vac.BUDGET_MEASUREMENT_VALUE, posEO.NAME AS NAME1, posEO.POSITION_ID, posEO.EFFECTIVE_START_DATE AS EFFECTIVE_START_DATE2, posEO.EFFECTIVE_END_DATE AS EFFECTIVE_END_DATE2, NULL AS ACCESS_FLAGS, Vac.STATUS AS VACANCY_STATUS, Bg.NAME AS NAME2, Bg.ORGANIZATION_ID AS ORGANIZATION_ID1, Vac.BUSINESS_GROUP_ID, VSC.EMPLOYEE, VSC.CONTRACTOR, VSC.EMPLOYMENT_CATEGORY, VSC.TRAVEL_PERCENTAGE, VSC.MIN_SALARY, VSC.MAX_SALARY, VSC.SALARY_CURRENCY, VSC.PROFESSIONAL_AREA, VSC.WORK_AT_HOME, VSC.MIN_QUAL_LEVEL, VSC.MAX_QUAL_LEVEL, VSC.ATTRIBUTE_CATEGORY, VSC.ATTRIBUTE1, VSC.ATTRIBUTE2, VSC.ATTRIBUTE3, VSC.ATTRIBUTE4, VSC.ATTRIBUTE5, VSC.ATTRIBUTE6, VSC.ATTRIBUTE7, VSC.ATTRIBUTE8, VSC.ATTRIBUTE9, VSC.ATTRIBUTE10, VSC.ATTRIBUTE11, VSC.ATTRIBUTE12, VSC.ATTRIBUTE13, VSC.ATTRIBUTE14, VSC.ATTRIBUTE15, VSC.ATTRIBUTE16, VSC.ATTRIBUTE17, VSC.ATTRIBUTE18, VSC.ATTRIBUTE19, VSC.ATTRIBUTE20, VSC.ATTRIBUTE21, VSC.ATTRIBUTE22, VSC.ATTRIBUTE23, VSC.ATTRIBUTE24, VSC.ATTRIBUTE25, VSC.ATTRIBUTE26, VSC.ATTRIBUTE27, VSC.ATTRIBUTE28, VSC.ATTRIBUTE29, VSC.ATTRIBUTE30, VSC.SEARCH_CRITERIA_ID, Vac.ATTRIBUTE_CATEGORY AS VAC_ATTRIBUTE_CATEGORY, Vac.ATTRIBUTE1 AS VAC_ATTRIBUTE1, Vac.ATTRIBUTE2 AS VAC_ATTRIBUTE2, Vac.ATTRIBUTE3 AS VAC_ATTRIBUTE3, Vac.ATTRIBUTE4 AS VAC_ATTRIBUTE4, Vac.ATTRIBUTE5 AS VAC_ATTRIBUTE5, Vac.ATTRIBUTE6 AS VAC_ATTRIBUTE6, Vac.ATTRIBUTE7 AS VAC_ATTRIBUTE7, Vac.ATTRIBUTE8 AS VAC_ATTRIBUTE8, Vac.ATTRIBUTE9 AS VAC_ATTRIBUTE9, Vac.ATTRIBUTE10 AS VAC_ATTRIBUTE10, Vac.ATTRIBUTE11 AS VAC_ATTRIBUTE11, Vac.ATTRIBUTE12 AS VAC_ATTRIBUTE12, Vac.ATTRIBUTE13 AS VAC_ATTRIBUTE13, Vac.ATTRIBUTE14 AS VAC_ATTRIBUTE14, Vac.ATTRIBUTE15 AS VAC_ATTRIBUTE15, Vac.ATTRIBUTE16 AS VAC_ATTRIBUTE16, Vac.ATTRIBUTE17 AS VAC_ATTRIBUTE17, Vac.ATTRIBUTE18 AS VAC_ATTRIBUTE18, Vac.ATTRIBUTE19 AS VAC_ATTRIBUTE19, Vac.ATTRIBUTE20 AS VAC_ATTRIBUTE20, decode((select update_allowed||delete_allowed from irc_rec_team_members rec where rec.vacancy_id = VAC.vacancy_id and rec.person_id = :3), 'NN', 'VIEW', 'UPDATE') AS TEAM_ACCESS, (select count(*) from hr_api_transactions where transaction_ref_table = 'PER_ALL_VACANCIES' and transaction_ref_id = Vac.vacancy_id and creator_person_id = :4 and status = 'S') AS SaveForLaterLocks, (select count(*) from hr_api_transactions where transaction_ref_table = 'PER_ALL_VACANCIES' and transaction_ref_id = Vac.vacancy_id and status != 'D' and (creator_person_id != :5 or transaction_state != null or status != 'S' )) AS TRANSACTION_LOCKS, (select decode((SELECT count(pav1.vacancy_id) FROM per_all_vacancies pav1 WHERE pav1.vacancy_id =vac.VACANCY_ID AND(pav1.status ='CLOSED' OR (pav1.date_to is not null and NOT :18 BETWEEN pav1.date_from AND pav1.date_to))),0,'Y','N') from dual) AS APPLY_FLAG, PSA.LOOKUP_TYPE AS LOOKUP_TYPE1, PSA.LOOKUP_TYPE AS LOOKUP_TYPE2, Grade.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER1, PSA.LOOKUP_CODE AS LOOKUP_CODE1, Loc.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER2, PSA.MEANING AS MEANING1, Recruiter.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER3, decode ((SELECT count(1) FROM PER_RECRUITMENT_ACTIVITIES PRA,PER_ALL_VACANCIES PAV, IRC_ALL_RECRUITING_SITES ias,PER_RECRUITMENT_ACTIVITY_FOR PRAE WHERE vac.vacancy_id=PRAE.vacancy_id AND pra.recruiting_site_id = ias.recruiting_site_id AND PRAE.RECRUITMENT_ACTIVITY_ID = PRA.RECRUITMENT_ACTIVITY_ID AND ias.EXTERNAL = 'R' AND sysdate BETWEEN pra.date_start AND NVL (pra.date_end, sysdate) ), 0,'N','Y') AS REFERRALS FROM PER_ALL_VACANCIES Vac, PER_JOBS_VL Job, PER_GRADES_VL Grade, HR_ALL_ORGANIZATION_UNITS_VL Org, HR_LOCATIONS_ALL_VL Loc, PER_ALL_PEOPLE_F Recruiter, PER_ALL_PEOPLE_F Manager, HR_LOOKUPS Status, HR_ALL_POSITIONS_F_VL posEO, HR_ALL_ORGANIZATION_UNITS_VL Bg, IRC_SEARCH_CRITERIA VSC, HR_LOOKUPS PSA WHERE VAC.vacancy_id = VSC.object_ID(+) AND VSC.object_type(+) = 'VACANCY' and Vac.Job_id = Job.JOB_ID(+) and Vac.Grade_id = Grade.GRADE_ID(+) and Vac.Organization_id = Org.ORGANIZATION_ID(+) and Vac.Location_id = Loc.LOCATION_ID(+) and Vac.Recruiter_id = Recruiter.PERSON_ID(+) and :6 between nvl(Recruiter.EFFECTIVE_START_DATE,:7) and nvl(Recruiter.EFFECTIVE_END_DATE, :8) and Vac.Manager_id = Manager.PERSON_ID(+) and :9 between nvl(Manager.EFFECTIVE_START_DATE,:10) and nvl(Manager.EFFECTIVE_END_DATE,:11) and Status.LOOKUP_TYPE(+) = 'VACANCY_STATUS' and Vac.Status = Status.LOOKUP_CODE(+) AND vac.position_id = posEO.position_id(+) AND :12 between nvl(posEO.EFFECTIVE_START_DATE, :13) AND nvl(posEO.EFFECTIVE_END_DATE, :14) AND VAC.business_group_id = BG.Organization_id and EXISTS (select null from PER_VACANCIES PV where PV.vacancy_id = VAC.vacancy_id) AND (exists (select null from irc_agency_vacancies iav where iav.agency_id = FND_PROFILE.VALUE('IRC_AGENCY_NAME') and iav.vacancy_id = vac.vacancy_id AND :15 between nvl(START_DATE,:16) AND nvl(END_DATE, :17)) or FND_PROFILE.VALUE('IRC_AGENCY_NAME') is null) AND PSA.LOOKUP_TYPE(+) = 'IRC_PROFESSIONAL_AREA' AND VSC.PROFESSIONAL_AREA = PSA.LOOKUP_CODE(+) AND (1=1where CreationDate between to_date(StartD,'dd-mon-rr') AND to_date(EndD,'dd-mon-rr') AND ( UPPER(Vac.NAME) like UPPER(:19) AND (Vac.NAME like :20 OR Vac.NAME like :21 OR Vac.NAME like :22 OR Vac.NAME like :23))) ORDER BY Vac.NAME
  6. 0

    Null pointer exception

    Oracle Community | 6 years ago | 828271
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    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 VAC.NAME vname, meaning status FROM XX_VACANCY_VIEW VAC, xx_fnd_lookups ST WHERE VAC.STATUS=ST.LOOKUP_CODE AND VAC.NAME like :1 AND MEANING like :2

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2867)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1840)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)
      7 frames