oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /*+ FIRST_ROWS */ NULL AS SelectFlag, PPF.FULL_NAME AS PERSON_NAME, ADDR.DERIVED_LOCALE, ADDR.ADDRESS_ID, PHN.PHONE_NUMBER, PHN.PHONE_ID, PPF.DATE_OF_BIRTH, PPF.EMAIL_ADDRESS, ADDR.ADDRESS_LINE1, to_number( decode ( :1 , 1, IRC_SKILLS_MATCHING_PKG.vacancy_match_percent( ppf.person_id, :2 , :3 ), 2, IRC_SKILLS_MATCHING_PKG.skills_match_percent( :4 , :5 , :6 , :7 , :8 , :9 , ppf.person_id),-1) ) AS Match_Percent, decode(irc_utilities_pkg.is_open_party(PPF.PARTY_ID,:10),'TRUE',(select count(*) from PER_ALL_ASSIGNMENTS_F PAF2 , PER_ALL_PEOPLE_F PPF2 where PPF.PARTY_ID = PPF2.PARTY_ID and :11 between PPF2.EFFECTIVE_START_DATE and PPF2.EFFECTIVE_END_DATE and PAF2.ASSIGNMENT_TYPE = 'A' and :12 between PAF2.effective_start_date and PAF2.effective_end_date and PAF2.person_id = PPF2.person_id having count(*)>0),null) AS Jobs_Applied_For, decode(irc_utilities_pkg.is_open_party(PPF.PARTY_ID,:13),'TRUE',(select MAX(PAF.effective_start_date) from PER_ALL_ASSIGNMENTS_F PAF, PER_ALL_PEOPLE_F PPF2 where PPF.PARTY_ID = PPF2.PARTY_ID AND :14 between PPF2.EFFECTIVE_START_DATE AND PPF2.EFFECTIVE_END_DATE AND PAF.ASSIGNMENT_TYPE = 'A' and :15 >= PAF.effective_start_date AND PAF.person_id = PPF2.person_id),null) AS Last_Application, VCN.CONSIDERATION_STATUS, VCN.PERSON_ID AS CONSIDERATION_PERSON_ID, VCN.VACANCY_ID AS CONSIDERATION_VACANCY_ID, to_number(:16) AS VACANCY_ID, (select meaning from HR_LOOKUPS LKP where LKP.LOOKUP_TYPE = 'IRC_CONSIDERATION' AND LKP.LOOKUP_CODE = VCN.consideration_status) AS CONSIDERATION, VCN.CONSIDERATION_STATUS AS CONSIDERATION_STATUS_DISPLAY, PPF.FIRST_NAME AS PERSON_FIRST_NAME, PPF.LAST_NAME AS PERSON_LAST_NAME, DOC.DOCUMENT_ID, DOC.FILE_NAME, NVL2( DOC.DOCUMENT_ID,'Y','N') AS PreviewEnabled, VCN.VACANCY_CONSIDERATION_ID, INP.NOTIFICATION_PREFERENCE_ID, PPF.PERSON_ID, PPF.EFFECTIVE_START_DATE, PPF.EFFECTIVE_END_DATE, PPF.ATTRIBUTE1 AS PPFATTRIBUTE1, PPF.ATTRIBUTE2 AS PPFATTRIBUTE2, PPF.ATTRIBUTE3 AS PPFATTRIBUTE3, PPF.ATTRIBUTE4 AS PPFATTRIBUTE4, PPF.ATTRIBUTE5 AS PPFATTRIBUTE5, PPF.ATTRIBUTE6 AS PPFATTRIBUTE6, PPF.ATTRIBUTE7 AS PPFATTRIBUTE7, PPF.ATTRIBUTE8 AS PPFATTRIBUTE8, PPF.ATTRIBUTE9 AS PPFATTRIBUTE9, PPF.ATTRIBUTE10 AS PPFATTRIBUTE10, PPF.ATTRIBUTE11 AS PPFATTRIBUTE11, PPF.ATTRIBUTE12 AS PPFATTRIBUTE12, PPF.ATTRIBUTE13 AS PPFATTRIBUTE13, PPF.ATTRIBUTE14 AS PPFATTRIBUTE14, PPF.ATTRIBUTE15 AS PPFATTRIBUTE15, PPF.ATTRIBUTE16 AS PPFATTRIBUTE16, PPF.ATTRIBUTE17 AS PPFATTRIBUTE17, PPF.ATTRIBUTE18 AS PPFATTRIBUTE18, PPF.ATTRIBUTE19 AS PPFATTRIBUTE19, PPF.ATTRIBUTE20 AS PPFATTRIBUTE20, PPF.ATTRIBUTE21 AS PPFATTRIBUTE21, PPF.ATTRIBUTE22 AS PPFATTRIBUTE22, PPF.ATTRIBUTE23 AS PPFATTRIBUTE23, PPF.ATTRIBUTE24 AS PPFATTRIBUTE24, PPF.ATTRIBUTE25 AS PPFATTRIBUTE25, PPF.ATTRIBUTE26 AS PPFATTRIBUTE26, PPF.ATTRIBUTE27 AS PPFATTRIBUTE27, PPF.ATTRIBUTE28 AS PPFATTRIBUTE28, PPF.ATTRIBUTE29 AS PPFATTRIBUTE29, PPF.ATTRIBUTE30 AS PPFATTRIBUTE30, PPF.ATTRIBUTE_CATEGORY AS PPFATTRIBUTE_CATEGORY, VCN.PERSON_ID AS PERSON_ID1, CSC.SEARCH_CRITERIA_ID, CSC.LOCATION, CSC.DISTANCE_TO_LOCATION, CSC.EMPLOYEE, CSC.CONTRACTOR, CSC.EMPLOYMENT_CATEGORY, CSC.KEYWORDS, CSC.TRAVEL_PERCENTAGE, CSC.MIN_SALARY, CSC.SALARY_CURRENCY, CSC.SALARY_PERIOD, CSC.MATCH_COMPETENCE, CSC.MATCH_QUALIFICATION, CSC.JOB_TITLE, CSC.DEPARTMENT, CSC.PROFESSIONAL_AREA, CSC.WORK_AT_HOME, CSC.ATTRIBUTE_CATEGORY, CSC.ATTRIBUTE1, CSC.ATTRIBUTE2, CSC.ATTRIBUTE3, CSC.ATTRIBUTE4, CSC.ATTRIBUTE5, CSC.ATTRIBUTE6, CSC.ATTRIBUTE7, CSC.ATTRIBUTE8, CSC.ATTRIBUTE9, CSC.ATTRIBUTE10, CSC.ATTRIBUTE11, CSC.ATTRIBUTE12, CSC.ATTRIBUTE13, CSC.ATTRIBUTE14, CSC.ATTRIBUTE15, CSC.ATTRIBUTE16, CSC.ATTRIBUTE17, CSC.ATTRIBUTE18, CSC.ATTRIBUTE19, CSC.ATTRIBUTE20, CSC.ATTRIBUTE21, CSC.ATTRIBUTE22, CSC.ATTRIBUTE23, CSC.ATTRIBUTE24, CSC.ATTRIBUTE25, CSC.ATTRIBUTE26, CSC.ATTRIBUTE27, CSC.ATTRIBUTE28, CSC.ATTRIBUTE29, CSC.ATTRIBUTE30, to_char(RowNum) AS RowNumber, PPF.PARTY_ID, POV.VENDOR_ID, POV.VENDOR_NAME, INP.CREATION_DATE, to_char(decode(:17,'Y',nvl2(ADDR.geometry,floor(irc_location_utility.sdo_miles(mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(:18,:19,null),null,null),ADDR.geometry,0.01)),''),'')) AS DISTANCE_TO_LOCATION_RESULTS, fnd_number.canonical_to_number(distance_to_location) AS DISTANCE_TO_LOCATION_INT, nvl2(ATMPT.MASTERY_SCORE,decode(greatest(ATMPT.MASTERY_SCORE,ATMPT.RAW_SCORE), ATMPT.RAW_SCORE, 'P', 'F'),nvl2(FND_PROFILE.VALUE('IRC_REGISTER_TEST'),nvl2(INP.ATTEMPT_ID, 'A','N'),null)) AS ATTEMPT_STATUS, to_number(decode(ATMPT.RAW_SCORE, -1000, null, ATMPT.RAW_SCORE)) AS ATTEMPT_SCORE, ATMPT.ATTEMPT_ID, decode(IrcReferralInfoEO.source_type,'ER','Y','N') AS Referred, IrcReferralInfoEO.START_DATE, IrcReferralInfoEO.OBJECT_ID, IrcReferralInfoEO.OBJECT_TYPE, IrcReferralInfoEO.END_DATE, (select meaning from hr_lookups where lookup_code = IRCREFERRALINFOEO.source_type and lookup_type = 'REC_TYPE') AS SourceType, decode (IrcReferralInfoEO.source_type, 'ER',(select distinct(full_name) from per_all_people_f where person_id = IrcReferralInfoEO.source_person_id), IrcReferralInfoEO.source_name ) AS SourceName FROM PER_ADDRESSES ADDR, PER_PHONES PHN, IRC_VACANCY_CONSIDERATIONS VCN, IRC_NOTIFICATION_PREFERENCES INP, IRC_DOCUMENTS DOC, PER_ALL_PEOPLE_F PPF, IRC_SEARCH_CRITERIA CSC, PO_VENDORS POV, OTA_ATTEMPTS ATMPT, IRC_REFERRAL_INFO IrcReferralInfoEO WHERE :20 BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE AND PPF.PERSON_ID = DOC.PERSON_ID(+) AND PPF.PERSON_ID = PHN.PARENT_ID(+) AND PHN.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F' AND PHN.phone_type(+) = 'H1' AND :21 between nvl(PHN.date_from,:22) and NVL(PHN.date_to,:23) AND PPF.PERSON_ID = VCN.PERSON_ID(+) AND VCN.VACANCY_ID(+) = :24 AND nvl(VCN.consideration_status,'X') <> 'NO' and PPF.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 :25 between ADDR.DATE_FROM(+) and nvl(ADDR.DATE_TO(+),:26) AND doc.type(+) like '%RESUME' AND doc.end_date(+) is null AND CSC.object_id = PPF.PERSON_ID AND CSC.object_type= 'WPREF' AND EXISTS (SELECT NULL FROM PER_PEOPLE_F PPFS WHERE PPFS.PERSON_ID = PPF.PERSON_ID) 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 INP.ATTEMPT_ID = ATMPT.ATTEMPT_ID(+) and ppf.party_id = IrcReferralInfoEO.object_id(+) and sysdate between IrcReferralInfoEO.start_date(+) and IrcReferralInfoEO.end_date(+) AND (PPF.ATTRIBUTE15 like :28) ORDER BY PPF.FULL_NAME ASC

