Skip to main content
Solved

How to get Navigator Preview of an User?

  • December 8, 2022
  • 6 replies
  • 249 views
hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • hhy38
  • Superhero (Customer)
  • 326 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?

Best answer by hhy38

We solved the problem by translating presentation objects. The query is below.

 

Query:

SELECT t.identity kullanici_adi,
	   ifsapp.person_info_api.get_id_for_user(t.identity) sicil,
	   ifsapp.person_info_api.get_name_for_user(t.identity) ad_soyad,
	   po_.role izin_seti,
	   po_.module modul,
	   po_.po_id ekran,
	   po_.description ekran_aciklamasi,
	   'https://server:port/client/runtime/Ifs.Fnd.Explorer.application?url=ifsapf:' || po_.po_id ekran_yolu
FROM   ifsapp.fnd_user_role_runtime 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 po_.pres_object_type_db = 'WIN'
	   AND (substr(po_.po_id, 1, 3) = 'tbw' OR substr(po_.po_id, 1, 3) = 'frm')
	   AND t.identity LIKE nvl('&Kullanici_Adi', '%')
	   AND po_.role LIKE nvl('&Yetki_Seti', '%')
	   AND po_.po_id LIKE nvl('&Ekran', '%')
	   AND ifsapp.pres_object_description_api.get_description(po_.po_id, 'tr') IS NOT NULL
ORDER  BY t.identity,
		  po_.role,
		  po_.module,
		  po_.po_id

Output:

 

View original
Linkedin Profile: https://www.linkedin.com/in/hhy34/
Did this topic help you find an answer to your question?

6 replies

hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • hhy38
  • Author
  • Superhero (Customer)
  • 326 replies
  • December 8, 2022

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

 

 

Linkedin Profile: https://www.linkedin.com/in/hhy34/
S
Do Gooder (Customer)
Forum|alt.badge.img+1
  • SteveW
  • Do Gooder (Customer)
  • 3 replies
  • February 6, 2023

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’) 

hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • hhy38
  • Author
  • Superhero (Customer)
  • 326 replies
  • February 7, 2023

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

Linkedin Profile: https://www.linkedin.com/in/hhy34/
S
Do Gooder (Customer)
Forum|alt.badge.img+1
  • SteveW
  • Do Gooder (Customer)
  • 3 replies
  • February 7, 2023

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.

 

hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • hhy38
  • Author
  • Superhero (Customer)
  • 326 replies
  • February 7, 2023

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

 

Linkedin Profile: https://www.linkedin.com/in/hhy34/
hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • hhy38
  • Author
  • Superhero (Customer)
  • 326 replies
  • Answer
  • May 30, 2024

We solved the problem by translating presentation objects. The query is below.

 

Query:

SELECT t.identity kullanici_adi,
	   ifsapp.person_info_api.get_id_for_user(t.identity) sicil,
	   ifsapp.person_info_api.get_name_for_user(t.identity) ad_soyad,
	   po_.role izin_seti,
	   po_.module modul,
	   po_.po_id ekran,
	   po_.description ekran_aciklamasi,
	   'https://server:port/client/runtime/Ifs.Fnd.Explorer.application?url=ifsapf:' || po_.po_id ekran_yolu
FROM   ifsapp.fnd_user_role_runtime 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 po_.pres_object_type_db = 'WIN'
	   AND (substr(po_.po_id, 1, 3) = 'tbw' OR substr(po_.po_id, 1, 3) = 'frm')
	   AND t.identity LIKE nvl('&Kullanici_Adi', '%')
	   AND po_.role LIKE nvl('&Yetki_Seti', '%')
	   AND po_.po_id LIKE nvl('&Ekran', '%')
	   AND ifsapp.pres_object_description_api.get_description(po_.po_id, 'tr') IS NOT NULL
ORDER  BY t.identity,
		  po_.role,
		  po_.module,
		  po_.po_id

Output:

 

Linkedin Profile: https://www.linkedin.com/in/hhy34/

Reply


Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings