Unexpected Error When Try to Add Job (already Added) to Job Basket Internal / External Application

(Doc ID 1948235.1)

Last updated on DECEMBER 20, 2016

Applies to:

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


On : 12.1.3 version, Candidate Self Service, Issue is happening in Test/Dev Instance

When attempting to add a Vacancy to Job Basket, the following error occurs.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT IrcJobBasketItemsEO.PARTY_ID, IrcJobBasketItemsEO.RECRUITMENT_ACTIVITY_ID, IrcJobBasketItemsEO.JOB_BASKET_ITEM_ID, IrcJobBasketItemsEO.PERSON_ID FROM IRC_JOB_BASKET_ITEMS IrcJobBasketItemsEO WHERE (person_id = :1)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:762

The issue can be reproduced at will with the following steps:
1. iRecruitment Employee Candidate >
2. Jobs Tab >
3. Search for Vacancies >
5. Select a Vacancy and add to Job Basket >
4. Select a Vacancy and apply >
5. After applying for the Vacancy >
6. Jobs Tab >
7. Search for Vacancy >
8. Add to Job Basket >

Error occurs.

The issue has the following business impact:
Due to this issue, users cannot add a job to Vacancy.
Error message should not block user.  A warning message is expected.

Work Around
Log out and log back in.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms