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';