Oracle Community | Renu Gupta | 5 years ago
  1. 0

    Add search parameter in oaf page

    Oracle Community | 5 years ago | Renu Gupta
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /*+ FIRST_ROWS */ NULL AS SelectFlag, PPF.FULL_NAME AS PERSON_NAME, ADDR.DERIVED_LOCALE, ADDR.ADDRESS_ID, PHN.PHONE_NUMBER, PHN.PHONE_ID, PPF.DATE_OF_BIRTH, PPF.EMAIL_ADDRESS, ADDR.ADDRESS_LINE1, to_number( decode ( :1 , 1, IRC_SKILLS_MATCHING_PKG.vacancy_match_percent( ppf.person_id, :2 , :3 ), 2, IRC_SKILLS_MATCHING_PKG.skills_match_percent( :4 , :5 , :6 , :7 , :8 , :9 , ppf.person_id),-1) ) AS Match_Percent, decode(irc_utilities_pkg.is_open_party(PPF.PARTY_ID,:10),'TRUE',(select count(*) from PER_ALL_ASSIGNMENTS_F PAF2 , PER_ALL_PEOPLE_F PPF2 where PPF.PARTY_ID = PPF2.PARTY_ID and :11 between PPF2.EFFECTIVE_START_DATE and PPF2.EFFECTIVE_END_DATE and PAF2.ASSIGNMENT_TYPE = 'A' and :12 between PAF2.effective_start_date and PAF2.effective_end_date and PAF2.person_id = PPF2.person_id having count(*)>0),null) AS Jobs_Applied_For, decode(irc_utilities_pkg.is_open_party(PPF.PARTY_ID,:13),'TRUE',(select MAX(PAF.effective_start_date) from PER_ALL_ASSIGNMENTS_F PAF, PER_ALL_PEOPLE_F PPF2 where PPF.PARTY_ID = PPF2.PARTY_ID AND :14 between PPF2.EFFECTIVE_START_DATE AND PPF2.EFFECTIVE_END_DATE AND PAF.ASSIGNMENT_TYPE = 'A' and :15 >= PAF.effective_start_date AND PAF.person_id = PPF2.person_id),null) AS Last_Application, VCN.CONSIDERATION_STATUS, VCN.PERSON_ID AS CONSIDERATION_PERSON_ID, VCN.VACANCY_ID AS CONSIDERATION_VACANCY_ID, to_number(:16) AS VACANCY_ID, (select meaning from HR_LOOKUPS LKP where LKP.LOOKUP_TYPE = 'IRC_CONSIDERATION' AND LKP.LOOKUP_CODE = VCN.consideration_status) AS CONSIDERATION, VCN.CONSIDERATION_STATUS AS CONSIDERATION_STATUS_DISPLAY, PPF.FIRST_NAME AS PERSON_FIRST_NAME, PPF.LAST_NAME AS PERSON_LAST_NAME, DOC.DOCUMENT_ID, DOC.FILE_NAME, NVL2( DOC.DOCUMENT_ID,'Y','N') AS PreviewEnabled, VCN.VACANCY_CONSIDERATION_ID, INP.NOTIFICATION_PREFERENCE_ID, PPF.PERSON_ID, PPF.EFFECTIVE_START_DATE, PPF.EFFECTIVE_END_DATE, PPF.ATTRIBUTE1 AS PPFATTRIBUTE1, PPF.ATTRIBUTE2 AS PPFATTRIBUTE2, PPF.ATTRIBUTE3 AS PPFATTRIBUTE3, PPF.ATTRIBUTE4 AS PPFATTRIBUTE4, PPF.ATTRIBUTE5 AS PPFATTRIBUTE5, PPF.ATTRIBUTE6 AS PPFATTRIBUTE6, PPF.ATTRIBUTE7 AS PPFATTRIBUTE7, PPF.ATTRIBUTE8 AS PPFATTRIBUTE8, PPF.ATTRIBUTE9 AS PPFATTRIBUTE9, PPF.ATTRIBUTE10 AS PPFATTRIBUTE10, PPF.ATTRIBUTE11 AS PPFATTRIBUTE11, PPF.ATTRIBUTE12 AS PPFATTRIBUTE12, PPF.ATTRIBUTE13 AS PPFATTRIBUTE13, PPF.ATTRIBUTE14 AS PPFATTRIBUTE14, PPF.ATTRIBUTE15 AS PPFATTRIBUTE15, PPF.ATTRIBUTE16 AS PPFATTRIBUTE16, PPF.ATTRIBUTE17 AS PPFATTRIBUTE17, PPF.ATTRIBUTE18 AS PPFATTRIBUTE18, PPF.ATTRIBUTE19 AS PPFATTRIBUTE19, PPF.ATTRIBUTE20 AS PPFATTRIBUTE20, PPF.ATTRIBUTE21 AS PPFATTRIBUTE21, PPF.ATTRIBUTE22 AS PPFATTRIBUTE22, PPF.ATTRIBUTE23 AS PPFATTRIBUTE23, PPF.ATTRIBUTE24 AS PPFATTRIBUTE24, PPF.ATTRIBUTE25 AS PPFATTRIBUTE25, PPF.ATTRIBUTE26 AS PPFATTRIBUTE26, PPF.ATTRIBUTE27 AS PPFATTRIBUTE27, PPF.ATTRIBUTE28 AS PPFATTRIBUTE28, PPF.ATTRIBUTE29 AS PPFATTRIBUTE29, PPF.ATTRIBUTE30 AS PPFATTRIBUTE30, PPF.ATTRIBUTE_CATEGORY AS PPFATTRIBUTE_CATEGORY, VCN.PERSON_ID AS PERSON_ID1, CSC.SEARCH_CRITERIA_ID, CSC.LOCATION, CSC.DISTANCE_TO_LOCATION, CSC.EMPLOYEE, CSC.CONTRACTOR, CSC.EMPLOYMENT_CATEGORY, CSC.KEYWORDS, CSC.TRAVEL_PERCENTAGE, CSC.MIN_SALARY, CSC.SALARY_CURRENCY, CSC.SALARY_PERIOD, CSC.MATCH_COMPETENCE, CSC.MATCH_QUALIFICATION, CSC.JOB_TITLE, CSC.DEPARTMENT, CSC.PROFESSIONAL_AREA, CSC.WORK_AT_HOME, CSC.ATTRIBUTE_CATEGORY, CSC.ATTRIBUTE1, CSC.ATTRIBUTE2, CSC.ATTRIBUTE3, CSC.ATTRIBUTE4, CSC.ATTRIBUTE5, CSC.ATTRIBUTE6, CSC.ATTRIBUTE7, CSC.ATTRIBUTE8, CSC.ATTRIBUTE9, CSC.ATTRIBUTE10, CSC.ATTRIBUTE11, CSC.ATTRIBUTE12, CSC.ATTRIBUTE13, CSC.ATTRIBUTE14, CSC.ATTRIBUTE15, CSC.ATTRIBUTE16, CSC.ATTRIBUTE17, CSC.ATTRIBUTE18, CSC.ATTRIBUTE19, CSC.ATTRIBUTE20, CSC.ATTRIBUTE21, CSC.ATTRIBUTE22, CSC.ATTRIBUTE23, CSC.ATTRIBUTE24, CSC.ATTRIBUTE25, CSC.ATTRIBUTE26, CSC.ATTRIBUTE27, CSC.ATTRIBUTE28, CSC.ATTRIBUTE29, CSC.ATTRIBUTE30, to_char(RowNum) AS RowNumber, PPF.PARTY_ID, POV.VENDOR_ID, POV.VENDOR_NAME, INP.CREATION_DATE, to_char(decode(:17,'Y',nvl2(ADDR.geometry,floor(irc_location_utility.sdo_miles(mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(:18,:19,null),null,null),ADDR.geometry,0.01)),''),'')) AS DISTANCE_TO_LOCATION_RESULTS, fnd_number.canonical_to_number(distance_to_location) AS DISTANCE_TO_LOCATION_INT, nvl2(ATMPT.MASTERY_SCORE,decode(greatest(ATMPT.MASTERY_SCORE,ATMPT.RAW_SCORE), ATMPT.RAW_SCORE, 'P', 'F'),nvl2(FND_PROFILE.VALUE('IRC_REGISTER_TEST'),nvl2(INP.ATTEMPT_ID, 'A','N'),null)) AS ATTEMPT_STATUS, to_number(decode(ATMPT.RAW_SCORE, -1000, null, ATMPT.RAW_SCORE)) AS ATTEMPT_SCORE, ATMPT.ATTEMPT_ID, decode(IrcReferralInfoEO.source_type,'ER','Y','N') AS Referred, IrcReferralInfoEO.START_DATE, IrcReferralInfoEO.OBJECT_ID, IrcReferralInfoEO.OBJECT_TYPE, IrcReferralInfoEO.END_DATE, (select meaning from hr_lookups where lookup_code = IRCREFERRALINFOEO.source_type and lookup_type = 'REC_TYPE') AS SourceType, decode (IrcReferralInfoEO.source_type, 'ER',(select distinct(full_name) from per_all_people_f where person_id = IrcReferralInfoEO.source_person_id), IrcReferralInfoEO.source_name ) AS SourceName FROM PER_ADDRESSES ADDR, PER_PHONES PHN, IRC_VACANCY_CONSIDERATIONS VCN, IRC_NOTIFICATION_PREFERENCES INP, IRC_DOCUMENTS DOC, PER_ALL_PEOPLE_F PPF, IRC_SEARCH_CRITERIA CSC, PO_VENDORS POV, OTA_ATTEMPTS ATMPT, IRC_REFERRAL_INFO IrcReferralInfoEO WHERE :20 BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE AND PPF.PERSON_ID = DOC.PERSON_ID(+) AND PPF.PERSON_ID = PHN.PARENT_ID(+) AND PHN.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F' AND PHN.phone_type(+) = 'H1' AND :21 between nvl(PHN.date_from,:22) and NVL(PHN.date_to,:23) AND PPF.PERSON_ID = VCN.PERSON_ID(+) AND VCN.VACANCY_ID(+) = :24 AND nvl(VCN.consideration_status,'X') <> 'NO' and PPF.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 :25 between ADDR.DATE_FROM(+) and nvl(ADDR.DATE_TO(+),:26) AND doc.type(+) like '%RESUME' AND doc.end_date(+) is null AND CSC.object_id = PPF.PERSON_ID AND CSC.object_type= 'WPREF' AND EXISTS (SELECT NULL FROM PER_PEOPLE_F PPFS WHERE PPFS.PERSON_ID = PPF.PERSON_ID) 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 INP.ATTEMPT_ID = ATMPT.ATTEMPT_ID(+) and ppf.party_id = IrcReferralInfoEO.object_id(+) and sysdate between IrcReferralInfoEO.start_date(+) and IrcReferralInfoEO.end_date(+) AND (PPF.ATTRIBUTE15 like :28) ORDER BY PPF.FULL_NAME ASC
  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 /*+ FIRST_ROWS */ NULL AS SelectFlag, PPF.FULL_NAME AS PERSON_NAME, ADDR.DERIVED_LOCALE, ADDR.ADDRESS_ID, PHN.PHONE_NUMBER, PHN.PHONE_ID, PPF.DATE_OF_BIRTH, PPF.EMAIL_ADDRESS, ADDR.ADDRESS_LINE1, to_number( decode ( :1 , 1, IRC_SKILLS_MATCHING_PKG.vacancy_match_percent( ppf.person_id, :2 , :3 ), 2, IRC_SKILLS_MATCHING_PKG.skills_match_percent( :4 , :5 , :6 , :7 , :8 , :9 , ppf.person_id),-1) ) AS Match_Percent, decode(irc_utilities_pkg.is_open_party(PPF.PARTY_ID,:10),'TRUE',(select count(*) from PER_ALL_ASSIGNMENTS_F PAF2 , PER_ALL_PEOPLE_F PPF2 where PPF.PARTY_ID = PPF2.PARTY_ID and :11 between PPF2.EFFECTIVE_START_DATE and PPF2.EFFECTIVE_END_DATE and PAF2.ASSIGNMENT_TYPE = 'A' and :12 between PAF2.effective_start_date and PAF2.effective_end_date and PAF2.person_id = PPF2.person_id having count(*)>0),null) AS Jobs_Applied_For, decode(irc_utilities_pkg.is_open_party(PPF.PARTY_ID,:13),'TRUE',(select MAX(PAF.effective_start_date) from PER_ALL_ASSIGNMENTS_F PAF, PER_ALL_PEOPLE_F PPF2 where PPF.PARTY_ID = PPF2.PARTY_ID AND :14 between PPF2.EFFECTIVE_START_DATE AND PPF2.EFFECTIVE_END_DATE AND PAF.ASSIGNMENT_TYPE = 'A' and :15 >= PAF.effective_start_date AND PAF.person_id = PPF2.person_id),null) AS Last_Application, VCN.CONSIDERATION_STATUS, VCN.PERSON_ID AS CONSIDERATION_PERSON_ID, VCN.VACANCY_ID AS CONSIDERATION_VACANCY_ID, to_number(:16) AS VACANCY_ID, (select meaning from HR_LOOKUPS LKP where LKP.LOOKUP_TYPE = 'IRC_CONSIDERATION' AND LKP.LOOKUP_CODE = VCN.consideration_status) AS CONSIDERATION, VCN.CONSIDERATION_STATUS AS CONSIDERATION_STATUS_DISPLAY, PPF.FIRST_NAME AS PERSON_FIRST_NAME, PPF.LAST_NAME AS PERSON_LAST_NAME, DOC.DOCUMENT_ID, DOC.FILE_NAME, NVL2( DOC.DOCUMENT_ID,'Y','N') AS PreviewEnabled, VCN.VACANCY_CONSIDERATION_ID, INP.NOTIFICATION_PREFERENCE_ID, PPF.PERSON_ID, PPF.EFFECTIVE_START_DATE, PPF.EFFECTIVE_END_DATE, PPF.ATTRIBUTE1 AS PPFATTRIBUTE1, PPF.ATTRIBUTE2 AS PPFATTRIBUTE2, PPF.ATTRIBUTE3 AS PPFATTRIBUTE3, PPF.ATTRIBUTE4 AS PPFATTRIBUTE4, PPF.ATTRIBUTE5 AS PPFATTRIBUTE5, PPF.ATTRIBUTE6 AS PPFATTRIBUTE6, PPF.ATTRIBUTE7 AS PPFATTRIBUTE7, PPF.ATTRIBUTE8 AS PPFATTRIBUTE8, PPF.ATTRIBUTE9 AS PPFATTRIBUTE9, PPF.ATTRIBUTE10 AS PPFATTRIBUTE10, PPF.ATTRIBUTE11 AS PPFATTRIBUTE11, PPF.ATTRIBUTE12 AS PPFATTRIBUTE12, PPF.ATTRIBUTE13 AS PPFATTRIBUTE13, PPF.ATTRIBUTE14 AS PPFATTRIBUTE14, PPF.ATTRIBUTE15 AS PPFATTRIBUTE15, PPF.ATTRIBUTE16 AS PPFATTRIBUTE16, PPF.ATTRIBUTE17 AS PPFATTRIBUTE17, PPF.ATTRIBUTE18 AS PPFATTRIBUTE18, PPF.ATTRIBUTE19 AS PPFATTRIBUTE19, PPF.ATTRIBUTE20 AS PPFATTRIBUTE20, PPF.ATTRIBUTE21 AS PPFATTRIBUTE21, PPF.ATTRIBUTE22 AS PPFATTRIBUTE22, PPF.ATTRIBUTE23 AS PPFATTRIBUTE23, PPF.ATTRIBUTE24 AS PPFATTRIBUTE24, PPF.ATTRIBUTE25 AS PPFATTRIBUTE25, PPF.ATTRIBUTE26 AS PPFATTRIBUTE26, PPF.ATTRIBUTE27 AS PPFATTRIBUTE27, PPF.ATTRIBUTE28 AS PPFATTRIBUTE28, PPF.ATTRIBUTE29 AS PPFATTRIBUTE29, PPF.ATTRIBUTE30 AS PPFATTRIBUTE30, PPF.ATTRIBUTE_CATEGORY AS PPFATTRIBUTE_CATEGORY, VCN.PERSON_ID AS PERSON_ID1, CSC.SEARCH_CRITERIA_ID, CSC.LOCATION, CSC.DISTANCE_TO_LOCATION, CSC.EMPLOYEE, CSC.CONTRACTOR, CSC.EMPLOYMENT_CATEGORY, CSC.KEYWORDS, CSC.TRAVEL_PERCENTAGE, CSC.MIN_SALARY, CSC.SALARY_CURRENCY, CSC.SALARY_PERIOD, CSC.MATCH_COMPETENCE, CSC.MATCH_QUALIFICATION, CSC.JOB_TITLE, CSC.DEPARTMENT, CSC.PROFESSIONAL_AREA, CSC.WORK_AT_HOME, CSC.ATTRIBUTE_CATEGORY, CSC.ATTRIBUTE1, CSC.ATTRIBUTE2, CSC.ATTRIBUTE3, CSC.ATTRIBUTE4, CSC.ATTRIBUTE5, CSC.ATTRIBUTE6, CSC.ATTRIBUTE7, CSC.ATTRIBUTE8, CSC.ATTRIBUTE9, CSC.ATTRIBUTE10, CSC.ATTRIBUTE11, CSC.ATTRIBUTE12, CSC.ATTRIBUTE13, CSC.ATTRIBUTE14, CSC.ATTRIBUTE15, CSC.ATTRIBUTE16, CSC.ATTRIBUTE17, CSC.ATTRIBUTE18, CSC.ATTRIBUTE19, CSC.ATTRIBUTE20, CSC.ATTRIBUTE21, CSC.ATTRIBUTE22, CSC.ATTRIBUTE23, CSC.ATTRIBUTE24, CSC.ATTRIBUTE25, CSC.ATTRIBUTE26, CSC.ATTRIBUTE27, CSC.ATTRIBUTE28, CSC.ATTRIBUTE29, CSC.ATTRIBUTE30, to_char(RowNum) AS RowNumber, PPF.PARTY_ID, POV.VENDOR_ID, POV.VENDOR_NAME, INP.CREATION_DATE, to_char(decode(:17,'Y',nvl2(ADDR.geometry,floor(irc_location_utility.sdo_miles(mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(:18,:19,null),null,null),ADDR.geometry,0.01)),''),'')) AS DISTANCE_TO_LOCATION_RESULTS, fnd_number.canonical_to_number(distance_to_location) AS DISTANCE_TO_LOCATION_INT, nvl2(ATMPT.MASTERY_SCORE,decode(greatest(ATMPT.MASTERY_SCORE,ATMPT.RAW_SCORE), ATMPT.RAW_SCORE, 'P', 'F'),nvl2(FND_PROFILE.VALUE('IRC_REGISTER_TEST'),nvl2(INP.ATTEMPT_ID, 'A','N'),null)) AS ATTEMPT_STATUS, to_number(decode(ATMPT.RAW_SCORE, -1000, null, ATMPT.RAW_SCORE)) AS ATTEMPT_SCORE, ATMPT.ATTEMPT_ID, decode(IrcReferralInfoEO.source_type,'ER','Y','N') AS Referred, IrcReferralInfoEO.START_DATE, IrcReferralInfoEO.OBJECT_ID, IrcReferralInfoEO.OBJECT_TYPE, IrcReferralInfoEO.END_DATE, (select meaning from hr_lookups where lookup_code = IRCREFERRALINFOEO.source_type and lookup_type = 'REC_TYPE') AS SourceType, decode (IrcReferralInfoEO.source_type, 'ER',(select distinct(full_name) from per_all_people_f where person_id = IrcReferralInfoEO.source_person_id), IrcReferralInfoEO.source_name ) AS SourceName FROM PER_ADDRESSES ADDR, PER_PHONES PHN, IRC_VACANCY_CONSIDERATIONS VCN, IRC_NOTIFICATION_PREFERENCES INP, IRC_DOCUMENTS DOC, PER_ALL_PEOPLE_F PPF, IRC_SEARCH_CRITERIA CSC, PO_VENDORS POV, OTA_ATTEMPTS ATMPT, IRC_REFERRAL_INFO IrcReferralInfoEO WHERE :20 BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE AND PPF.PERSON_ID = DOC.PERSON_ID(+) AND PPF.PERSON_ID = PHN.PARENT_ID(+) AND PHN.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F' AND PHN.phone_type(+) = 'H1' AND :21 between nvl(PHN.date_from,:22) and NVL(PHN.date_to,:23) AND PPF.PERSON_ID = VCN.PERSON_ID(+) AND VCN.VACANCY_ID(+) = :24 AND nvl(VCN.consideration_status,'X') <> 'NO' and PPF.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 :25 between ADDR.DATE_FROM(+) and nvl(ADDR.DATE_TO(+),:26) AND doc.type(+) like '%RESUME' AND doc.end_date(+) is null AND CSC.object_id = PPF.PERSON_ID AND CSC.object_type= 'WPREF' AND EXISTS (SELECT NULL FROM PER_PEOPLE_F PPFS WHERE PPFS.PERSON_ID = PPF.PERSON_ID) 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 INP.ATTEMPT_ID = ATMPT.ATTEMPT_ID(+) and ppf.party_id = IrcReferralInfoEO.object_id(+) and sysdate between IrcReferralInfoEO.start_date(+) and IrcReferralInfoEO.end_date(+) AND (PPF.ATTRIBUTE15 like :28) ORDER BY PPF.FULL_NAME ASC

      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