Question

How to get Navigator Preview of an User?

  • 8 December 2022
  • 5 replies
  • 137 views

Userlevel 5
Badge +14
  • Hero (Customer)
  • 275 replies

We want to check whom has which page. We wrote this piece of code to get it.

SELECT t.identity,
person_info_api.get_name_for_user(t.identity) person,
po_.*
FROM fnd_user_role_runtime_tab t,
(SELECT pog.po_id,
pog.role,
po.pres_object_type,
po.pres_object_type_db,
po.module,
po.description,
po.allow_read_only,
po.layer_id,
po.change_info,
po.change_date,
po.info_type
FROM ifsapp.pres_object_grant pog,
ifsapp.pres_object po
WHERE pog.po_id = po.po_id) po_
WHERE t.role = po_.role
AND t.identity LIKE nvl('&USERNAME', '%')
AND po_.role LIKE nvl('&PERMISSION_ROLE_NAME', '%')
AND po_.po_id LIKE nvl('&PAGE_NAME', '%')
ORDER BY t.identity,
po_.role,
po_.po_id

But, the description column is in English. We want to get page names in Turkish.

 

I found FND_USER_ROLE_RUNTIME and  FND_NAVIGATOR views. In the FND_NAVIGATOR view label column has page names in Turkish.

 

However, I could not find any connection between these views. Could you help us?


5 replies

Userlevel 5
Badge +14

I forgot to add the screenshot of the Navigator Preview. :) 

 

 

Badge +1

You should be able to get this from the PRES_OBJECT_DESCRIPTION view or use the related API
i.e. PRES_OBJECT_DESCRIPTION_API.Get_Description(po_.po_id,’tr’) 

Userlevel 5
Badge +14

Thank you for the response. But, the API returns null for all results. 

Badge +1

How strange, do you see any results other than English descriptions in:
select * from pres_object_description;

I wonder if you need to get the translation from a table such as text_translation. Unfortunately we work in a one language environment so I can’t really test this for you.

 

Userlevel 5
Badge +14

No worry. At least you try to respond to something. We have just one TR description. :)

 

Reply