Question

How to Find Navigator Preview of a Permission Set?

  • 18 January 2024
  • 3 replies
  • 87 views

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

Hi,

 

I will prepare a report. I need a query of the Navigator Previews of permission sets. I couldn’t find the connection between permission sets and the navigator. I must use the fnd_navigator view because It has a translated version of the navigator. Do you have any idea?

 

 


3 replies

Userlevel 5
Badge +14

Hi

 

@dsj @Charith Epitawatta @ShawnBerk @Yasas Kasthuriarachchi  @Marcel.Ausan  @Mathias Dahl 

 

Do you have any suggestions?

Userlevel 7
Badge +20

Hi @hhy38 

 

It seems FND_NAVIGATOR stores navigator entries for Aurena client, not the IEE.

 

I don’t have an exact answer, but I hope below queries will help you to build something

 

Query to get the windows (Presobjects) granted for a permission set

select * from pres_object_grant
where role = 'YOUR_PERMISSION_SET_ID'

 

Query to get the window names and translations

select * from language_text_translation a, pres_object b
where a.name = b.po_id
and a.lang_code = 'sv' -- Use your language code here
and b.pres_object_type_db = 'WIN' 

Hope it helps!

Damith

Userlevel 5
Badge +14

Hi @dsj Damith,

 

I think something is wrong with our translations. Because we have only 166 object translations in the language_text_translation view for Turkish. So, we need to translate presentation objects. Thank you for the effort.

 

Best Regards,

Hasan

Reply