Skip to main content

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?

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

 

 

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

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

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.

 

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

 

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:

 

Reply


Terms & ConditionsCookie settings