Skip to main content

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?

 

 

Hi

 

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

 

Do you have any suggestions?


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


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


Hi,

 

To solve the problem I translated presentation objects. First of all, I got all the presentation objects into an Excel file. After that, I made the translations. Then, I wrote a PLSQL script to insert translations. Finally, I wrote a query to get the translated names of the presentation objects.

 

 

SELECT * FROM temp_table FOR UPDATE;
DELETE FROM temp_table;

/*BEGIN
FOR rec_ IN (SELECT * FROM temp_table t WHERE t.area2 = 'tr')
LOOP
ifsapp.pres_object_description_api.insert_description(rec_.area1, 'tr', rec_.area3);
END LOOP;
END;*/

SELECT t.po_id,
t.lang_code,
t.description,
ifsapp.pres_object_description_api.get_description(t.po_id, 'tr') ceviri,
'ifsapf:' || t.po_id ekran
FROM ifsapp.pres_object_description t
WHERE (substr(t.po_id, 1, 3) = 'tbw' OR substr(t.po_id, 1, 3) = 'frm')
AND t.lang_code = 'en';

 


Reply