My Oracle Support Banner

Error JBO-27122 while Self Service Export To Excel In Transaction Monitor (Doc ID 2523035.1)

Last updated on JULY 06, 2021

Applies to:

Oracle Self-Service Human Resources - Version 12.2.7 and later
Information in this document applies to any platform.


On : 12.2.7 version, Person / Assignment Issues

When attempting to export the self service data into Excel , example Transaction Monitor
the following error occurs.

JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select t.TRANSACTION_HISTORY_ID, (select decode(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',p.global_name,p.local_name) from per_all_people_f p where p.person_id=t.CREATOR_PERSON_ID and sysdate between p.EFFECTIVE_START_DATE and p.EFFECTIVE_END_DATE) CREATOR_PERSON, t.CREATION_DATE, nvl((select decode(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',p.global_name,p.local_name) from per_all_people_f p where p.person_id=t.SELECTED_PERSON_ID and trunc(sysdate) between trunc(p.EFFECTIVE_START_DATE) and trunc(p.EFFECTIVE_END_DATE)),pqh_ss_history.getFullNameforHireTransMonitor(t.transaction_history_id,'C')) SELECTED_PERSON, f.user_function_name, 'Completed' STATUS, '' PRODUCT_CODE, hr_workflow_ss.getProcessDisplayName(t.item_type, t.item_key) WORKFLOW_PROCESS, APPROVAL_ITEM_KEY ITEM_KEY, t.CREATOR_PERSON_ID, t.FUNCTION_ID, (select FUNCTION_NAME from fnd_form_functions f where f.FUNCTION_ID = t.FUNCTION_ID) FUNCTION_NAME, t.SELECTED_PERSON_ID from pqh_ss_transaction_history t, fnd_form_functions_tl f where t.FUNCTION_ID = f.function_id and t.creation_date is not null and t.creation_date >= (select CREATION_DATE from fnd_menus where menu_name = 'HR_TRANS_MONITOR_FUNCTIONS') and t.function_id in ( select distinct FUNCTION_ID from fnd_menu_entries where MENU_ID = ( select MENU_ID from fnd_menus where menu_name = fnd_profile.value('HR_TRANSACTION_MONITOR_FUNCTIONS_MENU') ) ) and f.language = userenv('LANG') AND t.approval_item_key is not null) QRSLT WHERE (1=1 AND nvl(selected_person_id,creator_person_id) in (select distinct person_id from per_people_f where person_id = nvl(selected_person_id,creator_person_id)) AND CREATOR_PERSON_ID = :1 AND SELECTED_PERSON_ID = :2) ORDER BY

The issue can be reproduced at will with the following steps:
1. Login as the Employee Self-Service > Transaction Monitor > Export the table data > Gets above mentioned error.

The issue has the following business impact:
Due to this issue, users cannot Export the table data in to excel.


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.