My Oracle Support Banner

Error :: ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2484223.1)

Last updated on NOVEMBER 05, 2019

Applies to:

Oracle iRecruitment - Version 12.2.7 and later
Information in this document applies to any platform.


On : 12.2.7 version, Requisition and Vacancy
Patched at R12.HR_PF.C.Delta.11

When attempting to view applicants in a vacancy, the following error occurs.

## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.IRC_SKILLS_MATCHING_PKG", line 284
ORA-06512: at "APPS.IRC_SKILLS_MATCHING_PKG", line 445
ORA-06512: at "APPS.IRC_SKILLS_MATCHING_PKG", line 100
ORA-06512: at "APPS.IRC_SKILLS_MATCHING_PKG", line 690
ORA-06512: at line 1

Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PPF.FULL_NAME AS PERSON_NAME, PPF.FIRST_NAME AS PERSON_FIRST_NAME, PPF.LAST_NAME AS PERSON_LAST_NAME, ADDR.DERIVED_LOCALE, PPF.EMAIL_ADDRESS, ADDR.ADDRESS_ID, PHN.PHONE_NUMBER, PHN.PHONE_ID, PPF.DATE_OF_BIRTH, ADDR.ADDRESS_LINE1, to_char(IRC_SKILLS_MATCHING_PKG.vacancy_match_percent(irc_utilities_pkg.GET_RECRUITMENT_PERSON_ID(PPF.PERSON_ID,:1), PAV.VACANCY_ID , :2 )) AS MATCH_PERCENT, (select count(*) from PER_ALL_ASSIGNMENTS_F PAF2, PER_ALL_PEOPLE_F PPF2 where PAF2.ASSIGNMENT_TYPE = 'A' and :3 between PAF2.effective_start_date AND PAF2.effective_end_date AND PAF2.person_id = PPF2.person_id and PAF2.effective_start_date between PPF2.effective_start_date AND PPF2.effective_end_date AND PPF2.party_id = PPF.party_id AND not exists (select null from per_vac_linked_assignments where tgt_apl_asg_id=paf2.assignment_id) having count(*)>0) AS Jobs_Applied_For, (select MIN(PAF2.effective_start_date) from PER_ALL_ASSIGNMENTS_F PAF2 where PAF2.assignment_id=PAF.assignment_id) AS Last_Application, PPF.PERSON_ID AS APL_PERSON_ID, PPF.EFFECTIVE_START_DATE, PPF.EFFECTIVE_END_DATE, V

The issue can be reproduced at will with the following steps:
1. iRecruitment Recruiter >
2. iRecruitment Home >
3. Navigate to Vacancy tab >
4. search for vacancy ..Input  <VACANCY NAME >
5. Click on “View Applicant” >
6. error raised.

The issue has the following business impact:
Due to this issue, users cannot complete to fill up the vacancies. .




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.