My Oracle Support Banner

PIM Errors, JBO-27122, While Accessing People Tab Under ICC (Doc ID 2282751.1)

Last updated on MARCH 02, 2019

Applies to:

Oracle Product Hub - Version 12.2.5 and later
Information in this document applies to any platform.


On : 12.2.5 version, Catalog items

When attempting to Click on People Tab under any ICC, the following error occurs:

You have encountered unexpected error.

Error Page
Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT 'A' grantee_type, 'A1' name_link, grants.grant_guid grant_guid, grants.start_date start_date , grants.end_date end_date, grants.instance_type object_key_type, grants.instance_pk1_value object_key, ltrim(grantee_global.party_name,'* ') party_name, NULL company_name, -1 company_id, grantee_global.party_id party_id , granted_menu.menu_name role_name, granted_menu.menu_name role_description, obj.obj_name object_name, granted_menu.menu_id menu_id, 'egorolegranttableviewrolename' switcherCol, menutl.user_menu_name roleNameLink, grants.instance_pk1_value pk1_value, grants.instance_pk2_value pk2_value, grants.instance_pk3_value pk3_value, grants.instance_pk4_value pk4_value, grants.instance_pk5_value pk5_value, grants.instance_set_id instan

The issue can be reproduced at will with the following steps:
1. PIM responsibility
2. Navigate to Setup Workbench
3. Search for any ICC
4. Click on People Tab




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.