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

Last updated on JULY 03, 2017

Applies to:

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

Symptoms

On : 12.2.5 version, Catalog items

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

ERROR
-----------------------
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


STEPS
-----------------------
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

Cause

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